Click image for larger version. 

Name:	GBPUSDH1ChartTesterFailgrid.png 
Views:	28 
Size:	14.1 KB 
ID:	41642


Spreadsheets are a fairly old invention. Modern programs of this type have tremendous power and allow you to visually analyze data presented in tabular form. The analysis can be done from different angles and is performed quite quickly. It includes graphs, summary tables, what-if analysis, conditional cell formatting and much more.

I suggest testing some of this power to analyze custom strategies.

Personally, I use LibreOffice Calc because it is free and it works wherever I work :-) However, the same approach works for other spreadsheets: Microsoft Excel, Google Sheets, etc. Currently, they all allow converting into each other and feature the same principles of constructing equations.

So, I assume, you have some kind of spreadsheet program. You also have data in a text file format (*.txt or *.csv) you want to analyze. The article briefly describes how to import such files. I will use history from MetaTrader terminal, however, any other data will do, like Dukascopy or Finam. Obviously, you should have a strategy to configure signals. This is all that is required to apply article propositions in trading.

I hope, the article will be useful to different categories of traders, so I will try to write it so that it is understandable even for people who have never seen programs of this type before. At the same time, it will cover a range of issues even some experienced traders are not familiar with.
more...