Is there any way to return specific time every day? For example, I want to retrieve close price f...

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.

Find more posts tagged with

eikon

datascope-select

refinitiv-dataplatform-eikon

Accepted answers

raksina.samasiri

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

Hope this helps

All comments

jonathan.legrand

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

raksina.samasiri

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

Hope this helps

EXPLORE OUR SITES