Spreadsheets to Track PP

General Discussion on the Permanent Portfolio Strategy

Moderator: Global Moderator

rwbil
Junior Member
Junior Member
Posts: 1
Joined: Sun Feb 25, 2018 9:59 am

Re: Spreadsheets to Track PP

Post by rwbil » Sun Feb 25, 2018 10:57 am

Steve,

Do you have long term data showing the performance over decade or more. If so can you share exactly what you used and how you obtained the data.
steve
Executive Member
Executive Member
Posts: 264
Joined: Mon Jul 26, 2010 2:06 pm

Re: Spreadsheets to Track PP

Post by steve » Sun Feb 25, 2018 11:47 am

rwbil wrote:Steve,

Do you have long term data showing the performance over decade or more. If so can you share exactly what you used and how you obtained the data.
You can go to https://www.etfreplay.com/combine.aspx and play around comparing different portfolios

I shared what I could to help the group without my posting my own private excel sheet that spans more then a decade and is a tweaked work of art customized for my own individual use. My private data is nothing more then my real results over time which does not predict the future but documents the past.
User avatar
dualstow
Executive Member
Executive Member
Posts: 14225
Joined: Wed Oct 27, 2010 10:18 am
Location: synagogue of Satan
Contact:

Re: Spreadsheets to Track PP

Post by dualstow » Fri Nov 30, 2018 9:30 am

Anyone else having trouble with Google Drive's spreadsheets this morning? Specifically, no stock data updating?
RIP Marcello Gandini
User avatar
Mark Leavy
Executive Member
Executive Member
Posts: 1950
Joined: Thu Mar 01, 2012 10:20 pm
Location: US Citizen, Permanent Traveler

Re: Spreadsheets to Track PP

Post by Mark Leavy » Fri Nov 30, 2018 11:42 am

dualstow wrote:
Fri Nov 30, 2018 9:30 am
Anyone else having trouble with Google Drive's spreadsheets this morning? Specifically, no stock data updating?
Yep - same issue
User avatar
dualstow
Executive Member
Executive Member
Posts: 14225
Joined: Wed Oct 27, 2010 10:18 am
Location: synagogue of Satan
Contact:

Re: Spreadsheets to Track PP

Post by dualstow » Fri Nov 30, 2018 1:48 pm

Mark Leavy wrote:
Fri Nov 30, 2018 11:42 am
dualstow wrote:
Fri Nov 30, 2018 9:30 am
Anyone else having trouble with Google Drive's spreadsheets this morning? Specifically, no stock data updating?
Yep - same issue
Back from my "3-martini" lunch. It seems to be working normally now.
RIP Marcello Gandini
senecaaa
Full Member
Full Member
Posts: 77
Joined: Fri Nov 29, 2019 4:33 am

Re: Spreadsheets to Track PP

Post by senecaaa » Fri Dec 13, 2019 10:22 am

Hi! I have read through this thread and I can't get any of the sheets to work, see e.g. a screenshot below of an error in this sheet: https://docs.google.com/spreadsheets/d/ ... dit#gid=17.

Does anyone have the latest version of it? It looks awesome and would love to use it!
Any other spreadsheets that work for you are welcome as well ;D

Cheers!


err.png
err.png (106.39 KiB) Viewed 30611 times
User avatar
dualstow
Executive Member
Executive Member
Posts: 14225
Joined: Wed Oct 27, 2010 10:18 am
Location: synagogue of Satan
Contact:

Re: Spreadsheets to Track PP

Post by dualstow » Fri Dec 13, 2019 10:44 am

A lot of these data tables become obsolete and have to be redone.
I last used WSJ tables for bond data, but these days I just type them in by hand if I'm really curious. (Copying data from my monthly statement or, if mid-month, a figure from the same brokerage house)
RIP Marcello Gandini
senecaaa
Full Member
Full Member
Posts: 77
Joined: Fri Nov 29, 2019 4:33 am

Re: Spreadsheets to Track PP

Post by senecaaa » Sat Dec 14, 2019 3:35 am

Hmm pity, I'll keep on looking then. Maybe try to build something simple myself.
johntaylor
Associate Member
Associate Member
Posts: 35
Joined: Fri Jun 01, 2018 8:33 pm

Re: Spreadsheets to Track PP

Post by johntaylor » Sat Jan 04, 2020 8:57 pm

senecaaa wrote:
Sat Dec 14, 2019 3:35 am
Hmm pity, I'll keep on looking then. Maybe try to build something simple myself.
I just started PP for two years now. First year I also took a deep dive in making my own system and took data from different sources. I made things too complicated at first and it did not work out for me. I finally kept things as simple as possible in a few spreadsheets. Typed the data from the original sources of the assets accounts I used. I found it very confusing to use other data sources then the ones where my funds are actually in. I encountered weird differences which I could not explain and did not match up. Even with my simple spreadsheets I find it complicated enough to get and keep things in the right place.
User avatar
Mark Leavy
Executive Member
Executive Member
Posts: 1950
Joined: Thu Mar 01, 2012 10:20 pm
Location: US Citizen, Permanent Traveler

Re: Spreadsheets to Track PP

Post by Mark Leavy » Thu Aug 05, 2021 1:13 am

Botdude, so sorry I missed you before someone nuked you.

I understand the need to buy gold, and I was just talking to a gal tonight that is looking for safety. Please DM me and I will send you my spreadsheets. We can't act soon enough. Tell no one.
senecaaa
Full Member
Full Member
Posts: 77
Joined: Fri Nov 29, 2019 4:33 am

Re: Spreadsheets to Track PP

Post by senecaaa » Thu Oct 20, 2022 6:29 am

senecaaa wrote:
Sat Dec 14, 2019 3:35 am
Hmm pity, I'll keep on looking then. Maybe try to build something simple myself.
Three years later: So, I did build something myself, but it got a bit out of control (it supports any portfolio, not just PP or GB): asset.garden.

Anyone who would like to try it out, please go ahead, it's free.
User avatar
dualstow
Executive Member
Executive Member
Posts: 14225
Joined: Wed Oct 27, 2010 10:18 am
Location: synagogue of Satan
Contact:

Re: Spreadsheets to Track PP

Post by dualstow » Thu Oct 20, 2022 9:12 am

Mark Leavy wrote:
Thu Aug 05, 2021 1:13 am
Botdude, so sorry I missed you before someone nuked you.

I understand the need to buy gold, and I was just talking to a gal tonight that is looking for safety. Please DM me and I will send you my spreadsheets. We can't act soon enough. Tell no one.
O0 O0
RIP Marcello Gandini
johnnywitt
Senior Member
Senior Member
Posts: 147
Joined: Fri May 08, 2020 6:06 pm

Re: Spreadsheets to Track PP

Post by johnnywitt » Mon Jan 09, 2023 4:46 pm

frugal wrote:
Tue Dec 18, 2012 5:16 am
Hello,

where can I see daily variation of HBPP?

I would like to feel the flutuactions day by day in a chart.

Thank you.
The whole concept of the HBPP is antithetical to this.
User avatar
dualstow
Executive Member
Executive Member
Posts: 14225
Joined: Wed Oct 27, 2010 10:18 am
Location: synagogue of Satan
Contact:

Re: Spreadsheets to Track PP

Post by dualstow » Tue Jan 10, 2023 5:02 pm

Agree
RIP Marcello Gandini
Post Reply