Tax Season is Here! Save 15% on H&R Block Online
iconAll times are GMT -4. The time now is 02:52 AM. | Search:

» StockRants Stock Forum » Public Stock Forums » Member Uploads » SMA Crossover Calculator



Reply
 
Thread Tools Search this Thread
Old 08-03-2009, 07:15 PM   Nav to Top  #1
BuffaloBull
VIP Trader
 
BuffaloBull's Avatar
 
Join Date: May 2009
Location: Tempe
Posts: 65
Favorites: SPNG
Rep Power: 162
Reputation: 851
BuffaloBull is a splendid one to beholdBuffaloBull is a splendid one to beholdBuffaloBull is a splendid one to beholdBuffaloBull is a splendid one to beholdBuffaloBull is a splendid one to beholdBuffaloBull is a splendid one to beholdBuffaloBull is a splendid one to behold
Default SMA Crossover Calculator

I created this for anybody that likes to trade SMA crossovers but finds it difficult to calculate what the price would need to be for the specific crossover. Often times the crossover happens midday, and you can't determine if the crossover happened until after close. This allows to maximize profits using stop losses or stop buys for momentum swing investing intraday.

-It goes up to 29 days
-Just input the closing prices and the crossover values and the work is done for you.

How to use this for trading:
-Set your favorite crossover settings.
-If you are interested in buying a stock that you expect to get some momentum but aren't sure if it will hit the escape momentum put a buy limit stop slightly above the crossover, so if it hits your stop (escape momentum) you will catch it on the uptrend.
-You can do the same if you wish to sell on crossovers too. You can place your stop loss slightly below or at the crossover to maximize gains before a consolidation period.
-This has to be updated everyday to know where the crossover price would have to be.

Note: Crossover trading is not perfect, you will experience some false positives, so the key to success is risk management. Always set tight stop losses after a buy and then adjust accordingly in order to be profitable in the long run.

I just made this, and have only tested this a little bit, so if you notice that the math is off, send me a comment with values you used, and i will try to fix it and re-upload it.

Good Luck, Be sure to share good swing candidates in the forums.

FINAL NOTE- DON'T DRAG THE CELLS UP TO MAKE IT EASIER TO UPDATE, IT CHANGES THE FORMULA RANGES, INSTEAD USE COPY AND THEN PASTE SPECIAL AND SELECT (VALUES) TO MOVE EVERYTHING UP. THEN JUST DELETE WHAT YOU DON'T NEED. Also keep a default copy incase you accidently change something because i'm pretty sure this works as it should.
Attached Files
File Type: xls Crossover Calculator.xls (66.0 KB, 15 views)

Last edited by BuffaloBull; 08-03-2009 at 07:44 PM..
BuffaloBull is offline   1 thumbs up / 0 thumbs down. Rate this post Yes | No Reply With Quote
Reply

Tags
Calculator, Crossover, momentum, SMA, swing, Trading

Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Point Calculator Bigfoot Member Uploads 3 05-21-2009 10:13 AM
ROI calculator glossynappy Technical Stuff 0 05-12-2009 12:39 PM
Pivot Point Calculator DanB Technical Stuff 1 04-28-2009 05:25 AM


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On