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. Questions or want a heads-up at launch? Write to contact@finmagine.com.
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.
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.
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.
Write to contact@finmagine.com or see the FAQ.
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.