What does the 'CH':'Fd' parameter mean when using ek.get_data ?

Question

Question by blucap · Sep 04, 2019 at 09:11 PM · python get_data get_data params python eikon api

I am using this command to get the total returns on a day for a range of dates:

ek.get_data(firms, fields = ['TR.TotalReturn1D.date','TR.TotalReturn1D'], parameters={'SDate':Start,'EDate':End,'Frq':'D','CH':'Fd'})

It works, but what does 'CH':'Fd' mean?

0

10 |1500 characters needed characters left characters exceeded

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

Answer 1 · 2019-09-04T22:52:05Z

Best Answer

Answer by jirapongse.phuriphanvichai · Sep 04, 2019 at 10:52 PM

This is a parameter for the TR function in Eikon Excel.

Typically, it is used with RH (row headers). They are used to format the data displayed on the Eikon Excel, as shown below.

However, from my test, these parameters don't affect the result returned by Eikon Data APIs.

ch.png (43.5 KiB)

ex1.png (54.1 KiB)

1 · Share

10 |1500 characters needed characters left characters exceeded

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

Answer 2 · 2019-09-04T22:54:14Z

Answer by nick.zincone.1 · Sep 04, 2019 at 10:54 PM

The "CH:Fd" is relevant within an Excel spreadsheet to "Include Headers" within the sheet. It will have no effect within the Eikon Data APIs.

ahs.png (14.4 KiB)

1 · Share

10 |1500 characters needed characters left characters exceeded

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

Answer 3 · 2019-09-05T00:07:56Z

Answer by chavalit.jintamalit · Sep 05, 2019 at 12:07 AM

Just want to share how to access to document in @jirapongse.phuriphanvichai's answer.

ahs1.png (50.4 KiB)

ahs2.png (176.1 KiB)

1 · Share

10 |1500 characters needed characters left characters exceeded

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