Mutual Funds and ETFs - NPORT

Type in the character string similar to EXAMPLES for each type of graph and click "Plot" - use Examples for guidance

DATA used in this MENU is based on NPORT filings submitted to SEC

MANY GRAPHS FOR EQUITIES,ETFs,FUNDS,TREASURIES,AND PORTFOLIOS.
Disclaimer: All results are based on approximate historical data and are for informational purposes only. No guarantee is made as to the accuracy, completeness, or applicability of the results. Use at your own risk. This is not financial advice and is not guaranteed to be accurate.

MOST FEATURES ON THIS PAGE IS ACCESSIBLE WITHOUT LOGON FOR BETA TESTING.

Historical data and results may be inaccurate. Use at your own risk. THIS IS NOT FINANCIAL ADVICE.

EXAMPLES

nport,5,SPY — Shows 5-year flows and returns using NPORT (works for ETFs or Mutual Funds).
• Example: nport,5,FPURX shows mutual fund FPURX or , nport,2,SPY,BND — compares SPY and BND for 2 years.
nport,5,SPY,R will show only Redemption flows, nport,5,SPY,S will show only Sales flows.

hldgs,ticker — Displays a holdings pie chart or bar chart from NPORT (limited use) for an ETF or Mutual Fund.
• Example: hldgs,FPURX,exc — downloads the holdings as CSV - more practical use.

flm,years,nmonths,numcolors,tickers - a Flow heatmap for "years" in n-month buckets for tickers with colors=numcolots
• Example: flm,2024,1,9,spy,qqq or flm,2023-24,3,9,x_secs

snapshot,ticker — Displays a snapshot for an ETF or Mutual Fund.
• Example: snapshot,qqq

aum,years,ticker1,ticker2 etc - shows sum of aum change over years for given ticker(s)
• Example: aum,7,spy or aum,5,spy,qqq,voo,fxaix etc

Below Queries take much longer

sum,field1,field2=xxx - shows result of a query on nport holdings grouped by field1 where field2=xxx is a selection
• Example: sum,assetcat,upper(Fundname) like ''%%VANGUARD%%'' or sum,assetcat,issuercat=''UST'' etc -entries within quotes need two single quotes. sum,'' '', will show sum of all funds. Use two single quotes. Add ,exc at end to download result as csv. This following query will give a csv with list Maturities of US Treasuries held in all funds SUM,MATURITY,ISSUERCAT=''UST'' and assetcat=''DBT'', exc
if field1 contains two parts separated by a comma, replace the commma with a / Eg: sum,assetcat/issuercat,invcountry=''IN'',exc
SUM,CONCAT(ASSETCAT&"|"&ISSUERCAT), For all funds assets categorized by ASSETCAT and ISSUERCAT - use & instead of , inside concat

byticker,ticker — Displays top funds(etfs) holding the highest percentage of given ticker
• Example: byticker,tsla — shows top funds with highest percent of TSLA holdings. byticker,tsla,exc will download a csv file

byticker2,ticker — Displays top funds(etfs) holding the highest amount of given ticker
• Example: byticker2,tsla — shows top funds with highest amount of TSLA holdings. byticker2,tsla,exc will download a csv file.

byadvisor,ticker — Displays top advisors holding the highest percentage of given ticker (or isin)
• Example: byadvisor,tsla,exc — downloads csv file listing top advisors with highest percent of TSLA holdings

byadvisor2,advisor,ticker — Displays top funds(etfs) holding the highest amount of given ticker (or isin) within the given advisor
• Example: byadvisor2,Vanguard,tsla — Displays top funds(etfs) holding the highest amount of tsla within Vanguard funds. byadvisor2,vanguard,tsla,exc will download a csv file.

dupe - Displays a breakdowm of all Registered funds by various asset types. dupe,2025-12-31 does it as of that date. This command scales the holdings to match the stated AUM - also ignores dead funds.
• Example: dupe, dupe,2025-12-31, dupe,2025-12-31,exc etc.. At any time only two quarters are supported

regf - Shows total aum in all Registered Funds. regf,2025-03-31 shows the data as of March 31,2026
• Example: regf,2026-02-28

mmmkt - Displays a breakdowm of all money market funds by various asset types based on latest available data
• Example: mmkt

Other ways to specify years are: (in most cases on this page- not all)
Year - eg: 2022 will use data from 1/1/2022 to 12/31/2022
Year range : eg: 2021-2023 or 2021-23 will use data from 1/1/2021 to 12/31/2023
YTD : year to date
Years : 2 will show data from 2 years ago, 2.3 will data from 2.3 years ago, 3.5-6 will show data from 6 years to 3.5 years ago
Months : 3M will show data from 3months ago, 3M-7M will show data from 7 months ago to 3 months ago
daterange : 20210912 will show data from 9/12/2021 till today. 20210912-20231231 will show data from 9/12/2021 to 12/31/2023