Google offers an access to its services with Apps Scripts (JavaScript). That gives you a possibility to connect your spreadsheet to a fascinating variety of tools like geocoder, stock info, language translator, or email.My java-scri...

Equal risk contribution of assets determines the asset weights given the variance matrix. How sensitive are those weights to the variance estimate? Previously The post “Risk parity” gave an overview of the idea. In particular it distinguished the cases: the assets have equal risk contribution groups of assets have equal risk contribution A key difference … Continue reading...

Stumbling blocks on the trek from theory to practical optimization in fund management. Problem 1: portfolio optimization is too hard If you are using a spreadsheet, then this is indeed a problem. Spreadsheets are dangerous when given a complex task. Portfolio optimization qualifies as complex in this context (complex in data requirements). If you are … Continue reading...

2011 was a volatile year, no doubt about that, but was it exceptionally so from a historic point of view? To quantify the volatility, I used the Dow Jones Industrial average, which goes back to 1928 on Yahoo Finance: A volatile year no doubt, but once again confirming the fact that, in markets behaviour at

A famous finance professor once told us that good diversification meant holding everything in the world. Fine, but in what proportion? Suppose you could invest in every country in the world. How much would you invest in each? In a market-capitalization weighted index, you'd invest in each country in proportion to the market value of its investments (its "market capitalization")....

As my finance term paper, I investigated an interesting question where I tried to identify macroeconomic variables that explain the returns on equities. Much of the debate has already taken place on this topic which has given rise to two competing theo...

(This article was first published on Eran Raviv » R, and kindly contributed to R-bloggers) A few words for those of you who are not familiar with the “pairs trading” concept. First you should understand that the movement of every stock is dominated not by the companies performance but by the general market movement. This is the origin of...

By Joseph Rickert Put up a poster that says something like “Data Mining with R” anywhere in the Bay Area and you will surely draw a crowd. But it was still a bit of a surprise that the monthly meeting of the Bay Area R User’s group was so well attended. At one point there were 160 people on...