Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #3  
Old 03-21-2007, 09:28 PM
jamby
Guest
 
Posts: n/a
Default Re: Fidelity 401k account download problem - mismatched mutual fun

Thank you for the follow-up, Cal.

That appears to have done the trick. My most recent statement download that
included no new transactions didn't prompt me with the mis-match.

This solution is definitely not for the faint of heart though. Especially
when dealing with a 401k account that has twice monthly transactions plus
dividends for 5+ years. That was one heckuva time consuming task.

Well worth it though and I appreciate your taking the time to help me out.

Regards,
jamby

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, jamby wrote:
> > > Everything worked fine up until the "Now download from your broker for

> > real." step. I downloaded the actual Fidelity statement and the unwanted
> > PTMDX fund is still there.
> > > Once I do that I still get the prompt the 'Money found the following

> > investment' for PTMDX and wants to update my account.
> > > I've tried it twice with the same results.

> You have PTTRX that somehow incorrectly matched PTMDX. So in this
> process, you said that the new fake investment was the same as
> PTMDX, which went as expected.
> But when you again downloaded, it did not ask if you already have
> PTTRX as another name, but just still assumed it was PTMDX.
> Dang. If my recap correctly states it, I am disappointed. I don't
> know why it did not work as hoped.
> As with all such unusual things, keep an extra copy or backup of
> your Money file in case you want to undo something.... so here is
> another way to work around it, since the other way failed:
> 1. Lets call PTTRX NOWCO and lets call PTMDX OLDCO.
> If you currently have NOWCO defined in your file, to the investment
> details/settings for that fund. Change the name to ZZZZZ8 or some
> such, and *blank* the symbol. If it is not defined, skip this step.
> 2. Rename the current OLDCO to the name for NOWCO, and change its
> symbol to that of NOWCO. Now when the future downloads happen, it
> will be for what is now NOWCO.
> 3. Now to deal with the existing OLDCO transactions:
> Create a new OLDCO Fund with the correct name and symbol.
> Go back to investment NOWCO and choose InvestmentActivities.
> Enter a fake new Buy dated before all other transactions with
> quantity more than the total of other NOWCO transactions. That way,
> when you change transactions, you won't have Money complaining that
> there are not enough of the fund shares when you change a Buy.
> Change each NOWCO transaction that is really an OLDCO transaction to
> OLDCO using the drop-down list. Start with the oldest transaction.
> Keep going until there are no more transactions that need changing,
> except for the fake transaction. Delete the fake Buy transaction.
> Similarly, if you have any ZZZZZ8 transactions, change them to the
> right security.
> Careful. I might have mis-typed somewhere. I hope you see the
> pattern rather than just following the algorithm, which could have
> mistakes.

  #2  
Old 03-21-2007, 01:42 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Fidelity 401k account download problem - mismatched mutual fun

In microsoft.public.money, jamby wrote:

- quote -

> Everything worked fine up until the "Now download from your broker for
> real." step. I downloaded the actual Fidelity statement and the unwanted
> PTMDX fund is still there.
> Once I do that I still get the prompt the 'Money found the following
> investment' for PTMDX and wants to update my account.
> I've tried it twice with the same results.


You have PTTRX that somehow incorrectly matched PTMDX. So in this
process, you said that the new fake investment was the same as
PTMDX, which went as expected.

But when you again downloaded, it did not ask if you already have
PTTRX as another name, but just still assumed it was PTMDX.

Dang. If my recap correctly states it, I am disappointed. I don't
know why it did not work as hoped.

As with all such unusual things, keep an extra copy or backup of
your Money file in case you want to undo something.... so here is
another way to work around it, since the other way failed:

1. Lets call PTTRX NOWCO and lets call PTMDX OLDCO.
If you currently have NOWCO defined in your file, to the investment
details/settings for that fund. Change the name to ZZZZZ8 or some
such, and *blank* the symbol. If it is not defined, skip this step.

2. Rename the current OLDCO to the name for NOWCO, and change its
symbol to that of NOWCO. Now when the future downloads happen, it
will be for what is now NOWCO.

3. Now to deal with the existing OLDCO transactions:
Create a new OLDCO Fund with the correct name and symbol.

Go back to investment NOWCO and choose InvestmentActivities.
Enter a fake new Buy dated before all other transactions with
quantity more than the total of other NOWCO transactions. That way,
when you change transactions, you won't have Money complaining that
there are not enough of the fund shares when you change a Buy.

Change each NOWCO transaction that is really an OLDCO transaction to
OLDCO using the drop-down list. Start with the oldest transaction.

Keep going until there are no more transactions that need changing,
except for the fake transaction. Delete the fake Buy transaction.
Similarly, if you have any ZZZZZ8 transactions, change them to the
right security.

Careful. I might have mis-typed somewhere. I hope you see the
pattern rather than just following the algorithm, which could have
mistakes.
  #1  
Old 03-21-2007, 12:19 AM
jamby
Guest
 
Posts: n/a
Default Re: Fidelity 401k account download problem - mismatched mutual fun

Thanks for the response, Cal.

Everything worked fine up until the "Now download from your broker for
real." step. I downloaded the actual Fidelity statement and the unwanted
PTMDX fund is still there.

Once I do that I still get the prompt the 'Money found the following
investment' for PTMDX and wants to update my account.

I've tried it twice with the same results.

Other ideas?

Thank you.

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, jamby wrote:
> > > I'm using Money 2007. For the past couple of months now when I download my

> > active statement from Fidelity with Money I have a weird mutual fund matching
> > problem that occurs.
> > > My portfolio/account includes PTTRX - Pimco Total Returns Institutional.

> > The imported statement tries to match PTTRX to PTMDX (Pimco Total Return
> > Mortgage). I have a closed position in PTMDX from a different account in
> > Money.
> > > I've tried renaming and chaning the symbol for PTMDX, but that has not helped.
> > > It's a minor annoyance, but I'd appreciate any feedback or suggestions on

> > how to resolve this.
> > > FWIW - it didn't occur until I upgraded from Money 2006. Not suggesting

> > that's the cause, but it might be helpful in figuring it out.

> I suspect you once told Money, inadvertently, that they were the
> same security.
> I know a fix, but it may be intimidating.
> 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 (PTMDX). Click
> Next. When you get the "Are you sure xxxxx is the same investment as
> yyyyy(Pimco Total Return Mortgage)?", 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 ========================

 
Old 03-20-2007, 09:41 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Fidelity 401k account download problem - mismatched mutual funds

In microsoft.public.money, jamby wrote:

- quote -

> I'm using Money 2007. For the past couple of months now when I download my
> active statement from Fidelity with Money I have a weird mutual fund matching
> problem that occurs.
> My portfolio/account includes PTTRX - Pimco Total Returns Institutional.
> The imported statement tries to match PTTRX to PTMDX (Pimco Total Return
> Mortgage). I have a closed position in PTMDX from a different account in
> Money.
> I've tried renaming and chaning the symbol for PTMDX, but that has not helped.
> It's a minor annoyance, but I'd appreciate any feedback or suggestions on
> how to resolve this.
> FWIW - it didn't occur until I upgraded from Money 2006. Not suggesting
> that's the cause, but it might be helpful in figuring it out.


I suspect you once told Money, inadvertently, that they were the
same security.

I know a fix, but it may be intimidating.


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 (PTMDX). Click
Next. When you get the "Are you sure xxxxx is the same investment as
yyyyy(Pimco Total Return Mortgage)?", 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 ========================

  #-1  
Old 03-20-2007, 12:27 PM
jamby
Guest
 
Posts: n/a
Default Fidelity 401k account download problem - mismatched mutual funds

Greetings.

I'm using Money 2007. For the past couple of months now when I download my
active statement from Fidelity with Money I have a weird mutual fund matching
problem that occurs.

My portfolio/account includes PTTRX - Pimco Total Returns Institutional.
The imported statement tries to match PTTRX to PTMDX (Pimco Total Return
Mortgage). I have a closed position in PTMDX from a different account in
Money.

I've tried renaming and chaning the symbol for PTMDX, but that has not helped.

It's a minor annoyance, but I'd appreciate any feedback or suggestions on
how to resolve this.

FWIW - it didn't occur until I upgraded from Money 2006. Not suggesting
that's the cause, but it might be helpful in figuring it out.

Thank you.

-jamby
 

Tags
401k, account, download, fidelity, funds, mismatched, mutual, problem
Similar Threads
Thread Forum Replies Last Post
Download stock and mutual funds from Brazilian quotes
fabpovoa: Hi, guys ! I would like to hear from you whether it is possible for me to configure money to automatically download stocks and mutual funds from the...
Microsoft Money 1 01-20-2006 07:35 AM
Washington Mutual Download Problem With &
Douglas Jones: I have MS Money 2004 which has worked fine with WAMU online banking downloads until just recently. I have been informed that some upgrade that MS...
Microsoft Money 3 12-23-2005 08:49 PM
Mutual funds quotes DO NOT download
zharry: You are having a problem with the mutual fund quotes. They are not downloading. Many others are complaining of the same porblem. Stock quotes...
Microsoft Money 1 11-01-2005 06:49 AM



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 09:29 PM.