+1 888 340 6572

Using Performance Report: Difference between revisions

From MultiCharts
No edit summary
 
(9 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Performance reports are calculated based on trades and can be used to analyze strategy performance and check trades list and statistics. There are over 100 performance indices available for analysis, including about 30 charts.<br>
Performance reports are calculated based on trades and can be used to analyze strategy performance and check trades list and statistics. There are over 100 performance indices available for analysis, including about 30 charts.
 
There are two report types available: '''Strategy Performance Report''' and '''Trading Performance Report'''. One or the other can be used depending on one’s current goals. Check [[Comparison of the Reports]] for more info.
There are two report types available: '''Strategy Performance Report''' and '''Trading Performance Report'''. One or the other can be used depending on one’s current goals. Check [[Comparison of the Reports]] for more info.


Line 23: Line 24:


<div class="tip">Upon left-clicking on any performance index its description will appear in the lower right panel.</div>
<div class="tip">Upon left-clicking on any performance index its description will appear in the lower right panel.</div>
<div class="important"> Portfolio Trader Strategy Performance Report and MultiCharts Strategy Performance Report contain slightly different analysis parameters and display options. Further description is based on MultiCharts Strategy Performance Report functionality</div>
<div class="important"> Portfolio Trader Strategy Performance Report and MultiCharts Strategy Performance Report contain slightly different analysis parameters and display options. Further description is based on MultiCharts Strategy Performance Report functionality.</div>


=== Viewing Performance Indices ===
=== Viewing Performance Indices ===
Line 30: Line 31:


# In the left panel select a performance indices section to review.
# In the left panel select a performance indices section to review.
# In the right side move cursor on a performance index required. The cursor will change into '''Description'''  [[File:12_Cursor.gif]] cursor then left-click.  
# In the right side move cursor on a performance index required. The cursor will change into '''Description'''  <img src="https://www.multicharts.com/trading-software/images/9/93/Cursor_Description.png?20240719133820g" width="24"> cursor then left-click.  
# In the lower right panel a text description will appear. Click '''Close'''  <img src="https://www.multicharts.com/trading-software/images/a/ad/Delete_Instrument.png" width="24"> button to close the description panel.
# In the lower right panel a text description will appear. Click '''Close'''  <img src="https://www.multicharts.com/trading-software/images/a/ad/Delete_Instrument.png" width="24"> button to close the description panel.
# Use '''Back''' <img src="https://www.multicharts.com/trading-software/images/2/25/Scroll_Left.png" width="24">  and '''Forward''' <img src="https://www.multicharts.com/trading-software/images/a/a2/Scroll_Right.png" width="24"> toolbar buttons to move between the Performance Report sections.
# Use '''Back''' <img src="https://www.multicharts.com/trading-software/images/2/25/Scroll_Left.png" width="24">  and '''Forward''' <img src="https://www.multicharts.com/trading-software/images/a/a2/Scroll_Right.png" width="24"> toolbar buttons to move between the Performance Report sections.
Line 40: Line 41:
# In the left panel select a performance chart to review.  
# In the left panel select a performance chart to review.  
# Click '''Zoom In''' <img src="https://www.multicharts.com/trading-software/images/3/30/Zoom_In.png" width="24"> or '''Zoom Out''' <img src="https://www.multicharts.com/trading-software/images/b/bf/Zoom_Out.png" width="24"> toolbar buttons for zooming charts in an out respectively.  
# Click '''Zoom In''' <img src="https://www.multicharts.com/trading-software/images/3/30/Zoom_In.png" width="24"> or '''Zoom Out''' <img src="https://www.multicharts.com/trading-software/images/b/bf/Zoom_Out.png" width="24"> toolbar buttons for zooming charts in an out respectively.  
# Use '''Pan''' <img src="https://www.multicharts.com/trading-software/images/e/ec/Show_Hide_Cross_200.png" width="24"> or '''Cross''' <img src="https://www.multicharts.com/trading-software/images/3/3d/Background_Dragging.png" width="24"> cursor modes for moving charts or precise reviewing chart values respectively.
# Use '''Pan''' <img src="https://www.multicharts.com/trading-software/images/3/3d/Background_Dragging.png" width="24"> or '''Cross''' <img src="https://www.multicharts.com/trading-software/images/e/ec/Show_Hide_Cross_200.png" width="24">   cursor modes for moving charts or precise reviewing chart values respectively.
# Use '''Back''' <img src="https://www.multicharts.com/trading-software/images/2/25/Scroll_Left.png" width="24">  and '''Forward''' <img src="https://www.multicharts.com/trading-software/images/a/a2/Scroll_Right.png" width="24"> toolbar buttons to move between the Performance Report sections.
# Use '''Back''' <img src="https://www.multicharts.com/trading-software/images/2/25/Scroll_Left.png" width="24">  and '''Forward''' <img src="https://www.multicharts.com/trading-software/images/a/a2/Scroll_Right.png" width="24"> toolbar buttons to move between the Performance Report sections.


Line 53: Line 54:
Report-Chart Synchronization simplifies this process. Trades on the chart are automatically highlighted when the user hovers his mouse over a trade in the Strategy Performance Report.
Report-Chart Synchronization simplifies this process. Trades on the chart are automatically highlighted when the user hovers his mouse over a trade in the Strategy Performance Report.


To learn more about this feature, see [[Using_Performance_Report#Setting_Display_Properties|Setting Display Properties]]
To learn more about this feature, see [[Using_Performance_Report#Setting_Display_Properties|Setting Display Properties]].
 
<br>


== Setting Performance Report Properties ==
== Setting Performance Report Properties ==
Line 67: Line 66:
It is also posiible to display trades with partial exits basing on entries or on exits.
It is also posiible to display trades with partial exits basing on entries or on exits.


<br>
=== Setting Financial Properties ===
=== Setting Financial Properties ===


To set financial properties:  
To set financial properties:  


# In the Strategy Performance Report window click '''Settings''' [[File:10_Format_Window.png]] toolbar button.
# In the Strategy Performance Report window click '''Settings''' <img src="https://www.multicharts.com/trading-software/images/8/8b/Edit_Instrument.png" width="24"> toolbar button.
# Select the '''Financial''' tab.
# Select the '''Financial''' tab.
# Set appropriate properties or click '''Default''' to set back to the default settings.<br>'''No. of standard deviations''' - the number of standard deviations is used in some report indices calculation. The default is 1.<br>'''Minimal acceptable rate of return''' - reference point for Sortino Ratio (See "Performance Ratios" section in the Performance report).<br>'''Degree of risk aversion of the investor''' - reference point for Fouse Ratio (See "Performance Ratios" section in the Performance report).<br>
# Set appropriate properties or click '''Default''' to set back to the default settings.<br>'''No. of standard deviations''' - the number of standard deviations is used in some report indices calculation. The default is 1.<br>'''Minimal acceptable rate of return''' - reference point for Sortino Ratio (See "Performance Ratios" section in the Performance report).<br>'''Degree of risk aversion of the investor''' - reference point for Fouse Ratio (See "Performance Ratios" section in the Performance report).<br>
# Click '''OK'''.<br>
# Click '''OK'''.<br>
<br>


=== Setting Display Properties ===
=== Setting Display Properties ===
Line 83: Line 79:
To set display properties:  
To set display properties:  


# In the Strategy Performance Report window, click the '''Settings''' [[File:10_Format_Window.png]] toolbar button.
# In the Strategy Performance Report window, click the '''Settings''' <img src="https://www.multicharts.com/trading-software/images/8/8b/Edit_Instrument.png" width="24"> toolbar button.
# Select the '''Display''' tab.
# Select the '''Display''' tab.
# Select '''USD''' to display the report in U.S. dollars or select '''Regional Currency''' to display the report in another currency.  If '''Regional Currency''' is selected, enter the exchange rate in the '''USD/$ rate''' textbox.
# Select '''USD''' to display the report in U.S. dollars or select '''Regional Currency''' to display the report in another currency.  If '''Regional Currency''' is selected, enter the exchange rate in the '''USD/$ rate''' textbox.
Line 90: Line 86:
# Select the '''Enable Strategy Performance Report – Chart Synchronization''' check box to visually match the trades in the performance report to the signals in the chart.<br><br>Two additional options become available if this checkbox is selected:
# Select the '''Enable Strategy Performance Report – Chart Synchronization''' check box to visually match the trades in the performance report to the signals in the chart.<br><br>Two additional options become available if this checkbox is selected:
#* Select the '''Entry-based''' radio button to match the trade in the performance report to its entry signal in the chart.
#* Select the '''Entry-based''' radio button to match the trade in the performance report to its entry signal in the chart.
#* Select the '''Exit-based''' radio button to match the trade in the performance report to its exit signal in the chart.<br><div style="background-color: #E5F6FF;">To use this feature, in the Strategy Performance Report:<br>
#* Select the '''Exit-based''' radio button to match the trade in the performance report to its exit signal in the chart.<br>To use this feature, in the Strategy Performance Report:<br>
## Expand '''Trade Analysis''' in the tree view pane.
## Expand '''Trade Analysis''' in the tree view pane.
## Select '''List of Trades'''.
## Select '''List of Trades'''.
## Hover the mouse pointer over any trade on the list.  The trade on the list will be matched with the signal for this trade in the chart.  The signal on the chart will be highlighted.
## Hover the mouse pointer over any trade on the list.  The trade on the list will be matched with the signal for this trade in the chart.  The signal on the chart will be highlighted.
# Select '''Recalculate the Report on each new order''' checkbox to update the Strategy Performance Report in real-time with each new trade.  If a new trade is made while the Strategy Performance Report is open, the Strategy Performance Report will be updated immediately with the new trade.<br>If this checkbox is unchecked, then the Strategy Performance Report will be updated with the new trade only after closing and reopening the Strategy Performance Report.
# Select '''Recalculate the Report on each new order''' checkbox to update the Strategy Performance Report in real-time with each new trade.  If a new trade is made while the Strategy Performance Report is open, the Strategy Performance Report will be updated immediately with the new trade.<br>If this checkbox is unchecked, then the Strategy Performance Report will be updated with the new trade only after closing and reopening the Strategy Performance Report.
# Click '''OK'''.  
# Click '''OK'''.
 
<br>


== Saving Performance Report ==
== Saving Performance Report ==
Line 103: Line 97:
To save the Performance Report:  
To save the Performance Report:  


# In the Strategy Performance Report window click '''Save''' [[File:Portfolio_Save.png]] toolbar button.
# In the Strategy Performance Report window click '''Save''' <img src="https://www.multicharts.com/trading-software/images/4/41/Save-24-200.png" width="24"> toolbar button.
# In the '''Save As''' dialog window appeared navigate to the required file location.
# In the '''Save As''' dialog window appeared navigate to the required file location.
# In the '''File Name''' field type in the file name.<br><div style="background-color: #E3FBE5;">Note: The file name with symbol name included in it is supplied automatically.</div>
# In the '''File Name''' field type in the file name.<div class="note">The file name with symbol name included in it is supplied automatically.</div>
# In the '''Type''' field select the file type. There are 3 types available: *.XLS/*.XLSX (MS Excel), *.ODS (Open Office Workbook) and *.XML (XML RINA).
# In the '''Type''' field select the file type. There are 3 types available: *.XLS/*.XLSX (MS Excel), *.ODS (Open Office Workbook) and *.XML (XML RINA).
# Click '''Save'''.
# Click '''Save'''.


<div style="background-color: #F8D3CD;">Attention:
<div class="important">
* To save data in an *.XLS/*.XLSX format a version of Microsoft Excel that supports Visual Basic for applications must be installed on the computer. Once saved the *.XLS/*.XLSX file may be read by any Excel compatible application.
* To save data in an *.XLS/*.XLSX format a version of Microsoft Excel that supports Visual Basic for applications must be installed on the computer. Once saved the *.XLS/*.XLSX file may be read by any Excel compatible application.
* To save data in an *.ODS format OpenOffice package must be installed on the computer. Once saved the *.ODS file may be read by any *.ODS compatible application.</div>
* To save data in an *.ODS format OpenOffice package must be installed on the computer. Once saved the *.ODS file may be read by any *.ODS compatible application.</div>
<div style="background-color: #E3FBE5;">Note: In the *.XLS file the entire report will be saved (including charts).</div>
<div class="note">In the *.XLS file the entire report will be saved (including charts).</div>


== Printing Performance Report ==
== Printing Performance Report ==
Line 121: Line 115:


# In the left panel of the Strategy Performance Report select a section or a chart to be printed.
# In the left panel of the Strategy Performance Report select a section or a chart to be printed.
# Click  '''Print'''  [[File:03_Print.png]] toolbar button.
# Click  '''Print'''  <img src="https://www.multicharts.com/trading-software/images/5/56/Print_Report.png" width="24"> toolbar button.
# The standard print dialog will appear.
# The standard print dialog will appear.
# Click '''OK'''.
# Click '''OK'''.
Line 127: Line 121:
or
or
# In the left panel of the '''Strategy Performance Report''' select a section or a chart to be printed.
# In the left panel of the '''Strategy Performance Report''' select a section or a chart to be printed.
# Click  '''Print Preview'''  [[File:02_PPreview.png]] toolbar button. The '''Print Preview''' dialog will appear.
# Click  '''Print Preview'''  <img src="https://www.multicharts.com/trading-software/images/e/ef/Print_Preview_Report.png" width="24"> toolbar button. The '''Print Preview''' dialog will appear.
# Use '''Magnify Mode''' [[File:02_PPreview.png]] or  '''Whole Page'''  [[File:08_Hand.png]] toolbar buttons to preview the page.
# Use '''Magnify Mode''' <img src="https://www.multicharts.com/trading-software/images/e/ec/Magnify_Mode.png" width="24"> or  '''Whole Page'''  <img src="https://www.multicharts.com/trading-software/images/4/48/Whole_Page.png" width="24"> toolbar buttons to preview the page.
# Click '''Print'''  [[File:03_Print.png]] toolbar button to access the print dialog.
# Click '''Print'''  <img src="https://www.multicharts.com/trading-software/images/5/56/Print_Report.png" width="24"> toolbar button to access the print dialog.
# Click '''Close''' button to close the window.<br><br>
# Click '''Close''' button to close the window.<br><br>


[[Category:Backtesting]]
[[Category:Backtesting|D]]

Latest revision as of 12:27, 19 September 2024

Performance reports are calculated based on trades and can be used to analyze strategy performance and check trades list and statistics. There are over 100 performance indices available for analysis, including about 30 charts.

There are two report types available: Strategy Performance Report and Trading Performance Report. One or the other can be used depending on one’s current goals. Check Comparison of the Reports for more info.

Only one performance report can be opened at a time.

Accessing Strategy Performance Report

To access Strategy Performance Report:

  1. Apply a strategy to a chart.
  2. In the main menu select ViewStrategy Performance Report.

Accessing Trading Performance Report

To access Trading Performance Report:

  1. Plot a chart with the desired data range.
  2. Open the Chart Trading Panel. Connect your broker profile. Select the account that was used to place orders.
  3. In the main menu select ViewTrading Performance Report.

Viewing Performance Report

In MultiCharts the Performance Report features a tri-panel design.

Left panel is a navigation structure while the upper right one displays performance data.

Upon left-clicking on any performance index its description will appear in the lower right panel.
Portfolio Trader Strategy Performance Report and MultiCharts Strategy Performance Report contain slightly different analysis parameters and display options. Further description is based on MultiCharts Strategy Performance Report functionality.

Viewing Performance Indices

To view performance indices:

  1. In the left panel select a performance indices section to review.
  2. In the right side move cursor on a performance index required. The cursor will change into Description cursor then left-click.
  3. In the lower right panel a text description will appear. Click Close button to close the description panel.
  4. Use Back and Forward toolbar buttons to move between the Performance Report sections.

Viewing Performance Charts

To view performance charts:

  1. In the left panel select a performance chart to review.
  2. Click Zoom In or Zoom Out toolbar buttons for zooming charts in an out respectively.
  3. Use Pan or Cross cursor modes for moving charts or precise reviewing chart values respectively.
  4. Use Back and Forward toolbar buttons to move between the Performance Report sections.

Understanding Report-Chart Synchronization

MultiCharts allows the user to visually match the trades from a Strategy Performance Report with their signals on the chart.

For strategies that have hundreds of trades over a long data series, it may be cumbersome to manually match a trade in the Strategy Performance Report to the chart.

The user would have to use the scroll button to find the trade in the data series.

Report-Chart Synchronization simplifies this process. Trades on the chart are automatically highlighted when the user hovers his mouse over a trade in the Strategy Performance Report.

To learn more about this feature, see Setting Display Properties.

Setting Performance Report Properties

It is possible in MultiCharts to set financial and display settings for the Performance Report.

Financial settings allow to better analyze the strategy performance with different costs, statistic and risk level settings.

Display settings allow to configure visual setting for the report. It is possible to display the report figures in dollars or in a regional currency, set number of decimals to use and smoothing for charts. It is also posiible to display trades with partial exits basing on entries or on exits.

Setting Financial Properties

To set financial properties:

  1. In the Strategy Performance Report window click Settings toolbar button.
  2. Select the Financial tab.
  3. Set appropriate properties or click Default to set back to the default settings.
    No. of standard deviations - the number of standard deviations is used in some report indices calculation. The default is 1.
    Minimal acceptable rate of return - reference point for Sortino Ratio (See "Performance Ratios" section in the Performance report).
    Degree of risk aversion of the investor - reference point for Fouse Ratio (See "Performance Ratios" section in the Performance report).
  4. Click OK.

Setting Display Properties

To set display properties:

  1. In the Strategy Performance Report window, click the Settings toolbar button.
  2. Select the Display tab.
  3. Select USD to display the report in U.S. dollars or select Regional Currency to display the report in another currency. If Regional Currency is selected, enter the exchange rate in the USD/$ rate textbox.
  4. Set No. of digits after decimal to the required precision level.
  5. In the Performance & Quality section, select the appropriate smoothing.
  6. Select the Enable Strategy Performance Report – Chart Synchronization check box to visually match the trades in the performance report to the signals in the chart.

    Two additional options become available if this checkbox is selected:
    • Select the Entry-based radio button to match the trade in the performance report to its entry signal in the chart.
    • Select the Exit-based radio button to match the trade in the performance report to its exit signal in the chart.
      To use this feature, in the Strategy Performance Report:
    1. Expand Trade Analysis in the tree view pane.
    2. Select List of Trades.
    3. Hover the mouse pointer over any trade on the list. The trade on the list will be matched with the signal for this trade in the chart. The signal on the chart will be highlighted.
  7. Select Recalculate the Report on each new order checkbox to update the Strategy Performance Report in real-time with each new trade. If a new trade is made while the Strategy Performance Report is open, the Strategy Performance Report will be updated immediately with the new trade.
    If this checkbox is unchecked, then the Strategy Performance Report will be updated with the new trade only after closing and reopening the Strategy Performance Report.
  8. Click OK.

Saving Performance Report

To save the Performance Report:

  1. In the Strategy Performance Report window click Save toolbar button.
  2. In the Save As dialog window appeared navigate to the required file location.
  3. In the File Name field type in the file name.
    The file name with symbol name included in it is supplied automatically.
  4. In the Type field select the file type. There are 3 types available: *.XLS/*.XLSX (MS Excel), *.ODS (Open Office Workbook) and *.XML (XML RINA).
  5. Click Save.
  • To save data in an *.XLS/*.XLSX format a version of Microsoft Excel that supports Visual Basic for applications must be installed on the computer. Once saved the *.XLS/*.XLSX file may be read by any Excel compatible application.
  • To save data in an *.ODS format OpenOffice package must be installed on the computer. Once saved the *.ODS file may be read by any *.ODS compatible application.
In the *.XLS file the entire report will be saved (including charts).

Printing Performance Report

It is possible in the Performance Report to print a selected section or chart.

To print a selected section or chart:

  1. In the left panel of the Strategy Performance Report select a section or a chart to be printed.
  2. Click Print toolbar button.
  3. The standard print dialog will appear.
  4. Click OK.


or

  1. In the left panel of the Strategy Performance Report select a section or a chart to be printed.
  2. Click Print Preview toolbar button. The Print Preview dialog will appear.
  3. Use Magnify Mode or Whole Page toolbar buttons to preview the page.
  4. Click Print toolbar button to access the print dialog.
  5. Click Close button to close the window.