Download timed out

chetan.mehra

Hi


I am new to Refinitiv and its API. I am trying to download IBES and other fundamental data using Python. We are looking at some 300 tickers and downloading several factors such as Price to Book Value, PE etc.

We have looked at the documentation (not extensively) and the introductory videos and are using the prescribed methods. However we keep getting timed out we we download data. We either get "error 408" or "error 400", see below.

Can someone tell us a way around this issue. Maybe we are just doing it wrong. We are using Anaconda which has Python 3.7, the script is being run on Windows.


The error is below:



File "<ipython-input-86-11c53df5083c>", line 1, in <module>
runfile('C:/Python Scripts/Ref_m-master/temp.py', wdir='C:/Python Scripts/Ref_m-master')

File "C:\Anaconda\lib\site-packages\spyder_kernels\customize\spydercustomize.py", line 827, in runfile
execfile(filename, namespace)

File "C:\Anaconda\lib\site-packages\spyder_kernels\customize\spydercustomize.py", line 110, in execfile
exec(compile(f.read(), filename, 'exec'), namespace)

File "C:/Python Scripts/Ref_m-master/temp.py", line 33, in <module>
data = ek.get_data(stock_list, fields=flds, parameters=params)[0]

File "C:\Anaconda\lib\site-packages\eikon\data_grid.py", line 186, in get_data
result = eikon.json_requests.send_json_request(_endpoint, payload, debug=debug)

File "C:\Anaconda\lib\site-packages\eikon\json_requests.py", line 118, in send_json_request
_check_server_error(result)

File "C:\Anaconda\lib\site-packages\eikon\json_requests.py", line 194, in _check_server_error
raise EikonError(int(server_response['ErrorCode']), error_message)

EikonError: Error code 408 | Request timeout occured

Thanks

chavalit-jintamalit

Hi @chetan.mehra

Please review the API limitation document here.

I assume that you are referring to daily data for 14 years of 300++ RICs which will exceed the limit.

Try to split the RIC list into a smaller list and spit the period into a smaller period as well.

chavalit-jintamalit

Hi @chetan.mehra

Please share the RIC list, field list so I can try the same.

I have no problem trying to get data for 500 instruments.

chetan.mehra

We have over 300 RIC so the list will be long. We are downloading about 14 years of historic data for the files TR.EPSMean.

List below

Ticker HDBK.NS RELI.NS HDFC.NS INFY.NS ICBK.NS ITC.NS TCS.NS KTKM.NS LART.NS SBI.NS AXBK.NS HLL.NS BJFN.NS MRTI.NS INBK.NS ASPN.NS BRTI.NS HCLT.NS MAHM.NS NTPC.NS PGRD.NS ULTC.NS BJFS.NS SUN.NS TITN.NS TEML.NS NEST.NS WIPR.NS ONGC.NS UPLL.NS TISC.NS BAJA.NS GRAS.NS BRIT.NS APSE.NS REDY.NS HROM.NS IOC.NS COAL.NS VDAN.NS HALC.NS TAMO.NS BPCL.NS CIPL.NS JSTL.NS GAIL.NS GOCP.NS DABU.NS EICH.NS BHRI.NS HPCL.NS INBF.NS DIVI.NS PIRA.NS ZEE.NS FED.NS BJAT.NS MRCO.NS SHCM.NS PIDI.NS PLNG.NS HVEL.NS LUPN.NS RATB.NS LICH.NS ABUJ.NS HDFL.NS COLG.NS ARBN.NS YESB.NS SRTR.NS AVEU.NS CCRI.NS CTBK.NS INED.NS BOB.NS INGL.NS BOSH.NS MOSS.NS VOLT.NS ACC.NS APLH.NS RECM.NS TTPW.NS ICIR.NS PAGE.NS ASOK.NS IGAS.NS MRF.NS DLF.NS BFRG.NS MMFS.NS PWFC.NS SIEM.NS IHTL.NS TTCH.NS TAGL.NS BION.NS CUMM.NS PROC.NS ICIL.NS CHLA.NS TRCE.NS CROP.NS NMDC.NS UBBW.NS REXP.NS SBIL.NS JUBI.NS GLSM.NS EXID.NS GODR.NS GRUH.NS FRTL.NS IDFB.NS MBFL.NS BAJE.NS BHEL.NS EDEL.NS TVSM.NS BATA.NS PNBK.NS BRGR.NS ABB.NS TORP.NS ORCL.NS SRFL.NS PIIL.NS MINT.NS SUPI.NS MAXI.NS LTFH.NS AIAE.NS VODA.NS OEBO.NS ADIA.NS GLEN.NS HDFA.NS BANH.NS MUTT.NS TMIN.NS CAST.NS ASPT.NS BLKI.NS GSPT.NS CADI.NS ADAI.NS APLO.NS KANE.NS SANO.NS GENA.NS JNSP.NS INDB.NS CNBK.NS NHPC.NS TOPO.NS AMAR.NS WHIR.NS GLAX.NS HONE.NS PFIZ.NS NATP.NS CNTY.NS ADTB.NS ALKE.NS LRTI.NS HZNC.NS SAIL.NS GILE.NS ABOT.NS ADAN.NS CORF.NS OILI.NS GODI.NS VARB.NS EMAM.NS AUFI.NS SUTV.NS NALU.NS TAMdv.NS ADEL.NS BAYE.NS TATA.NS GMRI.NS JUBI.NS PNBH.NS JSWE.NS UNBK.NS BOI.NS NBCC.NS AJPH.NS ENDU.NS LTEH.NS MOFS.NS INBA.NS QUEC.NS GRPH.NS HEGL.NS RELL.NS MRPL.NS IDBI.NS BHAFau.M3 DWNH.NS DALAau.M3 ARVN.NS CESC.NS THEE.NS RLIN.NS SHCU.NS CRSL.NS RLCP.NS ENGI.NS CBI.NS VAKR.NS RPOL.NS PCJE.NS IDFC.NS SRID.NS SUZL.NS SIBK.NS MCEI.NS KBNK.NS GESC.NS THMX.NS NCCL.NS GPPL.NS JAIR.NS IRBI.NS IPCA.NS DSTV.NS TTEX.NS BLDT.NS ALEM.NS TVEB.NS RLCM.NS WLSP.NS WCKH.NS UNSP.NS ABRL.NS^F18 HDIL.NS SPRC.NS GETD.NS HEXT.NS JET.NS JUST.NS CAILb.BO CGPO.NS SKFB.NS JKBK.NS ESRO.M3 SBNK.NS ORBC.NS KVRI.NS ALBK.NS IFCI.NS ADBK.NS JAIA.NS UCBK.NS INRL.NS UNTE.NS IOBK.NS RANB.BO^I15 VYSA.BO^I15 PERS.NS TATS.NS HAWY.NS VEDI.NS MCLE.NS JAPR.NS HCPR.NS STRL.NS^L13 RELV.NS 63MO.NS ICMN.NS TTKL.NS GMDC.NS VJBK.NS DENA.NS JYPE.NS MNFL.NS GTGM.NS MMTC.NS IBUL.BO^E13 OPTO.NS FURE.NS EIHO.NS AMTK.NS PTCI.NS CHMB.NS NLCI.NS SRES.NS GFLL.NS IIFL.NS PUJL.NS SNTX.NS IVRC.NS LAIN.BO GVKP.NS JSWI.NS EDSO.NS WGSR.NS JIND.NS SCI.NS PTNI.NS^E12 HCNS.NS GJNC.NS HOEX.NS MTNL.NS ROLT.NS BEML.NS ABAN.NS BACH.NS KSKE.NS TTML.NS ANRA.NS BJHN.NS BDYN.NS JAIC.NS GTL.NS RENRqf.BO^D16 RTNP.NS PENG.NS DCHLau.NS^H17 PRAJ.NS ESRSau.M3 GOFS.BO RPET.BO^L09 STBI.NS GEPO.NS BFUT.NS CHPC.NS MRCT.NS NIIT.NS LKMC.NS UBHLau.M3 TVET.BO^H11 MOSR.BO RELM.NS^E14 TNSL.NS NDTV.NS

chetan.mehra

thanks... that was our plan...we hoped there would be a work around this issue.