Naar hoofdinhoud gaan
Mis niet wat er gaat komen tijdens Microsoft Ignite
Mis niet wat er gaat komen tijdens Microsoft IgniteKrijg directe toegang tot de mensen, producten en expertise achter Microsoft-technologie, met mogelijkheden om vragen te stellen, vaardigheden te ontwikkelen en samen met de community te leren.
Nu registreren
Microsoft
separator
https://catalogartifact.azureedge.net/publicartifacts/94233440.621cb316-2d4f-4139-8bc6-891887da198c-3e20bd9d-8fdb-45d1-a616-4d08f64539f3/image1_outputonlinepngtoolscropped.png

FinancialData.Net for Excel

door FinancialData.Net

FinancialData.Net Excel Add-in: Live financial data, readable functions, and a formula builder.

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

  1. Go to https://financialdata.net/ and create an account or sign in.
  2. Open your dashboard at https://financialdata.net/dashboard.
  3. Copy your API key.

Quick start

Use the add-in in four steps:

  1. Open the task pane from the Excel ribbon.
  2. Save your FinancialData.Net API key.
  3. Choose a dataset such as StockQuotes or IncomeStatements.
  4. 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.

Mogelijkheden van de app

Wanneer deze app wordt gebruikt, kan deze
  • Lezen en wijzigingen aan uw document aanbrengen
  • Gegevens via internet verzenden

Een overzicht

https://catalogartifact.azureedge.net/publicartifacts/94233440.621cb316-2d4f-4139-8bc6-891887da198c-3e20bd9d-8fdb-45d1-a616-4d08f64539f3/image0_exceladdin.png
Nederlands (België)
Pictogram Uw privacykeuzes afmelden Uw Californië privacykeuzes
Privacy van consumentenstatus Siteoverzicht Contact opnemen Privacy en cookies Gebruiksvoorwaarden Over onze advertenties Cookies beheren