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?
Upgrade from Eikon -> Workspace. Learn about programming differences.
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)
Hi,
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
5.7k
●21 ●2 ●6
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.
10.2k
●18 ●6 ●9
@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.
