Formula Result
See exactly how data fills into your sheet when the formula runs. This example shows the actual up-to-date information returned.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | trading_symbol | registrant_name | fiscal_quarter_end_date | report_date | conference_call_time | earnings_per_share_forecast |
| 2 | OIS | OIL STATES INTERNATIONAL, INC | 2025-09 | 2025-10-31 | 2025-10-31 09:00:00 | 0.1 |
| 3 | SMP | STANDARD MOTOR PRODUCTS, INC. | 2025-09 | 2025-10-31 | 2025-10-31 10:00:00 | 1.14 |
| 4 | MSEX | MIDDLESEX WATER CO | 2025-09 | 2025-10-31 | — | 0.86 |
| 5 | XHR | Xenia Hotels & Resorts, Inc. | 2025-09 | 2025-10-31 | 2025-10-31 09:00:00 | — |
| 6 | PRLB | Proto Labs Inc | 2025-09 | 2025-10-31 | 2025-10-31 07:30:00 | 0.24 |
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | trading_symbol | OIS | SMP | MSEX | XHR | PRLB |
| 2 | registrant_name | OIL STATES INTERNATIONAL, INC | STANDARD MOTOR PRODUCTS, INC. | MIDDLESEX WATER CO | Xenia Hotels & Resorts, Inc. | Proto Labs Inc |
| 3 | fiscal_quarter_end_date | 2025-09 | 2025-09 | 2025-09 | 2025-09 | 2025-09 |
| 4 | report_date | 2025-10-31 | 2025-10-31 | 2025-10-31 | 2025-10-31 | 2025-10-31 |
| 5 | conference_call_time | 2025-10-31 09:00:00 | 2025-10-31 10:00:00 | — | 2025-10-31 09:00:00 | 2025-10-31 07:30:00 |
| 6 | earnings_per_share_forecast | 0.1 | 1.14 | 0.86 | — | 0.24 |
Steps to Get Started
Install the Add-in
Open Excel, navigate to the Home tab, select Add-ins, and search for FinancialData.Net.
Grab Your Key
Sign in to your account at FinancialData.Net, open the dashboard, and copy your API key.
Run Your Formula
Open the task pane in Excel, save your API key, and start typing the =FDN(...) formula.
Formula Reference
Use the formula to retrieve financial data by specifying a dataset, ticker symbol, and additional parameters.
=FDN(dataset, identifier, argument, maxRows)"EarningsCalendar"."AAPL" or "AAPL,MSFT") or other supported identifier types."2025-01-15" or a reporting period like "year" or "quarter".5 returns the five most recent rows.Troubleshooting & FAQ
Install the Excel Add-in
Access 80+ financial datasets directly in Excel using simple formulas.
Install via AppSource