Strategy, Back Testing, Automated Models

Just a few questions to some experienced pipsters. I’m attempting to test a few strategies that I’ve created and need to find out where I can download historical data on Forex for regression tests. I’m predominantly going to be using EXCEL and VBA for analyzing the data unless there are better suggestions.

While I’m at it, let me ask a few more questions:

  1. Do you have a favorite software for back testing strategies? I’m seeing dozens on the market but want to know what’s the best one. I don’t trade on indicators but predominantly S/R levels. Any suggestions for software that would automatically find S/R levels or at the very least let me define a criteria for S/R would be ideal but not necessary.
  2. Any material you’d recommend as a must read for anyone who is trying to regression test their own strategies?
  3. Is there any EA (or other similar tool) that will let me specify how to close trades at specific spots? For example, I routinely run into an issue where I enter a trade late at night and set a trailing stop as well as a stop loss…but I find that the trailing stop triggers too early when the markets reach a midpoint between support and resistance levels. It’d be nice to have the ability to automate closing down parts of the order at specific intervals instead (EX: close 33% of order XXXXXXX at 10% of 1.4540, etc).

Would greatly appreciate the insight.

I love Forex Tester 2 for backtesting. Look around for a Forex Tester or Metatrader programmer on eLance or oDesk to create an indicator or EA, that is the best way to go. The programmer I used had my indicator ready in a couple of days.

Forex Tester works good for simulating discretionary trading with it’s pseudo-MT4 interface (almost an exact replica). I like it.

How does this work?