Communications
club_cafe
HelpRegister
Monthly tracking
Do any clubs use Excel to track performance of their
portfolios? I am trying to keep track of our stocks, and
wish to have an Excel spreadsheet to follow them. If anyone
has an established spreadsheet, please let me know. Thanks.

Stu
Hi Stu,

> Do any clubs use Excel to track performance of their
> portfolios? I am trying to keep track of our stocks, and
> wish to have an Excel spreadsheet to follow them.

I try very hard NOT to reinvent the wheel. For me personally, I think that
too many tools detract me from the bigger picture.

However...! If you are a member of NAIC, you already know that Toolkit 4
Pro has portfolio management tools. But Jim Thomas, has produced a
wonderful side took in Excel that I find absolutely fascinating! It's
called TK4Portfiolio, and you can find it at
http://www.bivio.com/irw/files/Public%20Files/ToolKit4

Let me explain. The new OPS service allows us to enter any ticker symbol
into our Toolkit program and automaticalloy download all the necessary
financial information into a Stock Selection Guide. Once these guides are
saved in Tookit, we can use the information to create various portfolio
management reports.

Jim has found a way to "find" the Toolkit portfolio library on our harddrive
and pull all that information into this new spreadsheet. It provides more
information on the portfolio than do the normal Toolkit reports. It's
brilliant! And I think that, between the Bivio reports, the Toolkit reports
and what Jim has created, you should have more than enough information to
aptly follow your stocks.

By the way, the spreadsheet already has completed portfolio management
information in it. You only have to reselect the info to get your own into
it. If you don't have Toolkit, you will at least be able to see what the
report does.

Good luck,

Lynn Ostrem, Minneapolis
www.bivio.com/crowriver