How to get the history HOLC price of XAU using python api

I want to know how to get the historical(e.g. past 10 trading days) daily HOLC(High, Open, Low, Close) price of XAU using python api.

The following code is my python code,however, I didn't get the data I want.

gold_code = "XAU=" # 黄金现货
fields = ['TR.OPENPRICE', 'TR.HIGHPRICE', 'TR.LOWPRICE', 'TR.CLOSEPRICE']  # 开高低收字段
data = ld.get_history(universe=gold_code, fields=fields, count=10)

Find more posts tagged with

python

forex

#content

Accepted answers

All comments

ujjawal_khandelwal

Hi @Hafads ,
Thank you for reaching out!

To my understanding, XAU= is a Gold Spot Instrument and since the market is open 24*7, we generally do not have a close price for that matter.

Also, the relevant fields for the instrument type and the code which is fetching the required details is as follows:

Interval I used is 1D (1 day) for demo:

gold_code = "XAU="

fields = ['TR.OpenAskPrice','TR.LOWPRICE','TR.HIGHPRICE']

data = ld.get_history(universe=gold_code, fields=fields, start = '2026-01-01', end= '2026-03-03', interval= '1D', count= 10) 

data

You can use the Data Item Browser (DIB) on Workspace to check the relevant fields, the field description and parameters it can accept. Just search for DIB on your LSEG Workspace application to access it.

For more examples and code samples, you can check the __examples__ folder on the Codebook app within LSEG Workspace. (Search for CODEBK to open the codebook app).

Please continue on this thread if you need help further. Thank you : )

Hafads

That's not correct—international gold prices(XAU) do have a closing price, and it is typically based on the closing time of the main contract of the COMEX. After all, there is a daily candlestick chart of XAU. I now need to obtain the corresponding open, high, low, and close prices. How should I write the Python code?Thanks a lot.

Jirapongse

@Hafads

You can ignore the fields parameter to retrieve historical data of real-time fields.

ld.get_history(
    universe = ['XAU='],
    start = '2026-01-01',
    end = '2026-03-04')

It provides BID closes and ASK closes.

EXPLORE OUR SITES