# 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.

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