Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 2 1 2

How to get only recent few days data?

Hi am using the python API to query recent data with ek.get_data function.

Using the following method to get RIC data, it takes a lot of time and processing to obtain and write in to VBA. So, are there any ways to setup the get_data time for few days?

https://community.developers.refinitiv.com/questions/36138/python-api-get-all-listed-markets.html
eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-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
18.2k 21 13 21

Hi @dsn

The answer in generic is that you can use Data Item Browser to check if the field you are retrieving the data can support date range or not.

To launch Data Item Browser, type "DIB" on Eikon Search Bar and press enter.


For examle:

TR.CLOSEPRICE field supports date range but TR.RICCode does not support date range



ahs.png (124.9 KiB)
ahs1.png (12.8 KiB)
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.

Hi @chavalit-jintamalit


Im looking for something similar - close prices of a stock price for yesterday, for 5 days previous, for 10 days previous, and 30 days previous. Basically, I want the close prices for particular days (today-1, today-5, today-10, today-30) rather than needing to specify exact dates. If this is possible, does it account for trading days only, and weekends?

Also, its there a simpler way to have the results displayed in columns, rather than rows? or do i have to pivot() the df?

Thank you

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.