Page 2 of 2

Re: Spreadsheets to Track PP

Posted: Sun Feb 25, 2018 10:57 am
by rwbil
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.

Re: Spreadsheets to Track PP

Posted: Sun Feb 25, 2018 11:47 am
by steve
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.

Re: Spreadsheets to Track PP

Posted: Fri Nov 30, 2018 9:30 am
by dualstow
Anyone else having trouble with Google Drive's spreadsheets this morning? Specifically, no stock data updating?

Re: Spreadsheets to Track PP

Posted: Fri Nov 30, 2018 11:42 am
by Mark Leavy
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

Re: Spreadsheets to Track PP

Posted: Fri Nov 30, 2018 1:48 pm
by dualstow
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.

Re: Spreadsheets to Track PP

Posted: Fri Dec 13, 2019 10:22 am
by senecaaa
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 30657 times

Re: Spreadsheets to Track PP

Posted: Fri Dec 13, 2019 10:44 am
by dualstow
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)

Re: Spreadsheets to Track PP

Posted: Sat Dec 14, 2019 3:35 am
by senecaaa
Hmm pity, I'll keep on looking then. Maybe try to build something simple myself.

Re: Spreadsheets to Track PP

Posted: Sat Jan 04, 2020 8:57 pm
by johntaylor
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.

Re: Spreadsheets to Track PP

Posted: Thu Aug 05, 2021 1:13 am
by Mark Leavy
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.

Re: Spreadsheets to Track PP

Posted: Thu Oct 20, 2022 6:29 am
by senecaaa
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.

Re: Spreadsheets to Track PP

Posted: Thu Oct 20, 2022 9:12 am
by dualstow
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

Re: Spreadsheets to Track PP

Posted: Mon Jan 09, 2023 4:46 pm
by johnnywitt
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.

Re: Spreadsheets to Track PP

Posted: Tue Jan 10, 2023 5:02 pm
by dualstow
Agree