Stocks Watch List in Google Sheets

Description
Stocks Watch List in Google Sheets - LIVE Updates!


You can use this template to build your own watch list of stocks.

The Template features are:

1. This template can be used to create your own list of stocks that you want to track performance.
2. Add a stock exchange and ticker symbol to the table and instantly see performance data
3. Customizable columns to display data of your choice
4. 21 day price history data trends shown
5. Indicator to highlight if a stock price exceeds previous 21 days’ high
6. Indicator to highlight if a stock price is lower than previous 21 days’ low
8. To add a new stock to your watchlist, just type a stock symbol in the cell just below the existing symbols


Once the stock exchange and ticker symbol is give, 
You can see the trading volume, current price, change and change %.
You can also see the 52 week price range of each of the stocks.


The Customizable Columns
There are two customizable columns as well.
You can change what is displayed in these two columns easily.
The drop down list shows all the available fields that you can choose from.


21 day history
We also have the price history for the previous 21 days.
Changing the rules for colors
To change the colors of the arrows, you can change the conditional formatting rules.
You can change the conditions easily by typing in a different value for the Green and Yellow colors on top of the watchlist sheet.