Author Topic: Duplicate Symbols in Database  (Read 439 times)

Tony

  • Hero Member
  • *****
  • Posts: 50
    • View Profile
Duplicate Symbols in Database
« on: October 31, 2019, 03:31:17 PM »
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

  • Administrator
  • Hero Member
  • *****
  • Posts: 570
    • View Profile
    • Stockalyze: Analyze Stocks freely and affordably.
Re: Duplicate Symbols in Database
« Reply #1 on: October 31, 2019, 08: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.
Stockalyze Support
Let's be friends

Tony

  • Hero Member
  • *****
  • Posts: 50
    • View Profile
Re: Duplicate Symbols in Database
« Reply #2 on: November 01, 2019, 08: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