How to get LME data earlier?

hyeonyeop
hyeonyeop
in Eikon Data APIs

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.


Tagged:

Best Answer

  • jonathan.legrand
    jonathan.legrand
    Answer ✓

    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.

Categories