Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
 
Old 12-20-2006, 04:08 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Investment Detail changes

In microsoft.public.money, John wrote:

- quote -

> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, John wrote:
> > > > I only just realized I have an investment which is listed as a Money Market
> > > account when it is actually a Mutual Fund and I`d like to change it. However
> > > when going to the details tab it seems I can only change the name, contact
> > > info and the like. I would appreciate any help changing the account ``Type``
> > > without having to recreate a new account and lose 2 years worth of
> > > transactions. I`ve been trying to do this for over an hour and I don`t think
> > > I`ve overlooked the simple fix for this, but if I did feel free to tell me so.
> > > Are you are downloading your transactions via OFX from your broker,

> > rather than entering the transactions manually, and you want to
> > continue that.
> > > If so, this is tricky to do. You did not miss a simple fix.


<snip
- quote -

> But no I am not downloading transactions ,nor do I plan to. I enter them
> manually.


It's surprising that this particular thing went for two years. The
MMF has its price fixed at $1.00. Keep an extra copy/backup of your
file at various stages in case you want to undo something.

================ Changing MMF to Mutual Fund =====================

It is not trivial, but not as hard as it first appears. A few
minutes should do it.

In the details, remove the existing symbol, and rename the existing
"MMF" to something you will never use. Let's suppose you choose
zzzz.

Create a new Fund with the correct name and symbol.

Go back to investment zzzz and choose View: Investment Details.
Enter a fake new Buy dated before all other transactions with
quantity more than the total of other "MMF" transactions.

Change each non-fake transaction to the fund using the drop-down
list. Start with the oldest transaction. Particular attention
should be made to not change the total. So you will want blank the
price, and to change the quantity to the actual number of shares
you transacted. You will probably need to work with the order of
things. If you lose the total for a transaction you are working
on, press the Esc key to get out of that edit attempt, and try
again.

Keep going until there are no more zzzz transactions remaining
except the fake transaction. Delete the fake Buy transaction. At
that point you can "delete" zzzz.
=================================


- quote -

> Is there a simpler fix? Something like just checking another box.
> I`m not sure how this originally happened, but it does not make sense to me
> that once you create an investment you are locked out of it.


Did you imagine I would answer "yes, there is a checkbox you could
tick to let you switch"? Actually, Money 2007 *does* have a setting
to do some changing. A new capability of Money 2007 is the ability
to change the InvestmentType, but it does not do the MMF to MF
change you want. You could change from MMF to Other, which could be
good enough for your purposes. In Microsoft Money, MMF and Other do
not track tax lots, as a mutual fund or stock do. But Other does let
you have non-one prices. So there is a simpler semi-fix by
converting to Money 2007 and changing the MMF to type Other.

The change of investment type will allow you to change among
MutualFund, Stock, Bond, and Index. (you can also change among
MMF,Other,or CD/USSavingsBond.) This capability has been long
requested and it will be very useful for some people. People
converting from Quicken will be major beneficiaries, but it will be
of use to many others also. This has some limitations. e.g., if
you have an Interest transaction for a fund, you cannot change the
security to a stock. This is because a Stock cannot have an
Interest transaction.

The transition that I wish had been included, but was not, is
Fund-> MMF.
  #-1  
Old 12-20-2006, 02:58 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Investment Detail changes

In microsoft.public.money, John wrote:

- quote -

> I only just realized I have an investment which is listed as a Money Market
> account when it is actually a Mutual Fund and I`d like to change it. However
> when going to the details tab it seems I can only change the name, contact
> info and the like. I would appreciate any help changing the account ``Type``
> without having to recreate a new account and lose 2 years worth of
> transactions. I`ve been trying to do this for over an hour and I don`t think
> I`ve overlooked the simple fix for this, but if I did feel free to tell me so.


Are you are downloading your transactions via OFX from your broker,
rather than entering the transactions manually, and you want to
continue that.

If so, this is tricky to do. You did not miss a simple fix.

-----Overview----
The fix involves renaming the MMF to something like zzzz and
blanking the symbol. Then create a new MF named AA_Right_MF. Change
all of the zzzz transactions to AA_Right_MF. This can be tedious,
but there are techniques that can help. Then rename AA_Right_MF to
the right name for the mutual fund.

At that point it looks as if you are done, but you are not. If you
then do an OFX download, Money will associate the downloaded
transactions to zzzz. To fix that, you will next File-> Import a
specially prepared OFX file as a statement. When Money asks if a
certain investment is the same as something you already have in the
file, you will say it is the same as zzzz. Then when you later
download from your broker, Money will ask if the actual fund is the
same as something you already have in the file. You will say it is
the same as the right mutual fund.
-----------------------------
So are you up to a complex fix?







 

Tags
detail, investment
Similar Threads
Thread Forum Replies Last Post
Income - Unassigned: no detail
petervanharmelen@yahoo.ca: Hello, My apologies if this has been asked before. I searched but came up with nothing. When I look at my Income and Spending report for...
Microsoft Money 1 05-16-2006 11:05 PM
credit card detail
martha: I'm new to Money, using 2004 Std edition. I'm trying to capture detail from my credit card statements from earlier in the year. Since I'm past...
Microsoft Money 4 09-16-2004 02:54 PM
investment download - get summary no detail
Fly Williams: Money 2002. I have online services setup with two different investment houses (plus my bank). While positions and fund balances successfully...
Microsoft Money 3 09-16-2003 08:13 PM
View of Detail after XP upgrade
trudy: I recently upgraded my mothers PC to XP. After the upgrade I restored the most recent money backup (Money 2001) and one of her accounts will not...
Microsoft Money 2 08-27-2003 02:55 PM
suppress detail in a report?
speedlever: I have a trial version of MS Money 2004. I want to generate a report based on Classification 1 and would like to see a summary only with no...
Microsoft Money 7 08-14-2003 03:36 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 10:22 PM.