Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

bug problem in portofolio value report

Questions on using, creating, or understanding data in Fund Manager reports.

Postby Normnip » Tue Apr 05, 2011 7:10 pm

In the portofolio value report the total value of one of my investments is astronomical and in error.

The report shows as the price the total dollars for the investment and multiplies that time the number of shares giving a huge total that is in error. My subportfolio shows the transaction accurately even when I drill down to the details.

I've had this happen several times in the past and forget how it is resolved. Isn't there some way to fix this so this cannot keep happening?

Also, what is the percentage column of this report supposed to represent?
Normnip
 
Posts: 6
Joined: Sat Dec 04, 2010 1:57 pm

Postby Mark » Tue Apr 05, 2011 8:28 pm

Hello Normnip,

Since the price is incorrect, you can correct it in the Data Register under the data type of "Prices". How are you updating prices that it is getting updated incorrectly? Are you retrieving prices from a quote server? Which quote server? What symbol do you have recorded for this investment? When retrieving quotes, the quote is retrieved from the selected server by symbol.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11815
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby Normnip » Tue Apr 05, 2011 9:55 pm

Data Register? Data type of prices? I have no idea what you're talking about, let alone how to get there.

Besides, I'm not doing any updating. The other prices for the other investments are the same as my cost so therefore one would conclude that the price column was for the 'price' I paid. In any event, as I've said I have not done any updating, why, then would it use a different figure than the others? That's a rhetorical question. I just want a report that I can rely on and trust for accurate information, that is easy to use and I'm not finding it! I've been using Fund Manager for almost 2 years or longer.

How do I add a column, then, for my cost or what I paid. Also, I would like to add a column to show the stock symbols. Finally, what does the % column mean? I've looked at your custom reports and I couldn't find an option for these columns.
Normnip
 
Posts: 6
Joined: Sat Dec 04, 2010 1:57 pm

Postby aviator » Wed Apr 06, 2011 3:00 am

Normnip, I'm no expert in Fund Manager but might be able to help.

To view the data register, just double-click on the investment in question. The screen that pops up is the data register and, if you still use the default settings that came with FM, you'll see the price history for this investment.

I think there might be confusion between share prices vs the price you paid when you bought an investment. The data register mentioned above shows the share price, not the price you paid. To see the price you paid, just go to the Data Type (which is found on the right side of the same pop-up screen) and click on the pull down menu. Under Transactions (All), click on Purchases. This will show you your purchase history.

To add columns to the Portfolio Editor (the screen, not reports), click View, then List Columns... This allows you to select which columns you want to view on the screen.

Hope this helps.
aviator
 
Posts: 419
Joined: Thu Jul 09, 2009 4:47 am

Postby Normnip » Wed Apr 06, 2011 6:03 am

Thanks Aviator. What you write helped. What I called subportfolio in my original post refered to the Data Register. I figured out with some help from you that the default screen is All Investments. If I click on the Data Type menu screen you refer to I found the price type and I identified my problem and 'corrected' it.

I understand now that here price means value not cost. On the main screen called Portofolio Editor I can customize it as you recommended by using the view command. The cost column is called OOP Historical Basis! It took me awhile to figure that out. However, I cannot print the Portfolio Editor screen. I would simply like to print out a report that lists my investments along with stock symbols, number of existing shares and total paid :(
Normnip
 
Posts: 6
Joined: Sat Dec 04, 2010 1:57 pm

Postby Mark » Wed Apr 06, 2011 8:02 am

Hi Normnip,

To get a report like this you can use either an "Open Lots" report, or a "Custom" report. The "Open Lots" report will list a line item for each purchase, where the Custom report will list a line item for each security, and if you bought it more than once, the combination of all your purchases will be shown on that line item.

When you create a Custom report, you choose which fields to display, and their order. You can choose from a wide variety, but it sounds like you would want these:

Symbol
Out of pocket basis (current)
Shares (ending)

Fund Manager can calculate either a tax cost basis, or an "Out of pocket" (OOP) cost basis. These differ due to distributions (dividends, etc). A paid dividend will reduce your OOP basis, but it does not affect your tax cost basis. You can choose either one in the Custom report. If you want the tax version, see the fields starting with "Tax basis".
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11815
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Reports

Who is online

Users browsing this forum: No registered users and 1 guest

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2025 Beiley Software, Inc. All rights reserved.