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

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?

Find more posts tagged with

python

eikon

workspace

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.

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.

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.

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