Hi,
I am trying to retreive historical Data for a list of stocks. Trying to retreive the following items:
'TR.TotalReturn' | |
|---|
'TR.PriceClose' | |
'TR.PriceCloseDate' | |
'TR.NIStockSplitDivisionRate' | |
'TR.NIStockSplitDivisionDate' | |
It works for a a single Stock, like "AAPL.O", but not for the list of stocks.
Do you have any idea, what my error could be?
import refinitiv.data as rd
rd.open_session()
df = rd.get_data(
universe = ticker_liste,
fields = [
'TR.TotalReturn',
'TR.PriceClose',
'TR.PriceCloseDate',
'TR.NIStockSplitDivisionRate',
'TR.NIStockSplitDivisionDate',
],
parameters = {
'SDate': '2005-01-01',
'EDate': '-1D',
'Frq': 'D'
}
)
display(df)
Error Message:
---------------------------------------------------------------------------RDError Traceback (most recent call last)/tmp/ipykernel_100/1614301727.py in <module> 1 import refinitiv.data as rd 2 rd.open_session()----> 3 df = rd.get_data( 4 universe = ticker_liste, 5 fields = [/opt/conda/lib/python3.8/site-packages/refinitiv/data/_access_layer/get_data_func.py in get_data(universe, fields, parameters, use_field_names_in_headers) 124 if exceptions and all(exceptions): 125 except_msg = "\n\n".join(exceptions)--> 126 raise RDError(-1, except_msg) 127 128 hp_and_cust_inst_data = HPAndCustInstDataContainer(stream_columns, stream_data, stream_df)RDError: Error code -1 | UDF Core request failed. Gateway Time-out Requested universes: ['KLAC.OQ', 'META.OQ', 'AMP.N', 'FTNT.OQ', 'CF.N', 'AMAT.OQ', 'GOOG.OQ', 'GOOGL.OQ', 'ADBE.OQ', 'ACGL.OQ', 'PHM.N', 'NVDA.OQ', 'LRCX.OQ', 'DECK.N', 'V.N', 'AAPL.OQ', 'NVR.N', 'ODFL.OQ', 'DHI.N', 'CINF.OQ', 'EBAY.OQ', 'MA.N', 'ANET.N', 'IT.N', 'MSFT.OQ', 'SPY', 'AMZN.OQ', 'TSLA.OQ', 'LLY.N', 'AVGO.OQ', 'JPM.N', 'UNH.N', 'APH.N', 'BRKb.N', 'WMT.N', 'XOM.N', 'JNJ.N', 'PANW.OQ', 'PG.N', 'HD.N', 'COST.OQ', 'ORCL.N', 'CVX.N', 'REGN.OQ', 'QCOM.OQ', 'EOG.N', 'TXN.OQ', 'VRTX.OQ', 'BKNG.OQ', 'COP.N', 'NFLX.OQ', 'CPRT.OQ', 'AON.N', 'PXD.N^E24', 'MU.OQ', 'INTC.OQ', 'SPGI.N', 'MNST.OQ', 'TROW.OQ', 'CSCO.OQ', 'BIIB.OQ', 'AMGN.OQ', 'ABBV.N', 'ALGN.OQ', 'EA.OQ', 'GILD.OQ', 'ILMN.OQ', 'LUV.N', 'INTU.OQ', 'STZ.N', 'CELG.OQ^K19', 'SBUX.OQ', 'DAL.N', 'MCO.N', 'ATVI.OQ^J23', 'ROST.OQ', 'UNP.N', 'ORLY.OQ', 'DIS.N', 'TJX.N', 'STT.N', 'LYB.N', 'SHW.N', 'BLK.N', 'MPC.N', 'MRK.N', 'PSX.N', 'MON.N^F18', 'VLO.N', 'BEN.N', 'T.N', 'ALXN.OQ^G21', 'ALL.N', 'PFE.N', 'CTSH.OQ', 'BDX.N', 'MCD.N', 'IBM.N', 'BMY.N', 'WYNN.OQ', 'BAX.N', 'CL.N', 'MDT.N', 'TPR.N', 'PM.N', 'ISRG.OQ', 'FCX.N', 'CSX.OQ', 'ACN.N', 'MOS.N', 'BMC.OQ^I13', 'FTI.N^A17', 'APOL.OQ^B17', 'GEN.OQ', 'KMB.N', 'IP.N', 'DO.N^D20', 'ELV.N', 'MCHP.OQ', 'ADI.OQ', 'RHT.N^G19', 'BCR.N^L17', 'AVP.N^A20', 'SCHW.N', 'HAL.N', 'PAYX.OQ', 'ESRX.OQ^L18', 'CA.OQ^K18', 'JNPR.N', 'ADP.OQ', 'EMC.N^I16', 'ZBH.N', 'MMM.N', 'LMT.N', 'DVN.N', 'NUE.N', 'OXY.N', 'APA.OQ', 'SWN.N^J24', 'NBL.OQ^J20', 'AET.N^K18', 'HPQ.N', 'XTO.N^F10', 'DELL.OQ^J13', 'GS.N', 'PCAR.OQ', 'FRX.N^G14', 'HOG.N', 'PGR.N', 'IGT.N^D15', 'APC.N^H19', 'BR.N^D06', 'PD.N^C07', 'CI.N', 'SYK.N', 'MO.N']. Requested fields: ['TR.TOTALRETURN', 'TR.PRICECLOSE', 'TR.PRICECLOSEDATE', 'TR.NISTOCKSPLITDIVISIONRATE', 'TR.NISTOCKSPLITDIVISIONDATE']
