For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
12 1 2 5

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

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.



eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
6.7k 8 6 7

@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)

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)

Is this the kind of thing you were after?



1605801434956.png (97.2 KiB)
1605801757300.png (74.5 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
6.7k 8 6 7

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
12 1 2 5

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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
6.7k 8 6 7

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
12 1 2 5

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea