Yahoo! Finance Key Statistics

Yahoo! Finance Key Statistics

Usage

Excel formula:

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

Example:

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

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

Data Fields and Excel Formulas

Excel ColumnExcel 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.

ParameterValue
RefreshInterval06:00:00, six hours
NextRequestDelay1000, one second
DataStartTime00:00:00 -05:00
DataEndTime24:00:00 -05:00
LoadEndTime24:00:00 -05:00
LoadOnSaturday1, loading Friday's data once.
LoadOnSunday1, loading Friday's data once.

Data Source

Yahoo! Finance Key Statistics

Example:

https://finance.yahoo.com/q/ks?s=AAPL+Key+Statistics