## replace_date('11 November 2017');

### Matrix Iterations for Adaptive Asset Allocation

• Adaptive Asset Allocation (AAA) is based on the Nobel Prize winning portfolio theory of Markowitz (1952)
• AAA combines asset’s momentum, volatilities, and cross-correlations for building diversified investment portfolios
• In a tactical application AAA exploits momentum for crash detection and results in consistent returns at mitigated risk levels

Actually, their encounter was coincidental. The fortuitous conversation between a stockbroker and a young mathematician in the early 1950’s proved to be seminal. After the stockbroker learned about the mathematician’s expertise, linear programming and utility maximization, and its real-life applications, he suggested to apply the math to financial portfolios. Fast-forwarding four decades, in 1990 Harry Markowitz shared the Nobel Prize in Economics for his pioneering work on Modern Portfolio Theory (MPT).

 Matrix rain animation courtesy TheCodePlayer. AniGif created with Gif Brewery.

The mathematical framework of MPT combines asset’s expected returns, volatilities, and cross-correlations for assembling well-balanced and diversified portfolios while maximizing the expected return for a given level of risk. Its key proposition: for a multi asset portfolio returns can be maximized for a given level of risk. Likewise, risk can be minimized for a desired level of return. With the efficient frontier as its famous graphical depiction (see graph below), Markowitz’ MPT is also known as “mean-variance analysis” since the “mean” or expected return is maximized given a certain level of risk, defined as the portfolio variance (which is volatility squared).

Efficient Frontier

MPT proposes a mathematical framework how investors can reduce overall risk while maximizing return by holding a diversified portfolio of non-correlated asset classes. Instead of looking at the risk-return characteristics of each single asset class, MPT assesses risk and return as cumulative factors for the portfolio as a whole. The Markowitz Efficient Frontier is the graphical depiction of the collection of portfolios that offer the lowest risk for a given level of return. In an excellent video Arif Irfanullah explains in merely 3 minutes how the efficient frontier represents the set of portfolios that will give the highest return at each level of risk or the lowest risk for each level of return (highly recommended).

To illustrate key elements of MPT, let’s bring to bear the top selection from a diversified investment universe SPY, EWJ, VGK, EEM, and DBC (both the full universe population as well as the selection methodology are explained in the next section).

The portfolio concept under consideration for this contribution is the long only minimum variance portfolio without leverage, located at the magenta dot on the outer left side of the purple portfolio cloud (see statistics in bold font in the table below the following graph). For this special case portfolio risk is minimized for all feasible long only combinations. To localize this particular portfolio an Adaptive Asset Allocation (AAA) approach is applied. Please note the purple long only portfolio cloud is only a subset of the full unconstrained long/short portfolio space demarcated by the blue portfolio envelop hyperbola.

## replace_date('27 August 2017');

### Update For Global Equities Momentum Excel VBA

By popular demand a new beta update is available for the Global Equities Momentum Excel VBA spreadsheet. The new edition sources data from Tiingo's. Following the same work flow as before, the spreadsheet allows to backtest Gary Antonacci's popular GEM strategy (see post).

 GEM with mutual funds for longer historical backtest
NB! Backtested results do not reflect actual trading. Furthermore, trading costs, slippage, and taxes are disregarded. Results are therefore purely hypothetical. Terms and conditions apply.
Next to some bug fixes a new pie chart and an annual returns table have been added to the spreadsheet. The pie chart shows the average allocations over the test periode. And the annual returns table specifies GEM's annual returns along with those of the underlying components and the classical 60/40 benchmark.

## replace_date('29 July 2017');

As the new kid on the block, Tiingo is shaking up the data community. Tiingo offers Freemium access to high quality data for an extensive collection covering the full historical record. Starting today historical dividend adjusted data for the Strategy Signals page is sourced from Tiingo's, with delayed current day's NYSE data grabbed "real time" from Google Finance.

For improved performance a newly designed dedicated backend caches updates from Tiingo's data servers, and operates as on-demand feed for the various Strategy Signal tables.

## replace_date('18 May 2017');

### Yahoo Finance API Ceased Working

Unfortunately this week the Yahoo Finance team changed the functionality of their financial data service. Apart from modifying the construction of the download link, the order and contents of the supported data fields have been altered too. As of writing support of total return data has been suspended.

Regretfully, as a result both the Excel VBA spreadsheets and the Google Sheets on the Strategy Signals page have stopped functioning. Until further notice I have no other choice but to discontinue these services from the blog.

## replace_date('09 March 2017');

### Index Mapping For ETF Proxies

In order to present results as realistic as possible in our PAA-paper, we constructed long-term end-of-month data series for popular ETF proxies, like SPY, GLD and TLT (see paper appendix on SSRN). All data series start December 1969. For the pre-inception history, the proxies are derived from suitable indices. As part of a complete revision of the long-term data set, we recently improved the construction of the data series by mapping the underlying index through a linear formula to arrive at the best fit over the life span of the ETF to be replicated. The construction process is demonstrated below for EFA. The link to an example spreadsheet with all the necessary calculations is published at the end of this post.

EFA seeks to track the investment results of the MSCI EAFE index which is composed of large- and mid-capitalization developed market equities, excluding the U.S. and Canada. The index data is available as free download from the MSCI website. Comparing EFA’s historical data record against the various index levels supported by MSCI like Price, Gross, Net, reveals the MSCI EAFE Net index as underlying index. Historical dividend adjusted data for EFA itself is offered by Yahoo Finance, also for free. For constructing a long-term EFA proxy the data from both sources is required.

With the data readily available in Excel, the next step is to derive the data for the ETF-proxy from the underlying index for the In-Sample (IS) period. The goal is to map the underlying to arrive at the best fit over the life span (=IS) of the ETF through a linear formula: r+ = b * r + a, where “r” is the return of the index and “r+” is the return for the proxy. The values for the coefficients “a” and “b” are determined through Excel’s Solver add-in by minimizing the unexplained sum of squared deviations for the return series of EFA and the ETF-proxy.

After Solver finishes the calculation cycles, the found coefficients result in high R-Squared and correlation readings.