Source for symbol change history
Author: Panache
Creation Date: 10/6/2019 9:25 PM
profile picture

Panache

#1
NASDAQ used to be my best source for finding changed symbols on US securities.
https://www.nasdaq.com/markets/stocks/symbol-change-history.aspx?sortby=OLDSYMBOL&descending=N However, they don't seem to be making that data available any more.

Does anyone have another source (preferably free or at least low cost) for either looking up symbol changes by symbol or a list of symbol changes? Ideally, it should cover all listed and national market symbols.

If not, I'm sure I can get it on Bloomberg. Unfortunately, my nearest Bloomberg terminal isn't real close, so that's not my preferred option.

fyi - https://otce.finra.org/otce/dailyList?viewType=Symbol%2FName%20Changes makes this data available for OTC securities.
profile picture

Eugene

#2
Yes, Nasdaq's recent website overhaul has killed a number of features that relied on it (maybe even the static/fundamental providers, not sure yet).
profile picture

Eugene

#3
Not sure what you meant exactly when saying "changed symbols" but you can follow the Yahoo provider's Classification Groups. With regard to the U.S. and global markets we follow, the lists are updated there on a regular basis. For U.S. stocks they contain NYSE, NASDAQ, AMEX symbol lists as well as various Russell and S&P indices. The constituent lists are actual and taken from the horse's mouth.

Of course it's not a historical source of changed symbols - one would hardly find it available for free.
profile picture

Panache

#4
QUOTE:
Not sure what you meant exactly when saying "changed symbols"

For example, in March Arsanis, Inc. which traded under the symbol ASNS became X4 Pharmaceuticals, Inc. which trades under the symbol XFOR. Since I've spent a lot of time getting my data clean, I used to simply rename the relevant files Wealth-Lab uses to XFOR.* and continue to update that data instead of having to start all over with new data for XFOR.

QuoteMedia has something close to what I'm looking for https://www.quotemedia.com/portal/quote/?qm_symbol=XFOR%3ANDD. However, you have to type in the old name, rather than just the old symbol. Bloomberg is also an option https://www.bloomberg.com/quote/ASNS:US

QUOTE:
you can follow the Yahoo provider's Classification Groups

Without asking you to give away any secrets, are the Classification Groups available somewhere on the Yahoo website or is this something you create? When I go to https://sg.finance.yahoo.com/quote/%5EGSPC/components/, it says "Components data is not available".

If it's something you do,
QUOTE:
the lists are updated there on a regular basis

Can you give me a feel for when they are updated? It's for a different purpose, but I'd like to know how soon after the beginning of each calendar year these are updated.

QUOTE:
The constituent lists are actual and taken from the horse's mouth

I assume you mean that for the S&P Indexes, the data comes from Standard & Poors, etc.
profile picture

Cone

#5
You have to keep up with it, but this will give you the changes for the last several months.
https://stockcharts.com/freecharts/adjusthist.html#d=other|t=

QUOTE:
I used to simply rename the relevant files Wealth-Lab uses to XFOR.*
Wealth-Lab Pro Fidelity data customers can change the names of symbols in the Data Manager > Fidelity Data view. Just click the symbol in the quarantine list, enter the new symbol, click Change Symbol, and patiently wait until the operation completes.

You need to turn on Symbol Management for the quarantine to populate.
profile picture

Eugene

#6
QUOTE:
Without asking you to give away any secrets, are the Classification Groups available somewhere on the Yahoo website or is this something you create?

Yahoo's component lists has proven to be considerably less reliable than one would imagine. They may be inactual, contain wrong constituents or partial lists, not be updated in time, even contain the wrong tickers and so on.

For this reason a solution was created to gather the index/exchange component lists straight from the original source. As it uses different sources it's not limited to polling the websites of global exchanges. A scheduled task updates the lists on a weekly basis.

Until recently it had been querying the Nasdaq website for certain US indices but this had to stop lately with Nasdaq phasing out the valuable service.
profile picture

Panache

#7
QUOTE:
You have to keep up with it, but this will give you the changes for the last several months.
https://stockcharts.com/freecharts/adjusthist.html#d=other|t=

Awesome Cone. That's pretty much what I had to do with the NASDAQ site anyway.

QUOTE:
change the names of symbols in the Data Manager > Fidelity Data view

I assume that only changes the Fidelity data symbols. I have a script written to also change the files for other data providers.

QUOTE:
A scheduled task updates the lists on a weekly basis

Excellent. Can I be even more nosy and ask which day of the week? Every year, I create data sets for the components of the major US indexes as of the first trading day of the year. I've been doing this on a Bloomberg terminal. However, if a can get this through the Yahoo Components (even if it is a couple of days after the beginning of the year), that would make my life a lot easier.
profile picture

Eugene

#8
QUOTE:
Can I be even more nosy and ask which day of the week?

Think end of week (it depends). The data is contained in an XML file that powers the Classification Groups and can be found at:

c:\Users\Windows username\AppData\Roaming\Fidelity Investments\WealthLabPro\1.0.0.0\Data\YahooStaticProvider\YahooClassification.xml
profile picture

Panache

#9
That will work.

QUOTE:
data is contained in an XML file

So when I look at the current XML file, it says:

<CG name="S&amp;P 500" id="y590" type="Symbols" func="4" update="2019-09-27T13:54:56.6552333Z" count="500">

I assume that means it was last updated on 2019-09-27.
profile picture

Eugene

#10
That's right.
profile picture

Cone

#11
Eugene's bot runs every week on Friday morning, and then I put the classification file together with a manual steps and then upload it. Sometimes I keep up with it weekly, but I look at it more as a bi-weekly task ;)

QUOTE:
I assume that only changes the Fidelity data symbols.
Right. It changes the data files and the symbol itself in the all DataSets where that symbol is found for the Fidelity provider only.
This website uses cookies to improve your experience. We'll assume you're ok with that, but you can opt-out if you wish (Read more).