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

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

Exit mobile version