Trying to get historical information about a company using the following code

shivananda.panegaon · June 13

I'm trying to get historical information about a company using the following code:

<code>
import refinitiv.data as rd
response = rd.get_history(
universe = ["AAPL.O"],
fields = ['TR.AvgDailyValTraded5D', 'TR.AvgDailyValTraded20D', 'TR.AvgDailyValTraded30D', 'TR.AvgDailyValTraded52W',
'TR.CompanyMarketCapitalization', 'TR.F.IntrCovRatio', 'TR.F.DPSComNetIssue5YrAvg', 'TR.F.NetDebtToEBITDA','TR.DividendYield', 'TR.F.EVToFCF', 'TR.F.LeveredFOCF', 'TR.FreeFloatPct', 'TR.F.CashDivPaidComStockBuybackNet', 'TR.NumberofSharesOutstandingActual','TR.GICSSectorCode', 'TR.GICSIndustryCode', 'TR.GICSSubIndustry', 'TR.GICSIndustry', 'TR.GICSIndustryGroup', 'TR.GICSSector','TR.F.PriceToCFPerShr', 'TR.PCReturnOnInvestedCapPct ', 'TR.WACC', 'TR.HeadquartersCountry', 'TR.F.DPSComNetIssue5YrCAGR'],start = "2014-04-30",end = "2025-06-30",)

</code>

The results are fundamentally null:
<results>
<class 'pandas.core.frame.DataFrame'>
DatetimeIndex: 4040 entries, 2014-04-01 00:00:00 to 2025-06-12 00:00:00Data columns (total 25 columns):# Column Non-Null Count Dtype
--- ------ -------------- -----

0 Average Daily Value Traded - 5 Days 1 non-null Float64
1 Average Daily Value Traded - 20 Days 1 non-null Float64
2 Average Daily Value Traded - 30 Days 1 non-null Float64
3 Average Daily Value Traded - 52 Weeks 1 non-null Float64
4 Company Market Capitalization 2798 non-null Float64
5 Interest Coverage Ratio 10 non-null Float64
6 DPS - Common - Net - Issue, 5 Yr Avg 20 non-null Float64
7 Net Debt to EBITDA 11 non-null Float64
8 Dividend yield 2900 non-null Float64
9 EV to FCF Net of Dividends (Net Inc) 11 non-null Float64
10 Free Cash Flow 11 non-null Int64
11 Free Float (Percent) 263 non-null Float64
12 Cash Dividends Paid & Common Stock Buyback - Net 11 non-null Int64
13 Number of Shares Outstanding - Actual 11 non-null Int64
14 GICS Sector Code 4040 non-null string
15 GICS Industry Code 4040 non-null string
16 GICS Sub-Industry Name 4040 non-null string
17 GICS Industry Name 4040 non-null string
18 GICS Industry Group Name 4040 non-null string
19 GICS Sector Name 4040 non-null string
20 Price to Cash Flow per Share 11 non-null Float64
21 TR.PCRETURNONINVESTEDCAPPCT 0 non-null Int64
22 Weighted Average Cost of Capital, (%) 3431 non-null Float64
23 Country of Headquarters 4040 non-null string
24 DPS - Common - Net - Issue, 5 Yr CAGR 8 non-null Float64
dtypes: Float64(14), Int64(4), string(7)
memory usage: 891.6 KB

</results>

Note that GICS information is empty although info() method reports non-null.

However, when I use "get_data" instead of "get_history" I get more information:

<code>
df = rd.get_data(
universe = ['AAPL.O'],
fields = ['TR.AvgDailyValTraded5D', 'TR.AvgDailyValTraded20D', 'TR.AvgDailyValTraded30D', 'TR.AvgDailyValTraded52W',
'TR.CompanyMarketCapitalization', 'TR.F.IntrCovRatio', 'TR.F.DPSComNetIssue5YrAvg', 'TR.F.NetDebtToEBITDA','TR.DividendYield', 'TR.F.EVToFCF', 'TR.F.LeveredFOCF', 'TR.FreeFloatPct', 'TR.F.CashDivPaidComStockBuybackNet', 'TR.NumberofSharesOutstandingActual','TR.GICSSectorCode', 'TR.GICSIndustryCode', 'TR.GICSSubIndustry', 'TR.GICSIndustry', 'TR.GICSIndustryGroup', 'TR.GICSSector','TR.F.PriceToCFPerShr', 'TR.PCReturnOnInvestedCapPct ', 'TR.WACC', 'TR.HeadquartersCountry', 'TR.F.DPSComNetIssue5YrCAGR']

<code>
<results>

,Instrument,Average Daily Value Traded - 5 Days,Average Daily Value Traded - 20 Days,Average Daily Value Traded - 30 Days,Average Daily Value Traded - 52 Weeks,Company Market Capitalization,Interest Coverage Ratio,"DPS - Common - Net - Issue, 5 Yr Avg",Net Debt to EBITDA,Dividend yield,EV to FCF Net of Dividends (Net Inc),Free Cash Flow,Free Float (Percent),Cash Dividends Paid & Common Stock Buyback - Net,Number of Shares Outstanding - Actual,GICS Sector Code,GICS Industry Code,GICS Sub-Industry Name,GICS Industry Name,GICS Industry Group Name,GICS Sector Name,Price to Cash Flow per Share,"Return on Invested Capital, % (Pvt)","Weighted Average Cost of Capital, (%)",Country of Headquarters,"DPS - Common - Net - Issue, 5 Yr CAGR"0,AAPL.O,11846616025.5075,10963104293.6686,10905852328.9591,12309214765.2963,2968943492280,,0.0,0.34498110068988,0.513149454778704,38.6320539443061,108807000000,97.9131,110183000000,15408095000,45,452020,"Technology Hardware, Storage & Peripherals","Technology Hardware, Storage & Peripherals",Technology Hardware & Equipment,Information Technology,30.4071834150589,55.3450652874093,7.99230626051174,United States of America,5.495263799739811,AAPL.O,,,,,,,0.893,,,,,,,,,,,,,,,,,,

</results>