Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
55 2 5 9

No data available for the requested date range

hi,

i am using get_timeseries to pull option pricing from the begining of the day until about an hour before the current time.

i am doing this for a long list rics. many of these requests come back with the following warning:

'Error with 'RIC': No data available for the requested date range'

it is not 1 or 2 but about 1/20 requests. this isn't an amount i can ignore. i have followed the source on the platform itself and the data does exist!

please help me this is extremely problematic.

ric examples - some work some dont:

['ABNBX172117000.U', 'ABNBL172117000.U', 'ABNBX232117000.U', 'ABNBL232117000.U', 'ACNX172137000.U', 'ACNL172137000.U', 'ACNX232137000.U', 'ACNL232137000.U', 'ADBEX172162000.U', 'ADBEL172162000.U', 'ADBEX232162000.U', 'ADBEL232162000.U', 'AHTX172101000.U', 'AHTL172101000.U', 'AHTX232101000.U', 'AHTL232101000.U', 'AMBAX172119000.U', 'AMBAL172119000.U', 'AMBAX232119000.U', 'AMBAL232119000.U', 'AMCX172102300.U', 'AMCL172102300.U', 'AMCX232102300.U', 'AMCL232102300.U', 'BILIX172105400.U', 'BILIL172105400.U', 'BILIX232105400.U', 'BILIL232105400.U', 'BLNKX172103100.U', 'BLNKL172103100.U', 'BLNKX232103100.U', 'BLNKL232103100.U', 'BNTXX172127000.U', 'BNTXL172127000.U', 'BNTXX232127000.U', 'BNTXL232127000.U', 'BYNDX172106700.U', 'BYNDL172106700.U', 'BYNDX232106700.U', 'BYNDL232106700.U', 'CHPTX172102100.U', 'CHPTL172102100.U', 'CHPTX232102100.U', 'CHPTL232102100.U', 'CLFX172102000.U', 'CLFL172102000.U', 'CLFX232102000.U', 'CLFL232102000.U', 'CSIQX172103200.U', 'CSIQL172103200.U', 'CSIQX232103200.U', 'CSIQL232103200.U', 'DASHX172115000.U', 'DASHL172115000.U', 'DASHX232115000.U', 'DASHL232115000.U', 'DFSX172111000.U', 'DFSL172111000.U', 'DFSX232111000.U', 'DFSL232111000.U', 'DKNGX172102900.U', 'DKNGL172102900.U', 'DKNGX232102900.U', 'DKNGL232102900.U', 'DKSX172110000.U', 'DKSL172110000.U', 'DKSX232110000.U', 'DKSL232110000.U', 'DOCUX172114000.U', 'DOCUL172114000.U', 'DOCUX232114000.U', 'DOCUL232114000.U', 'ENPHX172120000.U', 'ENPHL172120000.U', 'ENPHX232120000.U', 'ENPHL232120000.U', 'ETSYX172121000.U', 'ETSYL172121000.U', 'ETSYX232121000.U', 'ETSYL232121000.U', 'EXASX172107500.U', 'EXASL172107500.U', 'EXASX232107500.U', 'EXASL232107500.U', 'FDXX172124000.U', 'FDXL172124000.U', 'FDXX232124000.U', 'FDXL232124000.U', 'FSLRX172109500.U', 'FSLRL172109500.U', 'FSLRX232109500.U', 'FSLRL232109500.U', 'FSLYX172104000.U', 'FSLYL172104000.U', 'FSLYX232104000.U', 'FSLYL232104000.U', 'FUBOX172101700.U', 'FUBOL172101700.U', 'FUBOX232101700.U', 'FUBOL232101700.U', 'GMEX172114000.U', 'GMEL172114000.U', 'GMEX232114000.U', 'GMEL232114000.U', 'GRWGX172101400.U', 'GRWGL172101400.U', 'GRWGX232101400.U', 'GRWGL232101400.U', 'HOODX172101900.U', 'HOODL172101900.U', 'HOODX232101900.U', 'HOODL232101900.U', 'KSSX172104900.U', 'KSSL172104900.U', 'KSSX232104900.U', 'KSSL232104900.U', 'LAZRX172101500.U', 'LAZRL172101500.U', 'LAZRX232101500.U', 'LAZRL232101500.U', 'LCIDX172103900.U', 'LCIDL172103900.U', 'LCIDX232103900.U', 'LCIDL232103900.U', 'LENX172111000.U', 'LENL172111000.U', 'LENX232111000.U', 'LENL232111000.U', 'LIX172103100.U', 'LIL172103100.U', 'LIX232103100.U', 'LIL232103100.U', 'MX172102600.U', 'ML172102600.U', 'MX232102600.U', 'ML232102600.U', 'MRNAX172126000.U', 'MRNAL172126000.U', 'MRNAX232126000.U', 'MRNAL232126000.U', 'MTCHX172113000.U', 'MTCHL172113000.U', 'MTCHX232113000.U', 'MTCHL232113000.U', 'NCLHX172102100.U', 'NCLHL172102100.U', 'NCLHX232102100.U', 'NCLHL232102100.U', 'NEGGX172101200.U', 'NEGGL172101200.U', 'NEGGX232101200.U', 'NEGGL232101200.U', 'NETX172114000.U', 'NETL172114000.U', 'NETX232114000.U', 'NETL232114000.U', 'NIOX172103200.U', 'NIOL172103200.U', 'NIOX232103200.U', 'NIOL232103200.U', 'NKLAX172101000.U', 'NKLAL172101000.U', 'NKLAX232101000.U', 'NKLAL232101000.U', 'NVDAX172128000.U', 'NVDAL172128000.U', 'NVDAX232128000.U', 'NVDAL232128000.U', 'OPENX172101400.U', 'OPENL172101400.U', 'OPENX232101400.U', 'OPENL232101400.U', 'PENNX172104800.U', 'PENNL172104800.U', 'PENNX232104800.U', 'PENNL232104800.U', 'PLUGX172103200.U', 'PLUGL172103200.U', 'PLUGX232103200.U', 'PLUGL232103200.U', 'PTONX172104000.U', 'PTONL172104000.U', 'PTONX232104000.U', 'PTONL232104000.U', 'RBLXX172111000.U', 'RBLXL172111000.U', 'RBLXX232111000.U', 'RBLXL232111000.U', 'ROKUX172122000.U', 'ROKUL172122000.U', 'ROKUX232122000.U', 'ROKUL232122000.U', 'SEX172122000.U', 'SEL172122000.U', 'SEX232122000.U', 'SEL232122000.U', 'SFIXX172101900.U', 'SFIXL172101900.U', 'SFIXX232101900.U', 'SFIXL232101900.U', 'SNOWX172135000.U', 'SNOWL172135000.U', 'SNOWX232135000.U', 'SNOWL232135000.U', 'SPWRX172102200.U', 'SPWRL172102200.U', 'SPWRX232102200.U', 'SPWRL232102200.U', 'STNEX172101700.U', 'STNEL172101700.U', 'STNEX232101700.U', 'STNEL232101700.U', 'TDOCX172109200.U', 'TDOCL172109200.U', 'TDOCX232109200.U', 'TDOCL232109200.U', 'TEAMX172136000.U', 'TEAML172136000.U', 'TEAMX232136000.U', 'TEAML232136000.U', 'TWLOX172126000.U', 'TWLOL172126000.U', 'TWLOX232126000.U', 'TWLOL232126000.U', 'UALX172104200.U', 'UALL172104200.U', 'UALX232104200.U', 'UALL232104200.U', 'UPSTX172115000.U', 'UPSTL172115000.U', 'UPSTX232115000.U', 'UPSTL232115000.U', 'XX172102300.U', 'XL172102300.U', 'XX232102300.U', 'XL232102300.U', 'XPEVX172104400.U', 'XPEVL172104400.U', 'XPEVX232104400.U', 'XPEVL232104400.U', 'ZSX172129000.U', 'ZSL172129000.U', 'ZSX232129000.U', 'ZSL232129000.U']


i loop over the following code code:

start date (trade time) is an hour after market opens.

end date (now) is half an hour before running the code.

for i in range(0, len(ric_lst), 4):
df = ek.get_timeseries(ric_lst[i:i + 4], fields=['HIGH'], start_date=trade_time, 
end_date=now, interval='minute')


eikoneikon-data-apipythontimeseries
icon clock
10 |1500

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

here is a screenshot of error

1639512296608.png

1639512296608.png (205.2 KiB)

Hello @rafi.levy1

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS


@rafi.levy1

Hi,

Please let us know if you have any updates on this question.

If it is still an issue, please post again to offer further insight into your question.

Regards,

AHS

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,
AHS

Upvotes
Accepted
32.2k 40 11 20

Hello @rafi.levy1 ,

I understand your question. It looks like not all of this content, and not all the data points are available. I think it may be helpful to compare the results close to realitme, I am gong to assume you are testing in jupyter, if not, just remove the first two redundant lines.

Please run the following little test:

from IPython.core.interactiveshell import InteractiveShell
InteractiveShell.ast_node_interactivity = "all"
from datetime import datetime
now = datetime.now()
now_formatted = now.strftime("%Y-%m-%dT%H:%M:%S")
rics = ['ACNX2321370000.U','AMBAL172119000.U','AMBAL232119000.U']
for ric in rics:
    try:
        df = ek.get_timeseries([ric], fields=['HIGH'], start_date='2021-12-13T00:00:00', end_date=now_formatted, interval='minute')
        df
    except:
        print('Exception')

My result, today at current time is:

tst.gif

what do you see on your side? I would expect the first RIC to come up as invalid, and the data points be dependent on when you run the test, but to look similar.

If this is the case, and you feel the result is incorrect, the next step is opening a content investigation case, with Refinitiv Workspace/Eikon content experts, to confirm the validity of the results. You can do so directly, as a customer, or I can open one on your behalf.

I also would like to mention that your code does not seem to run "as is" for me. However, this may be due to a side factor. If the above runs as expected, please test this:

from IPython.core.interactiveshell import InteractiveShell
InteractiveShell.ast_node_interactivity = "all"
ric_lst = ['ABNBX172117000.U', 'ABNBL172117000.U', 'ABNBX232117000.U', 'ABNBL232117000.U', 'ACNX172137000.U', 'ACNL172137000.U', 'ACNX232137000.U', 'ACNL232137000.U', 'ADBEX172162000.U', 'ADBEL172162000.U', 'ADBEX232162000.U', 'ADBEL232162000.U', 'AHTX172101000.U', 'AHTL172101000.U', 'AHTX232101000.U', 'AHTL232101000.U', 'AMBAX172119000.U', 'AMBAL172119000.U', 'AMBAX232119000.U', 'AMBAL232119000.U', 'AMCX172102300.U', 'AMCL172102300.U', 'AMCX232102300.U', 'AMCL232102300.U', 'BILIX172105400.U', 'BILIL172105400.U', 'BILIX232105400.U', 'BILIL232105400.U', 'BLNKX172103100.U', 'BLNKL172103100.U', 'BLNKX232103100.U', 'BLNKL232103100.U', 'BNTXX172127000.U', 'BNTXL172127000.U', 'BNTXX232127000.U', 'BNTXL232127000.U', 'BYNDX172106700.U', 'BYNDL172106700.U', 'BYNDX232106700.U', 'BYNDL232106700.U', 'CHPTX172102100.U', 'CHPTL172102100.U', 'CHPTX232102100.U', 'CHPTL232102100.U', 'CLFX172102000.U', 'CLFL172102000.U', 'CLFX232102000.U', 'CLFL232102000.U', 'CSIQX172103200.U', 'CSIQL172103200.U', 'CSIQX232103200.U', 'CSIQL232103200.U', 'DASHX172115000.U', 'DASHL172115000.U', 'DASHX232115000.U', 'DASHL232115000.U', 'DFSX172111000.U', 'DFSL172111000.U', 'DFSX232111000.U', 'DFSL232111000.U', 'DKNGX172102900.U', 'DKNGL172102900.U', 'DKNGX232102900.U', 'DKNGL232102900.U', 'DKSX172110000.U', 'DKSL172110000.U', 'DKSX232110000.U', 'DKSL232110000.U', 'DOCUX172114000.U', 'DOCUL172114000.U', 'DOCUX232114000.U', 'DOCUL232114000.U', 'ENPHX172120000.U', 'ENPHL172120000.U', 'ENPHX232120000.U', 'ENPHL232120000.U', 'ETSYX172121000.U', 'ETSYL172121000.U', 'ETSYX232121000.U', 'ETSYL232121000.U', 'EXASX172107500.U', 'EXASL172107500.U', 'EXASX232107500.U', 'EXASL232107500.U', 'FDXX172124000.U', 'FDXL172124000.U', 'FDXX232124000.U', 'FDXL232124000.U', 'FSLRX172109500.U', 'FSLRL172109500.U', 'FSLRX232109500.U', 'FSLRL232109500.U', 'FSLYX172104000.U', 'FSLYL172104000.U', 'FSLYX232104000.U', 'FSLYL232104000.U', 'FUBOX172101700.U', 'FUBOL172101700.U', 'FUBOX232101700.U', 'FUBOL232101700.U', 'GMEX172114000.U', 'GMEL172114000.U', 'GMEX232114000.U', 'GMEL232114000.U', 'GRWGX172101400.U', 'GRWGL172101400.U', 'GRWGX232101400.U', 'GRWGL232101400.U', 'HOODX172101900.U', 'HOODL172101900.U', 'HOODX232101900.U', 'HOODL232101900.U', 'KSSX172104900.U', 'KSSL172104900.U', 'KSSX232104900.U', 'KSSL232104900.U', 'LAZRX172101500.U', 'LAZRL172101500.U', 'LAZRX232101500.U', 'LAZRL232101500.U', 'LCIDX172103900.U', 'LCIDL172103900.U', 'LCIDX232103900.U', 'LCIDL232103900.U', 'LENX172111000.U', 'LENL172111000.U', 'LENX232111000.U', 'LENL232111000.U', 'LIX172103100.U', 'LIL172103100.U', 'LIX232103100.U', 'LIL232103100.U', 'MX172102600.U', 'ML172102600.U', 'MX232102600.U', 'ML232102600.U', 'MRNAX172126000.U', 'MRNAL172126000.U', 'MRNAX232126000.U', 'MRNAL232126000.U', 'MTCHX172113000.U', 'MTCHL172113000.U', 'MTCHX232113000.U', 'MTCHL232113000.U', 'NCLHX172102100.U', 'NCLHL172102100.U', 'NCLHX232102100.U', 'NCLHL232102100.U', 'NEGGX172101200.U', 'NEGGL172101200.U', 'NEGGX232101200.U', 'NEGGL232101200.U', 'NETX172114000.U', 'NETL172114000.U', 'NETX232114000.U', 'NETL232114000.U', 'NIOX172103200.U', 'NIOL172103200.U', 'NIOX232103200.U', 'NIOL232103200.U', 'NKLAX172101000.U', 'NKLAL172101000.U', 'NKLAX232101000.U', 'NKLAL232101000.U', 'NVDAX172128000.U', 'NVDAL172128000.U', 'NVDAX232128000.U', 'NVDAL232128000.U', 'OPENX172101400.U', 'OPENL172101400.U', 'OPENX232101400.U', 'OPENL232101400.U', 'PENNX172104800.U', 'PENNL172104800.U', 'PENNX232104800.U', 'PENNL232104800.U', 'PLUGX172103200.U', 'PLUGL172103200.U', 'PLUGX232103200.U', 'PLUGL232103200.U', 'PTONX172104000.U', 'PTONL172104000.U', 'PTONX232104000.U', 'PTONL232104000.U', 'RBLXX172111000.U', 'RBLXL172111000.U', 'RBLXX232111000.U', 'RBLXL232111000.U', 'ROKUX172122000.U', 'ROKUL172122000.U', 'ROKUX232122000.U', 'ROKUL232122000.U', 'SEX172122000.U', 'SEL172122000.U', 'SEX232122000.U', 'SEL232122000.U', 'SFIXX172101900.U', 'SFIXL172101900.U', 'SFIXX232101900.U', 'SFIXL232101900.U', 'SNOWX172135000.U', 'SNOWL172135000.U', 'SNOWX232135000.U', 'SNOWL232135000.U', 'SPWRX172102200.U', 'SPWRL172102200.U', 'SPWRX232102200.U', 'SPWRL232102200.U', 'STNEX172101700.U', 'STNEL172101700.U', 'STNEX232101700.U', 'STNEL232101700.U', 'TDOCX172109200.U', 'TDOCL172109200.U', 'TDOCX232109200.U', 'TDOCL232109200.U', 'TEAMX172136000.U', 'TEAML172136000.U', 'TEAMX232136000.U', 'TEAML232136000.U', 'TWLOX172126000.U', 'TWLOL172126000.U', 'TWLOX232126000.U', 'TWLOL232126000.U', 'UALX172104200.U', 'UALL172104200.U', 'UALX232104200.U', 'UALL232104200.U', 'UPSTX172115000.U', 'UPSTL172115000.U', 'UPSTX232115000.U', 'UPSTL232115000.U', 'XX172102300.U', 'XL172102300.U', 'XX232102300.U', 'XL232102300.U', 'XPEVX172104400.U', 'XPEVL172104400.U', 'XPEVX232104400.U', 'XPEVL232104400.U', 'ZSX172129000.U', 'ZSL172129000.U', 'ZSX232129000.U', 'ZSL232129000.U']
from datetime import datetime
now = datetime.now()
now_formatted = now.strftime("%Y-%m-%dT%H:%M:%S")
for ric in ric_lst:
    try:
        df = ek.get_timeseries(ric, fields=['HIGH'], start_date='2021-12-13T00:00:00', end_date=now_formatted, interval='minute')
        df
    except:
        print('Exception')

This produces similar output for me, per RIC requested.

This should, hopefully, allow us to better understand and to narrow down the issue that you are facing?


tst.gif (34.5 KiB)
icon clock
10 |1500

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

it seems that in your sample you added a 0 at the end of the ric.
i wrote: ACNX232137000.U, this is a valid ric

you wrote: ACNX2321370000.U this is not.

i get this problem with many rics and it changes throughout the day i check nearly all of them on the platform to see if they are valid


i will run your suggestion and get back to you
thank you very much i appreciate the patiance

Upvotes
32.2k 40 11 20

Hello @rafi.levy1 ,

From my sample verification of a couple of the provided instruments (the top 3), some appear to be invalid instruments, while others return the limited number of HIGH data points from the beginning of day today:

now = datetime.now()
now_formatted = now.strftime("%Y-%m-%dT%H:%M:%S")
rics = ['ACNX2321370000.U','fake','AMBAL172119000.U','AMBAL232119000.U']
for ric in rics:
    try:
        df = ek.get_timeseries([ric], fields=['HIGH'], start_date='2021-12-13T00:00:00', end_date=now_formatted, interval='minute')
        df
    except:
        print('Exception')

Resulting in:

err.gif

Therefore, it appears that some of the data you are requesting is available, and some is not available.

However, for the definitive and in-depth advice on content availability, for example on what content is available, when it is available, why a specific number of data points is available, or when it becomes available, I would suggest to contact Refinitiv Eikon content experts directly, via Refinitiv Helpdesk Online -> Content -> Eikon. Please also let us know, if you are unable to proceed on this, and would like a hand, we will submit on your behalf.


err.gif (27.6 KiB)
icon clock
10 |1500

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

I didn't have 'fake' anywhere on my list. This are all valid Ric's with data on the platform which I can see. I do not understand why it isn't returning data, for every error I got I copied the roc to eikon bar and saw the data exists.

Hello @rafi.levy1 ,

I was trying to show how a non-existent instrument would behave, returning "Invalid RIC", any non-existent instrument, such as 'ACNX2321370000.U' and used RIC 'fake' as an example of that, only.

sorry I misunderstood your example. thank you for the clarification.


I will explain my issue again:
these rics are valid rics. iIuse them for other data pulling which works fine. I copied them to eikon bar and Isee the data I need under them.
this is why this is a problem,

if the data isn't available I would like to know why, and that it isn't possible to pull in another way, thank you for your patiance

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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