Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #8  
Old 10-30-2007, 08:36 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Investment Account position matching

In microsoft.public.money, RLSorensen wrote:

- quote -

> 2) A new mutual fund [in one of the accounts] got reported in my online
> updates but is now somehow matched to one of the unused names, rather than
> being reported as the fund it is. Now every time there is an update I get a
> dialog box
> "Position Matching
> The positions reported on the 10/29/2007 statement don't match those in your
> Money Account. Do you want Money to update your account to match the
> statement?"
> and it gives me the fund name and the number of shares it wants to reassign
> to the mystery name.
> To which I say No thanks... Money has helped enough already.
> So.. questions:

<snip> 2) [MORE IMPORTANT] How do I get Money to recognize the correct fund name in
> the online updates?


There would be more than one way to handle this, tho it might *also*
be addressed with the CombineWith operation.

With Money 2006, there would be a couple ways of handling this.

One way would be to

1. blank the symbol on the correct fund.
2. rename the correct fund to zzzz
3. rename the current wrong fund to match the name of the correct
fund, and change the symbol.
4. Change all existing transactions in zzzz to the now new correct
fund. This may involve creating a temporary fake addshares...


Another way would be to dissociate the old unused name from the
download:


Disassociate Mutual Fund

The purpose of this procedure is disassociate a security from the
download process. The problem this cures is that Money associates
downloaded fund by CUSIP. Renaming and/or changing the symbol is
not sufficient to appear as a different security.

Create dis_mf.ofx by cutting and pasting the portions between the
Begin and End lines (below) into a file named dis_mf.ofx.

I suggest making an extra copy of your Money file as a precaution.

File-> Import dis_mf.ofx

Select the appropriate Account from the list.

Select the institution as the actual institution that holds the
account.

You should get the "You have n statements to read" screen. The
account you just imported into should show the name account name
followed by (1). Click that name.

You should get the pop-up that says "Money found the following
investment in your brokerage statement:".

Select "This investment is already in my investment portfolio with
a different name. I use the following investment in my investment
portfolio to track this investment:". From the drop-down list,
choose the mutual fund you are trying to get rid of. Click Next.
When you get the "Are you sure xxxxx is the same investment as
yyyy?", click Yes.

If you get the screen that says "Do you want to change the ticker
symbol for xxxx in Money from yyyy to zzzz to match the statement,
I suggest you click Yes.

Get the screen that says "The positions reported on nn/nn/nn
statement don't match those in you Money account. Do you want to
update your account to match the statement?". I would select No,
but it is up to you. Click Finish.

Now download from your broker for real.

Feel free to suggest improvements to this procedure.




========================Begin dis_mf.ofx========================
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX<SIGNONMSGSRSV1

<SONRS<STATUS<CODE> 0
<SEVERITY> INFO
<MESSAGE> SUCCESS
</STATUS<DTSERVER> 20040302
<LANGUAGE> ENG
<DTPROFUP> 20030403
<DTACCTUP> 20040201
</SONRS> </SIGNONMSGSRSV1<INVSTMTMSGSRSV1

<INVSTMTTRNRS<TRNUID> Zzzz1
<STATUS<CODE> 0
<SEVERITY> INFO
<MESSAGE> Success so far with MF displacement
</STATUS
<INVSTMTRS<DTASOF> 20040302
<CURDEF> USD
<INVACCTFROM<BROKERID> YourBrokerOrZzzz2
<ACCTID> YourAccountOrZzzz3
</INVACCTFROM<INVPOSLIST
<POSMF<INVPOS<SECID<UNIQUEID> Zzzz4
<UNIQUEIDTYPE> CUSIP
</SECID<HELDINACCT> CASH
<POSTYPE> LONG
<UNITS> 0.01
<UNITPRICE> 01.00
<MKTVAL> 0.010
<DTPRICEASOF> 20040302
</INVPOS</POSMF</INVPOSLIST
</INVSTMTRS</INVSTMTTRNRS</INVSTMTMSGSRSV1

<SECLISTMSGSRSV1<SECLIST
<MFINFO<SECINFO<SECID<UNIQUEID> Zzzz4
<UNIQUEIDTYPE> CUSIP
</SECID<SECNAME> Zzzz5
<TICKER> Zzzz6
</SECINFO</MFINFO
</SECLIST</SECLISTMSGSRSV1</OFX
=========================END dis_mf.ofx ========================



  #7  
Old 10-30-2007, 08:04 PM
RLSorensen
Guest
 
Posts: n/a
Default Re: Investment Account position matching



"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, RLSorensen wrote:
> > > > Can we fix the real problem that this introduced? [see my previous post].

> Yes. See my response to that post.
> Money Plus (or 2007) gives the best handling via CombineWith. With
> Money 2006, your best available choice with downloading is to assign
> the symbol to one or the other. You could alternate if you wanted to
> work at it.


Cal,

You responded to the first part [the same fund in two different accounts]
but I'm trying to solve the problem of a different fund being reported
incorrectly by Money and trying to move shares of the other fund around
rather than show the second [or third, depending on how you count it] fund.

Rick Sorensen
  #6  
Old 10-30-2007, 07:51 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Investment Account position matching

In microsoft.public.money, RLSorensen wrote:

- quote -

> Can we fix the real problem that this introduced? [see my previous post].

Yes. See my response to that post.

Money Plus (or 2007) gives the best handling via CombineWith. With
Money 2006, your best available choice with downloading is to assign
the symbol to one or the other. You could alternate if you wanted to
work at it.
  #5  
Old 10-30-2007, 07:33 PM
RLSorensen
Guest
 
Posts: n/a
Default Re: Investment Account position matching



"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, RLSorensen wrote:
> > > You can have different names for different investments, and it makes
> > > sense to do so if they are indeed different investments. If they are
> > > actually different investments, it does not make sense that they
> > > have the same symbol. ...but..... see below:
> > > This is a bit off topic, but..... if I have the same mutual fund in two

> > different *accounts*, each account having different tax treatment, it really
> > isn't the same investment.

> They are different shares. To my way of thinking, they are the same
> investment. If you choose to think of them differently, that's fine.
> If you sell the holding, the buyer is not going to care which
> account they came from. They are fungible.
> > The problem is, as soon as I try to relate them to
> > the same ticker Money chokes and tells me it can't do that. Why NOT???

> If I were to see them as different investments, then that would be
> natural to not have the same ticker.
> > Fidelity reports them uniquely, so why can't Money get it right?

> The problem is that when you go to download from Fido NetBenefits,
> they come in with a different CUSIP. That should not be. But it is,
> due to a quirk of NetBenefits.
> So I would say why can't NetBenefits get it right? I am fine with
> discussing the philosophy first and dealing with reality later.


As I said, that was off-topic to the real problem I'm having. Philosophical
differences are just that. Ultimately I need to respond to the philosophical
interpretations imposed by the IRS, not Money, so... I'll deal with it best I
can.

Can we fix the real problem that this introduced? [see my previous post].

Thanks,

Rick Sorensen
  #4  
Old 10-30-2007, 04:24 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Investment Account position matching

In microsoft.public.money, RLSorensen wrote:

- quote -

> > You can have different names for different investments, and it makes
> > sense to do so if they are indeed different investments. If they are
> > actually different investments, it does not make sense that they
> > have the same symbol. ...but..... see below:

> This is a bit off topic, but..... if I have the same mutual fund in two
> different *accounts*, each account having different tax treatment, it really
> isn't the same investment.


They are different shares. To my way of thinking, they are the same
investment. If you choose to think of them differently, that's fine.
If you sell the holding, the buyer is not going to care which
account they came from. They are fungible.


- quote -

> The problem is, as soon as I try to relate them to
> the same ticker Money chokes and tells me it can't do that. Why NOT???


If I were to see them as different investments, then that would be
natural to not have the same ticker.

- quote -

> Fidelity reports them uniquely, so why can't Money get it right?

The problem is that when you go to download from Fido NetBenefits,
they come in with a different CUSIP. That should not be. But it is,
due to a quirk of NetBenefits.

So I would say why can't NetBenefits get it right? I am fine with
discussing the philosophy first and dealing with reality later.

  #3  
Old 10-30-2007, 03:46 PM
RLSorensen
Guest
 
Posts: n/a
Default Re: Investment Account position matching



"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, RLSorensen wrote:
> > > > "Cal Learner-- MVP" wrote:
> > > > In microsoft.public.money, RLSorensen wrote:
> > > > > > I have two problems here - looks like the first somehow lead to the second.
> > > > > > > 1) I have two investment accounts with the same mutual fund in each, but
> > > > Money won't let me assign the same ticker with a different name... I know, I
> > > > tried! In the process of setting that up I had some unused names lurking
> > > > [apparently] in the bowels of Money which lead to:
> > > > > > > 2) A new mutual fund [in one of the accounts] got reported in my online
> > > > updates but is now somehow matched to one of the unused names, rather than
> > > > being reported as the fund it is. Now every time there is an update I get a
> > > > dialog box
> > > > > If you have the same investment, you don't want to create a new name
> > > for that investment. Instead you would choose the existing
> > > investment from the drop-down list. See below.
> > > > > The solution would depend on the answer to the question below, and
> > > how long this has been going on.
> > > > > > > > > > > "Position Matching
> > > > > > > The positions reported on the 10/29/2007 statement don't match those in your
> > > > Money Account. Do you want Money to update your account to match the
> > > > statement?"
> > > > > > > and it gives me the fund name and the number of shares it wants to reassign
> > > > to the mystery name.
> > > > > > > To which I say No thanks... Money has helped enough already.
> > > > > > > So.. questions:
> > > > > > > 1) Is there a way to clearly label a specific investment so that I know
> > > > which is which without having to click back to see which account it is in?
> > > > > You can rename an investment. I don't know exactly what your
> > > question means, if that does not answer the question.
> > > The question is: Can I have different names for the two investments when

> > they amount to the same mutual fund held in two different accounts? One is in
> > a 401K and the other in a regular investment account and obviously have
> > different tax treatment. I haven't seen a way within Money to uniquely
> > identify them, and find in some reports the two are lumped together as a
> > single investment since they relate to the same ticker symbol.

> You can have different names for different investments, and it makes
> sense to do so if they are indeed different investments. If they are
> actually different investments, it does not make sense that they
> have the same symbol. ...but..... see below:


This is a bit off topic, but..... if I have the same mutual fund in two
different *accounts*, each account having different tax treatment, it really
isn't the same investment. The problem is, as soon as I try to relate them to
the same ticker Money chokes and tells me it can't do that. Why NOT???
Fidelity reports them uniquely, so why can't Money get it right?

- quote -

> > > > 2) [MORE IMPORTANT] How do I get Money to recognize the correct fund name in
> > > > the online updates?
> > > > > Is this involving Fidelity NetBenefits?
> > > Yes

> Lucky guess?... Special [odd] case. The same investment should also
> have the same CUSIP number. In the case of Fidelity NetBenefits,
> they create their own non-standard CUSIP for the holdings. This
> causes the problem you are seeing. Inspired by this, starting in
> Money 2007, Money came up with a way to deal with this. This
> involves a CombineWith operation. This lets Money treat an
> investment with a different CUSIP (which is involved in the
> downloads, even if you don't know it exists).


Think we miscommunicated here.

My current problem isn't this. The current problem is that Money has somehow
interpreted a DIFFERENT investment incorrectly and assigns an incorrect name
to it. Now, when I get online updates Money insists on trying to reallocate
shares rather than reporting the new investment which is NOT one of the ones
above. The name it assigns is one that I had tried to assign while trying to
maintain separate reporting of the previous fund, and there's no way [that I
know of] that Fidelity would even be aware of that name.

Here's the scenario as it emerged:

Buy mutual fund A in the 401K account...

Then buy mutual fund A in a regular investment account.

Discover confusion within Money when it tries to combine fund A [401K] with
fund A [investment].

Try to unravel the confusion by renaming fund A [investment] to fund A+

Discover that Money won't let me maintain fund A and fund A+ with the same
stock ticker.

Rename fund A+ to fund A and live with the confusion within Money.

With me so far??.... HERE'S the current problem:

Buy mutual fund B

Money does an online update and tries to label fund B as **fund A+** [and
wants to move shares from fund A to fund A+]

THIS is the problem I need to solve, and from the looks of things, M+ isn't
an answer.

Rick Sorensen
  #2  
Old 10-30-2007, 02:59 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Investment Account position matching

In microsoft.public.money, RLSorensen wrote:

- quote -

> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, RLSorensen wrote:
> > > > I have two problems here - looks like the first somehow lead to the second.
> > > > > 1) I have two investment accounts with the same mutual fund in each, but
> > > Money won't let me assign the same ticker with a different name... I know, I
> > > tried! In the process of setting that up I had some unused names lurking
> > > [apparently] in the bowels of Money which lead to:
> > > > > 2) A new mutual fund [in one of the accounts] got reported in my online
> > > updates but is now somehow matched to one of the unused names, rather than
> > > being reported as the fund it is. Now every time there is an update I get a
> > > dialog box
> > > If you have the same investment, you don't want to create a new name

> > for that investment. Instead you would choose the existing
> > investment from the drop-down list. See below.
> > > The solution would depend on the answer to the question below, and

> > how long this has been going on.
> > > > > > > "Position Matching
> > > > > The positions reported on the 10/29/2007 statement don't match those in your
> > > Money Account. Do you want Money to update your account to match the
> > > statement?"
> > > > > and it gives me the fund name and the number of shares it wants to reassign
> > > to the mystery name.
> > > > > To which I say No thanks... Money has helped enough already.
> > > > > So.. questions:
> > > > > 1) Is there a way to clearly label a specific investment so that I know
> > > which is which without having to click back to see which account it is in?
> > > You can rename an investment. I don't know exactly what your

> > question means, if that does not answer the question.

> The question is: Can I have different names for the two investments when
> they amount to the same mutual fund held in two different accounts? One is in
> a 401K and the other in a regular investment account and obviously have
> different tax treatment. I haven't seen a way within Money to uniquely
> identify them, and find in some reports the two are lumped together as a
> single investment since they relate to the same ticker symbol.


You can have different names for different investments, and it makes
sense to do so if they are indeed different investments. If they are
actually different investments, it does not make sense that they
have the same symbol. ...but..... see below:

- quote -

> > > > > > 2) [MORE IMPORTANT] How do I get Money to recognize the correct fund name in
> > > the online updates?
> > > Is this involving Fidelity NetBenefits?

> Yes


Lucky guess?... Special [odd] case. The same investment should also
have the same CUSIP number. In the case of Fidelity NetBenefits,
they create their own non-standard CUSIP for the holdings. This
causes the problem you are seeing. Inspired by this, starting in
Money 2007, Money came up with a way to deal with this. This
involves a CombineWith operation. This lets Money treat an
investment with a different CUSIP (which is involved in the
downloads, even if you don't know it exists).

So, your choice with Fidelity NetBenefits and Money 2006, is to have
two investments with different names and to leave the symbol blank
on the non-standard one. Enter prices by hand.

Alternatively, upgrade to Money Plus (or Money 2007) and use the
CombineWith operation that was inspired by Fidelity NetBenefits.












- quote -

> > > > > > > Money 2006 Premium edition
> > > WinXP Media Center
> > > > > Rick Sorensen

>
  #1  
Old 10-30-2007, 02:28 PM
RLSorensen
Guest
 
Posts: n/a
Default Re: Investment Account position matching



"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, RLSorensen wrote:
> > I have two problems here - looks like the first somehow lead to the second.
> > > 1) I have two investment accounts with the same mutual fund in each, but

> > Money won't let me assign the same ticker with a different name... I know, I
> > tried! In the process of setting that up I had some unused names lurking
> > [apparently] in the bowels of Money which lead to:
> > > 2) A new mutual fund [in one of the accounts] got reported in my online

> > updates but is now somehow matched to one of the unused names, rather than
> > being reported as the fund it is. Now every time there is an update I get a
> > dialog box

> If you have the same investment, you don't want to create a new name
> for that investment. Instead you would choose the existing
> investment from the drop-down list. See below.
> The solution would depend on the answer to the question below, and
> how long this has been going on.
> > > "Position Matching
> > > The positions reported on the 10/29/2007 statement don't match those in your

> > Money Account. Do you want Money to update your account to match the
> > statement?"
> > > and it gives me the fund name and the number of shares it wants to reassign

> > to the mystery name.
> > > To which I say No thanks... Money has helped enough already.
> > > So.. questions:
> > > 1) Is there a way to clearly label a specific investment so that I know

> > which is which without having to click back to see which account it is in?

> You can rename an investment. I don't know exactly what your
> question means, if that does not answer the question.


The question is: Can I have different names for the two investments when
they amount to the same mutual fund held in two different accounts? One is in
a 401K and the other in a regular investment account and obviously have
different tax treatment. I haven't seen a way within Money to uniquely
identify them, and find in some reports the two are lumped together as a
single investment since they relate to the same ticker symbol.


- quote -

> > > 2) [MORE IMPORTANT] How do I get Money to recognize the correct fund name in
> > the online updates?

> Is this involving Fidelity NetBenefits?


Yes

- quote -

> > > Money 2006 Premium edition
> > WinXP Media Center
> > > Rick Sorensen

 
Old 10-30-2007, 01:41 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Investment Account position matching

In microsoft.public.money, RLSorensen wrote:

- quote -

> I have two problems here - looks like the first somehow lead to the second.
> 1) I have two investment accounts with the same mutual fund in each, but
> Money won't let me assign the same ticker with a different name... I know, I
> tried! In the process of setting that up I had some unused names lurking
> [apparently] in the bowels of Money which lead to:
> 2) A new mutual fund [in one of the accounts] got reported in my online
> updates but is now somehow matched to one of the unused names, rather than
> being reported as the fund it is. Now every time there is an update I get a
> dialog box


If you have the same investment, you don't want to create a new name
for that investment. Instead you would choose the existing
investment from the drop-down list. See below.

The solution would depend on the answer to the question below, and
how long this has been going on.


- quote -

> "Position Matching
> The positions reported on the 10/29/2007 statement don't match those in your
> Money Account. Do you want Money to update your account to match the
> statement?"
> and it gives me the fund name and the number of shares it wants to reassign
> to the mystery name.
> To which I say No thanks... Money has helped enough already.
> So.. questions:
> 1) Is there a way to clearly label a specific investment so that I know
> which is which without having to click back to see which account it is in?


You can rename an investment. I don't know exactly what your
question means, if that does not answer the question.

- quote -

> 2) [MORE IMPORTANT] How do I get Money to recognize the correct fund name in
> the online updates?


Is this involving Fidelity NetBenefits?


- quote -

> Money 2006 Premium edition
> WinXP Media Center
> Rick Sorensen

  #-1  
Old 10-30-2007, 01:15 PM
RLSorensen
Guest
 
Posts: n/a
Default Investment Account position matching

I have two problems here - looks like the first somehow lead to the second.

1) I have two investment accounts with the same mutual fund in each, but
Money won't let me assign the same ticker with a different name... I know, I
tried! In the process of setting that up I had some unused names lurking
[apparently] in the bowels of Money which lead to:

2) A new mutual fund [in one of the accounts] got reported in my online
updates but is now somehow matched to one of the unused names, rather than
being reported as the fund it is. Now every time there is an update I get a
dialog box

"Position Matching

The positions reported on the 10/29/2007 statement don't match those in your
Money Account. Do you want Money to update your account to match the
statement?"

and it gives me the fund name and the number of shares it wants to reassign
to the mystery name.

To which I say No thanks... Money has helped enough already.

So.. questions:

1) Is there a way to clearly label a specific investment so that I know
which is which without having to click back to see which account it is in?

2) [MORE IMPORTANT] How do I get Money to recognize the correct fund name in
the online updates?

Money 2006 Premium edition
WinXP Media Center

Rick Sorensen
 

Tags
account, investment, matching, position
Similar Threads
Thread Forum Replies Last Post
Deleted Watch Investment Still Gets Updated - Position Matching
ira: I had a few investments in a watch account and deleted them all several months ago. for some reason i can't get rid of one of them. every single...
Microsoft Money 5 08-07-2007 04:45 PM
Investment Verification doesn't list matching security
kvoolk: Hello, I recently installed Money 2007 Deluxe. When I update my statement from my DWS-Scudder account (it doesn't happen with my other account),...
Microsoft Money 11 10-21-2006 12:02 AM
How to see position subtotaled by account
Miles: In MS Money 2005 Premium, when I look at my Portfolio, Select View = Holdings, Group By = Position, each equity position appears. If I click on...
Microsoft Money 4 03-01-2005 03:03 AM
Stock Position Updates
igorx: I have 3 accounts with Smith Barney. When I update these accounts in Money 2003 I get a box that is titled Position Matching. This box shows my...
Microsoft Money 1 08-28-2004 08:44 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 11:49 PM.