This is a simple calculator i made in excel for anybody who like to trade simple moving averages. Just input the closing prices and it will give you a value for which the price has to hit tomorrow in order to cause a crossover. I created it because I realized that often times i wanted to buy a stock and was waiting for some momentum via a crossover but the stock i was wanting to buy went way above the crossover and I missed out at maximizing profit. This allows you to determine buy stops and sell stops so you can get in intraday via a buy stop or sell stop at the crossover price. Please remember though you will get false positives sometimes, and the closer together the values you pick, the more likely a crossover will occur.
-REMEMBER- Don't drag cells around, as it screws up the formula ranges, only do copy and paste. Also you may want to check my work before you use it in your trading strategy. I'm pretty sure its correct but you never know. If you find an irregularity, send me a comment with the price data you used and i will try to fix it. Keep a default copy that you work from, so that you have it incase you accidently move some cells around.
I hope you like it, the technical junkies will.