Backtest custom date ranges

Feature added: you can backtest by calendar year or use custom date ranges. The selected time range also applies to the Excel export.

International indices added

Added in Portfolio Lab “risk/return” and “ETF correlations” views:

  • FTSE/Xinhua China 25 Index (FXI)
  • MSCI Australia (EWA)
  • MSCI Brazil (EWZ)
  • MSCI Canada (EWC)
  • MSCI France (EWQ)
  • MSCI Germany (EWG)
  • MSCI South Africa (EZA)
  • MSCI South Korea (EWY)
  • MSCI United Kingdom (EWU)

Comparing portfolios

A new command ‘Compare’ is situated under the performance metrics table. You may select any of your portfolios to compare with the current portfolio, making it easier to compare the portfolios returns, alpha, beta and other statistics.

compare Portfolios

In the example above, the current portfolio my portfolio is compared to another portfolio US sectors. In addition, the S&P500 Index benchmark is also displayed.

Excel export for backtest results

Export to Excel the monthly, quarterly, yearly periodic returns for the backtest by following these steps:

  1. Select the “Period’ view of the backtest chart
  2. Select the desired frequency for the report
  3. Click on the Export icon

Portfolio import

You may now import portfolios from Excel. Click on ‘Import’ and follow the guided steps. During the import process, you may select which columns contain the data to import:

Portfolio analysis

Please refer to the user manual for more information.