Indian & US Stock Data as Formulas in Microsoft Excel
Type =FINMAGINE.DATA("NSE:TCS","pe")
and get the number. Build watchlists, financial models and screens on live Finmagine data,
in Excel on the web, Windows and Mac, with no copy-pasting and no CSV exports.
Every analyst has the same routine: open a screener, export a CSV, paste it into a workbook, fix the formatting, and do it all again next week. The numbers go stale the moment you paste them.
With Finmagine for Excel the cell is the query. Put a symbol in column A and a formula beside it. When the underlying data changes, so does your workbook. Your models, watchlists and charts stay current without a manual step.
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.
Get Finmagine for Excel from Microsoft AppSource. It runs in Excel on the web, Windows and Mac. Open the Finmagine task pane from the Home tab.
Click Create Sample Sheets in the task pane. It adds India and US watchlists, a company-detail page, a screener and a metric reference to your workbook. It never overwrites your existing tabs.
Click Sign in to Finmagine and use your Finmagine account. Prefer an API key? Configure API Key works too. The formulas fill in.
If a formula shows an error, hover over the cell: the message says what happened, for example that the add-in is not connected or that a function needs a higher plan. Wrap any formula in IFERROR to show a friendlier fallback.
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.
From Microsoft AppSource: use the “Get it on Microsoft AppSource” button above, or search for Finmagine for Excel under Insert → Get Add-ins in Excel.
The add-in itself is 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.
Install the add-in, create the sample sheets and see the formulas fill in.
Requires a Finmagine account · Free to start