Spreadsheets to Track PP
Moderator: Global Moderator
Re: Spreadsheets to Track PP
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.
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
You can go to https://www.etfreplay.com/combine.aspx and play around comparing different portfoliosrwbil 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.
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.
- dualstow
- Executive Member
- Posts: 14298
- Joined: Wed Oct 27, 2010 10:18 am
- Location: synagogue of Satan
- Contact:
Re: Spreadsheets to Track PP
Anyone else having trouble with Google Drive's spreadsheets this morning? Specifically, no stock data updating?
- Mark Leavy
- Executive Member
- Posts: 1950
- Joined: Thu Mar 01, 2012 10:20 pm
- Location: US Citizen, Permanent Traveler
- dualstow
- Executive Member
- Posts: 14298
- Joined: Wed Oct 27, 2010 10:18 am
- Location: synagogue of Satan
- Contact:
Re: Spreadsheets to Track PP
Back from my "3-martini" lunch. It seems to be working normally now.
Re: Spreadsheets to Track PP
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
Cheers!
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
Cheers!
- dualstow
- Executive Member
- Posts: 14298
- Joined: Wed Oct 27, 2010 10:18 am
- Location: synagogue of Satan
- Contact:
Re: Spreadsheets to Track PP
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)
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
Hmm pity, I'll keep on looking then. Maybe try to build something simple myself.
-
- Associate Member
- Posts: 35
- Joined: Fri Jun 01, 2018 8:33 pm
Re: Spreadsheets to Track PP
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.
- Mark Leavy
- Executive Member
- Posts: 1950
- Joined: Thu Mar 01, 2012 10:20 pm
- Location: US Citizen, Permanent Traveler
Re: Spreadsheets to Track PP
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.
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
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.
- dualstow
- Executive Member
- Posts: 14298
- Joined: Wed Oct 27, 2010 10:18 am
- Location: synagogue of Satan
- Contact:
Re: Spreadsheets to Track PP
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.
-
- Senior Member
- Posts: 147
- Joined: Fri May 08, 2020 6:06 pm