This code is a daily stock screener I wrote that goes through all NYSE, NASDAQ and AMEX stocks and calculates their ichimoku values to determine if an important price event has occured. It gathers the stock tickers and automatically sends an email to everyone on the email list.

The Ichimoku Cloud is a technical indicator used most commonly on financial securities to better understand current and future price action. The cloud is particularly useful because it has two leading spans that are plotted 26 periods ahead on the chart. These spans give an indication of the trend future prices may take, which when combined with other technical analysis tools, can be used to trade more profitably.

StockCharts explanation

My screener (which is still a work in progress) looks for Tenkan-sen/Kijun-sen (TK) crosses, bullish cloud folds (span A overtakes span B) and price action that leaves the cloud in a bullish manner. It filters stocks based on volume, marketcap and PE ratio, as well as stocks under $1.00 (no pennystocks).

Add your name in the A column of the Google Sheet.

Sometime between 9-10pm EST Sunday-Thursday. The screener takes about an hour to run and I try to wait a couple hours after market close so that yahoo finance can give me up to date historical data. Also, it is still a work in progress so occasionally errors stop it from running and I have to execute it manually.

The stocks sent in the email are NOT a buying recommendation. They are simply stocks that could be at a pivotal point in their price action. If you don't understand Ichimoku Cloud or stock charts in general this screener will not be very helpful.