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)

rdp.get_search_metadata(view = rdp.SearchViews.CdsQuotes)

I cannot find the 'Official Close' or something similar. Where can I find the correct variable?

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

jonathan.legrand

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.

All comments

jonathan.legrand

Hi @r.bouwmans ,

jason.ramchandani01

@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.

EXPLORE OUR SITES