SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Strategies & Market Trends : Gorilla and King Portfolio Candidates

 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: Eric L who wrote (19926)3/12/2000 8:45:00 PM
From: Mike Buckley  Read Replies (1) of 54805
 
the excellent "Portfolio Manager" at Microsoft Investor provides all of this detail (and synchronizes with all my brokerage accounts) and any minute now DownSouth will pop in here to tell us that Quicken does the same.

As everyone explores alternatives to manually keeping stock prices on a spreadsheet, be aware that most sites and personal finance programs do not take into account the cash portion of the portfolio. In other words, the various calculations show only the returns of the equity portion of an investor's portfolio.

As we manage our accounts, a complete understanding of how well we are doing compared to the indexes requires that we include the cash that sits in our account earning relatively meager returns until we decide where to put it to better use. If you don't include the cash in the total value of your portfolio when you calculate the return, you are not getting an accurate picture of the portfolio.

Also, most of those sites and programs don't allow you to mingle the assets of various accounts. As an example, I have a joint taxable account with my wife in addition to the three tax-deferred accounts that we consider part of our household portfolio. The only way I know of to monitor my performance as the household portfolio's manager is to keep a spreadsheet that treats the combined assets as one portfolio.

Anyone who prefers to get a sample spreadsheet instead of having to construct one using my missive posted earlier, please send an e-mail to me at mbuckley@aol.com. I'll return an e-mail with an attached spreadsheet. Be sure to let me know what version of Excel and Windows you are using.

--Mike Buckley
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext