Entering text into the input field will update the search result below

Real-Time Watchlist: Never Miss Your Target Buying Price In Times Of High Volatility

Apr. 03, 2018 2:49 PM ETAAPL, ABBV, MO36 Comments
Stefan Redlich profile picture
Stefan Redlich


  • For years, volatility in the stock market has been very low and prices generally only knew one direction which is upward.
  • Ever since the February stock market correction, volatility has returned and with that came some heavy price fluctuations for stocks.
  • Attractive buying prices for quality stocks now come and go quickly, and in order to not miss these, this real-time watchlist with automated email triggers comes in handy.
  • Users will get automatic email updates once the target price has been reached with specific information.
  • By default, you will get no duplicate mails but you can change set behavior and define your own email frequency.

The big news in Q1/2018 for the stock markets has been the return of volatility.

Source: CBOE - VIX Volatility Index

With the markets now moving up and down by hundreds of points in the Dow Jones Industrial Index, this creates attractive buying opportunity for savvy investors.

Here are a few examples of such sharp price fluctuations:

  • Apple (AAPL): The stock dropped from $179 on January 18, 2018, to as low as $155 on February 8 before recovering to $182 on March 12 and currently trading at $168.
  • AbbVie (ABBV): The stock traded as high as $123 at end of January, fell back to $108 on February 8, recovered to $120 by March 13, and nosedived to $92 on March 27.
  • Altria (MO): The stock has been on a constant downward trend since December 19 when it traded at almost $74. It fell sharply in February to $62, recovered slightly to $66, and dropped to $59 on March 23. It is currently trading at $62.

In all these three examples, we can observe some heavy price fluctuations in quality stocks. In the case of Altria for instance, I received the following automated email trigger on March 22:

This popped up on my smartphone connected to Gmail, and as my target price of $60 had finally been reached, I made the call to buy more stock.

If you want to replicate that, following is the link to the respective script-based Google Sheet: Email watchlist with triggers

To start, please make your own personal copy of that tool by clicking on "File" and "Make a copy."

Every minute (the default setting), it is evaluated whether the defined target price has been reached, and if it has indeed, you will receive an email which looks as depicted. You will not get any duplicate emails.

This article was written by

Stefan Redlich profile picture
I am working as a Business Analyst and Data Engineer in Germany and have started to build up a portfolio focused on Dividend Growth, both on the high and low-end yield spectrum. Primary focus is on Blue Chips with long-reaching dividend track records. I have been investing for 2 years and have been standing on the sidelines for way too long before. I love developing spreadsheets in Google and Excel to analyze financial performance and integrate these two sources with each other!Happy to connect on the various channels!

Analyst’s Disclosure: I am/we are long MO, AAPL, ABBV. I wrote this article myself, and it expresses my own opinions. I am not receiving compensation for it (other than from Seeking Alpha). I have no business relationship with any company whose stock is mentioned in this article.

Seeking Alpha's Disclosure: Past performance is no guarantee of future results. No recommendation or advice is being given as to whether any investment is suitable for a particular investor. Any views or opinions expressed above may not reflect those of Seeking Alpha as a whole. Seeking Alpha is not a licensed securities dealer, broker or US investment adviser or investment bank. Our analysts are third party authors that include both professional investors and individual investors who may not be licensed or certified by any institute or regulatory body.

Recommended For You

To ensure this doesn’t happen in the future, please enable Javascript and cookies in your browser.
Is this happening to you frequently? Please report it on our feedback forum.
If you have an ad-blocker enabled you may be blocked from proceeding. Please disable your ad-blocker and refresh.