Duplicate Symbols in Database

[Tony]

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

[Sacha]

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.

[Tony]

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