The following charts were generated from Amibroker optimise runs. I optimised a number of criteria, %Risk, minimum position size $, capital and maximum number of trades held - all at the same time. What results is a lot of data that I then transfered to Excel. Using Autofilters and pivot tables in Excel I can fix some parameters, as well as exclude others, and create 3D charts as shown below.
I had some fun with colours - the default ones set on my version of Excel didn't really work for me.
So in the one spreadsheet I have, amongst other things, a large number of 3D combinations to consider. I lose the ability to rotate the charts but I did customise the colours to my liking. It's a little time consuming generating pivot tables and determining what values to include / exclude, what parameters to fix and what value to fix them at but I feel I am only scratching the surface with Excel.
regards
stevo
