European PP, update 6 months after starting

General Discussion on the Permanent Portfolio Strategy

Moderator: Global Moderator

User avatar
europeanwizard
Executive Member
Executive Member
Posts: 170
Joined: Sun Jun 04, 2017 4:06 am
Location: The Netherlands, Europe

European PP, update 6 months after starting

Post by europeanwizard » Sat Dec 16, 2017 3:42 am

Some time ago, a forum member asked me how my European PP was doing. Since I owe so much to this forum, here's a little update.

First of all, I'm in the experimental phase because until recently, I was still saving. I'm a contractor and this means no social security in The Netherlands. Since I have a family, I want a nice stash of cash. As of today, that reached 50k euros. Monthly expenses are 2400 euros, so this means about 21 months of living. This is enough for me, so I expect that in 2018, more money will flow into the PP.

That said, I started in July with three funds:
ETFS PHYSICALGOLD (JE00B1VS3770) 2489
ISHARES MSCI EUR A (IE00B4K48X80) 2481
ISHARES E GOV15-30 (IE00B1FZS913) 2414

After some talking here, I changed that last one to ISHARES E GOV7-10 (IE00B1FZS806), worth 2511 euros, the month after. Plus I found out that my broker lends out securities, so I switched to a special account type that's excluded from this practice. So the numbers aren't really reliable but to give a general idea. In August, I moved 2500 euros cash into the PP.

(dd/mm/yyyy) Euros
01/07/2017 7761,38
01/08/2017 7783,37
01/09/2017 7781,90
01/10/2017 10614,00
01/11/2017 10765,04
01/12/2017 10621,37

The cash portion is 25k in a CD at 0.8%, and another 25k in a savings account at 0.5%.

As you can see, the portfolio barely moved. Curious to see what it will do next year.
User avatar
frugal
Executive Member
Executive Member
Posts: 928
Joined: Sat Nov 10, 2012 12:49 pm

Re: European PP, update 6 months after starting

Post by frugal » Sat Dec 16, 2017 1:37 pm

europeanwizard wrote:Some time ago, a forum member asked me how my European PP was doing. Since I owe so much to this forum, here's a little update.

First of all, I'm in the experimental phase because until recently, I was still saving. I'm a contractor and this means no social security in The Netherlands. Since I have a family, I want a nice stash of cash. As of today, that reached 50k euros. Monthly expenses are 2400 euros, so this means about 21 months of living. This is enough for me, so I expect that in 2018, more money will flow into the PP.

That said, I started in July with three funds:
ETFS PHYSICALGOLD (JE00B1VS3770) 2489
ISHARES MSCI EUR A (IE00B4K48X80) 2481
ISHARES E GOV15-30 (IE00B1FZS913) 2414

After some talking here, I changed that last one to ISHARES E GOV7-10 (IE00B1FZS806), worth 2511 euros, the month after. Plus I found out that my broker lends out securities, so I switched to a special account type that's excluded from this practice. So the numbers aren't really reliable but to give a general idea. In August, I moved 2500 euros cash into the PP.

(dd/mm/yyyy) Euros
01/07/2017 7761,38
01/08/2017 7783,37
01/09/2017 7781,90
01/10/2017 10614,00
01/11/2017 10765,04
01/12/2017 10621,37

The cash portion is 25k in a CD at 0.8%, and another 25k in a savings account at 0.5%.

As you can see, the portfolio barely moved. Curious to see what it will do next year.
hi

you have 50K in CD and 7k in 3 ETFs?
User avatar
buddtholomew
Executive Member
Executive Member
Posts: 2274
Joined: Fri May 21, 2010 4:16 pm

Re: European PP, update 6 months after starting

Post by buddtholomew » Sat Dec 16, 2017 1:47 pm

Hi Frugal, I think OP was building an emergency fund before investing in the other PP assets. At least that is what I gathered from the post.

EuropeanWizard, why do you maintain such a large cash position?
User avatar
frugal
Executive Member
Executive Member
Posts: 928
Joined: Sat Nov 10, 2012 12:49 pm

Re: European PP, update 6 months after starting

Post by frugal » Sun Dec 17, 2017 1:54 am

buddtholomew wrote:Hi Frugal, I think OP was building an emergency fund before investing in the other PP assets. At least that is what I gathered from the post.

EuropeanWizard, why do you maintain such a large cash position?
Hi,

I think it is smarter to be 100% PP.

The main problem are ETF's and brokers...
User avatar
europeanwizard
Executive Member
Executive Member
Posts: 170
Joined: Sun Jun 04, 2017 4:06 am
Location: The Netherlands, Europe

Re: European PP, update 6 months after starting

Post by europeanwizard » Mon Dec 18, 2017 9:26 am

frugal wrote: you have 50K in CD and 7k in 3 ETFs?
25K absolutely cash (in a savings account)
25K in a CD
10K in 3 ETFs
buddtholomew wrote:why do you maintain such a large cash position?
Main emotional reason, I'm a bit of a nervous guy ;D

I've always worked for the man, very stable job and all that. I started contracting a couple of years ago, but I'm nowhere used to this feeling of not having a regular salary. So I wanted to have a big amount of cash, to be able to cover any emergency that may pop up.
frugal wrote:I think it is smarter to be 100% PP. The main problem are ETF's and brokers...
Yeah, I'm not too happy about it. For stocks, I'm fine with an ETF. For bonds, I may look into doing this myself in the future. As for gold, I think I'll have to revisit my choice when the amount is bigger. Having experienced a home burglary, I don't want physical gold in my house. Alternatives are pricey, and the ETF is very, very easy. But at some point (I'm guessing 50K or so), it'll have to go.
User avatar
frugal
Executive Member
Executive Member
Posts: 928
Joined: Sat Nov 10, 2012 12:49 pm

Re: European PP, update 6 months after starting

Post by frugal » Tue Dec 19, 2017 3:52 pm

Hi

ETFs are very easy yes!

I only have affraid of brokers...
juandelarocha
Junior Member
Junior Member
Posts: 7
Joined: Wed Aug 23, 2017 5:34 pm

Re: European PP, update 6 months after starting

Post by juandelarocha » Sun Apr 01, 2018 12:16 pm

Thanks for sharing your portfolio, amounts and wealth strategy Europeanwizard. I'm also a European investor trying to build up my EU-PP. To be sincere, after almost one year I'm kind of disappointed with its performance, here's my distribution:

Asset - % of weight - Name - Code

Shares - 24,69% - Vanguard EURZ ST IDX - IE0008248795
Gold - 24,53% - Xetra Gold (4GLD) - DE000A0S9GB0
Bonds - 25,57% - (60% Bundesrepublik Deutschland 2,500% 8/2046 - DE0001102341 + 40% FI VANGUARD 20+ YEAR EU - IE00B246KL88)
Cash - 25,21% - Bank account giving 0,5%.

So far, overall result is -0,55%. It had moments with good results reaching an overall +3% but sad enough, gold and bonds have been giving flat or negative results most of the time. Funny that Bonds part is positive right now supporting gold and shares negatives though.

Let's see how it goes, but I have already opened an account in the only Robo-advisor running in my homecountry. Good thing about it is that it leverages on the aggregated volume they manage to access to better classes of Vanguard and Amundi funds. So far, +1,8%. Truth be said, it's much more aggressive than our EU-PP:

American Shares - Vanguard US 500 Stk Idx -Ins
European Shares - Pictet Europe Idx -I
European Bonds - Vanguard Euroz Inf Lk Idx -Ins
Emerging Economies Shares - Vanguard Emrg Mk Stk Idx -Ins

BTW: I'm already suffering about the costs of my Gold and Bonds account of the EU-PP (Flatex in Germany). They started charging for holding the Xetra Gold shares... :(
WhiteElephant
Associate Member
Associate Member
Posts: 38
Joined: Wed Sep 20, 2017 6:01 am

Re: European PP, update 6 months after starting

Post by WhiteElephant » Mon Apr 02, 2018 8:52 am

Hi Juandelarocha,

-0.5% and 1.8% in a year doesn't mean much and sounds to me like you're focussing too much on short-term results.
Both the PP and a more conventional stock-heavy porftfolio can go nowhere for 10 years. 1 year results are meaningless.

It also seems you were expecting something different for the PP. -0.5% nominal in a year is perfectly normal for the PP. 99% of the time the PP is an extremely boring portfolio, you have to be able to handle that.

And just curious, how do you handle both accounts? Is the roboadvisor a second portfolio? A Variable portfolio?
User avatar
ochotona
Executive Member
Executive Member
Posts: 3214
Joined: Fri Jan 30, 2015 5:54 am

Re: European PP, update 6 months after starting

Post by ochotona » Mon Apr 02, 2018 11:46 am

Hi, my daughter might end up living in Europe, her boyfriend is French. She is studying in Switzerland this summer. So can I just get on a plane with a pile of gold bullion to give to her (say as a possible future wedding present), or do I have to have export and import licenses?
User avatar
frugal
Executive Member
Executive Member
Posts: 928
Joined: Sat Nov 10, 2012 12:49 pm

Re: European PP, update 6 months after starting

Post by frugal » Fri Apr 06, 2018 4:05 pm

WhiteElephant wrote:Hi Juandelarocha,

-0.5% and 1.8% in a year doesn't mean much and sounds to me like you're focussing too much on short-term results.
Both the PP and a more conventional stock-heavy porftfolio can go nowhere for 10 years. 1 year results are meaningless.

It also seems you were expecting something different for the PP. -0.5% nominal in a year is perfectly normal for the PP. 99% of the time the PP is an extremely boring portfolio, you have to be able to handle that.

And just curious, how do you handle both accounts? Is the roboadvisor a second portfolio? A Variable portfolio?
+1
ochotona wrote:Hi, my daughter might end up living in Europe, her boyfriend is French. She is studying in Switzerland this summer. So can I just get on a plane with a pile of gold bullion to give to her (say as a possible future wedding present), or do I have to have export and import licenses?

in the flight? Where do you put the gold?
johntaylor
Associate Member
Associate Member
Posts: 35
Joined: Fri Jun 01, 2018 8:33 pm

Re: European PP, update 6 months after starting

Post by johntaylor » Fri Jun 01, 2018 9:14 pm

Hello to you all. I am also an european (dutch) PP user. Many years ago I already wanted to organize myself a simple and failsafe portfolio and Harry Brown's PP was always anywhere back in my head for that. But then again I hate financials and bookkeeping so lost sight of the project. Begin this year I suddenly received some serious money which I needed to 'store' away and in a quick instant I decided to devide it over the 4 parts of the PP:
25% Stocks: Meesman Index fund, follows the msci Europe. NL0010436671
25% Bonds: European longterm government bonds
- 12.5%: EXX6, IE00BSKRJX20
- 12.5%: E20Y, DE000A0D8Q31
25% Gold: Goldmoney.com
25% Cash: Savings deposit on 1%

The last few months I did some more research on investing and portfolio's. I found some nice websites like portfoliocharts.com (thanks @Tyler). I especially digged into the german portfolio part:
https://portfoliocharts.com/portfolio/p ... folio-ger/
What I did was get myself european stockdata for european PP and looked if I could reproduce the same results as in portfoliocharts. Because EXX6 and E20Y only exist quite short, I took data from another bond that exists already since 2000: German long term bonds: DE0001134922
The results you will find here:
Image
PM 2020-1-5 I no longer stand behind the contents of the table above. Please don't take the results serious. JT.

What I find remarkable is that to me it looks like the european PP is much less profitable then the US PP. In the used timeframe (2002-2017) according to portfoliocharts.com the german portfolio should have a bit higher return (cagr:5.5%) then the us portfolio (cagr:5%). But in my calculations of my own portfolio I only get a return (real cagr) of 3.5%. As this is quite a big difference I am asking myself how this big difference can be caused. Any ideas are welcome.

Thanks, john
Last edited by johntaylor on Sat Jan 04, 2020 10:22 pm, edited 1 time in total.
User avatar
frugal
Executive Member
Executive Member
Posts: 928
Joined: Sat Nov 10, 2012 12:49 pm

Re: European PP, update 6 months after starting

Post by frugal » Sun Jun 03, 2018 2:06 am

johntaylor wrote:
Fri Jun 01, 2018 9:14 pm
Hello to you all. I am also an european (dutch) PP user. Many years ago I already wanted to organize myself a simple and failsafe portfolio and Harry Brown's PP was always anywhere back in my head for that. But then again I hate financials and bookkeeping so lost sight of the project. Begin this year I suddenly received some serious money which I needed to 'store' away and in a quick instant I decided to devide it over the 4 parts of the PP:
25% Stocks: Meesman Index fund, follows the msci Europe. NL0010436671
25% Bonds: European longterm government bonds
- 12.5%: EXX6, IE00BSKRJX20
- 12.5%: E20Y, DE000A0D8Q31
25% Gold: Goldmoney.com
25% Cash: Savings deposit on 1%

The last few months I did some more research on investing and portfolio's. I found some nice websites like portfoliocharts.com (thanks @Tyler). I especially digged into the german portfolio part:
https://portfoliocharts.com/portfolio/p ... folio-ger/
What I did was get myself european stockdata for european PP and looked if I could reproduce the same results as in portfoliocharts. Because EXX6 and E20Y only exist quite short, I took data from another bond that exists already since 2000: German long term bonds: DE0001134922
The results you will find here:
Image

What I find remarkable is that to me it looks like the european PP is much less profitable then the US PP. In the used timeframe (2002-2017) according to portfoliocharts.com the german portfolio should have a bit higher return (cagr:5.5%) then the us portfolio (cagr:5%). But in my calculations of my own portfolio I only get a return (real cagr) of 3.5%. As this is quite a big difference I am asking myself how this big difference can be caused. Any ideas are welcome.

Thanks, john
Hello !

Some questions:

- Stocks: why you use this unknown ETF ?
- CASH - can you get 1% in a Deposit? Seems too much...
- How much you pay for gold storage per year?

???

I believe your numbers are correct.

Everyone says USPP is better than EUPP.

Our problem is exchange rate... :'( :'(

Please comment.


Regards
johntaylor
Associate Member
Associate Member
Posts: 35
Joined: Fri Jun 01, 2018 8:33 pm

Re: European PP, update 6 months after starting

Post by johntaylor » Sun Jun 03, 2018 12:17 pm

- Stocks: why you use this unknown ETF ?
I presume you mean DE0001134922. I don't actually use these german bonds, because my brokers don't offer them. But I used them for my calculations because it is the only bonds option I know which exists and offers data since 2000. If anyone knows an european bond fund with longterm data I really like to hear.

I am actually using EXX6 and E20Y (50/50) for the bonds portion. EXX6 is <20y restrained to Germany, E20Y is 20+y and covers a greater part of Europe. I prefer long bonds from Germany, because the Netherlands and Germany are economically close related and are expected to move on together if the eurozone would collapse.
- CASH - can you get 1% in a Deposit? Seems too much...
well it took a while to find it ;) but there is a catch, because you get a penalty if you want to end the deposit before the end date (5yr).
- How much you pay for gold storage per year?
0.12%/yr
I believe your numbers are correct. Everyone says USPP is better than EUPP.
I know. But I am especially interested if I am right with my calculations, because the cagrR I calculated will determin the monthly income I will offer myself with the PP. It also determins if and when it can/will be time to give my emplorer the middle finger.

Have anyone ideas why my caluation of 2002-2017 EU PP cagrR is 3.5% while Tyler calculates 5.5% for the german PP in 2002-2017 ?
http://www.carterapermanente.es/cartera ... -con-etfs/

<quote>Our problem is exchange rate... :'( :'(</quote>
Don't understand what you mean exactly. The exchange rates euro->dollar has been:
2001-12-28: E1=$0.8851
2017-12-30: E1=$1.2005
that is a growth of 135.6%. So an european cagrR of 3.5% in euro's in this period should be compared to a cagrR of 3.5%*135.6% => 4.8% ? Is this correct ?

I don't see a big difference between USPP and GerPP on portfoliocharts.com, resp 5% and 5.5%. Does this mean that both are demoninated in dollars ? This should indeed explain the bigger part of the differences between my calculation (3.5%) and Tyler's (5.5%). Please feedback if I undertand things right ?

Please comment.
User avatar
Tyler
Executive Member
Executive Member
Posts: 2003
Joined: Sat Nov 12, 2011 3:23 pm
Contact:

Re: European PP, update 6 months after starting

Post by Tyler » Sun Jun 03, 2018 12:47 pm

johntaylor wrote:
Sun Jun 03, 2018 12:17 pm
Have anyone ideas why my caluation of 2002-2017 EU PP cagrR is 3.5% while Tyler calculates 5.5% for the german PP in 2002-2017 ?
http://www.carterapermanente.es/cartera ... -con-etfs/
Here's my asset assumptions that I would use in the PC calculators from reading your previous posts. From punching in the numbers, I'm pretty confident it's what you're also using.

Stocks: Europe
LTT: Long term German bunds
Cash: German Tbills
Gold: Gold

I can see a few things here.

First, the real CAGR for this portfolio from Jan 2002 - Dec 2017 is 4.98%. Your 5.5% number is from 2003-2017. So make sure you're comparing apples-to-apples on the start date.

Second, I see that you're using a fixed rate of return for cash. Tbills don't work like that. For example, 3-month German bills had an annualized return of 4.6% in 2008. For more accurate results, find a fund that tracks short term bunds or simply use the 3-month German bill rate from OECD.

And third, make sure that you're converting the numbers correctly to German inflation and currency. I use known German inflation and exchange rates every year to represent the real purchasing power in the home country.

Finally, it's always possible that different data sources have different returns. 2% a year is a big difference, though, so I suspect something else is going on from a methodology perspective.
johntaylor
Associate Member
Associate Member
Posts: 35
Joined: Fri Jun 01, 2018 8:33 pm

Re: European PP, update 6 months after starting

Post by johntaylor » Sun Jun 03, 2018 10:01 pm

Thanks for replying @Tyler, I am sure I can learn things from you ;)
First, the real CAGR for this portfolio from Jan 2002 - Dec 2017 is 4.98%. Your 5.5% number is from 2003-2017. So make sure you're comparing apples-to-apples on the start date.
I took the 5.5% from your '15-yr Rolling returns' graph. As far as I read the graph well the bar with start year 2002 has time frame 2002-2017. But please correct me if I misread the graph.
Image
Second, I see that you're using a fixed rate of return for cash. Tbills don't work like that. For example, 3-month German bills had an annualized return of 4.6% in 2008. For more accurate results, find a fund that tracks short term bunds or simply use the 3-month German bill rate from OECD.
Thanks for pointing me to the OECD site. I found a nice datafeed there:
https://data.oecd.org/interest/short-te ... -rates.htm
I did a quick and dirty check with these data, but that does not seem to change my total real cagr very much. I will update my program and take care to put some proper data for the cash portion. As soon as I have an update I will post a new table with the results here.
And third, make sure that you're converting the numbers correctly to German inflation and currency. I use known German inflation and exchange rates every year to represent the real purchasing power in the home country.
I will update my program with german cpi data also. I found a source here:
https://www.quandl.com/data/RATEINF/CPI ... ex-Germany
But I can't imagine they will be very different from the dutch cpi data I used so far, but we will see.
Finally, it's always possible that different data sources have different returns. 2% a year is a big difference, though, so I suspect something else is going on from a methodology perspective.
Same feeling here, the difference is to big and I like to find out where I am missing essential things. Can it not be caused that we both calculate in different currencies (euro's on my side) ?
User avatar
Tyler
Executive Member
Executive Member
Posts: 2003
Joined: Sat Nov 12, 2011 3:23 pm
Contact:

Re: European PP, update 6 months after starting

Post by Tyler » Mon Jun 04, 2018 12:07 pm

johntaylor wrote:
Sun Jun 03, 2018 10:01 pm
I took the 5.5% from your '15-yr Rolling returns' graph. As far as I read the graph well the bar with start year 2002 has time frame 2002-2017. But please correct me if I misread the graph.
I think it’s just a matter of reference dates. The column you’re pointing to shows the 15-year annualized return starting at the beginning of 2002 through the end of 2016. 2002-2017 is actually 16 years. So just make sure you’re comparing apples to apples.

BTW, I also get my inflation data from OECD if you want to take that variable out of the equation.

Also, one other thing you might want to keep an eye on is the annual rebalancing. All of my numbers assume that the portfolio is rebalanced every year. If you just let the assets ride or use a different rebalancing scheme, the numbers could vary quite a bit.
Pet Hog
Executive Member
Executive Member
Posts: 220
Joined: Tue May 28, 2013 4:08 pm

Re: European PP, update 6 months after starting

Post by Pet Hog » Mon Jun 04, 2018 2:38 pm

Tyler wrote:
Mon Jun 04, 2018 12:07 pm
The column you’re pointing to shows the 15-year annualized return starting at the beginning of 2002 through the end of 2016.
Tyler, if you're using monthly data, which I believe you are, how is this range not 14 years and 11 months? Perhaps one extra month won't affect the CAGR much, but it's not the same as 15 years.
User avatar
Tyler
Executive Member
Executive Member
Posts: 2003
Joined: Sat Nov 12, 2011 3:23 pm
Contact:

Re: European PP, update 6 months after starting

Post by Tyler » Mon Jun 04, 2018 3:04 pm

I’m in the process on getting monthly data and incorporating it into the calculators, but that will take time. Right now all of the returns are annual numbers as of December 31st.

So it’s definitely a full 15 years. The way the rolling returns chart is formatted, the labeled year is associated with the first full year of returns.
johntaylor
Associate Member
Associate Member
Posts: 35
Joined: Fri Jun 01, 2018 8:33 pm

Re: European PP, update 6 months after starting

Post by johntaylor » Mon Jun 04, 2018 4:49 pm

Tyler wrote:
Mon Jun 04, 2018 12:07 pm
I think it’s just a matter of reference dates. The column you’re pointing to shows the 15-year annualized return starting at the beginning of 2002 through the end of 2016. 2002-2017 is actually 16 years. So just make sure you’re comparing apples to apples.
oops, thanks for noticing that. It's quite a challenge to compare apples to apples, but I hope to make some progress ;)
Image
The final real cagr is now 4.4% I took care 1. inflation is now german 2. cash is now with short term interest rate of OECD 3. length is 15yr (2002-2016) 4. the portfolio is rebalanced every end of the year to 25/25/25/25. The rebalancing is done by 1. calculate the total return (both nominal and real) = average of the returns of the 4 portions. 2. calculate total growth (both nominal and real) from total return 3. calculate total cagr (both nominal and real) from total growth.
Also, one other thing you might want to keep an eye on is the annual rebalancing. All of my numbers assume that the portfolio is rebalanced every year. If you just let the assets ride or use a different rebalancing scheme, the numbers could vary quite a bit.
Thanks again for pointing me to that. I changed the scheme for that again.

Thanks for helping me on.

[Update] I suddenly realise that the way I work the portfolio is nèver rebalanced and gets more unbalanced every year. You can see it by comparing the values for growth for each portion with each other. For example in 2013 the (un) balance is stocks:13%, bonds:26%, gold:16% cash:44%. So there is still more work to do :)
[Update2] I removed the graph. I will replace it in a few hours with a new graph in which I took care of a yearly rebalancing of the portfolio. As far as I now know it will rise the final cagrR from 4.2% to 4.4%. But I want to do some more testing before placing the graph.
[Update3] I replaced the graph. The new graph is taking care of rebalancing each end of the year. I replaced my reaction on Tyler's quote.
Last edited by johntaylor on Wed Jun 06, 2018 10:40 am, edited 16 times in total.
User avatar
Tyler
Executive Member
Executive Member
Posts: 2003
Joined: Sat Nov 12, 2011 3:23 pm
Contact:

Re: European PP, update 6 months after starting

Post by Tyler » Mon Jun 04, 2018 4:59 pm

johntaylor wrote:
Mon Jun 04, 2018 4:49 pm
I don't see why I should need to do something extra to make the scheme balanced. Every year end I just calculate the average of the individual growth of each of the 4 portfolio parts. With the resulting average growth I calculate the cagr for the total. Is this not the right method ?
That's pretty much how I do it, too. Sounds reasonable.
User avatar
Tyler
Executive Member
Executive Member
Posts: 2003
Joined: Sat Nov 12, 2011 3:23 pm
Contact:

Re: European PP, update 6 months after starting

Post by Tyler » Wed Jun 06, 2018 9:26 am

By the way, if you want an example of a spreadsheet that calculates the real return from a collection of different assets (in addition to a bunch of different metrics) you might try downloading the Simba Spreadsheet from the Bogleheads forum. https://www.bogleheads.org/wiki/Simba%2 ... preadsheet
johntaylor
Associate Member
Associate Member
Posts: 35
Joined: Fri Jun 01, 2018 8:33 pm

Re: European PP, update 6 months after starting

Post by johntaylor » Wed Jun 06, 2018 10:15 am

I don't see why I should need to do something extra to make the scheme balanced. Every year end I just calculate the average of the individual growth of each of the 4 portfolio parts. With the resulting average growth I calculate the cagr for the total. Is this not the right method ?
I removed this reaction, because I realised I indeed forgot to take care of rebalancing. I just replaced my scheme in my former post with a new one. The error I made in the first graph was that I calculated total growth by averaging the growths of the individual portions. In the new graph I calculate total return by averaging the returns of the individual portions and calculate total growth from total return.
Tyler wrote:
Wed Jun 06, 2018 9:26 am
By the way, if you want an example of a spreadsheet that calculates the real return from a collection of different assets (in addition to a bunch of different metrics) you might try downloading the Simba Spreadsheet from the Bogleheads forum. https://www.bogleheads.org/wiki/Simba%2 ... preadsheet
Thanks for pointing me to that. I already extensively studied the Simba spreadsheet and learned a lot from it and continue to do so.
johntaylor
Associate Member
Associate Member
Posts: 35
Joined: Fri Jun 01, 2018 8:33 pm

Re: European PP, update 6 months after starting

Post by johntaylor » Mon Jun 11, 2018 5:56 pm

I found a new subject that is causing the differences between the results of my own calculations and those of portfoliocharts and the simba spreadsheet. I am using (free) data of the morningstar data stream:
http://globalquote.morningstar.com/glob ... ode=DIRECT

From earlier experiments I already learned that the data stream from finance.yahoo.com is not always reliable, especially in the way it calculates adj_close values. The free data stream from morningstar does not offer adj_close values, but it separately offers the bare dividend values itself. So with this data it is quite easy to calculate the adj_close values. I used the method described on this website:
https://joshschertz.com/2016/08/27/Vect ... th-Python/
_
Image

If I calculate the adj_close for VTSMX I get results that are pretty close to the data that morningstar presents on it's own graph:
For the period 1992-12-31 / 2017-12-29 the return values of VTSMX are:
my calculation on morningstar data: cagrN: 9.4% cagrR:7.0% growth: 944%
simba spreadsh: cagrN: 9.6% cagrR:7.2% (total growth: 994%, calculated from Data_TR_USD)
growth on morningstar graph: 981%
_
Image
Image
_
But if I calculate the adj_close for VFITX I get very different results then the results morningstar presents on its own graph:
my calculation on morningstar data: cagrN: 4.6% cagrR: 2.3% total growth: 293%
simba spreadsh: cagrN: 5.5% cagrR: 3.2% (total growth: 372% calculated from Data_TR_USD)
growth on morningstar graph: 373%
_
Image
Image
_
For VFITX I compared in more detail my own calculations with the results on the morningstar chart. One of the periods in which the results very quickly drift away from each other is 1992-12-29 to 1993-01-22.
_
Image
_
Underneath is a print screen of the calculations I made. In the graph next to it you see how the results from my calculations drift away from the results which I copied from the morningstar chart itself.
_
Image
_
I have no clue why I get such different results. Am I making a calculation error ? Or can't I trust the morningstar data ?

If anyone have any hints or clues I would appreciate very much !
Last edited by johntaylor on Tue Jun 12, 2018 8:35 am, edited 2 times in total.
User avatar
frugal
Executive Member
Executive Member
Posts: 928
Joined: Sat Nov 10, 2012 12:49 pm

Re: European PP, update 6 months after starting

Post by frugal » Tue Jun 12, 2018 12:10 am

Hi,

Do you admit to change from EUPP to USPP in function of these true results?

Why is it so important to you to know this real cagr?

My best regards.
johntaylor
Associate Member
Associate Member
Posts: 35
Joined: Fri Jun 01, 2018 8:33 pm

Re: European PP, update 6 months after starting

Post by johntaylor » Tue Jun 12, 2018 6:03 am

frugal wrote:
Tue Jun 12, 2018 12:10 am
Do you admit to change from EUPP to USPP in function of these true results?
Hope I understand you correctly. As a european I would definitely not use a USPP portfolio, I use and will continue to use a strict EUPP. The reason why I am deep diving into US funds now is that in US there are so much more data and tools with which I can fine tune and back test my own calculations. And in case you mean something else with your question: yes I took care to use the cpi from usa to calculate my own real cagr for US funds.
Why is it so important to you to know this real cagr?
What I learned from my queste in finance so far is that the real cagr is the best way to give you insight in the long term performance of your portfolio.
Post Reply