Reader Contribution

Sell stops, and especially their tracking, have resulted in a lot of reader feedback. While there are many ways to follow the high price of a fund/ETF you own, reader Kirk had this to say a few days ago:

In the spirit of Thanksgiving, I am sharing a sample of an easy to use spreadsheet for Trend Tracking.

Once it is set up, it only takes a few minutes each day to view and make any needed changes.

NOTE: To learn the formulas used for each cell, click on “View” and then “Show Formula Bar”. Then, when you click on a cell it will show the formula used.

This spreadsheet updates prices in real time. For closing prices, open after closing.

Each day, I compare the “Today” column (closing price) to the “Cycle High” column and the “StopSell” column. If the Today price is higher than Cycle High, I manually adjust Cycle High to the new price. If the Today price is lower than StopSell, I make a note to “sell” under “NOTES”. I can open the document the next morning to quickly be reminded what needs to be sold.

I use “change colors with rules” to make it easier to spot important information. Under “Notes” you can see different colors for the words “buy”, “watch”, and “sell” as examples. I also use color coding for “Date of Dividends”. If the date is less than one week old, it will be highlighted so I know to adjust my Cycle High by the dividend amount. I just added that function since Ulli wrote about adjusting for dividends.

I don’t know how many of these rules work with Excel. I am new to both Excel and Google Docs but found Google easier to learn because it has many tutorials available for Financial Data Spreadsheets.

While I personally keep all of my data on my computer, Kirk’s idea of utilizing Google Docs makes sense for those who move around a lot as part of their daily work routine. You’ll always be able to find access to a computer with internet connection to review your sell stops and/or to place trades.

About Ulli Niemann

Ulli Niemann is the publisher of "The ETF Bully" and is a Registered Investment Advisor. Learn more
This entry was posted in Uncategorized. Bookmark the permalink.