OmniTrader Forum OmniTrader Forum
forums calendars search
today this week
 
register logon control panel Forum Rules
You are currently browsing as a guest.
You should logon to access more features
A Self-Moderated Community - ALL MEMBERS, PLEASE READ!
Vote for Members who contribute the most to your trading, and help us moderate content within the Forums.


  Current location        Thread information  
OmniTrader Upgrade Forums
OmniTrader Technical Support
ASX Symbol Names Bug
Last Activity 4/11/2024 9:21 PM
17 replies, 1223 viewings

Jump to page : 1
Now viewing page 1 [25 messages per page]
 
back reply
Printer friendly version

^ Top
aztrix

Veteran
100
Posts: 116

Joined: 6/16/2004
Location: Sydney, NSW, Australia

User Profile
 
Subject : ASX Symbol Names Bug
Posted : 3/16/2022 6:42 AM
Post #48563

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

Attached file : OT22 ASX TLS.PNG (89KB - 229 downloads)

^ Top
Barry Cohen

Sage
5000100010010010025
Posts: 6338

Joined: 1/19/2004

User Profile
 
Subject : RE: ASX Symbol Names Bug
Posted : 3/16/2022 9:14 AM
Post #48568 - In reply to #48563

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
100
Posts: 116

Joined: 6/16/2004
Location: Sydney, NSW, Australia

User Profile
 
Subject : RE: ASX Symbol Names Bug
Posted : 3/16/2022 8:39 PM
Post #48573 - In reply to #48568

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
5000100010010010025
Posts: 6338

Joined: 1/19/2004

User Profile
 
Subject : RE: ASX Symbol Names Bug
Posted : 3/17/2022 10:11 AM
Post #48575 - In reply to #48573

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
100
Posts: 116

Joined: 6/16/2004
Location: Sydney, NSW, Australia

User Profile
 
Subject : RE: ASX Symbol Names Bug
Posted : 3/17/2022 2:33 PM
Post #48578 - In reply to #48575

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
S&P ASX 20
S&P ASX 50
S&P ASX MidCap 50
S&P ASX 100
S&P ASX 200
S&P ASX 300
ASX All Ordinaries
S&P ASX Small Ordinaries
ASX All Equities

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

Attached file : ASX All Lists.txt (44KB - 236 downloads)

^ Top
Barry Cohen

Sage
5000100010010010025
Posts: 6338

Joined: 1/19/2004

User Profile
 
Subject : RE: ASX Symbol Names Bug
Posted : 3/17/2022 4:02 PM
Post #48580 - In reply to #48578

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.

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?


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.

I have asked in the past whether OD would be supporting ASX data in the future and got a flat no


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
100
Posts: 116

Joined: 6/16/2004
Location: Sydney, NSW, Australia

User Profile
 
Subject : RE: ASX Symbol Names Bug
Posted : 3/17/2022 5:48 PM
Post #48583 - In reply to #48580

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
5000100010010010025
Posts: 6338

Joined: 1/19/2004

User Profile
 
Subject : RE: ASX Symbol Names Bug
Posted : 3/18/2022 11:09 AM
Post #48587 - In reply to #48583

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
100
Posts: 116

Joined: 6/16/2004
Location: Sydney, NSW, Australia

User Profile
 
Subject : RE: ASX Symbol Names Bug
Posted : 3/20/2022 4:57 PM
Post #48591 - In reply to #48587

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
100
Posts: 116

Joined: 6/16/2004
Location: Sydney, NSW, Australia

User Profile
 
Subject : RE: ASX Symbol Names Bug
Posted : 4/2/2022 12:07 PM
Post #48608 - In reply to #48587

Here is an example of what happens most Saturdays for corporate activities during the week:

Hello Bruce Williamson
Your subscription levels are as follows:
ASX End of Day Updates : Subscribed until 2 Sep 2022
ASX Progressive Snapshots : Subscribed until 2 Sep 2022
ASX Derivatives : Subscribed until 2 Sep 2022
US Stocks End of Day Updates : Not Subscribed
Processing 575KB of update files...

======= ASX ==========================================
Adjusting AEV
Adjusting KIL
Adjusting DHG
Merging LCK into NRZ
Merging LCKOA into NRZOA
Moving HHM to the "Delisted Securities" Folder
Moving PAF to the "Delisted Securities" Folder
Deleting MXROD
Deleting AMPPA
Updating names of ASX securities
Bulk deleting expired securities from the ETOs folder
Finished deleting expired securities
Bulk deleting expired securities from the Warrants folder
Finished deleting expired securities

======= World Indices ====================================
Distributing World Indices...
Records updated: 54
01/04/2022 World Indices distributed in 0.4 seconds

Update Procedures Complete

^ Top
aztrix

Veteran
100
Posts: 116

Joined: 6/16/2004
Location: Sydney, NSW, Australia

User Profile
 
Subject : RE: ASX Symbol Names Bug
Posted : 4/22/2022 5:32 AM
Post #48636 - In reply to #48575

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

Attached file : OT22 - Restart Error #0.PNG (5KB - 212 downloads)
Attached file : OT22 - Restart Error #1.PNG (4KB - 217 downloads)
Attached file : OT22 - Restart Error #2.PNG (4KB - 213 downloads)
Attached file : OT_220422_143909.log (23KB - 220 downloads)
Attached file : OT_220422_144220.log (19KB - 219 downloads)

^ Top
Barry Cohen

Sage
5000100010010010025
Posts: 6338

Joined: 1/19/2004

User Profile
 
Subject : RE: ASX Symbol Names Bug
Posted : 4/22/2022 5:01 PM
Post #48637 - In reply to #48636

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
100
Posts: 116

Joined: 6/16/2004
Location: Sydney, NSW, Australia

User Profile
 
Subject : RE: ASX Symbol Names Bug
Posted : 4/25/2022 1:18 AM
Post #48638 - In reply to #48637

Thanks Barry, seems to have resolved the issue
^ Top
aztrix

Veteran
100
Posts: 116

Joined: 6/16/2004
Location: Sydney, NSW, Australia

User Profile
 
Subject : RE: ASX Symbol Names Bug
Posted : 4/26/2022 1:40 AM
Post #48641 - In reply to #48637

I spoke to soon, same thing just happened today, please find attached OT log

Attached file : OT.log (74KB - 217 downloads)

^ Top
Barry Cohen

Sage
5000100010010010025
Posts: 6338

Joined: 1/19/2004

User Profile
 
Subject : RE: ASX Symbol Names Bug
Posted : 5/3/2022 12:46 PM
Post #48657 - In reply to #48641

Does it error when your database is set to AU, US, or both?
^ Top
aztrix

Veteran
100
Posts: 116

Joined: 6/16/2004
Location: Sydney, NSW, Australia

User Profile
 
Subject : RE: ASX Symbol Names Bug
Posted : 5/4/2022 5:21 AM
Post #48658 - In reply to #48657

It only seems to be US Barry
^ Top
Barry Cohen

Sage
5000100010010010025
Posts: 6338

Joined: 1/19/2004

User Profile
 
Subject : RE: ASX Symbol Names Bug
Posted : 5/4/2022 8:46 AM
Post #48659 - In reply to #48658

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
100
Posts: 116

Joined: 6/16/2004
Location: Sydney, NSW, Australia

User Profile
 
Subject : RE: ASX Symbol Names Bug
Posted : 5/6/2022 1:53 AM
Post #48660 - In reply to #48659

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

Jump to page : 1
Now viewing page 1 [25 messages per page]
back reply

Legend    Action      Notification  
Administrator
Forum Moderator
Registered User
Unregistered User
E-Mail this thread to a friend
Toggle e-mail notification


Nirvana Systems
For any problems or issues please contact our Webmaster at webmaster@nirvsys.com.