Efficient portfolios

Enhanced interface for portfolio optimization: use the slider to glide along the efficient frontier.

Assign the weights of the efficient portfolio to the current portfolio, or to a new portfolio.

ETF flows as a contrary indicator

Equity prices tend to fall after ETFs rake in large sums of money. A study by TrimTabs Investment Research finds that monthly equity ETF flows and returns of the S&P500 one month later are negatively correlated to the tune of 21.4%.

The study concludes: “We have two explanations for the strongly negative correlation between equity ETF flows and future market returns. First, ETFs are traded mostly by retail investors and day traders.  These are the least informed and most emotional market participants—the ones most likely to lose money over time.  Second, we suspect hedge funds use ETFs when liquidity dries up.  Hedge funds were forced to close individual stock positions during the credit crisis, so they bought equity ETFs instead. Equity ETFs posted large outflows in 2009, when liquidity improved”.

Daily returns correlation

Portfolio Lab calculates the correlations of either monthly or daily returns:

  • Monthly returns correlation is preferred in the context of strategic investment decisions
  • Daily returns correlation may be useful for short term trading and tactical moves.

Note that Portfolio Lab correlations are exponentially weighted, i.e. the most recent data points are given more weight in the computation, which has advantages over the more common equal weights computation.

Backtest periodic returns

We added a column chart for the backtest results. This chart shows the periodic returns. The frequency is user selectable (weekly to yearly).

You may export the chart data to Excel using the icon on the top right of the chart.

Column returns chart

To change to other chart types, use the labels on the top left:

  • Cumul: portfolio cumulative returns
  • Value: portfolio value
  • Weight: relative portfolio positions weights

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.