Money Management Secrets: For money tips, resources and tools not found on The Dough Roller, click here to follow me on Twitter

.

Deals of the Day
1. Last Minute Gifts: Order American Express Gift Cards online in time for the holidays.
2. Discover More Card: 5% to 20% Cashback bonus, 12 month 0 APR balance transfer, and no annual fee (review | apply)
3. WTDirect Savings Account: Up to 3.06% and FDIC Insured to $250,000.

Making the Most of Morningstar: Portfolio Manager

by DR on June 18, 2007

The Morningstar User’s Guide is a series of articles discussing how to make the best use of the tools, research and analysis available at Morningstar.com.

In the last article we covered a basic Introduction to Morningstar.com. Today we look at adding our portfolio to Morningstar. After you register with Morningstar (which is free), adding your portfolio takes just a few steps. If you’ve just registered as a free member, at the end of the registration process, Morningstar gives you an option to input your portfolio into Moringstar. If you’ve already registered, you can input your portfolio by clicking on the blue portfolio tab near the top of the home page. In either case, you have two choices to make when creating a new portfolio: (1) whether to upload your portfolio or input it manually; and (2) whether to create a Transaction Portfolio or a Watch List Portfolio:

mschoseportfolio.jpg

You can upload your portfolio from Quicken or Money, from several finance websites, or from excel. I chose to upload my portfolio from excel, which took some trial and error. The work sheet needs to be formatted as follows:

ms4.jpg

The worksheet must be saved in .cvs format (comma delimited), and if you’re running a Mac like I am, you’ll need to chose .cvs (Windows) format.

Next, you’ll need to decide whether to setup a Transaction or Watch List Portfolio. A Transaction Portfolio allows you to enter each individual transaction, including reinvested dividends (which it automatically downloads for you). The Transaction Portfolio allows you to track in detail your investment returns. For our purposes, I’ve chosen the Watch List Portfolio, which simply tracks the number of shares you own in each investment. Morningstar gives you the option of selecting which investments you uploaded from the spreadsheet to include in your portfolio. I included all of mine, and here is the result:

ms5.jpg

With our portfolio entered into Morningstar, in the next article in this series we will begin to explore some of the rich features Morningstar’s Portfolio Manager has to offer.

Return to the Morningstar User Guide table of contents.

{ 3 trackbacks }

Making the Most of Morningstar: Determining the Cost of Your Mutual Funds : The Dough Roller
06.20.07 at 10:04 am
50-50 Rule of Mutual Fund Investing
11.29.08 at 9:03 am
Making the Most of Morningstar: X-Ray Your Portfolio
12.13.08 at 7:00 am

{ 0 comments… add one now }

Leave a Comment

You can use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>