tag:blogger.com,1999:blog-22955634.post148361584707818259..comments2023-11-02T09:05:19.827-04:00Comments on Growth in Value: Free Money™GIVhttp://www.blogger.com/profile/00696914649890834002noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-22955634.post-10124011279135803412007-03-07T11:01:00.000-05:002007-03-07T11:01:00.000-05:00perhaps i should explain -- when I was using Googl...perhaps i should explain -- when I was using Google sheets, I was basically just using it to track from a giving starting point. Like you said, you can't input historical data, so I just started a spreadsheet in 2006, I inputted the book value and market value of teh securities I had at that time, and updated the market value every month. I then set benchmarks I was trying to meet and essentially just tried to gauge whether or not I was generally heading in the right direction.<BR/><BR/>It wasn't really scientific and kind of clunky in practice so I've pretty much scrapped it now that I have Money. <BR/><BR/>THe calculations were just done using simple Excel-era formulas like (SUM=C3:C10) to add up total values and (A3*A9) or whatever to multiply, say, unit holdings by market price, for example.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-22955634.post-30429734862161523392007-03-06T16:53:00.000-05:002007-03-06T16:53:00.000-05:00any chance you have a template you can share? I'd ...any chance you have a template you can share? I'd be interested to see what how you use it.<BR/><BR/>I use google sheets to keep track of my month-to-month net worth but don't really use it for my portfolio as you can't access historical financial data.Anonymousnoreply@blogger.com