Member-only story
How to Track Stocks at Great Buying Opportunites
An easy to follow guide to make a reliable tracker
I had started looking at data for a different article I planned to write. Like always, I spent way too much time looking at the data and playing around with it.
But, I decide what I had created was helpful for my investing future, so I thought I’d share it.
What I created was a spreadsheet using Google finance that tracks how much a stock is off its 52 week high, in terms of percentage.
This information can help identify a great buying opportunity into a company you are interested in owning. Below are the steps to make your own!
Set Up the Structure
First, you need a new Google Sheets from within your Google Drive.
The first thing you’re going to want to do is add your headers. I have mine in row 4. There are several ways to build a tracker like this.
The way I did mine the only cell in the headers that needs to be exactly like mine is Today’s changepct. The formula will read off “changepct” so make sure yours is set up like that as well. To clarify, that means “Today’s” should be in the row above it.
