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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
5 0 0 2

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
1.9k 12 2 2

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.

Upvote
4.2k 6 5 8

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.