Indian & US Stock Data as Formulas in Microsoft Excel
Type =FINMAGINE.DATA("NSE:TCS","pe")
and get the number. The same Finmagine data that powers our Sheets add-on, built for Excel on the web, Windows and Mac.
Finmagine for Excel is built and heading to Microsoft AppSource. We will announce it here as soon as it is available to install.
Need it today? The same data is available in Finmagine for Sheets for Google Sheets™, and through the Finmagine API for any tool that can call a web service.
Every symbol carries its market prefix: NSE: or BSE: for India; NASDAQ:, NYSE: or AMEX: for the US. You can set a default market once per workbook if you would rather not type it.
One metric for one company, in one cell. Valuation ratios, returns, margins, RS rating, price and more.
Quarterly or annual statements spill into a table you can chart or model on.
Trend and relative-strength readings for a company, as a single row.
A whole watchlist in one call: many companies, many metrics. Higher plans.
Filter the market by your own criteria and get the matches as a table. Higher plans.
Lists every metric you can ask for, so you never have to guess a key.
Also included: FINMAGINE.US_RATIOS for the full US ratio table, and FINMAGINE.QUOTA to see your plan and remaining requests. The same functions are documented for Google Sheets in the function reference.
One click builds India and US watchlists, a company-detail page, a screener and a metric reference in your workbook. It never overwrites your existing sheets, and works before you sign in.
Re-runs your Finmagine formulas on demand. It is skipped, with a message, when you are close to your limit, so your existing values are never wiped.
Choose India or US once per workbook and type bare symbols like TCS. An explicit prefix always wins.
See your connection, plan, remaining quota and the last error in one place.
For US companies, FINMAGINE.US_RATIOS returns the whole ratio table in one formula. India works differently: there is no single India ratio-table formula yet. Each India ratio is fetched on its own, by its metric key, with FINMAGINE.DATA, and the table below shows which key returns which ratio.
To build your own ratio table: put the symbols (with the NSE: prefix) down column A and the metric keys from the table across row 1, then fill one formula across the grid: =FINMAGINE.DATA($A2, B$1). On higher plans, FINMAGINE.BATCH can fetch many ratios for a whole watchlist in one call.
| Metric key | Ratio | Unit | Data set |
|---|---|---|---|
| roce | ROCE | % | Ratios* |
| roe | ROE | % | Profile |
| de | Debt / Equity | x | Profile |
| opm_pct | Operating margin | % | Profile |
| pe | P/E | x | Profile |
| sales_growth_pct | Sales growth | % | Profile |
| revenue_cagr_10y | 10-year revenue CAGR | % | Profile |
| pat_cagr_10y | 10-year profit (PAT) CAGR | % | Profile |
| ebitda_cagr_5y | 5-year EBITDA CAGR | % | Profile |
| ebitda_cagr_3y | 3-year EBITDA CAGR | % | Ratios* |
| fcf_yield | Free cash flow yield | % | Profile |
| fcf_cagr_5y | 5-year free cash flow CAGR | % | Ratios* |
| ocf_to_pat_5y | 5-year average OCF / PAT | x | Ratios* |
| altman_z_score | Altman Z-Score | score | Ratios* |
| profitable_years_10y | Profitable years (of last 10) | years | Ratios* |
| fcf_positive_years_10y | FCF-positive years (of last 10) | years | Ratios* |
| dividend_years_10y | Dividend-paying years (of last 10) | years | Ratios* |
| net_debt_cr | Net debt | ₹ crore | Profile |
| promoter_pct | Promoter holding | % | Profile |
| pledge_pct | Promoter pledge | % | Profile |
* "Ratios" metrics come from a second data set, so the first one you request for a company may use one extra request on top of the "Profile" data set that most metrics share. All of these keys are available on every plan, within the free-tier symbol limits. =FINMAGINE.SCHEMA("metrics") lists every metric key you can ask for.
A free Finmagine account works with usage limits. Higher plans raise the limits and unlock batch lookups, screens and US ratio tables. See API plans for current details.
| Formula | What it returns | Available on |
|---|---|---|
| FINMAGINE.DATA | One metric for one company (valuation, returns, margins, price, RS rating and more) | All plans |
| FINMAGINE.FINANCIALS | Quarterly or annual statements as a table | India: all plans · US: higher plans |
| FINMAGINE.MOMENTUM | Trend and relative-strength readings | India: all plans · US: higher plans |
| FINMAGINE.US_RATIOS | Full US ratio table for a company | Higher plans |
| FINMAGINE.BATCH | Many companies and metrics in a single call | Higher plans |
| FINMAGINE.SCREEN | Filter a market by criteria you set | US: higher plans · India: top API plan |
| FINMAGINE.SCHEMA | Lists every metric you can ask for | All plans |
| FINMAGINE.QUOTA | Your plan and remaining requests | All plans |
Only the symbols and metric names in your formulas go to Finmagine so it can answer them. Finmagine does not read your workbook. You sign in through a Finmagine consent screen, and you can disconnect at any time from the task pane. See our Privacy Policy for details.
It is heading to Microsoft AppSource. We will announce it on this page when you can install it.
The add-in itself will be free. You will need a Finmagine account; a free account works with usage limits, and higher plans raise the limits and unlock batch lookups and screens.
Excel on the web, Windows and Mac.
Yes. The Finmagine API can be called from Power Query or any tool that reads web data. For a ready-made formula experience today, try Finmagine for Sheets.
Finmagine provides information and analytical tools for educational and informational purposes only. Nothing here is investment advice or a recommendation to buy or sell any security. Microsoft Excel® is a trademark of Microsoft Corporation. Finmagine for Excel is an independent add-in.
Take Finmagine data wherever you already work: in your spreadsheet or in your browser.