Optimisation, Pivot Tables & Amibroker - Aussie Stock Forums

# Thread: Optimisation, Pivot Tables & Amibroker

1. ## Optimisation, Pivot Tables & Amibroker

Many probably know the power of pivot tables in Excel - here is a nice way to use them.

The 3D charts in Amibroker are really good for a visual look at how robust a system is. If you copy the optimise data to Excel you can set up a surface chart using a pivot table. Put the optimize variables as the rows and columns. Drop whatever metric you want to look at as the data and plot the chart. Set the chart type to surface.

Once set up as a chart I can drag different metrics off & on the chart to look at different aspects of the system. So I can quickly look at % drawdown or CAR just by dragging and dropping on the chart. In the example you can drag the "Sum of net %profit" off the chart, grab RAR from the PivotTable field list and drag it onto the chart to see a different view. The 3D view can be easily adjusted as well.

In the example attached the columns are a dummy variable to look at variation of the results. The 0 to 100 axis is the "Monte Carlo" or dummy axis. I also added a custom metric for expectancy. Custom metrics could be used to set up your own measure of system performance based on what you look for in a system, something that I haven't explored yet but apparently mentioned in Howard Bandy's book.

The advantage over the AB 3D charts (although they are really good) the the speed that you can look at all the different metrics vary quickly. It is also a nice way to store a optimisation for later reference.

regards

2. ## Re: Optimisation, Pivot Tables & Amibroker

Stevo,

Great work, appreciate this.
Cheers

3. ## 3D charts and Excel

I simultaneously optimised 4 position sizing parameters and dumped the results to Excel to generate numerous 3D charts. A couple of charts using this technique are shown below. Using the autofilter function and pivot tables I can generate multiple 3D charts relatively easily.

If the charts are not shown above you can see them on my blog.
regards,

4. ## Re: Optimisation, Pivot Tables & Amibroker

Charts?

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
Aussie Stock Forums