Google Finance Watchlist Template: A Free Template for Investors to Keep a Close Watch on Their Stocks

Wisesheets Real Time Watch list Template

Ever wished to keep a close eye on the ever changing value of the stocks in your portfolio? If your answer is yes, then you have come to the right place because we have the perfect solution! This Google Finance watchlist template is free to download and easy to use. It allows you to track the performance of a particular set of stocks .

You can now stay informed about any changes in their value. The template automatically updates with the latest information from Google Finance and Wisesheets. You can download it now and get started!

What is the Google Finance Watchlist Template, and How Does it Work?

The Google Finance watchlist template is a free, easy-to-use spreadsheet that allows you to track the performance of a particular set of stocks. It gets its information from Google Finance and Wisesheets.

The best feature, of this template, is that it is automatically updated with the latest data to keep an eye on, when looking at stocks. The data includes metrics such as market capitalization, PE, EPS, Volume, percent from the 52-week high, and more.

Wisesheets Real-time Watch List Template

What you need to do is simply enter the ticker symbols for the stocks you want to track, between cells B3 to B13, and the template will do the rest.

Click here to get free access to the template.

How to use the Google Sheets Watchlist Template to keep Track of your Stock Watchlist?

Your first step should be to click on the link above to get access to the template. Then, you will be prompted to make a copy of the file. Click on 'make a copy'. Now you can enter the ticker symbols for the stocks you want to track between cells B3 and B13. The template will automatically populate all the relevant information from Google Finance and Wisesheets. From here, you can use various filters and more conditional formatting rules to identify stocks that interest you.

This can be done by looking at the fundamental ratios like PE ratio, as well as, pricing metrics, such as, the automatically generated price chart, percentage from 52-week high, and volume.

As you analyze different companies, or a new company piques your interest, you can easily add it to the list so that you can compare it with the existing stocks on your watchlist.

*Note you need to have a Wisesheets account to get data in the template. Don't worry, you can easily get your account by signing up here.

Features of the Watchlist Template that can Help you in Making Sound Investment Decisions

Following is a list of features of the Watchlist Template. They can help you make sound investment decisions.

  • Automatically updated data from Google Finance and Wisesheets.
  • Ability to track multiple stocks at the same time.
  • Relevant information, such as, market capitalization, PE, EPS, Volume, and percentage from 52-week high.
  • Easy to use and customize the template

How to Customize the Watchlist Template to Suit Your Needs

One of the best aspects of conducting stock analysis, on a Google Sheet spreadsheet, is flexibility. Luckily, you can make any modifications and changes you'd like with the free Google Finance watchlist template.

After the file is duplicated, you could make aesthetic changes in fonts, colors, formatting, etc. You can also add more companies to the watchlist by dragging the existing formulas to the new rows. More importantly, you can add more columns with other key metrics and relevant stock data.

Here you can see how easy adding metrics such as ROIC and ROE to the template using the Wisesheets formulas.

Stock's ROIC on Google Sheets

If you'd like to learn more about customizing the template and adding more metrics, then be sure to check out this article describing how you can do that.


The Google Finance watchlist template is a powerful yet free tool that could be used by investors to stay on top of their investments. The template gets its data from Google Finance and Wisesheets, so the information is accurate and up-to-date.

Plus, it's easy to use, and you could customize it to fit your needs. Hence, if you are looking for a free way to track your stocks, then check out the Google Finance watchlist template.

Guillermo Valles
 | Website

Hello! I'm a finance enthusiast who fell in love with the world of finance at 15, devouring Warren Buffet's books and streaming Berkshire Hathaway meetings like a true fan.

I started my career in the industry at one of Canada's largest REITs, where I honed my skills analyzing and facilitating over a billion dollars in commercial real estate deals.

My passion led me to the stock market, but I quickly found myself spending more time gathering data than analyzing companies.

That's when my team and I created Wisesheets, a tool designed to automate the stock data gathering process, with the ultimate goal of helping anyone quickly find good investment opportunities.

Today, I juggle improving Wisesheets and tending to my stock portfolio, which I like to think of as a garden of assets and dividends. My journey from a finance-loving teenager to a tech entrepreneur has been a thrilling ride, full of surprises and lessons.

I'm excited for what's next and look forward to sharing my passion for finance and investing with others!

Related Posts