Live stock data in your spreadsheet
One formula puts live prices, our rating, moat score and DCF fair value into Google Sheets. No add-in, no key, no seat. Bloomberg charges for its Excel bridge and locks the data in. Ours is free, and the data can leave.
Google Sheets in one formula
Paste this into any cell. Change the tickers to whatever you want, up to 50 at a time.
=IMPORTDATA("https://steadyshares.com/api/sheets/quotes?t=AAPL,MSFT,NVDA")It returns a table with a header row and one row per ticker, in the order you asked. Pull a single number into a cell with INDEX, so your model reads one value and does not shift when you add tickers elsewhere:
=INDEX(IMPORTDATA("https://steadyshares.com/api/sheets/quotes?t=AAPL"), 2, 8)Row 2 is the data row (row 1 is headers) and column 8 is fair_value. The full column order is listed below and never reorders: new fields are appended at the end, so your cell references keep working.
Columns
| # | Column | Meaning |
|---|---|---|
| 1 | ticker | The symbol, echoed back in the order you asked. |
| 2 | name | Company name. |
| 3 | price | Latest price we hold. |
| 4 | change_pct | Day change, percent. |
| 5 | currency | Listing currency. |
| 6 | rating | Our overall rating, 0 to 100 (blank if the name is not rated). |
| 7 | moat | Our moat score, 0 to 100. |
| 8 | fair_value | Our DCF fair value per share. |
| 9 | upside_pct | Percent from price to our fair value. |
| 10 | pe | Price to earnings, when known. |
| 11 | dividend_yield | Trailing yield, percent. |
| 12 | sector | Sector label. |
Excel via Power Query
Excel does not have IMPORTDATA, but Power Query reads the same URL. Data, then From Web, paste the URL, and Excel turns the CSV into a refreshable table:
https://steadyshares.com/api/sheets/quotes?t=AAPL,MSFT,NVDARight click the query and set a refresh interval to keep it live.
Limits and honesty
Up to 50 tickers per formula, and roughly 30 requests a minute from one place, which is far more than a normal sheet needs. The data is what SteadyShares holds: prices can lag their exchange, our rating, moat and fair value are model estimates, not advice, and a name we do not cover returns blank cells rather than a guess. For programmatic access with higher limits and more endpoints, see the Data API. None of this is financial advice, see the disclaimer.