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.

Modeling financial time series with S-PLUS (Zivot & Wang)

Modeling financial time series / Zivot

A well organized reference book with both a theory refresher and code examples for each topic: univariate and multivariate regressions, GARCH, cointegration, state space models and much more. This is a practical book  for that may be also be used with R, the open-source alternative to S-PLUS. A solid background in statistics is recommended.