Hot answers tagged reuters
Here are some pointers. First of all: What you list as a Reuters RIC, RSF.ANY.AAPL.OQ, is not really a RIC, only the AAPL.OQ is. The initial part is some stuff which is essentially site specific and tells me that you are working on a site that has a legacy RTIC infrastructure (some Reuters/TIBCO technology which is quite old these days and for all ...
Bloomberg equity codes are usually quite easy to derive if you know the ticker (though you may have to replace dashes/spaces/slashes for preferred and multi-class shares). This is just for equities though and this is definitely not the case for futures. RICs are a different story. In the US, you need to know on what exchange the ticker is listed to get the ...
I will be adding here some resources that I found during the research, hopefully it will turn useful for others: http://www.linkedin.com/groups/master-symbol-database-most-cost-98173.S.51776671
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 & ...
Bloomberg provides unique identifiers, I assume Reuters does the same thing. It might be a good idea to use those, or at least track them. Presumably you have pricing data on each of these? You could always check a few close prices against each other to check if you have matched the strings correctly.
Only top voted, non community-wiki answers of a minimum length are eligible