EDIT: I originally set up this thread for 2 reasons ... firstly to help those that were asking for it by showing them how to setup the spreadsheet or any other to import the info in the exported sheets ... I modified it to show both the FxPro and IBFx pairs because at that time Trader101 was often giving examples of trades he had taken using his method, showing sometimes FxPro examples and sometimes IBFx ... so I thought it might be useful to see both on one sheet.
This thread was never meant to offer yet another system for monitoring the Trader101 setup... there are two great ones out there already for that. ... please see my post#24 of this thread for the rest of this ... thanks
-----------------------------------------
EDIT: I may be jumping the gun a bit people but it seems that the main originator of this style of trading, Trader101, has decided to make the IBFx Pairs the 'Universal Pairs' for any on going development ... this solves a lot problems regarding indicator development and allows us all to concentrate our efforts and analysis of this new method of trading in one unified direction... So my current advice to any newcomers is to open an IBFx account and focus your studies on the threads below regarding the methods as well as Orest's and Crodzillas ongoing developments on their threads.
----------------------------------------
Just a short thread for all the people who have PM'd and emailed me regarding their setup problems with the spreadsheets and DSN script exports.
Firstly Acknowledgments.
Of course to Trader101. Julius Thank you for sharing the results of 2 years work with all of us here. Truly an extrodinary new way of observing the markets. Many Many Thanks Mate.
Original Thread:- Simple Trading Method with trader101.
http://www.forexfactory.com/showthread.php?t=107119
Follow on Thread:- Signals for Simplicity ... from page 9.
http://www.forexfactory.com/showthread.php?t=57375
Hope I’ve got the names right … PM me and I will fix if not.
Franco … corvogrigio … Thanks for the Original version of this Spreadsheet … Looking forward to the next versions.
Luke …. hndymann … Thanks for the Conditional Formatting rules … a Brilliant way to observe slot jumping … that saved me from embarrasing myself with a nasty code module that the truly gifted (Yourself, Orest, Crodzilla, RonaldRaygun) would have wet themselves laughing at … thanks hndymann.
Ian … ianf0ster .. Thanks for the PipToDollar multiplier rules … they seem to be working fine … (another great Limey contribution
).
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
This spreadsheet does NOT replace the IAs that you need to set up each week ... You will need the ProfitCalc for its trend advice and whatever goodies Julius is kind enough to share with us in future versions.
However it does allow you to:-
1) OverRide the Sunday Midnight (GMT) imported file Opening prices ... with any opening prices that you like ... to match your IAs... to match Julius... to do daily's .... ect.
2) Observe multiple IA opening times for 5 weeks back for both FxPro and IBFx pairs.
The Spreadsheet shows PipToDollar conversions that should exactly match any IA you have running if you have set the open prices in ImportSheet1 to these opening prices ... Totals are without Swaps but should match Julius's ProfitCalc.
All scripts and Screenshots are for FxPro demo account IA purposes. The difference between FxPro and IBFx is marginal so should not make that much difference ... please feel free to correct me if I am wrong here.
I find it is best not to use the Auto Sort too often ... this give hndymans condtional formatting a chance to show you the slot movement.
I am considering putting in a slot movement history ... showing the last 3 slots that the pair occupied... but obviously this will only be valid if you keep the sheet open 24/7 and not sure if it will show much more than the formatting.... comments please.
The rest of the sheet is self explanatory really... Please feel free to PM me, post any comments or complaints ... the first will be appreciated ... the latter ignored.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
EDIT: Bug in 1.1 now on 1.2 ... TextImport Connections for NZDJPY AND NZDUSD were not set up .... Sorry ... this will mean you will have to go through the TextImport File selection set up again if you have not done so already .... That should be it for ImportSheet1 .... I hope.
.
This thread was never meant to offer yet another system for monitoring the Trader101 setup... there are two great ones out there already for that. ... please see my post#24 of this thread for the rest of this ... thanks
-----------------------------------------
EDIT: I may be jumping the gun a bit people but it seems that the main originator of this style of trading, Trader101, has decided to make the IBFx Pairs the 'Universal Pairs' for any on going development ... this solves a lot problems regarding indicator development and allows us all to concentrate our efforts and analysis of this new method of trading in one unified direction... So my current advice to any newcomers is to open an IBFx account and focus your studies on the threads below regarding the methods as well as Orest's and Crodzillas ongoing developments on their threads.
----------------------------------------
Just a short thread for all the people who have PM'd and emailed me regarding their setup problems with the spreadsheets and DSN script exports.
Firstly Acknowledgments.
Of course to Trader101. Julius Thank you for sharing the results of 2 years work with all of us here. Truly an extrodinary new way of observing the markets. Many Many Thanks Mate.
Original Thread:- Simple Trading Method with trader101.
http://www.forexfactory.com/showthread.php?t=107119
Follow on Thread:- Signals for Simplicity ... from page 9.
http://www.forexfactory.com/showthread.php?t=57375
Hope I’ve got the names right … PM me and I will fix if not.
Franco … corvogrigio … Thanks for the Original version of this Spreadsheet … Looking forward to the next versions.
Luke …. hndymann … Thanks for the Conditional Formatting rules … a Brilliant way to observe slot jumping … that saved me from embarrasing myself with a nasty code module that the truly gifted (Yourself, Orest, Crodzilla, RonaldRaygun) would have wet themselves laughing at … thanks hndymann.
Ian … ianf0ster .. Thanks for the PipToDollar multiplier rules … they seem to be working fine … (another great Limey contribution

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
This spreadsheet does NOT replace the IAs that you need to set up each week ... You will need the ProfitCalc for its trend advice and whatever goodies Julius is kind enough to share with us in future versions.
However it does allow you to:-
1) OverRide the Sunday Midnight (GMT) imported file Opening prices ... with any opening prices that you like ... to match your IAs... to match Julius... to do daily's .... ect.
2) Observe multiple IA opening times for 5 weeks back for both FxPro and IBFx pairs.
The Spreadsheet shows PipToDollar conversions that should exactly match any IA you have running if you have set the open prices in ImportSheet1 to these opening prices ... Totals are without Swaps but should match Julius's ProfitCalc.
All scripts and Screenshots are for FxPro demo account IA purposes. The difference between FxPro and IBFx is marginal so should not make that much difference ... please feel free to correct me if I am wrong here.
I find it is best not to use the Auto Sort too often ... this give hndymans condtional formatting a chance to show you the slot movement.
I am considering putting in a slot movement history ... showing the last 3 slots that the pair occupied... but obviously this will only be valid if you keep the sheet open 24/7 and not sure if it will show much more than the formatting.... comments please.
The rest of the sheet is self explanatory really... Please feel free to PM me, post any comments or complaints ... the first will be appreciated ... the latter ignored.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
EDIT: Bug in 1.1 now on 1.2 ... TextImport Connections for NZDJPY AND NZDUSD were not set up .... Sorry ... this will mean you will have to go through the TextImport File selection set up again if you have not done so already .... That should be it for ImportSheet1 .... I hope.
.
Attached File(s)