Fair Value in Google Sheets
GOOGLEFINANCE() gives you a price but not a valuation. Paste one formula and your sheet gets each stock’s model fair value estimate, the gap to its last valued close, how many of the valuation models sit above that price, and its Fundamentals score, refreshed after every U.S. market close. Free, no API key, no account. Model output under stated assumptions, not investment advice.
1. A whole table in one cell
Paste into any empty cell. It fills one row per ticker, with a header row.
2. One number next to your own holdings
With a ticker in A2, this puts just the model fair value estimate in the cell. Drag it down the column.
Or for a fixed ticker:
Columns you can ask for
Add &fields= with any of these, separated by commas:
- model_fair_value_estimate, price_at_last_recompute, margin_of_safety_differential_pct
- models_above_price, models_below_price, models_total
- fundamental_strength_score, fundamental_strength_grade, equity_rank_score
- company_name, sector, market_cap, last_recomputed, page_url
Excel: Data → From Web, paste the address inside the quotes from formula 1, then Load. Google Sheets refreshes IMPORTDATA about once an hour; the figures change once a day after the nightly valuation. Want every covered stock at once? The full dataset is free too. Prefer dates in your calendar? Subscribe to earnings and dividend dates.
See every valuation method behind these numbers
A free account shows the per-method breakdown, the Fundamentals score and a watchlist. No card required.
Free Weekly Update
3,000+ stocks re-scored every week.
Delivered free every Sunday.
- Top 5 most undervalued stocks by margin of safety — with valuation breakdown
- Biggest score changes from the prior week across 3,000+ equities
- Best options setups from the screener (covered calls, cash-secured puts)
Research and educational purposes only. Not investment advice.
Educational Use Only — Not Financial Advice
All content, analysis, valuations, options strategies, AI-generated commentary, screener results, and other information provided by Equity Rank is for informational and educational purposes only. Nothing on this platform constitutes financial advice, investment advice, trading advice, or any other type of advice. Equity Rank is not a registered investment adviser, broker-dealer, or financial planner under any applicable law or regulation.
Valuation models, margin of safety percentages, fair value estimates, options strategy outputs, and AI analysis are algorithmic outputs based on publicly available data and do not represent personalized investment recommendations. All financial models contain assumptions that may be incorrect. Past performance of any security is not indicative of future results. You may lose money on any investment.
Every fair value figure on Equity Rank is our model’s opinion of a company’s intrinsic worth under stated assumptions — it is not a prediction, forecast, or price target for where the security will actually trade. Fair value estimates describe what the model considers a business to be worth today, not where its market price is headed. Actual market prices are set by supply and demand and by factors no model can fully capture, and may differ materially and indefinitely from any fair value shown here.
Always conduct your own independent due diligence. Consult a licensed financial advisor, tax professional, or attorney before making any investment or financial decision. By using Equity Rank, you acknowledge that you understand and accept these limitations. Portfolio model outputs are mathematical results of quantitative algorithms and do not represent investment recommendations.