Difference between revisions of "Using Performance Report"

From MultiCharts
Jump to navigation Jump to search
(25 intermediate revisions by 7 users not shown)
Line 1: Line 1:
Basing on the trades placed in the chart the performance report can be calculated to comprehensively analyze the strategy performance measures as well as trades list and statistics. There over 100 performance indices are available for analysis including about 30 charts.  
+
Basing on the trades placed in the chart the performance report can be calculated to comprehensively analyze the strategy performance measures as well as trades list and statistics. There are over 100 performance indices available for analysis including about 30 charts.  
  
<div style="background-color: #F8D3CD;">Attention: The new trades occurred are not being included in the performance report in realtime. To include the new trades occurred the performance report should be re-opened again.</div>
+
<div style="background-color: #F8D3CD;">Attention: The new trades occurred are not being included in the Strategy Performance Report in realtime. To include the new trades occurred the performance report should be re-opened again.</div>
  
  
<div style="background-color: #F8D3CD;">Attention: In case signals were added or deleted the performance report should be re-opened again.</div>
+
<div style="background-color: #F8D3CD;">Attention: In case signals were added or deleted the Strategy Performance Report should be re-opened again.</div>
  
  
Line 15: Line 15:
  
 
# [[Understanding_Strategies|Apply a strategy]] to a chart.
 
# [[Understanding_Strategies|Apply a strategy]] to a chart.
# In the menu select '''View''' then click '''Strategy Performance Report'''.
+
# In the main menu select '''View''' then click '''Strategy Performance Report'''.
  
<br>
+
To access a Trading Performance Report:
 +
 
 +
# Connect a [[Broker Profiles Overview | Broker Profile]].
 +
# Make sure that there are historical trades on the chart.
 +
# In the main menu select '''View''' then click '''Trading Performance Report'''.
  
 
== Viewing Performance Report ==  
 
== Viewing Performance Report ==  
Line 25: Line 29:
 
Left panel is a navigation structure while the upper right one displays performance data.  
 
Left panel is a navigation structure while the upper right one displays performance data.  
  
<div style="background-color: #E5F6FF;">Tip: Upon left-clicking on any performance index its description will appear in the lower right panel.</div>
+
<div style="background-color: #E5F6FF;">Tip: Upon left-clicking on any performance index its description will appear in the lower right panel.</div><br>
 +
<div style="background-color: #F8D3CD;">Attention: 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>
  
<br>
 
 
=== Viewing Performance Indices ===
 
=== Viewing Performance Indices ===
  
 
To view performance indices:
 
To view performance indices:
  
# In the left panel select a performance indices section http://www.multicharts.com/img/wiki/toolbar/BTReport/14_Icon_Table.gif to review.
+
# In the left panel select a performance indices section [[File:14_Icon_Table.gif]] to review.
# In the right side move cursor on a performance index required. The cursor will change into '''Description'''  http://www.multicharts.com/img/wiki/toolbar/BTReport/12_Cursor.gif cursor then left-click.  
+
# 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 lower right panel a text description will appear. Click '''Close'''  http://www.multicharts.com/img/wiki/toolbar/BTReport/13_Close.gif button to close the description panel.
+
# In the lower right panel a text description will appear. Click '''Close'''  [[File:13_Close.gif]] button to close the description panel.
# Use '''Back''' http://www.multicharts.com/img/wiki/toolbar/27_Left.png  and '''Forward''' http://www.multicharts.com/img/wiki/toolbar/28_Right.png   toolbar buttons to move between the Performance Report sections.
+
# Use '''Back''' [[File:Scroll Left new.png]] and '''Forward''' [[File:Scroll_Right.png]] toolbar buttons to move between the Performance Report sections.
  
 
<br>
 
<br>
Line 43: Line 47:
 
To view performance charts:
 
To view performance charts:
  
# In the left panel select a performance chart http://www.multicharts.com/img/wiki/toolbar/BTReport/15_Icon_Chart.gif to review.  
+
# In the left panel select a performance chart [[File:15_Icon_Chart.gif]] to review.  
# Click '''Zoom In''' http://www.multicharts.com/img/wiki/toolbar/31_Zoom_In.png or '''Zoom Out''' http://www.multicharts.com/img/wiki/toolbar/32_Zoom_Out.png toolbar buttons for zooming charts in an out respectively. Click '''Reset Zooming''' http://www.multicharts.com/img/wiki/toolbar/33_Reset_Scales.png  to reset a zoomed chart.
+
# Click '''Zoom In''' [[File:Zoom In new.png]] or '''Zoom Out''' [[File:Zoom Out.png]] toolbar buttons for zooming charts in an out respectively. Click '''Reset Zooming''' [[File:Reset Both Scales new.png]]   to reset a zoomed chart.
# Use '''Pan'''  http://www.multicharts.com/img/wiki/toolbar/BTReport/08_Hand.png or '''Cross''' http://www.multicharts.com/img/wiki/toolbar/17_Show_Cross.png cursor modes for moving charts or precise reviewing chart values respectively.
+
# Use '''Pan'''  [[File:08_Hand.png]] or '''Cross''' [[File:Show Hide Cross.png]] cursor modes for moving charts or precise reviewing chart values respectively.
# Use '''Back''' http://www.multicharts.com/img/wiki/toolbar/27_Left.png   and '''Forward''' http://www.multicharts.com/img/wiki/toolbar/28_Right.png   toolbar buttons to move between the Performance Report sections.
+
# Use '''Back''' [[File:Scroll_Left_new.png]]  and '''Forward''' [[File:Scroll Right.png]] toolbar buttons to move between the Performance Report sections.
  
 
<br>
 
<br>
Line 79: Line 83:
 
To set financial properties:  
 
To set financial properties:  
  
# In the Strategy Performance Report window click '''Settings''' http://www.multicharts.com/img/wiki/toolbar/10_Format_Window.png toolbar button.
+
# In the Strategy Performance Report window click '''Settings''' [[File:10_Format_Window.png]] toolbar button.
 
# Select the '''Financial''' tab.
 
# Select the '''Financial''' tab.
# Set appropriate properties or click '''Default''' to set back to the default settings.<br>More Information:<br>'''Point value''' – review [[<span style="color: red;">'''LINK'''</span> /101-01_SettingIndProp.html name="";  |Big Point Value]] definition.<br>'''Initial capital''' - Initial capital to start strategy performance calculations with.<br>'''Commission''' - the amount supposed to be paid to broker for trades execution. The commission can be set on "per contract" or on "per trade" basis. <br>With '''Per Contract''' option, the '''Commission''' value is multiplied for the each trade by the double number of contracts in the trade (i.e. for Entry and Exit).<br>With '''Per Trade''' option, the '''Commission''' value value is multiplied for each trade by the 2 (i.e. for Entry and Exit).<br>The default '''Commission''' value is zero. <br>'''Slippage''' - the amount reserved for differencies between the expected and actual order execution price. The commission can be set on "per contract" or on "per trade" basis. <br>With '''Per Contract''' option, the '''Slippage''' value is multiplied for the each trade by the double number of contracts in the trade (i.e. for Entry and Exit).<br>With '''Per Trade''' option, the '''Slippage''' value is multiplied for each trade by the 2 (i.e. for Entry and Exit).<br>The default '''Slippage''' value is zero. <br>'''Margin per contract''' - the amount to be borrowed when trading on a margin account. This number is used in some report indices calculation.<br>'''Interest rate''' - the rate used in some report indices calculation. Usually the Treasury Bill rate is used.<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>
  
Line 90: Line 94:
 
To set display properties:  
 
To set display properties:  
  
# In the Strategy Performance Report window, click the '''Settings''' http://www.multicharts.com/img/wiki/toolbar/10_Format_Window.png toolbar button.
+
# In the Strategy Performance Report window, click the '''Settings''' [[File:10_Format_Window.png]] 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 110: Line 114:
 
To save the Performance Report:  
 
To save the Performance Report:  
  
# In the Strategy Performance Report window click '''Save''' http://www.multicharts.com/img/wiki/toolbar/03_Save_Workspace.png  toolbar button.
+
# In the Strategy Performance Report window click '''Save''' [[File:Portfolio_Save.png]] 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.<br><div style="background-color: #E3FBE5;">Note: The file name with symbol name included in it is supplied automatically.</div>
# In the '''Type''' field select the file type. There are 2 types available: *.XLS (MS Excel) 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: To save data in an .XLS format a full version of Microsoft Excel must be installed on the computer. Once saved the .XLS file may be read by any Excel compatible application.</div>
+
<div style="background-color: #F8D3CD;">Attention:
 
+
* 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>
 
<div style="background-color: #E3FBE5;">Note: In the *.XLS file the entire report will be saved (including charts).</div>
 
<div style="background-color: #E3FBE5;">Note: In the *.XLS file the entire report will be saved (including charts).</div>
  
<br>
 
 
== Printing Performance Report ==
 
== Printing Performance Report ==
  
Line 128: Line 132:
  
 
# 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'''  http://www.multicharts.com/img/wiki/toolbar/BTReport/03_Print.png toolbar button.
+
# Click  '''Print'''  [[File:03_Print.png]] toolbar button.
 
# The standard print dialog will appear.
 
# The standard print dialog will appear.
 
# Click '''OK'''.
 
# Click '''OK'''.
 
<br>
 
<br>
 
 
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'''  http://www.multicharts.com/img/wiki/toolbar/BTReport/02_PPreview.png toolbar button. The '''Print Preview''' dialog will appear.
+
# Click  '''Print Preview'''  [[File:02_PPreview.png]] toolbar button. The '''Print Preview''' dialog will appear.
# Use '''Magnify Mode'''   http://www.multicharts.com/img/wiki/toolbar/BTReport/02_PPreview.png or  '''Whole Page'''  http://www.multicharts.com/img/wiki/toolbar/BTReport/08_Hand.png toolbar buttons to preview the page.
+
# Use '''Magnify Mode''' [[File:02_PPreview.png]] or  '''Whole Page'''  [[File:08_Hand.png]] toolbar buttons to preview the page.
# Click '''Print'''  http://www.multicharts.com/img/wiki/toolbar/BTReport/03_Print.png toolbar button to access the print dialog.
+
# Click '''Print'''  [[File:03_Print.png]] 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]]

Revision as of 16:13, 28 April 2017

Basing on the trades placed in the chart the performance report can be calculated to comprehensively analyze the strategy performance measures as well as trades list and statistics. There are over 100 performance indices available for analysis including about 30 charts.

Attention: The new trades occurred are not being included in the Strategy Performance Report in realtime. To include the new trades occurred the performance report should be re-opened again.


Attention: In case signals were added or deleted the Strategy Performance Report should be re-opened again.


Note: Only one performance report can be opened at a time.


Accessing Performance Report

To access a Strategy Performance Report:

  1. Apply a strategy to a chart.
  2. In the main menu select View then click Strategy Performance Report.

To access a Trading Performance Report:

  1. Connect a Broker Profile.
  2. Make sure that there are historical trades on the chart.
  3. In the main menu select View then click Trading 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.

Tip: Upon left-clicking on any performance index its description will appear in the lower right panel.


Attention: 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 14 Icon Table.gif to review.
  2. In the right side move cursor on a performance index required. The cursor will change into Description 12 Cursor.gif cursor then left-click.
  3. In the lower right panel a text description will appear. Click Close 13 Close.gif button to close the description panel.
  4. Use Back Scroll Left new.png and Forward Scroll Right.png 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 15 Icon Chart.gif to review.
  2. Click Zoom In Zoom In new.png or Zoom Out Zoom Out.png toolbar buttons for zooming charts in an out respectively. Click Reset Zooming Reset Both Scales new.png to reset a zoomed chart.
  3. Use Pan 08 Hand.png or Cross Show Hide Cross.png cursor modes for moving charts or precise reviewing chart values respectively.
  4. Use Back Scroll Left new.png and Forward Scroll Right.png 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 10 Format Window.png 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 10 Format Window.png 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 Portfolio Save.png 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.
    Note: 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.
Attention:
  • 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.
Note: 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 03 Print.png 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 02 PPreview.png toolbar button. The Print Preview dialog will appear.
  3. Use Magnify Mode 02 PPreview.png or Whole Page 08 Hand.png toolbar buttons to preview the page.
  4. Click Print 03 Print.png toolbar button to access the print dialog.
  5. Click Close button to close the window.