I'm working on a project that will fetch data from Google Finance and Reuters. In order to avoid keeping two separate lists of stock symbols, I'm looking for some kind of conversion or database or API or anything already built.

Something similar to this question. It's common for venues to abuse the security reference of the primary venue to mean anywhere that this security is traded.

Preferred Ticker Symbols and Names - ywepubuy.web.fc2.com

So - for some venues and data sources - if they talk about trading the LSE-listing of RIO on Bats Europe, they will refer to that as RIO. I believe your examples above have this kind of crossover.

One would refer the price across participating secondary markets, the other to the price specific to the LSE. There are downloads that you can use as Rosetta Stones to convert between representations. For European securities, Bats Europe makes a lot of good information public http: The reference data symbology offered on their website is handy for conversions, and some documents offer close prices.

They're one of the largest secondary markets in Europe, so this is valuable data. Their TRF dataset is significantly larger, and useful for rosetta stone purposes.

AAPL Interactive Stock Chart | Apple Inc. Stock - Yahoo Finance

The conversion database is a good idea. I've been wanting to do this for a while, and laid some groundwork yesterday, which is why all of this is fresh in my mind. You will have to manually find the list of exchange mnemonics for each. Note that till recently NYSE and NASDAQ had an agreement for one to use 3-letter tickers and the other 4-letter tickers to help distinguish the markets apart. Today this means the same ticker symbol may appear on each exchange but represent a different company, Reuters uses the mnemonic.

GOOGLEFINANCE - Docs editors Help

K for when NYSE tickers would overlap. By posting your answer, you agree to the privacy policy and terms of service.

Sign up or log in to customize your list. Stack Exchange Inbox Reputation and Badges. Questions Tags Users Badges Unanswered. Quantitative Finance Stack Exchange is a question and answer site for finance professionals and academics.

Join them; it only takes a minute: Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top. Conversion stock symbols Google Finance vs. Something similar to this question For example, for company "REN - Rede Electrica Nacional", the tickers are: LS Does anyone know if there's already something like this?

Thanks in advance for any help! Nuno Nogueira 2. There isn't a reliable mechanism.

Some things to think about: Craig Turner 21 3. Sign up or log in StackExchange.

Sign up using Facebook. Sign up using Email and Password.

Post as a guest Name. Quantitative Finance Stack Exchange works best with JavaScript enabled. MathOverflow Mathematics Cross Validated stats Theoretical Computer Science Physics Chemistry Biology Computer Science Philosophy more 3. Meta Stack Exchange Stack Apps Area 51 Stack Overflow Talent.