Take the 2-minute tour ×
Quantitative Finance Stack Exchange is a question and answer site for finance professionals and academics. It's 100% free, no registration required.

This question already has an answer here:

I have a large list of US equity tickers such as: "GIRO", "ITUB", "BITA" etc

and I would like to convert them into their corresponding RIC codes. Do you know how can I do it? I have access to Bloomberg and to Thomson EIKON...

Many thanks for your help!

share|improve this question
add comment

marked as duplicate by chriscross, chrisaycock Nov 11 '13 at 15:01

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer

up vote 1 down vote accepted

I think your request is too broad. ITUB, for example is an Italian company and has ADRs traded in several stock exchanges. Hence, if you do search in Eikon, you find multiple tickers for it.

And I failed to find critea, which could yield single return value for each tickers you supplied.

I used request: =RSearch("Equity", "TickerSymbol:" & B3 & "*") where you place your ticker into B3 cell.

For GIRO there are: GIRO.PA GIRO.PA1 GIROp.TQ GIROp.BS GIROp.CHI

For BITA I had: BITA.K BITA.N BITA.TH BITA.P BITA.DG BITA.Z BITA.B BITA.C BITA.W BITA.DY BITA.ZY BITA.PH BITA.MW BITA.DF BITA.ITC BITA.NB

And there were ever more tickers for ITUB. When I added search criteria, number of results decreased.

I have no Bloomberg, but when I used http://bsym.bloomberg.com/sym/ I had similar results:

Symbol: ITUB

Market Sector: Equity

Security Type: ADR, Common Stock

And there were 14 BBGIDs.

Hence, I think there's no direct way to do it.

share|improve this answer
    
thank you very much rustam for your nice answer. actually what is just want to do is to merge a file which contains equity tickers with a file which contains RIC codes. for the examples you provided, I have the feeling that the RIC code is merely the ticker + some ".whatsoever" stuff. In that case I would merge just on the basis of the ticker. What do you think? Many thanks! –  Noobie Nov 11 '13 at 15:31
    
Looks like that's the case. Unfortunately, I can't say for sure, but I'd suggest you to try. –  Rustam Nov 11 '13 at 15:37
add comment

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