The first step in comparing, selecting and/or designing trading systems, âexpert sourcesâ and indicators would seem to be some analytics as to their performance over time, over different instruments and in various market conditions. My question is how to best do those analytics? Trading environments such as tradestation, ningatrader, amibroker and metastock do a good job showing you an indicator on the screen and giving you buy/sell recommendations from a strategy. They will also give you some level of back testing capability, abet limited. Tradestation in particular is very limited in that it canât even back test a group of stocks, compare a set of strategies or support rotation. Yet TS seems like the best supported environment (I had hopes for OOEL, but it also is very limited). I can dump data out of these and do some analytics in Excel, but that can be very slow and clumsy. For example it would not be easy at all to compare 2000 stocks over 10 strategies. If I want to answer questions like âwhat is the probability of a gap being closed within 2 daysâ and âwhat are the probabilities of the gap getting wider by various percentages prior to gap closingâ, etc. The trading platforms are simply not set up for this kind of analytics and back testing is insufficient. I would also have to do some major excel programming in VB to support such analytics. The analytics environment would seem to be a good place to explore optimizations and alternatives and may include genetic algorithms, etc. On the other hand, I would really prefer to have the indicators and systems all defined in one environment â reproducing formula in 2 environments would be time consuming, error prone and expensive. So the options I am looking at include: â¢ doing all the formula in a trading environment (probably TS) and exporting data to excel. â¢ Having formula in both the trading environment and excel. â¢ Using Excel as the primary environment (i.e. AnalizerXL). â¢ Buying/Learning MATLAB or "R". â¢ Extending ningatrader to provide some of these capabilities (since it is based on a general language) â¢ Using some kind of business intelligence (i.e. pentaho) or data mining (i.e. rapidminder) package. â¢ A âtechnicalâ solution would be to do formula in a DLL which could be used by multiple environments, but that could be a lot of work. I donât mind writing some code but donât want this to be a lifeâs work either. So my question is: what is the best way to do analytics in support of selecting and/or designing trading systems? The group on this forum would seem to be the kind of people that would have some answers to a common need. Thanks in advance for your thoughts!