Trader101 Method Back Testing Tool Q+A

Quoting CindyXXXX

Disliked

This process may appear by it’s length to be confusing and time consuming but once you do it once you will be able to set up each week of your choosing for back testing the Trader101 system in just 10 minutes

NOTE One more thing be careful not to delete any of the formulas accidentally or the spreadsheet won’t function properly. If a cell has no formula in it then it is obviously safe to delete anything in the cell but otherwise be careful. If you mess up the spreadsheet you can always download it again or save a hardcopy for yourself.


1 – Download the spreadsheet Blueprint and save it in a place you will remember


2- Open the spreadsheet – There are 4 different sheets: Results, Chart, Data, and Import (small tabs at the bottom of the page) just click them to cycle through the different sheets.

Go to file and click “save as” “Week 15th September (for the example we are using below). This means you will always have a “blank” blueprint to test any new weeks you want. So any time you want to start a new test just open up the original “blueprint and “save as” the week you are going to back test.


The pairs you see in the Results tabs are the pairs for Interbank Fx users because that’s the Platform I use.

If you use different pairs just replace them in the FIRST (top) table of the Results sheet. So all your Sell pairs go in the red cells and all your Buy pairs go in the green cells.

So for example if you one of your SELL pairs is CAD/JPY just click on any of the RED cells and type CAD/JPY and press enter…. Easy.





(notice Above in the second “group” the CAD/JPY was automatically entered because I changed it in the first group)

So now our pairs are sorted we want to decide on which week we want to back test…..

Ignored

Quoting trader101

Disliked

Cindy,
i dont know if this is the right forum, maybe is should be in Trading discussion, its up to the mods, then i will link this to my post #1.
Julius

Ignored

Quoting shiva

Disliked

Hey Cindy, can this thread be used for general discussion on t101 method?

Ignored

Quoting Tjpld

Disliked

What helps alot having a currency Dashboard to compare the various currencies.

Ignored

Quoting shiva

Disliked

Wow! What in the name of lord is that hehehe. Is this thing available somewhere? is it a trading platform? I like how it displays news releases

Ignored

Quoting Aad

Disliked

You can find the latest about that MT4 indicator here...

Ignored

Quoting CindyXXXX

Disliked

Hi All

I have decided to open this thread so if anyone has any questions about the back testing questions they can have them answered here as I under stand the insrtuctions are pretty long and may envoke some confusion in how to use the Spreadsheet so if you have any queries ask away...

[size=3][font=Times New Roman]Also the Spreadsheet and PDF instructions (you will need to read to set up the spreadsheet) is attached... If you don't know what I'm on about...

Ignored