Is it possible to pull historical bid ask prices for Microsoft, for the past 1 year, during regular trading hours only, at 5 min intervals?
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
Is it possible to pull historical bid ask prices for Microsoft, for the past 1 year, during regular trading hours only, at 5 min intervals?
Hello @philipr,
Please confirm, if you are looking to pull this data in Eikon Excel or Eikon Data API, Python.
Thank you for your participation in the forum. Are any of the replies below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply that best answers your question. 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
Hello @philipr,
For Excel usage questions, for a customer, the best approach is to refer your questions directly to Refinitiv Helpdesk Online -> Eikon, so you can be connected with and helped by Eikon Excel expert. This forum is the way to reserch answers on APIs, this section is dedicated to EDAPI Python.
@philipr I believe it would be possible using the rhistory function in excel - please see the following thread. I am not however sure if that can specify normal market session only.
You can certainly achieve this with our RDP Historical Pricing API:
rdp.get_historical_price_summaries( universe = 'MSFT.O', interval = rdp.Intervals.FIVE_MINUTES, # Supported intervals: ONE_MINUTE, FIVE_MINUTES, TEN_MINUTES, THIRTY_MINUTES, ONE_HOUR count = 500, sessions = [ #rdp.MarketSession.PRE, rdp.MarketSession.NORMAL #rdp.MarketSession.POST ] )
However unfortunately at the moment there is an issue with this endpoint which means it returns minute intervals only (though its easy to resample this in python.). I hope this can help.