Finmagine for Excel
by Finmagine
Live Indian and US stock data, fundamentals and screens in Excel with =FINMAGINE formulas.
Bring Finmagine market data into your spreadsheet with simple formulas.
Type =FINMAGINE.DATA("NSE:TCS","pe") or =FINMAGINE.DATA("NASDAQ:AAPL","price_cmp") in any cell and get live figures for Indian (NSE/BSE) and US (NASDAQ/NYSE/AMEX) companies: valuation ratios, returns, margins, RS ratings, price and more.
What you can do
- DATA: one metric for one company. SCHEMA lists every available metric.
- FINANCIALS: multi-year or quarterly financial statements that spill into a table.
- MOMENTUM: trend and relative-strength readings for a company.
- BATCH: many companies and metrics in one call (higher plans).
- SCREEN: filter the market by criteria you set (higher plans).
- QUOTA: see your plan and remaining requests.
- Create Sample Sheets: one click builds ready-to-use watchlist, company-detail, screener and metric-reference tabs.
- Refresh Data, Set Default Market and About/Diagnostics from the task pane.
A Finmagine account is required to use this add-in. Create one free at https://finmagine.com/auth/register.php; a free account works with usage limits. Paid Finmagine plans, purchased separately on finmagine.com and not through Microsoft, raise the limits and unlock batch and screening. The add-in does not work without an account. Account questions: contact@finmagine.com.
Sign in with your Finmagine account (OAuth) or paste an API key. Finmagine never reads your workbook: only the symbols and metric names you type are sent to the Finmagine API.
Finmagine provides information and analytical tools for educational and informational purposes only. Nothing in this add-in is investment advice or a recommendation to buy or sell any security.
Microsoft Excel is a trademark of Microsoft Corporation.
App capabilities
- Can read and make changes to your document
- Can send data over the Internet