df, error = ek.get_data('USDSB3L1Y=TWEB', ['TR.ASKPRICE.Date', 'TR.ASKPRICE','TR.BIDPRICE'], parameters={'SDate':'2017-08-01', 'EDate':'2017-08-04'}) ---------------------------------------------------------------------------------- The code above gives me a daily value at close of day. However, I want to be able to get bid/ask at a specific time to synch with European markets ( 3 p.m. EST ). The get_timeseries() function doesn’t support bid/ask and the get_data() function doesn’t have a clear way of getting 3 p.m. EST bid/ask values. I am able to get this value using the Excel RHistory function by picking a daily 1 hour bar ending at 3 p.m. =RHistory(USDSB3L1Y=TWEB, .TIMESTAMP:BID.CLOSE,END: 01Aug17:15:00 NBROWS:1 TIMEZONE:EST INTERVAL:60M) Is there an equivalent call I can make using the get_data Python function? need bid/ask at specific time of 3 pm EDT
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
1
●0 ●1 ●1
how to get specific bid/ask at 3pm edt
Hi,
Thank you for your participation in the forum.
Is the reply below satisfactory in resolving your query?
If yes please click the 'Accept' next to the appropriate reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
AHS
Hi @mc1,
Thank you for your participation in the forum.
Is the reply below satisfactory in resolving your query?
If yes please click the 'Accept' next to the appropriate reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
39.4k
●77 ●11 ●27
I'm afraid currently there's no way to achieve what you're looking for using Eikon Data APIs. The only two APIs currently available through Eikon that provide this capability are RHistory COM library, which can only be used in Excel VBA, and Eikon .NET API.
