How to Get Mutual Fund Holdings in Excel

Get mutual fund holdings directly in Excel using custom formulas. Retrieve financial data, automate your workflows, and keep your spreadsheets updated with our Excel add-in.

Install Add-inView Pricing
No VBA/Macros Required
Microsoft Certified Add-in
2-Minute Setup
EXCEL FORMULA
=FDN("MutualFundHoldings", "VTSAX", "", 5)

This formula pulls data into your spreadsheet once our Excel add-in is installed.

Formula Result

See exactly how data fills into your sheet when the formula runs. This example shows the actual up-to-date information returned.

ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1central_index_keyregistrant_nameperiod_of_reportfund_namefund_symbolseries_idclass_idissuer_namelei_numbertitle_of_securitytrading_symbolcusip_numberisin_numberamount_of_unitsdescription_of_unitsdenomination_currencyvalue_in_usdpercentage_value_compared_to_assetspayoff_profileasset_typeissuer_typecountry_of_issuer_or_investmentis_restricted_securityfair_value_levelis_cash_collateralis_non_cash_collateralis_loan_by_fund
20000036405VANGUARD INDEX FUNDS2026-06-30Admiral SharesVTSAXS000002848C000007806Boston Beer Co Inc/The529900Q02MQ0DCQNRM58BOSTON BEER-ASAM100557107US1005571070237531NSUSD42050112.930.001829985045LongECCORPUSFalse1FalseFalseFalse
30000036405VANGUARD INDEX FUNDS2026-06-30Admiral SharesVTSAXS000002848C000007806Alumis Inc—ALUMIS INCALMS022307102US02230710203139756NSUSD88352733.840.00384503561LongECCORPUSFalse1FalseFalseTrue
40000036405VANGUARD INDEX FUNDS2026-06-30Admiral SharesVTSAXS000002848C000007806Flexible Solutions International Inc—FLEX SOLUTIONS IFSI33938T104CA33938T1049270455NSUSD1801230.30.000078388006LongECCORPUSFalse1FalseFalseFalse
50000036405VANGUARD INDEX FUNDS2026-06-30Admiral SharesVTSAXS000002848C000007806Liberty Broadband Corp549300MIX43II8JLN536LIBERTY BR-CN/A530307305US53030730513761502NSUSD125107556.520.005444574141LongECCORPUSFalse1FalseFalseFalse
60000036405VANGUARD INDEX FUNDS2026-06-30Admiral SharesVTSAXS000002848C000007806Celsius Holdings Inc—CELSIUS HOLDINGSCELH15118V207US15118V20796080911NSUSD178049074.080.007748543825LongECCORPUSFalse1FalseFalseTrue
ABCDEF
1central_index_key00000364050000036405000003640500000364050000036405
2registrant_nameVANGUARD INDEX FUNDSVANGUARD INDEX FUNDSVANGUARD INDEX FUNDSVANGUARD INDEX FUNDSVANGUARD INDEX FUNDS
3period_of_report2026-06-302026-06-302026-06-302026-06-302026-06-30
4fund_nameAdmiral SharesAdmiral SharesAdmiral SharesAdmiral SharesAdmiral Shares
5fund_symbolVTSAXVTSAXVTSAXVTSAXVTSAX
6series_idS000002848S000002848S000002848S000002848S000002848
7class_idC000007806C000007806C000007806C000007806C000007806
8issuer_nameBoston Beer Co Inc/TheAlumis IncFlexible Solutions International IncLiberty Broadband CorpCelsius Holdings Inc
9lei_number529900Q02MQ0DCQNRM58——549300MIX43II8JLN536—
10title_of_securityBOSTON BEER-AALUMIS INCFLEX SOLUTIONS ILIBERTY BR-CCELSIUS HOLDINGS
11trading_symbolSAMALMSFSIN/ACELH
12cusip_number10055710702230710233938T10453030730515118V207
13isin_numberUS1005571070US0223071020CA33938T1049US5303073051US15118V2079
14amount_of_units237531313975627045537615026080911
15description_of_unitsNSNSNSNSNS
16denomination_currencyUSDUSDUSDUSDUSD
17value_in_usd42050112.9388352733.841801230.3125107556.52178049074.08
18percentage_value_compared_to_assets0.0018299850450.003845035610.0000783880060.0054445741410.007748543825
19payoff_profileLongLongLongLongLong
20asset_typeECECECECEC
21issuer_typeCORPCORPCORPCORPCORP
22country_of_issuer_or_investmentUSUSUSUSUS
23is_restricted_securityFalseFalseFalseFalseFalse
24fair_value_level11111
25is_cash_collateralFalseFalseFalseFalseFalse
26is_non_cash_collateralFalseFalseFalseFalseFalse
27is_loan_by_fundFalseTrueFalseFalseTrue
A mutual fund is an investment fund that pools money from numerous investors to purchase securities. Mutual funds are not traded on stock exchanges, but they can be bought and sold through brokerage firms or fund companies. Our Excel add-in provides information on the securities held by mutual funds.

Steps to Get Started

01
Install the Add-in

Open Excel, navigate to the Home tab, select Add-ins, and search for FinancialData.Net.

02
Grab Your Key

Sign in to your account at FinancialData.Net, open the dashboard, and copy your API key.

03
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)
datasetString
Specifies the dataset to query. Enter the dataset name enclosed in quotation marks, for example "MutualFundHoldings".
identifierString
Accepts one or multiple identifiers such as ticker symbols (e.g., "AAPL" or "AAPL,MSFT") or other supported identifier types.
argumentString
Filters the dataset output using an additional parameter, such as a date like "2025-01-15" or a reporting period like "year" or "quarter".
maxRowsInteger
Limits the number of records returned by the formula. For example, setting the value to 5 returns the five most recent rows.

Troubleshooting & FAQ

If Excel doesn't recognize the =FDN() formula, the add-in may not have loaded correctly. Restart Excel or reinstall the add-in from the Office Add-ins Store.

Excel displays this error when it does not recognize the =FDN() formula. This means the add-in is either not installed or has been disabled.

The =FDN() formula outputs multiple rows and columns of data, which Excel blocks if any existing text or formatting occupies the surrounding cells. Simply clear these obstructing cells to allow the formula to expand completely.

Install the Excel Add-in

Access 80+ financial datasets directly in Excel using simple formulas.

Install via AppSource
Compatible with Office 365 and Excel for Web
Data Subscriptions for Excel
Standard SubscriptionCore financial data
$29 / mo
Premium Subscription
Full financial data
$69 / mo
Get Started