Looking for a statistic tool

September 24th, 2013, 02:05 PM

Does anybody know a statisctic tool which is able to import a trade list as csv (e.g. from amibroker), filter the trades and create stats from the filtered trades?

Thereby it should be possible to get stats for a specific time periode without retest and to remove trades with unusual high profits. Another nice feature would be to estimate the effect of sucequently introducing initial stops by aim of the MAE.

September 24th, 2013, 04:07 PM

Hi,

I think that it depends how far you want to go in the analysis.

If you want to process only the trades (delete outliers, filter according to time in the day, etc...), it could be done with 3 lines of code with R. I guess that it is possible in Excel too.

Calculating MAE is another story, since you need to know how the price of the instrument has evolved during the trade.

Two not-so-difficult alternative ideas come to my mind. They both require some coding skills.

(1) import the trades list into your platform (through a study run on the chart displaying the price of the instrument), and process. It is possible with Sierra Chart (C++), and I guess that it is possible with Ninja Trader (C#) or MultiCharts .NET (C#)

(2) import the trades list and the price in R and process.

Nicolas

Looking for a statistic tool

Discussion in Trading Reviews and Vendors

Looking for a statistic tool