Stop guessing which formulas actually work for financial data. This step-by-step guide shows you how to pull live stock quotes and historical stock prices directly into your spreadsheets and financial models.
You don't need to know how to code or learn complex programming. We built a custom Excel function called =FDN(). All you do is type the stock ticker, and the data instantly loads right into your sheet.
First, add the FinancialData.Net add-in to your Excel ribbon. It takes less than a minute to install through the built-in Microsoft store, giving your workbook instant access to live and historical market data.
To start pulling stock prices into your spreadsheet, you need to get a unique API key from FinancialData.Net. This connects the add-in and allows your Excel formulas to download stock data. Make sure you have an active subscription — historical prices are available with a free subscription, while real-time data requires a paid subscription.
You can now use the formula anywhere in your Excel workbook. Whether you are building an investment portfolio tracker or a stock valuation model, the standard format looks like this:
Get real-time stock quotes, including the last price, change, and percentage change.
| Ticker | Company Name | Live Price | Today's Change | % Change |
|---|---|---|---|---|
| AAPL | Apple Inc. | $308.89 | +3.82 | +1.25% |
| MSFT | Microsoft Corp. | $418.61 | -0.39 | -0.09% |
| NVDA | NVIDIA Corp. | $215.14 | -4.33 | -1.97% |
Get daily historical stock prices, including OHLC and volume data.
| Date | Open | High | Low | Close | Volume |
|---|---|---|---|---|---|
| May 22, 2026 | $419.54 | $424.40 | $416.33 | $418.57 | 22,390,340 |
| May 21, 2026 | $424.75 | $426.34 | $415.71 | $419.09 | 31,393,470 |
| May 20, 2026 | $414.17 | $422.10 | $411.30 | $421.06 | 27,864,020 |