primary listing exchange with refinitiv.get_data

mjg

hello,

using DIB i see fields like

LIST_MKT

CF_EXCHNG

etc

i am unable to get data back when i pass a list of cusips to

df = rd.get_data(my_list_of_cusips, [ 'LIST_MKT', 'CF_EXCHNG'])

is there another field i can use? shuold i be able to tell that in DIB? are these fields unavailable via rd.get_data, but available via the old eikon get data? i am confused. this seems like a very simple thing to query

Jirapongse

@mjg

Thank you for reaching out to us.

Those fields are real-time fields. Typically, real-time fields work with RICs.

Therefore, you need to convert CUSIPs to RICs.

rd.get_data(["459200101"],fields= ["TR.RIC"])

Then, use RICs to get real-time fields.

rd.get_data(["/IBM","/GOOG.OQ","/AAPL.OQ"],fields= ['LIST_MKT', 'CF_EXCHNG'])

I prefixed all RICs with the '/' character because I don't have permissions to access real-time data of those RICs.

mjg

how can i query for primary listening exchange WITHOUT needing real time data?

Jirapongse

https://community.developers.refinitiv.com/discussion/comment/112891#Comment_112891

@mjg

You can use the Eikon Data API in the RD library.

df, err = ek.get_data(["IBM","GOOG.OQ","AAPL.OQ"],fields= ['LIST_MKT', 'CF_EXCHNG'])
df