Historical bid/ask FX Eikon API

JIAN.DU

Hi Reuters,

I am currently using a python script that links up our FX OMS database with Eikon python API, to check if the rate we are getting are within pre agreed discretionary spread off the BBO at the time. Think of it as a real time sanity check/fat finger monitor.

Currently I am using get_data which pulls in the best bid/ask for FX eg PHP= at time we get the FIX fill. It works fine however I am looking to be able to pull one historical data point given a date/time such as when my code crashes... don’t want to compare historical fills against real time/current rates

Get_timeseries would be best for this however believe it doesn’t support bid/ask, and seems like get_data doesn’t support historical time?

Zhenya Kovalyov

That's correct. You can access only the interday time series with the get_data() call, while get_timeseries() currently exposes only the default view, which is BID for PHP=, so there is not really a solution for what you would like to do in Python.

You can use RHistory COM API in Excel VBA for this purpose or the .NET Time series data API.