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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
3 0 0 1

Can I choose the weekday for which I want to obtain weekly stock prices via get_timeseries? Seems like weekly price data is always located to Fridays.

no matter which date I choose, the weekly data is always shown for Fridays:

In[124]: ek.get_timeseries('ALGN.O', fields='CLOSE', start_date='2019-09-24', interval='weekly')
Out[124]: 
ALGN.O       CLOSE
Date              
2019-09-27  175.84
2019-10-04  181.59
2019-10-11  200.16
ek.get_timeseries('ALGN.O', fields='CLOSE', start_date = '2019-09-26', interval = 'weekly')
Out[125]: 
ALGN.O       CLOSE
Date              
2019-09-27  175.84
2019-10-04  181.59
2019-10-11  200.16
2019-10-18  213.88

Would be great if somebody could help along.

Thanks and regards

Kilian

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
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.

1 Answer

Upvotes
Accepted
18k 21 12 20

Hi @kilian

The reporting date is at the end of the period.

For example, monthly - end of the month, weekly - end of the week, yearly - end of the year.

I also checked https://docs-developers.refinitiv.com/1571982546960/14684/book/en/eikon/index.html#get_timeseries and it does not support changing the end of period.

So it is not possible to change.

But if you are only interested in CLOSE field.

You can request daily data and drop out other days except for Tue.

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