FinancialData.Net Excel Add-in for Microsoft Excel

FinancialData.Net for Excel helps you pull live and historical financial market data directly into Excel with readable custom formulas, a built-in task pane, and a fast one-time API key setup.

What you can do in Excel

Get stock, ETF, forex, crypto, index, company, and fundamentals data in Excel.

Spill tabular data into worksheets with a single formula.

Start quickly using the formula builder from the task pane.

Prerequisites

Before you install the add-in, make sure you have:

Microsoft Excel with Office add-in support.

A FinancialData.Net API key.

Where to get your FinancialData.Net API key

Go to https://financialdata.net/ and create an account or sign in.

Open your dashboard at https://financialdata.net/dashboard.

Copy your API key.

Quick start

Use the add-in in four steps:

Open the task pane from the Excel ribbon.

Save your FinancialData.Net API key.

Choose a dataset such as StockQuotes or IncomeStatements.

Paste or generate a formula in your worksheet.

Formula reference

=FDN(dataset, identifier, argument, maxRows)

The FDN function retrieves multi-row financial datasets directly into Excel. You only need to enter the formula into a single cell. The function automatically "spills" the returned data into the adjacent rows and columns.

Excel formula examples

Real-time stock quote

=FDN("StockQuotes","MSFT,AAPL","",2)

Spills across two rows to display live stock quotes for both Microsoft and Apple simultaneously

Income statements

=FDN("IncomeStatements","MSFT","year",50)

Generates a comprehensive table of all available fiscal year income statements.

Company information

=FDN("CompanyInformation","MSFT","",1)

Returns a single-row dataset containing the company’s official name, industry, sector, and business summary.

List of formulas

=FDN("StockSymbols","","",5)

=FDN("InternationalStockSymbols","","",5)

=FDN("EtfSymbols","","",5)

=FDN("CommoditySymbols","","",5)

=FDN("OtcSymbols","","",5)

=FDN("StockQuotes","MSFT,AAPL","",5)

=FDN("StockPrices","MSFT","",5)

=FDN("InternationalStockPrices","SHEL.L","",5)

=FDN("MinutePrices","MSFT","2020-01-15",5)

=FDN("LatestPrices","MSFT","",5)

=FDN("CommodityPrices","ZC","",5)

=FDN("OtcPrices","AABB","",5)

=FDN("OtcVolume","AABB","",5)

=FDN("IndexSymbols","","",5)

=FDN("IndexQuotes","^GSPC,^DJI","",5)

=FDN("IndexPrices","^GSPC","",5)

=FDN("IndexConstituents","^GSPC","",5)

=FDN("OptionChain","MSFT","",5)

=FDN("OptionPrices","MSFT260123C00455000","",5)

=FDN("OptionGreeks","MSFT260123C00455000","",5)

=FDN("FuturesSymbols","","",5)

=FDN("FuturesPrices","ZN","",5)

=FDN("CryptoSymbols","","",5)

=FDN("CryptoInformation","BTC","",5)

=FDN("CryptoQuotes","BTCUSD,ETHUSD","",5)

=FDN("CryptoPrices","BTCUSD","",5)

=FDN("CryptoMinutePrices","BTCUSD","2025-01-15",5)

=FDN("ForexSymbols","","",5)

=FDN("ForexQuotes","EURUSD,GBPUSD","",5)

=FDN("ForexPrices","EURUSD","",5)

=FDN("ForexMinutePrices","EURUSD","2025-01-15",5)

=FDN("CompanyInformation","MSFT","",5)

=FDN("InternationalCompanyInformation","SHEL.L","",5)

=FDN("KeyMetrics","MSFT","",5)

=FDN("MarketCap","MSFT","",5)

=FDN("EmployeeCount","MSFT","",5)

=FDN("ExecutiveCompensation","MSFT","",5)

=FDN("SecuritiesInformation","AAPL","",5)

=FDN("IncomeStatements","MSFT","year",5)

=FDN("BalanceSheetStatements","MSFT","year",5)

=FDN("CashFlowStatements","MSFT","year",5)

=FDN("InternationalIncomeStatements","SHEL.L","year",5)

=FDN("InternationalBalanceSheetStatements","SHEL.L","year",5)

=FDN("InternationalCashFlowStatements","SHEL.L","year",5)

=FDN("LiquidityRatios","MSFT","year",5)

=FDN("SolvencyRatios","MSFT","year",5)

=FDN("EfficiencyRatios","MSFT","year",5)

=FDN("ProfitabilityRatios","MSFT","year",5)

=FDN("ValuationRatios","MSFT","year",5)

=FDN("PressReleases","MSFT","",5)

=FDN("SecPressReleases","","2026-01-27",5)

=FDN("FedPressReleases","","2025-10-29",5)

=FDN("EarningsCalendar","","2025-10-31",5)

=FDN("IpoCalendar","","2025-10-31",5)

=FDN("SplitsCalendar","","2025-10-29",5)

=FDN("DividendsCalendar","","2025-10-29",5)

=FDN("EconomicCalendar","","2025-10-19",5)

=FDN("InsiderTransactions","MSFT","",5)

=FDN("ProposedSales","MSFT","",5)

=FDN("SenateTrading","MSFT","",5)

=FDN("HouseTrading","MSFT","",5)

=FDN("InstitutionalInvestors","","",5)

=FDN("InstitutionalHoldings","MSFT","",5)

=FDN("InstitutionalPortfolioStatistics","0000102909","",5)

=FDN("EtfQuotes","SPY,QQQ","",5)

=FDN("EtfPrices","SPY","",5)

=FDN("EtfHoldings","SPY","",5)

=FDN("MutualFundSymbols","","",5)

=FDN("MutualFundHoldings","VTSAX","",5)

=FDN("MutualFundStatistics","VTSAX","",5)

=FDN("EsgScores","MSFT","",5)

=FDN("EsgRatings","MSFT","",5)

=FDN("IndustryEsgScores","","2025-01-01",5)

=FDN("InvestmentAdviserNames","","",5)

=FDN("InvestmentAdviserInformation","BLACKROCK INVESTMENT MANAGEMENT, LLC","",5)

=FDN("EarningsReleases","MSFT","",5)

=FDN("InitialPublicOfferings","ABNB","",5)

=FDN("StockSplits","MSFT","",5)

=FDN("Dividends","MSFT","",5)

=FDN("ShortInterest","MSFT","",5)

Keywords

FinancialData.Net Excel add-in, financial data API for Excel, stock market data in Excel, company financial statements in Excel, ETF data in Excel, forex data in Excel, stock prices in Excel, Excel financial formulas, Excel market data add-in.

FinancialData.Net for Excel

Автор: FinancialData.Net