How to obtain the closing price of the bond for multiple trading days?I can only get one day's cl...

yuyang.1958 · October 2019

...osing price by the following method.

df = ek.get_data("QA182443131=", ['CF_CLOSE'], {'SDate': "2019-10-18", 'EDate': '2019-10-22'})[0]

Jirapongse · November 2019

You can also use the get_timeseries method to retrieve the historical data, as shown below.

chavalit-jintamalit · October 2019

Hi Yuyang

CF_CLOSE field is from realtime database so it does not support historical data.

You can use TR.PriceClose or TR.ClosePrice fields instead.

yuyang.1958 · October 2019

These two fields have been tried, but the data cannot be fetched

chavalit-jintamalit · October 2019

Can you use TR.ASKPRICE, TR.BIDPRICE, TR.MIDPRICE fields ?

Best Answer