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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
aquilesjlp300 avatar image
98 ●10 ●21 ●27

Issue requesting Chilean Peso fx rates at specific hourly cut-offs.

Hi, I want to request Chilean Peso FX rate using Eikon, in a specific Hourly Rate. But I'm having trouble with it.


When I try this, it works:

data = ek.get_data(["CLP="], ["TR.MIDPRICE", "TR.MIDPRICE.CalcDate"], {'sdate': '04/01/2021', 'edate':'04/06/2021'})

Result:

(  Instrument  Mid Price   Calc Date
0       CLP=    717.130  2021-04-01
1       CLP=    717.130  2021-04-02
2       CLP=    721.505  2021-04-05
3       CLP=    717.880  2021-04-06, None)

But when I try this it doesn't:

data = ek.get_data(["CLP16H="], ["TR.MIDPRICE", "TR.MIDPRICE.CalcDate"], {'sdate': '04/01/2021', 'edate':'04/06/2021'})


Why is that? Is it related to this other issue? https://community.developers.refinitiv.com/questions/54371/no-data-in-cf-volume-and-acvol-1-for-chilean-excha.html


Thanks for any input you might provide.

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
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.

1 Answer

Upvote
Accepted
Alex Putkov.1 avatar image
39.2k ●75 ●11 ●27

@aquilesjlp300

I have no problem retrieving data for CLP16H= using your code snippet on my end. What do you get when you execute it? Is there anything in the error object returned by get_data method? The error object is the second element of the tuple returned by get_data.

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.

aquilesjlp300 avatar image aquilesjlp300

@Alex Putkov. hi, thanks again for your attention. I managed to catch a typo in my notebook on my end which did not reflect what I wrote over here in my post. After making the proper edit I also got the data back. I simply forgot to reply so.

Thank you! And my apologies.


Click below to post an Idea Post Idea