ETF Worksheet for 2024

If you’re looking for a smart way to invest your money, exchange-traded funds (ETFs) might be your best bet. These investment vehicles offer a hassle-free and cost-effective way to access a diverse range of assets, including stocks, bonds, and alternative investments. With ETFs, you can quickly diversify your portfolio and minimize your risk while enjoying the benefits of a simplified investment process. ETFs offer core advantages of low-cost diversification, tax efficiency, and ease of buying and selling. The popularity and growth of ETFs have surpassed traditional mutual funds and for a good reason.

At Successful Portfolios, we want to help you make smart investment decisions. That’s why we’re excited to offer our readers a complete ETF Worksheet (Excel) featuring data on over 3,000 US-based ETFs. This valuable resource includes critical metrics such as market price, net assets, expense ratios, Morningstar ratings, and more, providing a detailed snapshot of each ETF’s performance and characteristics.

Whether you’re a seasoned investor or just starting, our custom ETF worksheet is designed to help you analyze and compare ETFs efficiently so you can make informed investment choices that align with your financial goals.

Our worksheet is fully formatted and ready to rank, sort, and filter.

✔ Data as of 01/31/2024

 👉 Download the ETF Worksheet 

Here are the definitions for each of the ETF Worksheet columnar data points according to Morningstar:

  • Name: The official name of the fund or security.
  • Ticker: The unique series of letters representing a particular stock or mutual fund.
  • Market Price (Daily): The price of the security in the market, updated daily, in US dollars.
  • Net Assets – Share Class: The total value of a fund’s investment portfolio minus its liabilities in US dollars.
  • Average Spread/Price Ratio: The average difference between a security’s bid (buy) and ask (sell) prices, divided by its price.
  • Prospectus Net Expense Ratio: The total annual fund operating expenses, including management fees, administrative fees, and other asset-based costs, expressed as a percentage of average net assets, as reported in the fund’s prospectus.
  • Actively Managed: Indicates whether the fund’s portfolio is managed by investment professionals with discretion to decide what securities to buy or sell or passively managed based on an index like the S&P 500.
  • Global Broad Category Group: The global category to which the fund belongs, based on the types of securities it invests in and its investment strategy.
  • US Category Group: The US-specific category to which the fund belongs, based on the types of securities it invests in and its investment strategy.
  • Morningstar Rating Overall: A rating given by Morningstar based on a fund’s risk-adjusted returns compared to other funds in the same category. It ranges from 1 to 5 stars, with five being the best.
  • Morningstar Medalist Rating: A rating given by Morningstar analysts based on their conviction in the fund’s ability to outperform its peer group and relevant benchmark on a risk-adjusted basis over the long term. ETFs are rated Gold, Silver, Bronze, Neutral, or Negative.
  • Total Ret YTD (Daily): The fund’s total return for the current calendar year is updated daily in US dollars.
  • Total Ret 1 Year (Daily): The fund’s total return for the past year, updated daily, in US dollars.
  • Total Ret Annualized 3-Year (Daily): The annualized total return of the fund for the past three years, updated daily, in US dollars.
  • Total Ret Annualized 5-Year (Daily): The annualized total return of the fund for the past five years, updated daily, in US dollars.
  • Total Ret Annualized 10-Year (Daily): The annualized total return of the fund for the past ten years, updated daily, in US dollars.
  • Total Ret Annualized 15-Year (Daily): The annualized total return of the fund for the past 15 years, updated daily, in US dollars.
  • # of Holdings (Long): The number of securities the fund holds.
  • Morningstar Portfolio Risk Score (MPRS): A measure of the overall risk of a portfolio or ETF based on the volatility of its returns relative to a fitting benchmark Morningstar Target Risk Index.
  • Std Dev 3 Year (Mo-End): The standard deviation of the fund’s returns over the past three years, indicating the volatility or risk associated with the fund’s investment returns.
  • Inception Date: The date when the fund was first launched.
  • Primary Prospectus Benchmark: As stated in its prospectus, the fund benchmark index is used for comparison purposes.
  • Morningstar Category: The category assigned by Morningstar is based on the fund’s investment strategy and the types of securities it invests in.

Need Help?

Please consider scheduling a free consultation with Parker Evans, CFA, CFP. During this consultation, Parker can walk you through our ETF Worksheet and help you make informed investment decisions based on your specific financial situation and goals. Parker’s extensive knowledge in portfolio construction and risk analysis can be extremely helpful in navigating the often complicated world of investing.

Make an Appointment

Talk to Parker Evans, CFA, CFP