Exporting to Excel

To export the evaluation results to Excel, click the button in Results View Parameters:

 

Excel is opened automatically. (Must be Excel 2007 or later).

The workbook contains 5 or 6 sheets, depending on whether you are in commodity or portfolio mode.

Summary

Shows summary table and summary chart. The summary chart displays the value of the first row in the worksheet. Click the values in column A to change the chart.

Formulas

Shows parameters: Start Date, End Date, Value Display, Bar Interval, Showing, Portfolio/Commodity, Sell Signal, Sell Entry Price, Buy Signal, Buy Entry Price.

Data

Shows columns: Commodity, Date, Entry, and bars. Rows of short entries are have an orange background. Positive bars out values are green, negative are red, and neutral are black.

Profit Curve

Shows pivot table and pivot chart for the table in the Data worksheet.

Distribution

Shows table of distribution data calculated dynamically depending on selected bars out in Distribution worksheet.

Portfolio

Shows pivot table and pivot chart for the table in the Data worksheet.