> get_symbology(list("LU0070214613"), from_symbol_type="ISIN", to_symbol_type="RIC",debug=TRUE)
[1] "Request *************************************"
{"Entity":{"E":["SymbologySearch"],"W":{"symbols":[["LU0070214613"]],"from":["ISIN"],"to":[["RIC"]],"bestMatchOnly":[true]}}}
[1] "Response *************************************"
[1] "{\"mappedSymbols\":[{\"bestMatch\":{\"error\":\"No best match available\"},\"symbol\":\"LU0070214613\"}]}"
[1] "Response status *************************************"
[1] 200
I am using R to retrieve data. Symbology works very badly. It does not resolve many ISINs that are in the system. The example of code and json request and response are above.
This ISIN is recognized in the search field of Eikon terminal. It is also successfully resolved by Datastream XREF. I have a long list of ISINs. The best matching ability was from Bloomberg SECF call. Datastream XREF was able to recongnize not as many. The symbology call resolved a small fraction relative to Datastream (ca. 20%)
Is there another alternative to getting RICs based on ISINs?
EDIT: The ISIN gets resolved into "lipperID" (the type is not documented by the author of the package: it would be nice to have a full list of admissible values!). Then if I add "LP" to Lipper ID of 60003513, as it is how RICs are formed and try to get its ISIN it does get correctly resolve to the ISIN I started with. So the information is in the system, but it does not get retrieved correctly.
> get_symbology(list("LP60003513"), from_symbol_type="RIC", to_symbol_type="ISIN",debug=TRUE)
[1] "Request *************************************"
{"Entity":{"E":["SymbologySearch"],"W":{"symbols":[["LP60003513"]],"from":["RIC"],"to":[["ISIN"]],"bestMatchOnly":[true]}}}
[1] "Response *************************************"
[1] "{\"mappedSymbols\":[{\"bestMatch\":{\"ISIN\":\"LU0070214613\"},\"symbol\":\"LP60003513\"}]}"
[1] "Response status *************************************"
[1] 200
Symbol ISIN
1 LP60003513 LU0070214613
Any recommendation for the recommended list of output ID types (I have stocks, warrants, bonds and mutual funds, maybe more, in my list, so I need something very flexible to retrieve price information on the securities in my other dataset)? All advice is greatly appreciated.
I also the this "bestMatchOnly" option in the JSON call. Any chance to get more than one match then? It is not documented in the R package and not something mentioned in the Python webinar.
