fbpx

6 Flexible, Free Investment Spreadsheets With Real-Time Trends

An investment spreadsheet remains one of the most popular, flexible tools for tracking your portfolio. Indeed, it's been said that "Every serious DIY investor still uses stock tracking spreadsheets."

A simple investment spreadsheet remains one of the most popular and flexible tools for tracking your portfolio.

The benefits of using your own spreadsheet to track your investments include privacy, simplicity, and endless flexibility.

With a spreadsheet, you can track the value of your stocks, mutual funds, ETFs, and more. Or you can run custom reports and analyze trends, project your tax liability, and visualize retirement income scenarios.

Keeping Your Holdings Data Current

stock exchange board

Both Google Sheets and Excel (with a 365 subscription) make it easy to automate current and historic stock pricing data in your spreadsheets.

Updated stock data in Excel

Stocks is a new Excel feature for Microsoft 365 subscribers. It’s a type of “linked data” because it connects to an online data source. Use to keep your stock prices updated with a refresh of your workbook. Learn more here.

Meanwhile, the STOCKHISTORY function retrieves historical data about a financial instrument and loads it as an array. Learn more here.

Updated stock data in Google Sheets

There are more high-quality, free investment trackers for Google Sheets than Microsoft Excel. That’s because of Google Sheets has long supported the GOOGLEFINANCE function.

Unlike the Stocks data type in Excel, GOOGLEFINANCE automatically updates your spreadsheet with the latest prices every 20 minutes.

➜ You might also consider using a net worth template or retirement planning template along with one of the free templates below.

Free Investment Templates for Google Sheets

Investment Tracking Spreadsheet for Google Sheets

Stock Tracking Spreadsheet

Track the daily price history of your stocks in Google Sheets with this simple template powered by Google Finance.

Or, read how to make your own investment tracker for Google Sheets in this post.

“Ultimate Investment Tracking Spreadsheet” from Rob Berger

Best Investment Tracking Spreadsheet Google Sheets
Ultimate Investment Tracking Spreadsheet

Leading money expert (and founder of Dough Roller) Rob Berger has shared an excellent Google Sheets investment tracker on his site. It tracks fundamentals for your holdings such as purchase price, current value, and expense ratio. But you can also designate an asset class for each of your holdings. The template then automatically tracks your allocations over time, so you can see when you it’s time to rebalance your portfolio.

Rob has detailed instructions and a video on his blog.

Bonus: Simple Investment Calculator for Google Sheets

Simple Investment Calculator Google Sheets
Monthly Family Budget Template

See if you’re on track with your investment goals and model how changes to your strategy might impact the end result with this free investment calculator for Google Sheets.

Free Investment Templates for Excel

Simple Investment Tracker for Excel

Investment Tracker Excel

Use Excel to track your investments. It’s as easy as typing text into a cell and converting it to the Stocks data type.That connection allows you to bring back rich, interesting information that you can work with and refresh. This accessible investment tracking spreadsheet template is perfect for stock portfolio tracking and gives you a simple overview of your current portfolio with current prices and details of your assets.

Free Stock Quotes in Excel from Vertex42

excel stock quotes and portfolio template

This simple template from Vertex42 uses Excel’s Stock data type to get price updates, and also contains a basic stock portfolio worksheet that uses VLOOKUP to get the current price based on the stock symbol.

Stock Portfolio Tracker Excel Template 

Stock Portfolio Tracker Excel Template

The Stock portfolio tracker Excel template from Indzara shows:

  • Current market value of all your stocks and the Cash balance
  • Portfolio mix by instrument type and industry
  • Today’s market performance and your portfolio performance
  • List of all your stocks with performance data (Quantity, Gain/Loss, % Gain/Loss, etc.)
Edward Shepard

Edward Shepard

Marketing Lead at Tiller. Writer. Spreadsheet nerd. Get in touch with partnership ideas at edward @ tillerhq.com.

Start Your Free Trial

"There isn’t another tool on the market that does what Tiller can do.”
Will Hinton, Google Review October 30, 2023