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
1 0 0 1

Different HST_CLOSE between API Python and excel with refinitiv

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

pythonworkspace#content
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.

1 Answer

· Write an Answer
Upvotes
Accepted
6.9k 21 3 6

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.

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.