I would like to save the optimization result in either TXT or CSV file with the data delimited by comma or tab when the optimization completes.
I think it would be either a feature in WL7 itself or a method to call from BacktestComplete so that I can directly import the files to Excel for further processing.
Currently I optimize on WL6 and I copy-past manually from the optimization result window to Excel. It's a lot of work when optimizing tens or hundreds of symbols.
I think it would be either a feature in WL7 itself or a method to call from BacktestComplete so that I can directly import the files to Excel for further processing.
Currently I optimize on WL6 and I copy-past manually from the optimization result window to Excel. It's a lot of work when optimizing tens or hundreds of symbols.
Rename
Wealth-Lab can do better than these hackish ways. Instead of doing a copy/paste to Excel or saving optimization results from BacktestComplete, the Wealth-Lab 7 way is to build an optimization visualizer to visualize the results and post-process them with external math libraries (for example):
https://www.wealth-lab.com/Support/ExtensionApi/Optimizer
https://www.wealth-lab.com/Support/ExtensionApi/OptimizationVisualizer
https://www.wealth-lab.com/Support/ExtensionApi/Optimizer
https://www.wealth-lab.com/Support/ExtensionApi/OptimizationVisualizer
Those ExtensionAPI look overkill for my purpose but I'm interested in post-processing the results.
Let's say I wouod like to post-process the results as follows (filtering and sorting), which ExtensionAPI and which method I have to implement?
- Trades > number of trading days * 50%
- Winning % > 30%
- Net Profit > 10% of Starting Capital
- Sort by Net Profit
Let's say I wouod like to post-process the results as follows (filtering and sorting), which ExtensionAPI and which method I have to implement?
- Trades > number of trading days * 50%
- Winning % > 30%
- Net Profit > 10% of Starting Capital
- Sort by Net Profit
Haven't you already entered a feature request for this and Dion agreed that it's feasible (provided the request gets enough votes to break in the top)?
https://www.wealth-lab.com/Discussion/Filter-optimization-results-6482
https://www.wealth-lab.com/Discussion/Filter-optimization-results-6482
That feature request still requires manual filtering and sorting. Obviously better than the hackish ways but I'm not just waiting for it to getting enough votes.
Here I'm interested in either exporting the results automatically or coding to filter and sort the results automatically.
Because I have 50 to 100 symbols to optimize frequently, any manual operation still takes a lot of time.
Here I'm interested in either exporting the results automatically or coding to filter and sort the results automatically.
Because I have 50 to 100 symbols to optimize frequently, any manual operation still takes a lot of time.
Your Response
Post
Edit Post
Login is required