Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
5 2 2 3

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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
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
78.8k 250 52 74

@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
17.1k 80 39 63

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
18.2k 21 13 21

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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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