JustData ASX Ticker symbol and Stock name do not align

AmiBroker
1

HI,
I am very much a newbie and would appreciate any help with this annoying problem.
I am in Australia and get data from JusData subscribing to US and Australian exchanges. However with some symbols in my Australian data the name of the stock is transferred form the equivalent US stock ( so CSL Australia - name CSL, is now named Carlisle Companies -NYSE -CSL). It only occurs when there is the same symbol on the ASX and one of the US exchanges The US data is unaffected. this seems to occur randomly although I have not checked every possible stock where there is a similar symbol across two exchangesI have checked my data source and the data is coming in with the correct names.
I have tried'Update US symbol list' and Cleanup data with no improvement.
Can anyone advise how to solve?
Thanks

2

The symbol has to be UNIQUE. Therefore your ASX data can't use same symbols as US symbols. If there is a conflict you should be making them unique by, for example, adding a suffix, like .AX (convention used by Yahoo).
If your data source does not allow to use different symbols / suffixes, you should keep your ASX data in separate database.

Also "Update US symbol list" will ADD US symbols to your database and assign US-symbol names and company names. Obviously when you already have a conflicting symbol in your ASX database doing "Update US symbol list" would add US company name to your conflicting ASX symbol, so - don't use Update US symbol list on ASX database that does NOT use suffixes to make the symbols unique.

3

Hi Tomasz

Thanks for your prompt reply, however I already have my data in 3 separate databases- Indices, USA and Australia. I have been using AmiBroker and my data supplier (JustData) now for many years but this problem has only emerged in the last couple of months, so I think something has changed but I am not aware I have done anything different. I am still using v6.20.1 and otherwise it is working fine

Thanks

Graham

Sent from my iPhone

On 28 Jul 2023, at 6:28 pm, Tomasz Janeczko via AmiBroker Community Forum forum-notify@amibroker.com wrote:

45x45 Tomasz Owner
July 28

The symbol has to be UNIQUE. Therefore your ASX data can't use same symbols as US symbols. If there is a conflict you should be making them unique by, for example, adding a suffix, like .AX (convention used by Yahoo).
If your data source does not allow to use different symbols / suffixes, you should keep your ASX data in separate database.

Also "Update US symbol list" will ADD US symbols to your database and assign US-symbol names and company names. Obviously when you already have a conflicting symbol in your ASX database doing "Update US symbol list" would add US company name to your

4

Nothing has changed. You just have run "Update US symbols" procedure on your ASX database:

Did you read my previous reply explaining what "Update US symbol list" does?

2 Likes
5

Hi Toamacz,
My reply seems to have been confused. What i had written was that I already have my data from US and Australia in separate databases ( indices are also in a separate database.
I have been using AmiBroker and JustData data for several years but this problem has only emerged over the last couple of months. It was present before I updated the US database.
Thanks for your prompyt reply again
Graham

6

There is nothing in AmiBroker that would modify your data "out of the blue" and "out of of itself". Programs don't think (at least not yet) and don't do things on their own.
If you got full name modified, you must have imported that data to your ASX database.
Knowingly or by mistake. It is enough to have wrong database (say ASX) loaded while you are importing fundamental data from Yahoo using AmiQuote.
That is why I told you to use suffixes for Australian symbols. Should you use .AX suffix, no collision between ASX and US symbols would exist and you would not have imported US company full names onto colliding ASX symbols.

7

@DueDillignce

Graham, for USA and Australia, I would do yourself a favor, due dillignce' and try PremiumData / Norgate for it data quality, survivorship-bias-free, corporate actions, and of course Amibroker integration and organization. Just my 2 cents.

1 Like