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: 260
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: 10343
Joined: Wed Oct 27, 2010 10:18 am
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?
”My option is to displace the mayor of New York City and bring in the National Guard -- as the governor, in a state of emergency -- and basically take over the mayor's job," Cuomo said. He quickly added that, "I don't think we are at that point,"
User avatar
Mark Leavy
Executive Member
Executive Member
Posts: 655
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: 10343
Joined: Wed Oct 27, 2010 10:18 am
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.
”My option is to displace the mayor of New York City and bring in the National Guard -- as the governor, in a state of emergency -- and basically take over the mayor's job," Cuomo said. He quickly added that, "I don't think we are at that point,"
senecaaa
Full Member
Full Member
Posts: 52
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 6663 times
User avatar
dualstow
Executive Member
Executive Member
Posts: 10343
Joined: Wed Oct 27, 2010 10:18 am
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)
”My option is to displace the mayor of New York City and bring in the National Guard -- as the governor, in a state of emergency -- and basically take over the mayor's job," Cuomo said. He quickly added that, "I don't think we are at that point,"
senecaaa
Full Member
Full Member
Posts: 52
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.
Post Reply