Bogleheads

[edge]

[edge]

Whoops, sorry for the double post.

Thanks again Simba!

[serbeer]

Simba,

Dec. 2007 CPU-I data were released today:
http://www.bls.gov/news.release/cpi.nr0.htm
and I calculated that with Dec index level being 210.036
2007, 2007 Average is 207.342 vs 2006 Average 201.6, thus making official inflation level of 2007 2.85%

also, Morningstar shows BRSIX 2007 return of -5.4 and PCRIX's return of 23.8

So now you can complete backtesting tool for entire 2007--I just did so on my copy.

Thank you for the wonderful tool to play with!

Serbeer

[simba]

Thanks serbeer.

I've updated the spreadsheet and for those interested, You can download the Excel Spreadsheet [rev7c] and OpenOffice version [rev7c]

Rev 7c has updated information for the Commodities returns.

Based on the work done by Jeff (Cb/Gnobility) at http://gnobility.com/Syn_Comm/....06_san.xls
He calculated the returns as follows:

Collaterallized Chase Index 1972-1990
DJ-AIJ plus T-Bills 1991-1996
DJ-AIG plus Yahoo's IPS 'category' returns 1997-2001 (prior to VIPSX)
DJ-AIJ plus VIPSX - 2001-2002
Pimco PCRIX 2003-2007

Best Regards,
Simba

[schwarm]

[Cb]

[schwarm]

[Cb]

[serbeer]

Simba,
I was looking into the way you calculate Sortino Ratio and noticed that in the version 07c of the spreadsheet, there are problems with encompassing 2007 data in some formulas.

For example, Sortino Ratio calculations in Returns_72_07!F105 refer to
AH$62:AH$96 range, while 2007 portfolio return is in AH97. You probably should have used AH$62:AH$102 range to allow for expansion.

Same with both nominal and real data of STDDev, Sharpe ratio, C-US, C-Intl, etc formulas, and with other tabs as well...


Also, a question:
If I were trying to calculate Sortino for DRO, I'd probably be forced to make Target Return another parm on Porfolio spreadsheet, so that the user can calculate Sortino based on that...

You seem to be using Average ofr all returns for target return on Sortino ratio. I assume you and perhaps Gummy if he was helping with it had your reasoning, wander what it was. Sortino was supposed to be Target Return-specific...

Thanks,
Serbeer

[simba]

Serber - curiousinvestor informed me of the errors a couple of days ago. I have uploaded the revised version (rev7d).

Those interested can download the Excel Spreadsheet [rev7d] and OpenOffice version [rev7d]

As far as the sortino ratio is concerned, I am not sure I follow you. I am using the TBill returns as the Riskfree return.

Cb - I do mean to post a topic to see what ER's I should be deducting from the raw Index Fund returns.


Regards,
Simba

[RobertH]

Simba,

You asked for clarification on the issue with the Sortino ratios. Check out this thread, where Sortino ratios were calculated using your spreadsheet. The ratios for Gibson's Medium Return portfolios don't look right to me.

And thanks for the great work on this spreadsheet.

Robert

P.S. You might consider adding the unhedged global bond returns shown in the thread linked to above, for everyone's benefit.

[simba]

[stratton]

I'm getting errors trying to download this. "Requested header could not be found." So the file is probably:

1. Not there.
2. You have it open and its locked.
3. We don't have privs to get it.
4. File name/location not correct in url

Paul

[simba]

Paul/Cb,

I corrected the links. Try downloading it again.

Thanks

-Simba

[Cb]

Thanks Simba - got it this time!

I know adding the option to subtract appropriate ER's from the pre-fund inception data must have taken quite a bit of effort.

Cb

[MossySF]

The formula in the "Compare 5 portfolios" section appear to be slightly different from the main section. For example:

1972-2007 TSM = 10.96/17.24
Compare 5 TSM = 11.08/17.25

1985-2007 TSM = 12.22/16.03
Compare 5 TSM = 12.29/15.69
_________________
personalbizfinance.com

[simba]

[Cb]

Simba - regarding how much to deduct - we're probably splitting hairs, but if you're going to eliminate the option to specify an ER I think maybe subtracting current Vanguard Investor ER's would be appropriate... transaction costs were higher in the past, but current Admiral Funds or ETF's are a tad lower...

Cb

[etc06]

For the Sharpe calculation when comparing 5 portfolios for 1972-2007, the divisor is the average (row 197) instead of STDEV (row 198) like you have for 1985 - 2007.

Thanks for making this spreadsheet, it's fun to see how portfolios would've done.

[Willy]

Thanks to all who contributed input and, especially, to Simba for this great tool!!

[jmFightSpam]

Hi,

Simba, TrevH, or to whom it may concern:

Where did you get the data from to populate the spreadsheet?

Thanks.

[financialguy]

[jmFightSpam]

[nathank]

This thing is AMAZING! Thanks

[Webfoot]

What does nominal and real mean or MAR?

This is a truly amazing piece of work.

[mikenz]

Real returns are returns adjusted for inflation (return after inflation). Nominal is the unadjusted return.

No idea about MAR. Median Annualized Return? March?
_________________
Bogleheads Search:
http://www.bogleheads.org/moresearch.htm
http://tinyurl.com/65z33t

[simba]

nathank/webfoot - Thanks for the compliments.

As I've said numerous times, use this ONLY for entertainment purposes. Do not alter your AA based on historical returns.
As Paul says - "Don't chase the ghosts of past returns"

Having said that the I've updated the spreadsheet.

Those interested can download the Excel Spreadsheet [rev7f] or the OpenOffice version [rev7f]

The returns for the single portfolio should now match the returns from the comparison section.

Best Regards,
Simba

[simba]

[mbrasher1]

What a great tool! Just for fun, I tried to see what the highest Sharpe ratio I could get on the 1972-2007 data. I found that a portfolio of:

30% SCV
20% EM
10% REIT
40% Commodities

Produces a Sharpe ratio of .82

A high allocation to commodities really bumps up the Sharpe ratio of a portfolio.

[Random Musings]

mbrasher1 wrote:

[Cb]

[james22]

[DP]

Hi,
Thanks so much for posting this spreadsheet! Very helpful.

I came in with respect for the Permanent Portfolio (search these forums for separate discussion on this) but thinking it was a little conservative and perhaps a little out of balance. I was thinking that a portfolio equally balanced among diverse (as much as possible) asset classes would outperform. The spreadsheet confirms: equal allocations to US Stocks, Int''l Stocks, REIT, Commodity, LT US Bonds, Global Bonds does very well, outperforming well known allocations such as Coffeehouse, Permanent Portfolio, and others. Following this a logical breakdown for US stocks would be Small Cap Value and LC Growth (arguably the best performing sub-class and the most uncorrelated subclass), and a similar breakdown for Int'l stocks would be Emerging Markets and Int'l Value. This yields a portfolio with a sortino of nearly 10 since 1985 and substituting Tips for Global bonds, a sortino of 1.81/sharpe .79 since 72.

One other comment, I have seen disparaging remarks on the outlook for commodities and rarely see this incorporated into a portfolio. Being virtually the only asset class with negative correlation and yet strong historical returns it would seem essential to include this in any balanced portfolio, and to exclude it based on expectations of future performance seems to go against the whole concept - creating a balanced portfolio precisely because it is so difficult to predict what asset class will outperform in the future.

Don

[edge]

Hi,

Do not fall victim to overanalysis of past performance and shifting correlations. I don't think commodities have performed well except in the very recent past. Their historically low/negative correlation may be useful and it does make sense in many ways.

If you include them, they should be part of portfolio insurance against a unique set of risks. The estimated real return from commodities is very low. Do not expect the current trend of performance to continue. That would similar to expecting housing ni 2006 to continue its extraordinary above historical trend return path.

[DP]

Hi,

[zhiwiller]

Sorry for resurrecting an ancient thread, but has anyone updated Simba's spreadsheet with 2008's returns? It should make for some interesting backtests.

[stratton]

[grok87]

[Paul Douglas Boyer]

I have attempted to make this spreadsheet web-enabled by importing it into Google Spreadsheets. It appears to work. I did detect some bugs in the formulas that I tried to fix.

I have added data for 2008 from https://flagship.vanguard.com/....ndsByType.

I also added Gold so that we can try calculating the Harry Browne Permanent Portfolio. Not sure if I picked the right bond funds.

Here's the link:

https://spreadsheets.google.co....mp;newcopy

I believe you need a Google account to open a Google Docs spreadsheet. This link will open the template as a new document that you own. This means that you will not get updates automatically. That's too bad.

Let me know if it works for you. Let me know of better ideas.
_________________
Paul Douglas Boyer, host, MadMoneyMachine.com

[grok87]

[Paul Douglas Boyer]

Also note that http://www.icarra.com gives you the ability to input your portfolio and calculate returns, standard deviations, and Sharpe ratios.

And you can input any funds, stocks, whatever. I don't think it has a good proxy for Gold, however. GLD only goes back a couple of years.

Have fun. And remember, history doesn't predict.
_________________
Paul Douglas Boyer, host, MadMoneyMachine.com

[DP]

Hi,

[Cb]

Paul,

Have you got an Excel version of the spreadsheet?

If so, I could host it...

thanks,

Cb

[DaleMaley]

[Cb]

[simba]

Sorry Folks, I have been out of pocket for sometime.

I've updated the spreadsheet and for those interested, You can download the Excel Spreadsheet [rev7h] and OpenOffice version [rev7h]


This includes the 2008 returns and some minor updates.

Best Regards,
Simba

[grok87]

[Bob]

Many thanks Simba

[grayfox]

What happened to gold? I thought gold was added to the spreadsheet so that Harry Browne permanent portfolio could be compared.

[stratton]