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

aquilesjlp300
aquilesjlp300
in Eikon Data APIs

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.

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1
    Answer ✓

    @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.

Answers

  • aquilesjlp300
    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.


Categories