10

I have downloaded a complete list of all NYSE stock symbols from the NASDAQ website here. As it turns out, many of these symbols are not recognized by the yahoo finance page. In particular, there are ticker symbols that use "^" and "/" (eg. VALE/A or CTZ^A) which yahoo finance does not recognize.

I've just noticed that, vice versa, yahoo itself has some conventions (eg. adding ".F" or ".SG" to the symbols) that don't appear on the NASDAQ list I downloaded. Why this incompatibility? Does anyone know how to "translate" the ticker symbols between the NASDAQ list and the yahoo finance webpage? I thought these symbols were supposed to be a sort of universal identifier.

2
  • Have you looked into who is supplying the data for these sites? There is a chance that they may use different delimiters to denote share classes or possibly other components of a stock that may contain special characters that would make it worth noting if there if a FAQ about the tickers listed.
    – JB King
    Sep 4 '13 at 18:51
  • 2
    @JBKing beat me to it, but try replacing them with periods. This is usually used to differentiate between different types/classes of the stock, e.g. common vs. preferred, so some providers will write BRK.A and BRK.B to denote preferred vs. common, while others will write BRK/A and BRK/B. VALE and VALE.P (or VALE/P) are a similar case. Yahoo also uses the ^ to signify indexes, e.g. ^DJI for the Dow Jones. Sep 4 '13 at 18:51
5

There isn't a single universal way to reference a stock, there are 4 major identifiers with many different flavours of exchange ticker (see xkcd:Standards)

  • Exchange Ticker, (i.e. What you got from NASDAQ) these are in different formats on each exchange. They are unique within the exchange but the same Ticker can be used on different exchanges maybe even within the same country (although this seems to be rare). Different finance companies (Yahoo, Google, Bloomberg, Thomson Reuters etc.) seem to use different variations of dots, dashes etc. to denote warrants, rights and different classes of shares.
  • SEDOLs (my favourite) this is as far as I can tell the only globally unique ID that will never cause you any problems since they identify a specific listed instrument on a specific exchange.
  • CUSIPs only unique with a country, only really used in US/Canada
  • ISINs like Cusips but with a country code so they can be used globally

I believe CUSIPs and ISINs represent a specific security rather than a specific listed instrument. This means you can have two listed instruments with one ISIN but different SEDOLs because they are listed in different places. The difference is subtle but causes problems with settlement

Specifically on your question (sorry I got sidetracked) take a look at CQS Symbol convention to see what everything means

2
  • Actually ISIN is the global unique ID. SEDOL and CUSIP are local identifiers...
    – Martin M.
    Aug 30 '17 at 18:55
  • A single ISIN can sometimes map onto one or more SEDOL. For example, Vanguard S&P 500 UCITS ETF is traded on the London Stock Exchange as VUSA (GBP) and VUSD (USD). Both have the same ISIN (IE00B3XXRP09) but different SEDOL (B7NLLS3 and B7NLJN4). Such is the case for many London Stock Exchange-listed ETFs that are traded in multiple currencies.
    – Flux
    Jul 5 at 17:59
2

Nomenclature for stock symbols isn't standardized. Brokers and web sites use a variety of suffixes for non standard symbols. This is particularly maddening for preferred stocks. Fortunately, securities have CUSIP numbers so that other than infrequent human error, ACAT transfers operate efficiently.

To demonstrate the insanity of web site nomenclature for preferred stocks, here's an example for an Alabama Power preferred stock:

 QuantumOnline     -       ALP-Q    
 S&P               -       ALP-Q    
 NYSE              PR      ALPPRQ   
 NYSE Amex         p       ALPpQ    
 Bloomberg        /P       ALP/PQ   
 Charles Schwab   /PR      ALP/PRQ    
 E-Trade           p       ALPpQ    
 Fidelity          PR      ALPPRQ   
 Google Finance    -       ALP-Q    
 JPMorgan          PR      ALP PRQ  
 LPL Financial     '       ALP'Q        
 MarketWatch      .PR      ALP.PRQ  
 Quicken           PR      ALP PRQ  
 TD Ameritrade     -       ALP-Q    
 Vanguard         _p       ALP_pQ   
 Yahoo!           -p       ALP-pQ   
2
  • Meanwhile in Canada we would tend to format as ALP.PR.Q. May 1 '20 at 12:12
  • You're fortunate if they only use one format in Canada. It's annoying to have so many formats here in the US. May 1 '20 at 12:26
2

On NASDAQ the ^ is used to denote other securities and / to denote warrants for the underlying company. Yahoo maybe using some other designators for same.

1
  • Do you have a source for that?
    – vonjd
    Jun 21 at 10:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.