How to get LME data earlier?

hyeonyeop

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:

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

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.

jonathan.legrand

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()

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.