Historical intraday bid ask in Eikon Excel

Philip
Philip Newcomer
in Eikon Data APIs

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?

Tagged:

Best Answer

  • zoya faberov
    zoya faberov ✭✭✭✭✭
    Answer ✓

    Hello @Philip,

    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.

Answers

  • jason.ramchandani01
    jason.ramchandani01 admin

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

  • Philip
    Philip Newcomer

    both would be great, but ideally excel

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In
Register

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In
Register

Quick Links

Categories