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
hyeonyeop avatar image
1 ●0 ●0 ●0

How to get LME data earlier?

i, Please help me.

I am using theses formula below:

(import refinitiv.data as rd

import eikon as tr)

eg)

tr.get_data("CCBD0","TR.OFFICIALASKPRICE", "TR.LOWPRICE", "TR.HIGHPRICE", "TR.OFFICIALASKPRICE.date")

rd.get_history("CCBD0","OFF_ASK", "LOW_1", "HIGH_1", end='2023-10-31')


AND This is what i got in my log:

1699491380752.png

Then I ask Refinitiv for the log files, and this is what i got:

1699491521092.png


They said it is already updated at 2023-10-31 17:53:18 but when I execute that function up there:

It provided only 2023-10-27's data.

It should be 2023-10-30's data.

Please help me.


eikoneikon-data-apirefinitiv-dataplatform-eikon#technology
1699491380752.png (11.5 KiB)
1699491521092.png (157.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.

wasin.w avatar image   wasin.w

Hello @hyeonyeop

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS

raksina.samasiri avatar image   raksina.samasiri

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,
AHS

1 Answer

· Write an Answer
Upvotes
Accepted
jonathan.legrand avatar image
5.8k ●21 ●2 ●6

Hi @hyeonyeop ,


For a like-for-like comparasion, I believe you would need to specify an end date in both calls, in which case results seem as designed:


import refinitiv.data as rd
try:  # The following libraries are not available in Codebook, thus this try loop
    rd.open_session(
        config_name="C:\\Example.DataLibrary.Python-main\\Configuration\\refinitiv-data.config.json", # this is where my config file is, where my credential details are, to authenticate myself to LSEG's API services
        name="desktop.workspace")
except:
    rd.open_session()

rd.get_data(
    universe="CCBD0",
    fields=["TR.OFFICIALASKPRICE", "TR.LOWPRICE", "TR.HIGHPRICE", "TR.OFFICIALASKPRICE.date"],
    parameters={
        'EDate': '2023-10-31',
        # 'SDate': '2022-11-29',
        })
rd.get_history("CCBD0", ["OFF_ASK", "LOW_1", "HIGH_1"], end='2023-10-31').tail()


1699883240086.png


Note that the `get_history` function is inclusive with regards to (wrt) its upper limit, and `get_data` is exclusive wrt its upper limit.

`get_data` is a rather "raw" function, in that it pings databases and returns data with few/no filters. This is why we do not advise using it, suggesting instead `get_history`, which checks things such as date intervals in an intuitive manner.


1699883240086.png (138.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.

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.