data = rdp.search( view = rdp.SearchViews.CdsQuotes, filter = filterStr, select = srchfields, top = N)
I cannot find the 'Official Close' or something similar. Where can I find the correct variable?
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
1
●0 ●0 ●0
How can I find quotes (official closes) via Refinitiv API?
filterStr = "IndustrySectorDescription eq 'Sovereign'"srchfields = "RIC, ExchangeCountry, IndustrySectorDescription, ContractCdsTermCode"N = 40
data = rdp.search( view = rdp.SearchViews.CdsQuotes, filter = filterStr, select = srchfields, top = N)
data = rdp.search( view = rdp.SearchViews.CdsQuotes, filter = filterStr, select = srchfields, top = N)
1.4k
●6 ●2 ●2
Hi @r.bouwmans ,
I would advise using ek.get_data to retrieve Close Price data. To do so in tandem with rdp.search, I'd suggest using the search API to get RIC codes of returned instruments (similarly to Marcin's answer) and passing them through a ek.get_data function.
6.7k
●8 ●6 ●7
@r.bouwmans so you should use rdp search to get the universe of RICs you want then pass that list to the ek.get_data() api call and use the TR.SETTLEMENTPRICE field:
df, err = ek.get_data('your list of rics',['TR.SETTLEMENTPRICE.date','TR.SETTLEMENTPRICE'])
df
I hope this can help.
