Different HST_CLOSE between API Python and excel with refinitiv

fabrice02

Hello,

We're trying to write a python script to get HST_CLOSE and ADJUST_CLS.

But when we compare with excel and python we get different HST_CLOSE. Has someone an explanation?

Python results:

{
    "data": [
        {
            "Instrument": "AMZN.O",
            "ADJUST_CLS": 182.15,
            "HST_CLOSE": 180.75
        },
        {
            "Instrument": "AAPL.O",
            "ADJUST_CLS": 189.99,
            "HST_CLOSE": 189.98
        },
        {
            "Instrument": "META.O",
            "ADJUST_CLS": 479.92,
            "HST_CLOSE": 478.22
        },
        {
            "Instrument": "QQQ.O",
            "ADJUST_CLS": 459.68,
            "HST_CLOSE": 457.95
        }
    ],
    "no_data_symbols": []
}

Excel results

jonathan.legrand

Hi @fabrice02,

Please note that this Q&A forum is for LSEG API technical questions only. For content questions such as yours, please refer to my.refinitiv.com.