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.