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
jeremiemae.celajes avatar image
3 ●0 ●1 ●7

Delayed update for RIC via API

This data was published at 3.15 pm and was available via the excel add in (and terminal) immediately.


In the python API it was not available until 9pm. That is a 6-hour lag of data delivers from one method to another, a method which in my opinion should be much quicker.



I used CODEBK and below was able to get the data. Below is the code I used.

import refinitiv.dataplatform.eikon as ek

ek.set_app_key('DEFAULT_CODE_BOOK_APP_KEY')


ek.get_timeseries("STK-GO-ARA",

fields="*",

start_date='2024-03-01',

interval='daily')

api.png


Can you confirm if what the issue is in the code client used as there is no delay in Excel nor Eikon terminal.


Code client used:

import eikon as ek

ek.set_app_key('App_Key')


today = datetime.date.today()

ara = ek.get_timeseries('STK-GO-ARA', fields='CLOSE', start_date='2019-01-01')

eikon-data-apipythonworkspace#content
api.png (70.3 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.

3 Answers

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
84.6k ●287 ●53 ●77

@jeremiemae.celajes

I ran the code and got the data properly.

1720153325803.png

The API retrieves data from the source. It can't delay the data. For the ek.get_timeseries method, the data source is the UDF service. Please contact the helpdesk to verify the content on UDF.

The client can verify the retrieved raw data by using the following code.

import eikon as ek
ek.set_log_level(1)
ek.set_app_key('<App key>')

The raw data looks like this:

1720153949787.png

If the client can't see the data in the log, the problem should be in the backend system.

Morever, if the problem happens with the Eikon Data API on the local machine, please try to replicate the issue on the same enviroment as the client (not using CodeBook) because the data sources may be different.


1720153325803.png (19.5 KiB)
1720153949787.png (36.1 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
Jirapongse avatar image
84.6k ●287 ●53 ●77

@jeremiemae.celajes

Thank you for reaching out to us.

I ran the code and got this data.

1719803597076.png

The client can try to use the get_history method in the Refinitiv Data Library for Python instead. 

df = rd.get_history( 
        universe=['STK-GO-ARA'],        
        start='2024-06-01'     
    )

The examples are on GitHub. However, according to the problem statement, it could be the content issue. Therefore, you may contact the helpdesk team to verify when the current data was available in the histoical database.


1719803597076.png (21.4 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.

jeremiemae.celajes avatar image jeremiemae.celajes
Hi @Jirapongse


Checked this in Excel and CODEBK, there are no delays hence it is not a content issue. Could be related to his script or system used to pull the data?

Jirapongse avatar image Jirapongse jeremiemae.celajes

@jeremiemae.celajes

If the client runs the same code at different times and gets different results, it should be a content issue.

jeremiemae.celajes avatar image jeremiemae.celajes Jirapongse

Hi @Jirapongse


I checked this with Content and confirmed there was an outage where there is a delay in update however that was resolved before the update time of the RIC which is 3PM.

As per the below ALERT:

"Issue is ow resolved. Updates resumed at 11:00 GMT after the source resolved the issue. There was no data loss during the outage. Daily aggregated values are unaffected by this incident."


And Content confirmed there as well were no delays post the alert was resolved.


Could this be a delay with PYTHON API?



You also suggested to use get_history however this data library and ‘get_history’ method is an inadequate solution, having read through some of the docs, client need to install a new library and edit a config file, which is not an acceptable solution.


I greatly appreciate your help and confirmation on this.

Upvotes
Jirapongse avatar image
84.6k ●287 ●53 ●77

@jeremiemae.celajes

I don't think the the Python API can delay the data. It just sends a request message to the backend and them process a response message on the backend.

I ran the code and got the following result.

1719913554354.png

Is it delayed? Can you replicate this issue with Eikon Data API on your machine?


1719913554354.png (20.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.

jeremiemae.celajes avatar image jeremiemae.celajes

Hi @Jirapongse


The data is delayed again, still not available via the API were in Eikon, data is already available, and I am not able to replicate using CODEBK.

So, there is nothing wrong with the content but with Python API.


Please see the below screenshot from the client.

python.png


From Eikon, RIC is already updated.


stk-go-ara-q.jpg



Please confirm if why data is being delayed in Python API. Thanks


python.png (31.5 KiB)
stk-go-ara-q.jpg (30.1 KiB)

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.