Watching a Trend Develop

April 22, 2022

Trading with Microsoft Excel spreadsheets (and eSignal intraday tabular price data).

Since we use 35 minute price data (Open, High, Low, Close), we are usually on top of the movement  and development of medium and short trends.   But, price changes can surprise and catch a trader who is off guard and not paying attention.

So, pay attention to your Microsoft Excel spreadsheet charts as you add prices during the trading day.

Here is the Emini S&P June 2022 contract as of mid-day:

Explanation of the above chart:

Yellow dots are end-of-day markers.  Green dots are bullish momentum dots.  Gray dots are neutral momentum dots.  Red dots are bearish momentum dots.

Blue line is the blue Bill Williams Alligator line.  This is the 13 bar s.m.a. of the close, then smoothed by 8.

Red Line is the 29 bar s.m.a.  of the close.  This is our primary trend direction tool.

Using 35 minute price data.

Good luck to your trading!