rdp.get_search_metadata(view = rdp.SearchViews.CdsQuotes)
I cannot find the 'Official Close' or something similar. Where can I find the correct variable?
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.
@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.