Yahoo! Finance Key Statistics

Usage

Excel formula:

=RTD("gartle.rtd",,"YahooFinanceKeyStatistics","<Ticker>","<Data Field>")

Example:

=RTD("gartle.rtd",,"YahooFinanceKeyStatistics","YHOO","% Held by Insiders")

Use https://finance.yahoo.com/ to find tickers. See also the complete list of Yahoo! Finance exchanges.

Data Fields and Excel Formulas

Excel Column	Excel Formula
Symbol
% Held by Insiders	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"% Held by Insiders")`
% Held by Institutions	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"% Held by Institutions")`
200-Day Moving Average	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"200-Day Moving Average")`
5 Year Average Dividend Yield	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"5 Year Average Dividend Yield")`
50-Day Moving Average	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"50-Day Moving Average")`
52-Week Change	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"52-Week Change")`
52-Week High	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"52-Week High")`
52-Week Low	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"52-Week Low")`
Avg Vol (10 day)	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Avg Vol (10 day)")`
Avg Vol (3 month)	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Avg Vol (3 month)")`
Beta	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Beta")`
Book Value Per Share	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Book Value Per Share")`
Current Ratio	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Current Ratio")`
Diluted EPS	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Diluted EPS")`
Dividend Date	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Dividend Date")`
EBITDA	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"EBITDA")`
EBITDA$	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"EBITDA$")`
Enterprise Value	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Enterprise Value")`
Enterprise Value$	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Enterprise Value$")`
Enterprise Value/EBITDA	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Enterprise Value/EBITDA")`
Enterprise Value/Revenue	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Enterprise Value/Revenue")`
Ex-Dividend Date	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Ex-Dividend Date")`
Financial Highlights	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Financial Highlights")`
Fiscal Year Ends	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Fiscal Year Ends")`
Float	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Float")`
Float$	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Float$")`
Forward Annual Dividend Rate	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Forward Annual Dividend Rate")`
Forward Annual Dividend Yield	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Forward Annual Dividend Yield")`
Forward P/E	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Forward P/E")`
Gross Profit	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Gross Profit")`
Gross Profit$	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Gross Profit$")`
Last Split Date	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Last Split Date")`
Last Split Factor	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Last Split Factor")`
Levered Free Cash Flow	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Levered Free Cash Flow")`
Levered Free Cash Flow$	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Levered Free Cash Flow$")`
Market Cap	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Market Cap")`
Market Cap$	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Market Cap$")`
Most Recent Quarter	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Most Recent Quarter")`
Net Income Avl to Common	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Net Income Avl to Common")`
Net Income Avl to Common$	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Net Income Avl to Common$")`
Operating Cash Flow	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Operating Cash Flow")`
Operating Cash Flow$	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Operating Cash Flow$")`
Operating Margin	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Operating Margin")`
Payout Ratio	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Payout Ratio")`
PEG Ratio	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"PEG Ratio")`
Price/Book	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Price/Book")`
Price/Sales	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Price/Sales")`
Profit Margin	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Profit Margin")`
Qtrly Earnings Growth	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Qtrly Earnings Growth")`
Qtrly Revenue Growth	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Qtrly Revenue Growth")`
Return on Assets	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Return on Assets")`
Return on Equity	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Return on Equity")`
Revenue	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Revenue")`
Revenue$	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Revenue$")`
Revenue Per Share	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Revenue Per Share")`
S&P500 52-Week Change	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"S&P500 52-Week Change")`
Shares Outstanding	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Shares Outstanding")`
Shares Outstanding$	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Shares Outstanding$")`
Shares Short	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Shares Short")`
Shares Short$	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Shares Short$")`
Shares Short (prior month)	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Shares Short (prior month)")`
Shares Short (prior month)$	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Shares Short (prior month)$")`
Short % of Float	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Short % of Float")`
Short Ratio	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Short Ratio")`
Symbol	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Symbol")`
Total Cash	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Total Cash")`
Total Cash$	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Total Cash$")`
Total Cash Per Share	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Total Cash Per Share")`
Total Debt	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Total Debt")`
Total Debt$	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Total Debt$")`
Total Debt/Equity	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Total Debt/Equity")`
Trailing Annual Dividend Yield	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Trailing Annual Dividend Yield")`
Trailing P/E	`=RTD("gartle.rtd",,"YahooFinanceKeyStatistics",[Symbol],"Trailing P/E")`

See Copying formulas about inserting formulas into Excel spreadsheets.

Data Provider Settings

The data provider is configured to loading data every 6 hours when the Excel workbook is open.

See Data provider settings.

Parameter	Value
RefreshInterval	06:00:00, six hours
NextRequestDelay	1000, one second
DataStartTime	00:00:00 -05:00
DataEndTime	24:00:00 -05:00
LoadEndTime	24:00:00 -05:00
LoadOnSaturday	1, loading Friday's data once.
LoadOnSunday	1, loading Friday's data once.

Data Source

Yahoo! Finance Key Statistics

Example:

https://finance.yahoo.com/quote/AAPL/key-statistics?ltr=1