As of yesterday

Templates Downloaded

Excel Templates for Stock Market

The Stocks Data type in Excel and Stock History function open doors for a lot of interesting and useful applications in Excel in the stock market or financial market space.

I want to first state that I am not an active trader and that I am not an expert in the stock market. However, the combination of Excel, Mathematics, and Data visualization is motivating and exciting for me. I have published 30 free stock market excel templates that cover a spectrum of applications for the stock market.

Template Topics

  • Viewing the current price and other data for one or multiple stocks or currencies
  • Viewing the price history for one or multiple stocks
  • Viewing the dashboard summary of the stock market as a whole
  • Technical Indicators that are used to analyze the stocks
  • Our own stock screener to find stocks
  • Managing your own portfolio of stocks and track performance

As with all our templates, we will be focusing on providing ‘Simple & Effective’ solutions.

Please do not forget to post your ideas for templates and videos that we should be doing in the future to

Premium Stock Market Templates

  • Stock Screener Excel Template
  • Simple Moving Average Stock Screener Excel Template

Free Stock Market Templates

Complete YouTube Playlist


The templates are compatible with Microsoft 365 subscription. If you already have the subscription then these templates will work in your Excel. If you don’t have a subscription, please use the link below to find details on Microsoft 365. Microsoft 365 offers the most popular suite of Office apps including Word, Excel, PowerPoint, Outlook, Teams and cloud storage on OneDrive.

For a full-fledged trading analysis platform