importing to excel?


Active member
243 0
Does anyone know of a plugin, application or method that can convert system test outputs into a form importable by excel?


Active member
243 0

I am talking specifically about Metastock. I have been doing a lot of system tests and want to analyse the output in various ways on excel. Metastock is weak when it comes to portfolio testing, and this is what I want to check out. I can export information into a text file with metastock, but they have done a very poor job on its output. The text isn't fixed width or coma separated.. its just a congealed mess. It needs manual editing to make it useful. So i was wondering if there was a plugin a something out there that takes metastock test output and converts it into a more useable form.


Junior member
11 0

Only just come across this thread hence late entry. Try highlighting the test results (highlight the top result, then press Ctrl A to take the rest in), copy, and then paste it into Excel. I totally agree with you that the portfolio test reporting is weak. What one actually wants is a complete report for the test which covers all the stocks used, added together.

Have you as yet cracked all the rules for when the test buys and sells (today, tomorrow, on the open, close, etc etc)? I find it thoroughly confusing !
AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock