Spreadsheet to Calculate Buy/Sell Levels
Hi All,
I don't know if anyone will find this useful or not, but I've generated a simple spreadsheet that calculates all of the buy/sell levels for Williama's system (which has intrigued me since I first read this thread 3 days ago).
I had to generate the spreadsheet because I'm using NinjaTrader and I need to calculate the SL and TP in pips from the stop price.
So here's the poop:
Simply enter the current price and all the other fields are calculated for you.
You can adjust the Spread, Steps (between levels), and the Half Range. This means that you can use it for any currency pair.
The spreadsheet may be lock protected. Only the fields you would want to change are unlocked. If for any reason you'd like to unprotect the sheet, the password is "stop" (less quotes).
Oh yeah. You'll notice that the Level 0 buy and sell are offset in the middle of the spreadsheet. I did this because I think that you would normally only enter a level 0 after a level 1 has been triggered. So it just keeps it outta the way until you need it.
Have fun!
Bogie
Hi All,
I don't know if anyone will find this useful or not, but I've generated a simple spreadsheet that calculates all of the buy/sell levels for Williama's system (which has intrigued me since I first read this thread 3 days ago).
I had to generate the spreadsheet because I'm using NinjaTrader and I need to calculate the SL and TP in pips from the stop price.
So here's the poop:
Simply enter the current price and all the other fields are calculated for you.
You can adjust the Spread, Steps (between levels), and the Half Range. This means that you can use it for any currency pair.
The spreadsheet may be lock protected. Only the fields you would want to change are unlocked. If for any reason you'd like to unprotect the sheet, the password is "stop" (less quotes).
Oh yeah. You'll notice that the Level 0 buy and sell are offset in the middle of the spreadsheet. I did this because I think that you would normally only enter a level 0 after a level 1 has been triggered. So it just keeps it outta the way until you need it.
Have fun!
Bogie
Attachments
Last edited: