Page 1 of 1

Permanent Portfolio Allocator

Posted: Wed Jun 09, 2010 8:09 am
by Gumby
For those of you with Mac computers or iPads, I've created a Permanent Portfolio Allocator spreadsheet for Numbers. Just type your account values for each asset into the top section and the bottom Rebalancing section will tell you when it's time to rebalance with automatic color-higlighting rebalancing bands.

Image

You can download the Numbers (for MAC OS X only) file here:

Image

* Numbers '09 or higher is required to use this spreadsheet

Feel free to share and pass along!

Re: Permanent Portfolio Allocator

Posted: Wed Jun 09, 2010 1:31 pm
by craigr
Looks nice! I need to get Numbers for my Mac. Can Numbers export to Excel format?

Re: Permanent Portfolio Allocator

Posted: Wed Jun 09, 2010 3:01 pm
by Gumby
craigr wrote: Looks nice! I need to get Numbers for my Mac. Can Numbers export to Excel format?
It can export to Excel, but it can't make the Excel spreadsheet do things that only Numbers can visually do. I had tried exporting this file, but unfortunately I used too many Numbers-specific parameters and design elements. It was completely unintelligible when I opened it up in Excel because it wasn't formatted like a typical spreadsheet.

Re: Permanent Portfolio Allocator

Posted: Thu Jun 10, 2010 11:34 am
by slk23
Clive wrote: I've just quickly knocked up an Excel version that's somewhat similar

I think its ok but I've only quickly tested it so make sure you're happy that it works ok before using it for real.
Thanks Clive.  Looks good.

Re: Permanent Portfolio Allocator

Posted: Thu Jun 10, 2010 11:36 am
by MarcV
Gumby wrote: For those of you with Mac computers or iPads, I've created a Permanent Portfolio Allocator
Feel free to share and pass along!
Thank you very much!  It's useful and attractive.  I can quickly see how much money market cash to move to bonds and stock indices.

Re: Permanent Portfolio Allocator

Posted: Thu Jun 10, 2010 8:50 pm
by Gumby
Clive wrote:I've just quickly knocked up an Excel version that's somewhat similar
Nicely done, Clive!

Re: Permanent Portfolio Allocator

Posted: Sat Jun 12, 2010 5:55 pm
by Pres
Impressive. Thanks, both of you!

Re: Permanent Portfolio Allocator

Posted: Mon Jun 14, 2010 5:02 pm
by gonetowindsurf
Thanks Gumby and Clive!!! Awesome!