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
5 0 0 4

Is there any way to return specific time every day? For example, I want to retrieve close price for 8 pm for GEL= with daily interval as time series. A solution for any api is welcome.

eikonrefinitiv-dataplatform-eikondatascope-select
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.

Upvotes
Accepted
14.9k 32 5 10

hi @bohdan.vahalik ,

In case you'd like to get historical data, you could use Eikon Data API get_timeseries to get hourly data

df =  ek.get_timeseries(['GEL='],
                        ['CLOSE'],
                        start_date='2022-06-01T20:00:00', 
                        end_date='2022-06-24T20:00:00', 
                        interval='hour')
df

then filter only the row with a time equal to 20:00 (please note that this timestamp is GMT, so it needs to be converted to the desired timezone)

import datetime
df.loc[datetime.time(20,0)] #20:00 GMT

1656041544664.png

Hope this helps


1656041544664.png (55.0 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.

Upvotes
6.5k 21 3 6

Hi @bohdan.vahalik ,



To do this, I tend to use the Windows Scheduler to open Workspace and then run a python script:

https://www.windowscentral.com/how-create-automated-task-using-task-scheduler-windows-10

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.