Stockalyze

STOCKALYZE => General Discussion => Topic started by: Tony on October 31, 2019, 11:31:17 AM

Title: Duplicate Symbols in Database
Post by: Tony on October 31, 2019, 11:31:17 AM
I notice that when I use a symbol from the AMEX exchange via Yahoo, there are two symbols that show up. One from AMEX and other from NYSEMKT.

Are they in fact two separate entries in the database?

Which one would be the correct one to use?

Should I delete one of them?

Thanks,
Tony
Title: Re: Duplicate Symbols in Database
Post by: Sacha on October 31, 2019, 04:29:12 PM
As of now all stocks symbols are unique within a single data-provider. So it doesn't matter which one you use. The downloaded data will be exactly same. If you want you can delete the duplicate.

Just for information, this wasn't the case earlier when google was also a data-provider in Stockalyze. Google's symbols were not unique but they were unique within one country. And exchange name was needed to download price data. Google no longer supports price history and so that problem is no longer there.

Regarding duplicate symbols I will find time to clean them up and also update them. But it may take some time.
Title: Re: Duplicate Symbols in Database
Post by: Tony on November 01, 2019, 04:56:05 AM
Thanks for the explanation. I just wasn't sure if deleting either of them would somehow corrupt the database.

I will delete the duplicates as I come across them.

Thanks,
Tony