Stock Price Chart in Google Sheets – Dynamic – LIVE updates

Looking for a simple template to view price history of stocks of your choice? This is the template for you!

Stock Price Chart Template in Google Sheets

Read along to know the features of this simple yet quite useful template and how to use it.


Template features

A very important visual in the area of stock markets is the price chart of a stock.

Stock Price Chart in Google Sheets

The template allows

  • Entering a stock ticker symbol to pull in up to an year of price history
  • Allows controlling the period displayed on the chart (5 days, Month To date, 3 Months, etc.)
  • Allows controlling the interval of price data – Daily or Weekly
  • Automatically identifying the max and min price points on the chart based on your period range and interval choices
  • Shows the volume of trading daily with green color bars for periods when closing price was greater than previous period’s closing price and red bars when closing price was less than previous period’s closing price.

You can change the Exchange Code and Ticker symbol and immediately view the price chart for a stock.

Features of Stock Price Chart in Google Sheets

To select the stock you are interested in, you need to enter the correct Exchange Name and the correct Ticker symbol in the sheet as shown below.

Enter Exchange code and Ticker symbol for stock


The template can pull up to an year of price history by default. You can choose how much history to display on the chart easily using the drop-down.

Stock Price Chart: Dynamic Periods

The options are 5 Days, Month Till Date, 1 Month, 3 Months, 6 Months, Year Till Date and 1 Year.


The template allows price history at 2 different intervals.

Stock Price Chart: Dynamic Intervals

Daily/Weekly are the options.

Premium Stock Templates in Google Sheets

Premium Stock Templates in Microsoft Excel


Please share your feedback and suggestions on the comments below.

Related Templates

Leave a Reply

Your email address will not be published. Required fields are marked *