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

Question

question

yuyang.1958

1 ●0 ●2 ●4

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

Oct 23, 2019 at 06:15 AM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Answer 1 · 2019-11-08T06:55:49Z

Jirapongse

38.1k ●69 ●35 ●53

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

1573196110938.png (19.3 KiB)

Nov 08, 2019 at 06:55 AM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Answer 2 · 2019-10-23T06:46:23Z

chavalit-jintamalit

18k ●21 ●12 ●20

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.

Oct 23, 2019 at 06:46 AM

10 |1500

Attachments: Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

yuyang.1958 Oct 23, 2019 at 08:37 AM

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

chavalit-jintamalit yuyang.1958 Oct 23, 2019 at 11:48 AM

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

ahs.png (15.6 KiB)