Mutual Funds and ETFs - NPORT
READ THIS FIRST
Type in a character string similar to one of the EXAMPLES below and click "Plot".
You can also click any example shown in blue to run it directly.
(DATA BASED PRIMARILY ON N-PORT FILINGS SUBMITTED TO THE SEC)
This menu provides graphs and analysis for ETFs, Mutual Funds, Treasuries, and Portfolios using SEC N-PORT data.
Disclaimer: All results are based on approximate historical data and are provided for informational purposes only. No guarantee is made regarding the accuracy, completeness, or applicability of the results. Historical data and calculated results may contain errors. Use at your own risk. This is not financial advice.
Most features on this page are accessible without logging in during beta testing.
EXAMPLES
N-PORT Flows and Returns:
nport,years,ticker(s) — Shows flows and returns calculated using N-PORT data. Works with ETFs and Mutual Funds.
nport,5,SPY — Shows 5 years of flows and returns for SPY.
nport,5,FPURX — Shows 5 years of flows and returns for Mutual Fund FPURX.
nport,2,SPY,BND — Compares SPY and BND over 2 years.
nport,5,SPY,R — Shows Redemption flows only.
nport,5,SPY,S — Shows Sales flows only.
Holdings:
hldgs,ticker — Displays a holdings pie chart or bar chart using N-PORT data for an ETF or Mutual Fund. This feature has limited practical use for funds with many holdings.
hldgs,FPURX,exc — Downloads the holdings of FPURX as a CSV file.
Flow
flws,years,ticker - shows barchart of total flows
flws,2,spy - Monthly flows of SPY over 2 years
Flow Heatmap:
flm,years,nmonths,numcolors,tickers — Creates a flow heatmap over the specified period, grouped into n-month intervals and displayed using the specified number of colors.
flm,2024,1,9,SPY,QQQ — Monthly flow heatmap for SPY and QQQ during 2024 using 9 colors.
flm,2023-24,3,9,x_secs — 3-month flow heatmap for the X_SECS group during 2023-2024 using 9 colors.
Fund Snapshot:
snapshot,ticker — Displays a snapshot for an ETF or Mutual Fund.
snapshot,QQQ
Assets Under Management:
aum,years,ticker1,ticker2,... — Shows the cumulative change in Assets Under Management (AUM) over the specified period for one or more funds.
aum,7,SPY
aum,5,SPY,QQQ,VOO,FXAIX
Below Queries May Take Much Longer:
The following commands analyze holdings across the N-PORT database and may require more processing time.
SUM - Analyze N-PORT Holdings:
sum,field1,field2=xxx — Groups N-PORT holdings by field1, with an optional selection condition.
For conditions containing text, use two single quotes around the text.
Examples:
sum,assetcat,upper(Fundname) like ''%%VANGUARD%%''
— Groups holdings by asset category for funds with VANGUARD in the fund name.
sum,assetcat,issuercat=''UST''
— Groups U.S. Treasury holdings by asset category.
sum,'' '',
— Shows the sum for all funds. Use two single quotes as shown.
Add ,exc at the end of a query to download the results as a CSV file.
SUM,MATURITY,ISSUERCAT=''UST'' and assetcat=''DBT'',exc
— Downloads a CSV showing the maturities of U.S. Treasury debt holdings across funds.
If field1 contains two fields separated by a comma, replace the comma with /.
Example:
sum,assetcat/issuercat,invcountry=''IN'',exc
— Groups holdings by ASSETCAT and ISSUERCAT for investments with country code IN and downloads the result as a CSV file.
When using CONCAT, use & instead of a comma inside CONCAT.
SUM,CONCAT(ASSETCAT&"|"&ISSUERCAT),
— Categorizes holdings across all funds using both ASSETCAT and ISSUERCAT.
Funds Holding a Ticker:
byticker,ticker — Displays the funds/ETFs holding the highest percentage of the specified ticker.
byticker,TSLA — Shows funds with the highest percentage of their holdings in TSLA.
byticker,TSLA,exc — Downloads the results as a CSV file.
byticker2,ticker — Displays the funds/ETFs holding the largest dollar amount of the specified ticker.
byticker2,TSLA — Shows funds holding the largest dollar amount of TSLA.
byticker2,TSLA,exc — Downloads the results as a CSV file.
Advisors Holding a Ticker:
byadvisor,ticker — Displays advisors whose funds hold the highest percentage of the specified ticker or ISIN.
byadvisor,TSLA,exc — Downloads a CSV listing advisors whose funds have the highest percentage exposure to TSLA.
byadvisor2,advisor,ticker — Displays funds/ETFs within a specified advisor holding the largest amount of the specified ticker or ISIN.
byadvisor2,Vanguard,TSLA — Shows Vanguard funds holding the largest amount of TSLA.
byadvisor2,Vanguard,TSLA,exc — Downloads the results as a CSV file.
Registered Fund Assets:
dupe — Displays a breakdown of Registered Fund assets by asset type.
The command scales holdings to match the fund's stated AUM and excludes inactive funds.
dupe — Uses the latest supported data.
dupe,2026-03-31 — Shows the breakdown as of the specified date.
dupe,2026-03-31,exc — Downloads the results as a CSV file.
Only two quarters of data are supported at any given time.
Pricing of ISIN or ticker in Funds - as csv file download
pricing,US9128285W63,2026-03-31,exc , pricing,TSLA,2026-03-31,exc Note : works only to about 9 months in the past
Total Registered Fund AUM:
regf — Shows total AUM for all Registered Funds.
A date may be specified to obtain the total as of that date.
Example:
regf,2026-02-28
Total Registered Fund AUM History:
Size,yrs : monthly history of total aum for yrs years
Example:
size,1 Will list AUMs each month over past 1 year
size,2,exc Will downlod AUMs each month over past 2 years into an excel csv file
Money Market Funds:
mmkt — Displays a breakdown of Money Market Fund assets by asset type using the latest available data.
mmkt
Other Ways to Specify the Time Period:
The following formats work with most, but not all, features on this page.
Year:
2022 — Uses data from 1/1/2022 through 12/31/2022.
Year Range:
2021-2023 or 2021-23 — Uses data from 1/1/2021 through 12/31/2023.
YTD:
Uses data from the beginning of the current year through today.
Years:
2 — Starts 2 years ago.
2.3 — Starts 2.3 years ago.
3.5-6 — Uses data from 6 years ago through 3.5 years ago.
Months:
3M — Starts 3 months ago.
3M-7M — Uses data from 7 months ago through 3 months ago.
Date Range:
20210912 — Uses data from 9/12/2021 through today.
20210912-20231231 — Uses data from 9/12/2021 through 12/31/2023.