The foundation of this template is the Stocks Data type and StockHistory function. If the price < min (21 days history of closing prices) then we will see a cross mark. If the price > max (21 days history of closing prices) then we will see a check mark.
We also have a column to indicate recent performance. You can change the conditions easily by typing in a different value for the Green and Yellow colors. To change the colors of the arrows, you can change the conditional formatting rules. We also have the price history for the previous 21 days. The drop down list shows all the available fields that you can choose from. You can change what is displayed in these two columns easily. There are two customizable columns as well. You can also see the 52 week price range of each of the stocks. You can see the trading volume, current price, change and change %. To add a new stock to your watchlist, just type a stock symbol in the cell just below the existing symbols – as shown below. Indicator to highlight if a stock price is lower than previous 21 days’ low.Indicator to highlight if a stock price exceeds previous 21 days’ high.Customizable columns to display data of your choice.Add a stock ticker symbol to the table and instantly see performance data.This template can be used to create your own list of stocks that you want to track performance. Template features Stocks Watchlist Excel Template
0 kommentar(er)
