Doh!Clive wrote:
=((end_amount/start_amount)^(1/number_of_years))-1
is pretty generic
Thanks.
Moderator: Global Moderator
Doh!Clive wrote:
=((end_amount/start_amount)^(1/number_of_years))-1
is pretty generic
That only works for a one-time purchase - that is if there were no additional investments after the start_amount had been invested. I guess this is what you were looking for.Clive wrote:=((end_amount/start_amount)^(1/number_of_years))-1rickb wrote: Anyone know how to compute CAGR (given a starting and ending value, and number of years) using google docs? It looks like rate() should do it, but I haven't been able to get it to work. I'm looking for the equivalent of what in openoffice would be rri(years;start;end).
is pretty generic
Code: Select all
=Index(ImportHTML("http://apmex.com/","table",7),2,2)
Code: Select all
=Index(ImportHTML("http://apmex.com/","table",7),3,2)
Kapitall.com and SmartMoney.com do a good job with reinvesting dividends as they happen. But those sites have some minor issues with historical dividend calculating. SmartMoney.com has the only real-time portfolio chart that I'm aware of. It's pretty amazing to see the PP remain stable, every minute of the day, in real time.julian wrote: What are ppl using to track the PP that takes into accnt dividends from TLT & VTI when calculating performance. Google finance just adds the dividend to cash but does not use it to calculate performance
I just manually add new entries to my spreadsheet of all PP-related transactions, once a month or so. This takes less than 10 minutes and satisfies my obsessive-compulsive need to know exactly how well the PP is working for me.julian wrote: What are ppl using to track the PP that takes into accnt dividends from TLT & VTI when calculating performance. Google finance just adds the dividend to cash but does not use it to calculate performance
A belated thanks for laying this out. I never could get the prices to come out quite right to match what Fidelity was saying but it's still neat to be able to do it.fnord123 wrote: I cannot take credit for the use of Price() for calculating Treasury values - someone on Bogleheads suggested it. My contribution was combining it with the current bond prices of Yahoo to automate it.
Ha ha, so very true. It's really nicely presented and just so... fun to watch. I only allow myself to check on the PP once per month but when I do, I always like to take at least a few seconds to watch those cool charts.Storm wrote: Watching realtime gain/loss in dollars is like crack if you are a compulsive portfolio checker like I am. This morning I spent a good 10 minutes just staring at the $ counter like a gambling addict watching a slot machine payout... it is bad.
It looks like Google has updated the way it calls URLs. They seem to be locking out multiple stock comparisons in the same static URL-based chart.Gumby wrote: I avoid looking at my portfolio specifics as much as I can, but once in awhile I'm curious to see which asset is holding up the portfolio at any given time. I just bookmark the following URL:
http://www.google.com/finance/chart?cht ... hy&tlf=12h
and that gives me a quick real-time peek at the PP — if I want to take its pulse.
Nope. The second chart no longer works for me, here in the US (at least not today). We just see a "No Chart Available" on that second image. Hopefully it's temporary.Clive wrote: Sometimes individual tickers seem to cause a no chart return for a day or two.
The Canadian set
http://www.google.com/finance/chart?cht ... SB&tlf=12h
and excluding both TLT and GLD
http://www.google.com/finance/chart?cht ... HY&tlf=12h
still work.
It seems to be working again. Thanks, Clive!Clive wrote: I see all four of these OK (excepting TLO just having price data up to 1pm) http://www.google.com/finance/chart?cht ... hy&tlf=12h
and suspect the others will all come back again in a day or so
This is beautiful. Even though I spent a lot of time creating google doc spreadsheets, I'm going to try to pull away from them for 29 days a month and just look at this.Gumby wrote: I avoid looking at my portfolio specifics as much as I can, but once in awhile I'm curious to see which asset is holding up the portfolio at any given time. I just bookmark the following URL:
http://www.google.com/finance/chart?cht ... hy&tlf=12h
and that gives me a quick real-time peek at the PP — if I want to take its pulse.
It looks like this:
(VTI is red, GLD is yellow, TLT is blue and SHY is green).
I find that occasionally glancing at those squiggly lines allows me to go a few weeks without checking my actual portfolio numbers. It's a bit like peeking at the drizzling code of the Matrix. And by only glancing at this URL I avoid looking at financial websites and their meaningless time-consuming articles. It's still a little addictive though, but at least it allows me to be more detached from my detailed PP performance.
Hint: You can change that URL to pretty much any array of securities — you just have to remember which color corresponds to each security.