Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Money Market losing money

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

Postby Ivan » Mon Feb 23, 2015 7:25 pm

Hi Mark,

I just noticed that my money market funds show a loss for some, apparently random, sales on the Investment Gain graph. It only seems to happen when the graph is set to Current Cost. There are no fees and all purchases and sales are at $1.00/share, so I don't understand why this is happening.

Thanks,
Ivan
Ivan
 
Posts: 168
Joined: Thu Nov 18, 2010 4:43 pm

Postby Mark » Mon Feb 23, 2015 7:39 pm

Hi Ivan,

Do you have any negative valued distributions? Try turning on all the markers, and you should easily be able to see when the gain goes negative, and find the associated transaction from the displayed marker(s).

A positive distribution lowers your OOP basis, so a negative distribution would increase it...

You can also check all your recorded closing prices, to make sure you only have prices recorded at 1.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby Ivan » Tue Feb 24, 2015 11:33 am

Hi Mark,

Hope I'm not being dense. I have attached a graph showing a typical drop in gain along with a snapshot of the transactions surrounding it. I don't understand why the sale on 9/14 shows a drop in gain. I'm especially confused since the previous sale on 9/6 had no effect on gain.

Thanks for you patience,
Ivan
Attachments
Data.png
Data.png (7.1 KiB) Viewed 2729 times
Graph.png
Graph.png (48.48 KiB) Viewed 2729 times
Ivan
 
Posts: 168
Joined: Thu Nov 18, 2010 4:43 pm

Postby Mark » Tue Feb 24, 2015 8:53 pm

Hi Ivan,

Can you post, or email me your investment file (*.dat) for this money market? I will take a look, and try to provide a more specific answer.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby Ivan » Tue Feb 24, 2015 9:04 pm

Hi Mark,

I just emailed you the .dat file.

Thanks for the help,
Ivan
Ivan
 
Posts: 168
Joined: Thu Nov 18, 2010 4:43 pm

Postby Mark » Wed Feb 25, 2015 10:20 am

Hi Ivan,

When you are in the "Current" cost mode, the gain only on the currently owned shares is plotted. An important point here is that this is the gain from the graph's starting date. Notice, if you change the starting date, the graph still starts near 0 (the gain on the first plotted day is included, so it may not be exactly 0). If you plot your gain for the full history, you will see it does not go negative. The gain goes up when you record an interest distribution because the OOP cost of all the shares owned at the time of the distribution goes down. You can see this happening if you look at the "Historical" mode. The historical gain keeps going up when you receive interest. In the current cost mode, when you sell these lower cost shares, you are left with higher cost shares, thus your gain on the currently owned shares is smaller than before the sell transaction. If your starting date is not at investment inception, this means it can go negative, but this is only negative relative to it being 0 on the graph's start date.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby Ivan » Wed Feb 25, 2015 10:51 am

Got it! Thanks for the clear explanation.

Ivan
Ivan
 
Posts: 168
Joined: Thu Nov 18, 2010 4:43 pm


Return to Graphs

Who is online

Users browsing this forum: No registered users and 6 guests

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