This tab shows the same data as the 'Watchlist' tab, but allows you to use the template as a 'Screener', so that you can sort and filter your watchlist according to custom criteria. Shares: The number of shares outstanding / available to tradeįields listed with an asterisk (*) are hidden columns by default in the tracker, but can be unhidden if you want to see them.Įach of the columns listed above will also be shown in the 'Sort Filter' tab, as well as the 'Favorites' tab.*Gap (Pure): The gap percentage considering the low / high price for the day.

*Low: Lowest price for current trading day.*High: Highest price for current trading day.Gap %: The percentage that the price has risen / fallen since open.Open Price: The opening price for the current trading day.Volume Today: The volume for the current trading day.Daily (7 Days): This column shows the daily price trend over a 7-day period.Daily (3 Months): This column shows the daily price trend over a 3-month period.Weekly (2 Years): This column shows the weekly price trend over a 2-year period.Here are the types of data that you can view for each stock in the watchlist: This tab allows you to see a variety of data related to each stock symbol that is entered into the watchlist The red sparkline shows the price trend over 2 years, the yellow sparkline shows the price trend over 3 months, and the green sparkline shows the price trend over 12 days. This stock analysis template displays sparklines for each stock in your watchlist, showing the price trend on three different timelines.

Always double check data with other sources, and perform your own research, before placing trades. Note that the cells which can be edited in this template, are colored grey.Īgain, do not place trades based off of these trackers. You can also use the tracker as a 'screener', to filter / sort your watchlist by specified criteria, so that you can generate lists of stocks that match the criteria you are looking for in your trading strategy. This stock tracker will allow you to keep a watchlist of up to 132 stocks, and will analyze the performance / statistics of each stock in your watchlist, such as the current price, how much the price has risen / fallen for the day, the price trend over time, and more. Stock Analysis Template (Watchlist + Screener)Īnalyze the performance of chosen stocks, then sort and filter by custom criteria

Google Sheets Stock Portfolio Trackers: Advanced Versions.

Stock Analysis Template (Watchlist + Screener).

Easily access DailyHabits through your mobile browser. Or perhaps you had an epiphany and you want to make a note of it.Don't lose that thought. Mark it as done right there on your mobile. You might be at the gym finishing off your exercise habit. No journey is complete without reflection, which promotes self-awareness and prompts you to evaluate your own progress, as well as areas where you need to improve.Ultimately, you are the best judge of your own journey. It's more important that you continue doing your habit. But don't let that stop your progress.Goals are based on flexible consistency, which makes it okay to fail sometimes. With a simple calendar view, you can see your activity for the entire month to see how you're doing and which areas you might need to focus on. Visualize your entire month at one glance A simple habit tracker app that helps you do more, by doing less.

Google sheets weight tracker template