Is it possible to get in one call, a time-series of intraday numbers for "Quotes" , "volume" , and

davide.costanzo
davide.costanzo
in Eikon Data APIs

I'd like to get with one call a time-series of intraday numbers for "Quotes" , "volume" , and "vwap" ? I tried the new python Data Platform which does the job for quotes but 'volume' and 'vwap' are missing. One minute time Interval if possible.



Tagged:

Best Answer

  • jason.ramchandani01
    jason.ramchandani01
    Answer ✓

    @davide.costanzo This call to the historical pricing events can get you trade and quote level details you want. This call does not provide time-aggregated summaries. You would need to do this yourself. 

    df1 = rdp.get_historical_price_events(universe = 'LCOF1', 
                                       eventTypes = ['trade','quote'],   
                                       fields = ['TRDPRC_1','TRDVOL_1','VWAP'])

    display(df1)

    image

    The historical pricing summaries function provide one minute aggregation but no VWAP.

    df1 = rdp.get_historical_price_summaries(universe = 'LCOF1',
                                       interval = rdp.Intervals.ONE_MINUTE, 
                                       fields = ['TRDPRC_1','ACVOL_UNS'])

    display(df1)

    image

    Is this the kind of thing you were after?


Answers

  • jason.ramchandani01
    jason.ramchandani01

    @davide.costanzo do you mean you are using the get_timeseries api call - which does provide OHLC and volume at 1 min resolution?

    Or are you referring to the Refinitiv Data Platform Historical Pricing API ? Please could you provide the API call you are using.

  • davide.costanzo
    davide.costanzo

    thanks for answering. The get_timeseries (of the Eikon API) gives indeed OHLCV candles , while the rdp.get_historical_price_summaries() (of the Eikon Data Platform) provides the QUOTES. I am wondering if it is possible to get the VOLUME and the QUOTES in one call at the same time (and the VWAP possibly), for 1 minute time interval.

  • jason.ramchandani01
    jason.ramchandani01

    @davide.costanzo can you give me an example RIC and I will try to get you the correct API call. For example if its an FX RIC you could use the Count field of the get_timeseries for an indication of volume. VWAP would only come from Historical Pricing Events function - which you may need to aggregate to 1 min horizon. Send me a sample RIC and I will try.

  • davide.costanzo
    davide.costanzo

    thank you! The RIC that I would like for example is LCOF1

Categories