In microsoft.public.money, RM wrote:

- quote -

It sounds as if you have two different securities still defined as
Microsoft. Do you?

- quote -

Funny thing. This worked, but now other investment accounts that have MSFT
in it keep prompting me to associate 'Microsoft Stock' with 'Microsoft
Stock'. This seems like a real bug, I don't see a reason why I would need to
keep reassociating these investments after each download. Is there a work
around for this?

"RM" <r[at]m.com> wrote in message
news:431a0b6d$0$31378$c3e8da3[at]news.astraweb.com...
- quote -

Thanks! That worked. Whoever is maintaining the FAQ should probably add this
as an item. Or the Money team could add a way to remove unwanted
investments.

-R

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:8frjh1he27qiv3ujcrbmrhrkjd5jijhfk6[at]4ax.com...
In microsoft.public.money, RM wrote:

- quote -


This is not that. It is something I devised when I had a similar
problem. I don't represent it to be the best way. It is the way I
know worked for me. It is much simpler than rebuilding your Money
file. It will involve doing some rather unusual things.

Whenever you do something unusual, you want to make an extra copy of
your Money file in case something does not work as you hope. This is
more unusual, so make two copies.

Here is the overall plan:

Change over all of your actual MSFT transactions to the one you want
to keep. Rename the one you want to get rid of to something unusual
and distinctive. Blank the symbol.

Put the MSFT symbol on the one you want to be downloading data for.

Each investment has a unique number that is usually a CUSIP number.
That is what Money uses to know whether something is the same
investment. However the CUSIP is maintained in a place that is not
accessible. So the trick is to disassociating the CUSIP from the
wrong place by giving it a new fake CUSIP. That is what I wrote the
following procedure to accomplish:

------Disassociate Stock from Money Download---------

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

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

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

File-> Import dis_sk.ofx into Money

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 stock 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. The plan is that you will be
asked if you already have that Microsoft stock defined already.
Choose it from the list, and you should be good.

Feel free to suggest improvements to this procedure.


========================Begin dis_sk.ofx========================
OFXHEADER:100
DATA:OFXSGML
OLDFILEUID:NONE
NEWFILEUID:NONE
CHARSET:1252
VERSION:102
COMPRESSION:NONE
ENCODING:USASCII
SECURITY: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> ZzzzA1
<STATUS<CODE> 0
<SEVERITY> INFO
<MESSAGE> Success so far with stock modification of symbol and CUSIP
</STATUS
<INVSTMTRS<DTASOF> 20040221
<CURDEF> USD
<INVACCTFROM<BROKERID> YourBrokerOrZzzzA2
<ACCTID> YourAccountOrZzzzA3
</INVACCTFROM


<INVPOSLIST
<POSSTOCK<INVPOS<SECID<UNIQUEID> ZzzzA4
<UNIQUEIDTYPE> CUSIP
</SECID<HELDINACCT> CASH
<POSTYPE> LONG
<UNITS> 0.0000
<UNITPRICE> 42.840
<MKTVAL> 0.000
<DTPRICEASOF> 20041102000000.000[-5:EST]
</INVPOS</POSSTOCK
</INVPOSLIST
</INVSTMTRS</INVSTMTTRNRS</INVSTMTMSGSRSV1

<SECLISTMSGSRSV1<SECLIST
<STOCKINFO<SECINFO<SECID<UNIQUEID> ZzzzA4
<UNIQUEIDTYPE> CUSIP
</SECID<SECNAME> ZzzzA4 Dissassocated stock
<TICKER> GSK
</SECINFO</STOCKINFO
</SECLIST</SECLISTMSGSRSV1</OFX
=========================END dis_sk.ofx ========================

Note. If you re-use this proceure on the same file, you will
probably need to change all occurances of Zzzz to a different
string.













- quote -

In microsoft.public.money, RM wrote:

- quote -


This is not that. It is something I devised when I had a similar
problem. I don't represent it to be the best way. It is the way I
know worked for me. It is much simpler than rebuilding your Money
file. It will involve doing some rather unusual things.

Whenever you do something unusual, you want to make an extra copy of
your Money file in case something does not work as you hope. This is
more unusual, so make two copies.

Here is the overall plan:

Change over all of your actual MSFT transactions to the one you want
to keep. Rename the one you want to get rid of to something unusual
and distinctive. Blank the symbol.

Put the MSFT symbol on the one you want to be downloading data for.

Each investment has a unique number that is usually a CUSIP number.
That is what Money uses to know whether something is the same
investment. However the CUSIP is maintained in a place that is not
accessible. So the trick is to disassociating the CUSIP from the
wrong place by giving it a new fake CUSIP. That is what I wrote the
following procedure to accomplish:

------Disassociate Stock from Money Download---------

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

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

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

File-> Import dis_sk.ofx into Money

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 stock 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. The plan is that you will be
asked if you already have that Microsoft stock defined already.
Choose it from the list, and you should be good.

Feel free to suggest improvements to this procedure.


========================Begin dis_sk.ofx========================
OFXHEADER:100
DATA:OFXSGML
OLDFILEUID:NONE
NEWFILEUID:NONE
CHARSET:1252
VERSION:102
COMPRESSION:NONE
ENCODING:USASCII
SECURITY: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> ZzzzA1
<STATUS<CODE> 0
<SEVERITY> INFO
<MESSAGE> Success so far with stock modification of symbol and CUSIP
</STATUS
<INVSTMTRS<DTASOF> 20040221
<CURDEF> USD
<INVACCTFROM<BROKERID> YourBrokerOrZzzzA2
<ACCTID> YourAccountOrZzzzA3
</INVACCTFROM


<INVPOSLIST
<POSSTOCK<INVPOS<SECID<UNIQUEID> ZzzzA4
<UNIQUEIDTYPE> CUSIP
</SECID<HELDINACCT> CASH
<POSTYPE> LONG
<UNITS> 0.0000
<UNITPRICE> 42.840
<MKTVAL> 0.000
<DTPRICEASOF> 20041102000000.000[-5:EST]
</INVPOS</POSSTOCK
</INVPOSLIST
</INVSTMTRS</INVSTMTTRNRS</INVSTMTMSGSRSV1

<SECLISTMSGSRSV1<SECLIST
<STOCKINFO<SECINFO<SECID<UNIQUEID> ZzzzA4
<UNIQUEIDTYPE> CUSIP
</SECID<SECNAME> ZzzzA4 Dissassocated stock
<TICKER> GSK
</SECINFO</STOCKINFO
</SECLIST</SECLISTMSGSRSV1</OFX
=========================END dis_sk.ofx ========================

Note. If you re-use this proceure on the same file, you will
probably need to change all occurances of Zzzz to a different
string.













- quote -

Why was I expecting to hear that... Well, I'd like to hear about it, if you
don't mind typing it all up. I'm not sure I'm willing to rebuild my money
file from the ground up right now, but at this point I'm really curious what
the people at Money designed for this particular case.

Thanks,
Relja

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:98aih1doaa5t63ulfc5tfcj9mh5l9lbc0r[at]4ax.com...
In microsoft.public.money, RM wrote:

- quote -

Yes, but my method is complex. Are you motivated?

In microsoft.public.money, RM wrote:

- quote -

Yes, but my method is complex. Are you motivated?

Hi, I'm running into an annoying issue with Money 2006:

A while ago I accidentally set up two investments for MSFT: one with an
associated stock symbol, and the other obviously with no symbol. I would
like to merge these two investments. I tried doing that by remapping all of
the 'wrong' investment transactions to the right investment (the one with
the stock symbol), and then deleting the wrong investment. However, every
time I go to download account updates from Fidelity, I get a prompt saying
"you've got xxx stock of Microsoft Corp. (the wrong type)". If I let Money
update my positions, I get duplicate transactions. Is there any way I can
get Money to stop associating Fidelity downloads to the wrong investment?

Thanks,
-R.