get_timeseries : Chain RIC closing yields

sisa.mayekiso

Hi,

Have the following code looking to extract Closing yields for the 60 attached Chain RIC for the last 12 months. The program runs but there significant gaps in the data output across the various RICS. Is the a better way to make this call to render all the data?This is my code and the Instrument Codes:

data_instr = pd.DataFrame(data_extract,columns= ['Instrument'])

Column_list =[]

for rows in data_instr.itertuples():

my_list = rows.Instrument

Column_list.append(my_list)

stocks_list = Column_list

df = ek.get_timeseries(stocks_list, fields='CLOSE',

start_date="2019-01-01",

end_date="2019-12-31",

interval='daily')

Instrument Codes.txt

nick.zincone

Hi @sisa.mayekiso,

I don't believe it is a function of your specific algorithm that is creating gaps in the data. The data itself, based on the timeframe you specified may not all have the historical close prices. In some cases, I do see gaps within the data when looking at more recent history. This may be due to the nature of the data.

I would suggest you open a ticket within the Refinitiv Helpdesk and provide a few examples of the elements within your list for an explanation as to why there are gaps. For example, I did a quick test for one of the instruments in the month of December, 2019. You can see that there are a number of gaps without Closing data:

Note: Make sure you frame the question around the nature of the data as opposed to the use of the API.

sisa.mayekiso

Thanks Nick! I will route it through my Account Manager to ensure that its framed appropriately to the HelpDesk.