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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
9 0 0 3

retrieve FX Polls from Eikon

Hi I am trying to retrieve historical FX polls from Eikon. I am able to do it in Excel using

RHistory("AUD1YP=","FCAST_MED.Timestamp;FCAST_MED.Value","START:01-Mar-2000 END:01-Mar-2020 INTERVAL:1MO",,"TSREPEAT:NO CH:Fd",B2)

But I am having trouble in Python. I am using:

get_data("AUD1YP=", ['FCAST_MED.Value'],{'SDate':'2012-01-01', 'EDate':'2019-12-31', 'FRQ': 'M'})

I also tried get_timeseries but didnt seem to work.

Any idea how to make it work?

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonforex
icon clock
10 |1500

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

Upvotes
Accepted
18k 21 12 20

Hi @ninja

Sorry, I misread the interval in your question.

RHistory("AUD1YP=","FCAST_MED.Timestamp;FCAST_MED.Value","START:01-Mar-2000 END:01-Mar-2020 INTERVAL:1MO",,"TSREPEAT:NO CH:Fd",B2)

You should be able to use this interval with Eikon Data API(Python).



ahs.png (16.9 KiB)
icon clock
10 |1500

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

Upvotes
18k 21 12 20

Hi @ninja

You can get the data back to 90 days using interval = taq

You can also try interval = weekly


If you need the same data as RHistory, It is not possible to retrieve the same data using Eikon Data API(Python)

You have to use Eikon Data API(.NET).

Please see sample code here, https://developers.refinitiv.com/eikon-apis/net-apis-use-custom-applications/learning?content=8724&type=learning_material_item


ahs.png (97.0 KiB)
icon clock
10 |1500

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

Upvotes
9 0 0 3

Thanks @chavalit.jintamalit,

I did try the .NET but I couldnt get it to work using those parameters

WithView("BID")

.WithAllFields()

.WithInterval(CommonInterval.Monthly)

Can you send me an example?

icon clock
10 |1500

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

Click below to post an Idea Post Idea