Current location | Thread information | |
![]() ![]() ![]() ![]() ![]() ![]() |
Last Activity 4/11/2024 9:21 PM 17 replies, 1223 viewings |
|
|
Printer friendly version |
^ Top | |||||
aztrix![]() Veteran ![]() Posts: 116 Joined: 6/16/2004 Location: Sydney, NSW, Australia ![]() |
Howzit Folks? Many of the ASX symbol names based on User Data are incorrect, see attached for an example of TLS i.e. Telstra https://www2.asx.com.au/markets/company/tls which is mistaken as Telos Please will you let me know whether this is a configuration issue or a bug? Cheers Aztrix ![]() | ||||
^ Top | |||||
Barry Cohen![]() Sage ![]() ![]() ![]() ![]() ![]() ![]() Posts: 6338 Joined: 1/19/2004 ![]() |
TLS is a US symbol as well & the company is Telos. If you want ASX names (TLS as Telstra), you would need to use the ASX database & not the US database. In OmniTrader it is not possible to use 2 databases simultaneously. In order to switch between them you would need to switch your profile as well as your symbol database under Edit/Exchange Information. | ||||
^ Top | |||||
aztrix![]() Veteran ![]() Posts: 116 Joined: 6/16/2004 Location: Sydney, NSW, Australia ![]() |
Is my understanding correct Barry, that Exchange Information is specific to each profile and not controlled by the Data Source? That would certainly make my life much easier :-) Or do I still have to change Exchange Information each time I switch profiles? Cheers Bruce | ||||
^ Top | |||||
Barry Cohen![]() Sage ![]() ![]() ![]() ![]() ![]() ![]() Posts: 6338 Joined: 1/19/2004 ![]() |
Exchange Information is global to OmniTrader. You mentioned the volume * close for VEA in the other thread not being right & it's due to the same issue as this watermark issue. VEA is a US symbol too & that value it's calculating is from the US VEA symbol. In other words any symbol that is in both markets is going to cause you problems. The best course of action would be to use 2 separate Windows devices, with OT set to US on one & OT set to AU/ASX on the other. You could use VMWare or something like that on the same PC allowing access to a 2nd Windows running on a virtual machine. That way you can do them both on a single PC. The alternative is to switch databases & profiles whenever you want to switch between US & ASX, especially if you have any symbols that are in both US & ASX markets, which you obviously do. The problems with this are that it's tedious, but also it's very easy to make a mistake & accidently get US symbols targeting Metastock or ASX symbols targeting OmniData. So let's say you have a US profile using OmniData & an ASX profile using Metastock data, & you're currently set to use the US database. To switch you will do the following: 1. Switch to the AU database & ASX exchange under Edit/Exchange Information. 2. Restart OT. 3. Switch to your ASX profile. That would be your normal process. But to get that to work you will first need to get all your Metastock data symbols to target the correct locations while the AU database is in use. To do that, create a temporary profile (File/New) after steps 1-3 above. Then add ALL your ASX symbols from your Metastock folders. That should retarget all your symbols & allow your previous ASX profiles to work properly (watermark & OmniScan). You might need to rerun your analysis in those OmniScan used profiles though first. | ||||
^ Top | |||||
aztrix![]() Veteran ![]() Posts: 116 Joined: 6/16/2004 Location: Sydney, NSW, Australia ![]() |
Many thanks for your detailed response Barry, much appreciated Firstly I don't believe the VEA issue is the same as the Exchange Information issue even tho the symbols are the same so I will respond to that in the original thread. IMNSHO I don't think 2 devices whether real or virtual is a "reasonable" solution for what is essentially an application design/software issue. Having a Global Exchange Information setting is great but there should be an option to override it in the profile. It would be conceptually simple, if the local i.e. Profile Exchange Information is not set it defaults to the Global Exchange Information setting. I agree it will be tedious switching Exchange Information settings but it's cheaper than 2 devices except in terms of time and hopefully not for long until the Profile Exchange Information settings are implemented :-D That said, the raw data i.e. historical price & volume, should always be determined by the Data Source! More on this in the https://www.omnitrader.com/currentclients/otforum/thread-view.asp?threadid=16534&posts=4 thread My MetaStock data is all setup correctly and I've created an ASX Template Profile so I don't have to do it repetitively for each ASX profile I have. Altho doing quarterly updates is still extremely tedious which begs the question, why can't/doesn't OT automatically sync with my MetaStock folders so I don't have to do this repetitively? The obvious proviso here is that I want all the symbols in the folder which in my case I do because my data provider, Premium Data https://www.premiumdata.net, supports custom folders to meet my needs e.g. Market Cap Lists
See attached for a comprehensive list of typical focus lists provided by OS that UD users would potentially be interested in if it wasn't so cumbersome to manage. I have asked in the past whether OD would be supporting ASX data in the future and got a flat no :-( I've just had a light bulb moment to ease the burden of keeping UD focus lists current, could I code custom lists in the OL IDE and incorporate those in OS? I might have to talk with Jim Dean if he's listening :-) Anyway, many thanks for your continued efforts Barry, I'm definitively not ungrateful so I hope it doesn't come across that way :-) Cheers Aztrix ![]() | ||||
^ Top | |||||
Barry Cohen![]() Sage ![]() ![]() ![]() ![]() ![]() ![]() Posts: 6338 Joined: 1/19/2004 ![]() |
Unfortunately it isn't that simple. It's a design flaw with OT that goes back many years. It's not impossible to change, but it is unlikely given the scope of what's needed. As a result, we typically do not support more than one database simultaneously. I've told you the only way I know to get around the limitations.
Anything is possible with enough development time, but it's difficult to find the resources to make changes like that. I'm not sure why you would have to retarget your Metastock symbols every 4 months unless your Metastock user data is changing, & if that's the case then yes you would have to retarget. I'm glad you know to use a "template profile" to fix the pointers.
Correct. Our provider does not carry ASX, so we couldn't if we wanted to. But additionally, the exchange charges a very hefty monthly cost to distribute this data. | ||||
^ Top | |||||
aztrix![]() Veteran ![]() Posts: 116 Joined: 6/16/2004 Location: Sydney, NSW, Australia ![]() |
Thanks again Barry I think you'll find that the constituents of most indexes change quarterly or annually but some almost instantaneously e.g. sector indices, even the Dow Jones Industrial Average, altho it does not change very frequently. I'm pretty sure most S&P indexes including S&P 100, S&P 500, S&P 1500, etc. also change quarterly, not just the S&P ASX indexes. I quote from S&P U.S. Indices Methodology: S&P Equal Weight U.S. Indices. The indices are rebalanced after the market close on the third Friday of the quarter-ending month with weights set to 1/N for each company in the index where N equals the number of companies in the index at rebalancing. At each quarterly rebalancing, companies are equal weighted using closing prices as of the second Friday of the quarter-ending month as the reference price. For those companies having multiple share class lines in the index, each share class line is assigned a weight that is proportional to its FMC as of the second Friday pricing reference date. Since index shares are assigned based on prices one week prior to the rebalancing, the actual weight of each company at the rebalancing differs from the target equal weights due to market movements. S&P Capped Market Cap Weighted U.S. Indices. The indices are rebalanced for reweighting purposes quarterly after the close of business on the third Friday of March, June, September, and December. The rebalancing reference date is the second Friday of March, June, September, and December respectively. Sector Index Reclassifications. A sector index constituent may move from one GICS sub-index to another when a GICS reclassification is made. For any sector index, the company is deleted from the relevant GICS index and added to the other at the time this reclassification occurs for the underlying index. Reference: https://www.spglobal.com/spdji/en/documents/methodologies/methodology-sp-us-indices.pdf In my research I discovered that S&P and Dow Jones have actually merged … | ||||
^ Top | |||||
Barry Cohen![]() Sage ![]() ![]() ![]() ![]() ![]() ![]() Posts: 6338 Joined: 1/19/2004 ![]() |
I see. That makes sense now, & why you'd need to do that once in a while. It would be dependent on when Metastock updates their own lists though, not what goes on at the exchanges. | ||||
^ Top | |||||
aztrix![]() Veteran ![]() Posts: 116 Joined: 6/16/2004 Location: Sydney, NSW, Australia ![]() |
Fortunately Premium Data https://www.premiumdata.net do a great job in this space and custom lists are updated every Saturday but I only refresh my focus lists quarterly when the major changes happen which is a big enough pita as it is … Cheers Aztrix | ||||
^ Top | |||||
aztrix![]() Veteran ![]() Posts: 116 Joined: 6/16/2004 Location: Sydney, NSW, Australia ![]() |
Here is an example of what happens most Saturdays for corporate activities during the week:
| ||||
^ Top | |||||
aztrix![]() Veteran ![]() Posts: 116 Joined: 6/16/2004 Location: Sydney, NSW, Australia ![]() |
Hi Barry I've been using the method you provided for switching between ASX & US profiles which works for the most part but I keep getting the following error: Restart Error Following a restart I get: Error3167: Record is deleted See attached for screenshots and OT logs Cheers Aztrix ![]() ![]() ![]() ![]() ![]() | ||||
^ Top | |||||
Barry Cohen![]() Sage ![]() ![]() ![]() ![]() ![]() ![]() Posts: 6338 Joined: 1/19/2004 ![]() |
With OT closed, browse to the ...OT2022/Results folder & delete everything in it. These will be recreated when you open profiles & run analysis, but it may clear up whatever is causing the error. | ||||
^ Top | |||||
aztrix![]() Veteran ![]() Posts: 116 Joined: 6/16/2004 Location: Sydney, NSW, Australia ![]() |
Thanks Barry, seems to have resolved the issue | ||||
^ Top | |||||
aztrix![]() Veteran ![]() Posts: 116 Joined: 6/16/2004 Location: Sydney, NSW, Australia ![]() |
I spoke to soon, same thing just happened today, please find attached OT log ![]() | ||||
^ Top | |||||
Barry Cohen![]() Sage ![]() ![]() ![]() ![]() ![]() ![]() Posts: 6338 Joined: 1/19/2004 ![]() |
Does it error when your database is set to AU, US, or both? | ||||
^ Top | |||||
aztrix![]() Veteran ![]() Posts: 116 Joined: 6/16/2004 Location: Sydney, NSW, Australia ![]() |
It only seems to be US Barry | ||||
^ Top | |||||
Barry Cohen![]() Sage ![]() ![]() ![]() ![]() ![]() ![]() Posts: 6338 Joined: 1/19/2004 ![]() |
That's good, then try this. With OT set to the US database & with OT closed, browse to the ...\Nirvana\data folder. Rename Symbols32.mdb to Symbols32.mdb.old then restart OT & it will create a new US database & that may fix the error. | ||||
^ Top | |||||
aztrix![]() Veteran ![]() Posts: 116 Joined: 6/16/2004 Location: Sydney, NSW, Australia ![]() |
I've followed your instructions and the latest Symbols32 is 11,204 kb vs 11,624 kb for the previous instance Hopefully this will resolve the issue Thanks Barry |
|
|
Legend | Action | Notification | |||
Administrator
Forum Moderator |
Registered User
Unregistered User |
![]() |
Toggle e-mail notification |