For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
5 1 1 2

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?

eikoneikon-data-apipythonworkspaceworkspace-data-apirefinitiv-dataplatform-eikon
icon clock
10 |1500

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

Upvote
Accepted
47.4k 111 44 60

@blucap

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)
icon clock
10 |1500

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

Upvote
12.1k 59 39 61

Hi @blucap,

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)
icon clock
10 |1500

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

Upvote
18k 21 12 20

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


ahs1.png (50.4 KiB)
ahs2.png (176.1 KiB)
icon clock
10 |1500

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