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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
58 2 3 7

get_timeseries `No data available for the requested date range` and other problems

Hi,

I am running the following code:

def getPrices(RIC):
    try:
        return ek.get_timeseries([RIC], interval='quarterly', start_date='1900-12-31')[["CLOSE"]].rename(lambda x: RIC, axis=1)
    except: # ek.EikonError
        return None

exp = "SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), IN(TR.ExchangeCountryCode,""CA""), CURN=CAD)"
equities = ek.get_data(exp,["TR.Instrument", "TR.SharesOutstanding"])[0]
prices = [getPrices(ins) for ins in equities.Instrument]

There are a few problems right now.

1. I'm getting a large number of "No data available for the requested date range" (e.g. for RIC VIBE.CD) After adjusting the date range, the same RICs still return the same error message.

2. This is taking a very long time, probably because I am getting time series for each of the 3000+RIC's retrieved from the screen. Is there a more efficient way to achieve the same goal?

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.

1 Answer

Upvote
Accepted
4.6k 26 7 22

@dshi

1. VIBE.CD started trading on the 3rd of April 2019, hence you see no quarterly data.

2. You can request the first trading date (TR.FirstTradeDate) for each equity, map it to a specific quarter and then request the time series.

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.

I see, Thanks!

Click below to post an Idea Post Idea