How could I adjust ek.get_timeseries in order to make it work for LAST_QUOTE.Close?

susskaya.anita

The following code gets data

ek.get_timeseries(rics=['ARSMPR=BCRA'], fields=["CLOSE"], start_date='2020-01-01',end_date= '2020-01-20', interval = 'daily'),
but the next one does not:

ek.get_timeseries(rics=['NGMPR='], fields=["LAST_QUOTE.CLOSE"], start_date='2020-01-01',end_date= '2020-01-20', interval = 'daily')

Via Excel add-in historical data for NGMPR= we could extract via the following formula:=RHistory("NGMPR=";"LAST_QUOTE.Timestamp;LAST_QUOTE.Close";"START:01-Jan-2020 END:31-Jan-2022 INTERVAL:1D";;"TSREPEAT:NO SORT:ASC CH:IN;Fd";B2)

How could I adapt it for the formula ek.get_timeseries?

raksina.samasiri

Hi @susskaya.anita

according to an answer in this thread, I'm following my colleague's suggestion and found that

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 the note below regarding this instrument):

df, err = ek.get_data('VOD.L', fields = ['TR.PriceClose.date','TR.PriceClose','TR.Volume'],parameters={'SDate':'2020-01-01','Frq':'D','EDate':'2022-01-31'})
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 NGMPR= is not yet available via this service, but many others will be - so it may help you in the future.

However, ticket number 10930190 has been raised to a content specialist via MyRefinitiv asking for the suggestion of the proper field to get LAST_QUOTE.Close price of RIC "NGMPR=" using =@TR excel formula (which can be converted to Eikon Data API get_data function) and the support team is going to contact you soon.

I hope this can help.