Retrieve LAST_QUOTE from Eikon API using python

fgaspar

I need to retrieve LAST_QUOTE data history using python and Eikon API. I want the same output as if using Eikon Excel call:

=RHistory(".IBBEU003D","LAST_QUOTE.Timestamp;LAST_QUOTE.Close","INTERVAL:1D NBROWS:25",,"TSREPEAT:NO")

It would be appreciated if the solution would work for similar data fields.

jason.ramchandani01

@fgaspar So the get_timeseries api call has a reduced datamodel - Open, High, Low, Close, Volume, Count. The Close field in that model is the same as CF_CLOSE - which you can find the description for in the Data Item Browser app. Unfortunately you cannot use the get_timeseries API to request any other fields as a timeseries history. You can use the get_data api call to retrieve non-realtime field history. Something like this would usually work (it does not with the RIC you wanted - see my note below regarding this instrument):

df, err = ek.get_data('VOD.L', fields = ['TR.PriceClose.date','TR.PriceClose','TR.Volume'],parameters={'SDate':'2019-12-01','Frq':'D','EDate':'2020-12-01'})

df

We do however, have another route - which is the Refinitv Data Platform (RDP) APIs and their accompanying ease of use RDP Libraries (Python, Typescript and a community supported .NET version). Eikon users have access to many new services there such as Search APIs, Instrument Pricing and Analytics APIs & much more, and importantly in your case Historical Pricing APIs - these have an enhanced realtime data model of about 30 fields instead of the reduced get_timeseries data model. You can see examples of how to get started (pip install refinitiv.dataplatform) in the links above. You could try something as simple as:

import refinitiv.dataplatform as rdp
import pandas as pd
import numpy as np
session = rdp.open_desktop_session('YOUR EIKON APP KEY HERE')

rdp.get_historical_price_summaries('VOD.L')

Now unfortunately - the RIC you were initially looking for .IBBEU003D is not yet available via this service, but many others will be - so it may help you in future.

In terms of Data Item Browser usage you should type in an instrument and then you can also get values. The instrument you were looking for is a contributed index which is using illogical Fields or FIDs - so it is slightly more complicated than more standard instruments. If you need more help with that particular instrument and field meanings or where things are located please open a ticket with our content support team using Contact Us in the main Eikon menu and specifying a content query.

I hope this can help.