System Messages

This forum is for members of the Apiary Investment Fund. To learn more about how to get involved, sign up now or fill out the form below and preview the training right now!

Overnight Whipsaw Trade Template

Back to Forums

Overnight Whipsaw Trade Template

Hi Everyone,

I have started trading the Overnight Whipsaw strategy and would spend up to half an hour doing the math to get a trade set up before going to bed. Being tired at that time of day it seemed to take a long time for me so I put together this spreadsheet to do the math. It works great for me and I would like to share this to possibly help you with this task if you are interested in trying it.

What you will need is the daily ATR that goes in column B, the Current Price (CP) goes in column C, and your Risk Management Lot size goes in column H. The spreadsheet will then figure your entry prices with the Buy info on the left and the Sell info on the right including the entry, Stop Loss (SL) and Take Profit (TP). 

You can also use the Forex Volatility Tool from the website for your ATR data here is the link

I am currently using this with EURUSD and GBPUSD but you can try it with your markets and see if it works for you. I don't have the link for the video that explains the Overnight whipsaw strategy so maybe someone can share it if you have it available.

Let me know if I can help with any questions.


Onite Whip Worksheet.ods13.55 KB
Tue, 09/10/2019 - 11:15pm

Thanks for the template. That does make things easier.

Here is a link to one of the Whipsaw Setup videos:

Best of luck to you.


Thanks Brad.
Thanks for posting the link. Are you using the whipsaw in your silver account or in a sim account? I am testing it and watching my numbers with it to make adjustments to my style. So far I have noticed that if I check the daily chart for an ATR reading with a 3 period setting and then I go to and compare their volatility and I use the smallest of the two in order to increase the odds of completion.

Good look on your journey to Gold III will see you there soon.


I only used it a couple of times so far in the sim account. I've really been on the strategies I know are working for me to get through Silver. Now that I have your spreadsheet, I am going to test it out in the sim account as I am looking for a good overnight strategy.
By the way, I hope to be in Gold I in the next 6 hours or so.


thanks for the useful information


Very cool. Can't wait to try this out! Thanks for sharing!



Thanks for sharing this. I have been trading overnight, and sometimes it works and sometimes it doesn't. I will definitely watch the video.


I like it.


Thanks everyone for the kind words.
@Brad, Yeh I have 2 more profitable 10 pip days and I will be going to Silver II, shooting for Wednesday.. Well it has been about 5 hours since your post and I am hoping you made it to Gold!!!


Thanks mboegel. I will try this out.