New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
kilian avatar image
3 ●0 ●0 ●2

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-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-api
icon clock
10 |1500

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

1 Answer

· Write an Answer
Upvotes
Accepted
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●21

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 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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