For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 0

get_timeseries : Chain RIC closing yields

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

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythontime-serieschain-ric
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvote
Accepted
9.7k 49 38 60

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.


ahs.png (18.3 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
1 0 0 0

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea