Change Mapping Continued


S

SMERTZ

I have had to take my file back to one week ago when I bought 2005 Premium.

Microsoft Support totally messed up the file, so I'm back where I started.
I
think I have three problems, and I'm going to take them on one at a time.

Currently In my portfolio in another account, I have DTV Stock. Fidelity is
trying to download "The DIRECTV Group Common Stock Fund" Should this be a
new investment, different from Direct TV (DTV)?


When I try to import and at the point with the radio buttons that say
"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:".

My Direct TV stock is not part of the drop down selection? So how should I
handle this import?
 
Ad

Advertisements

C

Cal Learner-- MVP

I have had to take my file back to one week ago when I bought 2005 Premium.

Microsoft Support totally messed up the file, so I'm back where I started.
I
think I have three problems, and I'm going to take them on one at a time.

Currently In my portfolio in another account, I have DTV Stock. Fidelity is
trying to download "The DIRECTV Group Common Stock Fund" Should this be a
new investment, different from Direct TV (DTV)?
I think your problems include The Directv Group Inc (DTV) should
have been set up as a stock, but it is set up as a Money Market fund
(a special kind of mutual fund).

Money somehow thinks that a Fidelity mutual fund holding (which I
will call F***X) you have is also The Directv Group Inc (DTV).


My suggestion is to

1. Rename the current DTV investment to a weird name-- perhaps "bad
DTV"-- and blank its symbol. If you don't know how to rename it or
blank its symbol, ask.

2. Create a mutual fund for (F***X) if you don't have one already
using the right symbol.

3. Create a mutual fund for The Directv Group Inc if you don't have
one already using the DTV symbol.

4. Go to the InvestmentActivities for "bad DTV" and change each
transaction for "bad DTV" into one for the fund or stock referenced
in items 2 or 3 above. When done, there should be no remaining
transactions for "bad DTV" left. If you don't know how to find the
InvestmentActivities for "bad DTV", ask. Do not delete "bad DTV" at
this time.

5. If you did not download, you would be done. But you do download.
Save a copy/backup of where you are at this point.

6. Disassociate "bad DTV" from its current download references by
using the dis_mf.ofx file you prepared from the section of an
earlier posting. If you can't locate that, ask. Follow the
directions from that posting to make the fake download think that
the "bad DTV" is a different weird fund to you-- one that is not DTV
and is not F***X.

7. When you download for real, the download from Fidelity should now
ask if The Directv Group Inc is known to you under a different name.
Answer Yes. Select the one referenced in item 3. Ditto for F***X
and item 2.

8. You should be in good shape now. If so, you can finally delete
"bad DTV".

When I try to import and at the point with the radio buttons that say
"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:".

My Direct TV stock is not part of the drop down selection? So how should I
handle this import?
If you keep your story on one thread, it could allow somebody to
follow along. OK, in this case, I can see nobody could follow the
previous thread.

If a step
 
S

SMERTZ

We may be starting this with an incorrect assumption. The Directv Group Inc
(DTV) is classified as a stock

After completing your proceedure, when I download again it tries to come in
as Direct TV Group Fund as a Mutual Fund again.

Below following ******* is what I did according to your instructions.
Please note I have DTV stock options in another account and I am told you
can't export and re-import option accounts so I am trying to be careful with
this file. Yes I have a backup.


Cal Learner-- MVP said:
I think your problems include The Directv Group Inc (DTV) should
have been set up as a stock, but it is set up as a Money Market fund
(a special kind of mutual fund).

Money somehow thinks that a Fidelity mutual fund holding (which I
will call F***X) you have is also The Directv Group Inc (DTV).


My suggestion is to

1. Rename the current DTV investment to a weird name-- perhaps "bad
DTV"-- and blank its symbol. If you don't know how to rename it or
blank its symbol, ask.
******* By this I assume you mean the bad one, not the good one I
have as a stock
****** I renamed to "AA Bad DTV Fund"
2. Create a mutual fund for (F***X) if you don't have one already
using the right symbol. I do not own and FPURX Fidelity Puritan so I
created a fund by that name.

3. Create a mutual fund for The Directv Group Inc if you don't have
one already using the DTV symbol.
*******I already have one, after the rename it is now called "AA Bad DTV
Fund"
4. Go to the InvestmentActivities for "bad DTV" and change each
transaction for "bad DTV" into one for the fund or stock referenced
in items 2 or 3 above. When done, there should be no remaining
transactions for "bad DTV" left. If you don't know how to find the
InvestmentActivities for "bad DTV", ask. Do not delete "bad DTV" at
this time.
*******I edited all activities to "AA Bad DTV Fund"
5. If you did not download, you would be done. But you do download.
Save a copy/backup of where you are at this point.

6. Disassociate "bad DTV" from its current download references by
using the dis_mf.ofx file you prepared from the section of an
earlier posting. If you can't locate that, ask. Follow the
directions from that posting to make the fake download think that
the "bad DTV" is a different weird fund to you-- one that is not DTV
and is not F***X.
*******I ran the MF (mutual Fund) Dis import as you asked
 
C

Cal Learner-- MVP

We may be starting this with an incorrect assumption. The Directv Group Inc
(DTV) is classified as a stock
As opposed to DVTJ??? See
http://groups.google.com/groups?hl=en&lr=&selm=uDq#ZhczEHA.2656@TK2MSFTNGP14.phx.gbl

We need a scorecard.
After completing your proceedure, when I download again it tries to come in
as Direct TV Group Fund as a Mutual Fund again.

Below following ******* is what I did according to your instructions.
You will be able to see what I have added below because the lines
will not be preceded by ">" characters.
Please note I have DTV stock options in another account and I am told you
can't export and re-import option accounts so I am trying to be careful with
this file. Yes I have a backup.



******* By this I assume you mean the bad one, not the good one I
have as a stock
****** I renamed to "AA Bad DTV Fund"
OK. That's the TPBJ? So there are three existing investments
(including two bad ones) plus an option for one of them. Is there a
good one defined as a stock with symbol DTV? Is that the one that
the options reference?

*******I already have one, after the rename it is now called "AA Bad DTV
Fund"

*******I edited all activities to "AA Bad DTV Fund"
You would want to edit all activities *away*FROM* "AA Bad DTV Fund"
to the correct investment. It is possible that that is what you
meant you did.
*******I ran the MF (mutual Fund) Dis import as you asked
Good.
With no asking whether you hold that fund under another name? I am
thinking that you started TWO bad "funds"... the one you renamed
already, and the one that that got matched this time. So my theory
is that "Directv Group Fund" was not actually added during this
latest download, but was there before in addition to the other
problem security.



That can be handled. So you need to rename bad "Directv Group
Fund", blank its symbol, and make a proper STOCK for DTV. I just
need to post an additional version of dis_mf.ofx so that you can
disassociate that one from downloads also. Or you can make your
own.The file cannot use the same IDs as before. Make a copy of the
previous one, but change *all* occurrences of "Zzzz" into "Zzzy".
Or let me know, and I will post a modified file.

Again follow that same method, but use the modified file.
 
S

SMERTZ

This is just way toooooooo complicated. I can't believe MS can't
resolve a stock entered as a MF. I'm taking this back to Quicken. Thanks
for the help, but I have taken a week off work and spent over 40 hours on
this, and it is just not worth the trouble.

I'm spent and I need a drink. OK 4 drinks!!!

I'm going back to keeping the stuff I need in a spreadsheet.!!!!!
 
S

SMERTZ

As a parting try, I created a new BLANK file. I then created a new account
with Fidelity and the download brought Directv Grp Fund down as a Mutual
fund. Can anyone explain why? There can't be any reference to it in a
blank file!!

When I got the box that said ""Money Found the Following Investments in your
brokerage statement" I selected add, and it came in as a MF. There was no
drop down choice to select it already existed as it was the first thing
imported!!
 
C

Cal Learner-- MVP

As a parting try, I created a new BLANK file. I then created a new account
with Fidelity and the download brought Directv Grp Fund down as a Mutual
fund. Can anyone explain why? There can't be any reference to it in a
blank file!!
Not unless you are putting a Passport on your file. If you are doing
so, I suggest that you try a new file with no Passport. The trick is
to click that you Decline.
When I got the box that said ""Money Found the Following Investments in your
brokerage statement" I selected add, and it came in as a MF. There was no
drop down choice to select it already existed as it was the first thing
imported!!
When you use a passport on a file, Money 2005 puts data onto a
server. If you use the same passport on the new file, Money is
probably getting data from that server.

I guess I should have thought about that before, but I didn't.
 
S

SMERTZ

That did not seem to make any difference. I created a new passport with a
different email address and yet another new file. Directv Grp Fund still
came down as a MF!!
 
C

Cal Learner-- MVP

That did not seem to make any difference. I created a new passport with a
different email address and yet another new file. Directv Grp Fund still
came down as a MF!!
That is strange.

OK. Is it possible the account is a 401(K) administered for DirecTV
and they actually have a private money market fund that they call
Directv Grp Fund?


If not, can you create a new file with NO Passport and set it up for
Fidelity access? That would make sure that the access is OFX style
and not Yodlee.

If there is OFX access, it is possible to turn on logging of
incoming OFX files as *RS.txt. The way to turn on that logging is to
create a registry key. That can be made by creating and running a
4-line file called ProvLog5.reg. Then download.

=====begin:provLog5.reg===============
REGEDIT4

[HKEY_CURRENT_USER\Software\Microsoft\Money\14.0\Online]
"FLogProviderData"=dword:00000001
=====end:provLog5.reg===============

I can see your eyes rolling and hear muttering of "here we go
again".

If you got a resulting file in the same folder in your Money file
after download, you make a copy named *.xml. Then you would look at
that file using IE6.

In the file you might see a string such as
<SECNAME>FIDELITY CONTRAFUND</SECNAME>
but with the actual name of the fund. Now you would know for sure
what is coming in from Fidelity.

In a command window, this could be used to make the copy:
copy "FidelityInvestments 950012345 RS.txt" \temp.xml
WITH the quotes (substituting the actual filename) In the above
case, you could enter "c:\temp.xml" without the quotes into the
address box of IE6.


Or do the copying and renaming in Windows Explorer. IE6 formats the
file nicely-- or at least as nicely as you are going to find.
 
Ad

Advertisements

S

SMERTZ

OK, I see this in the XML file along with many others

</SECID>
<SECNAME>THE DIRECTV GRP FUND</SECNAME>

Is this what you thought it would be?




Cal Learner-- MVP said:
That did not seem to make any difference. I created a new passport with a
different email address and yet another new file. Directv Grp Fund still
came down as a MF!!
That is strange.

OK. Is it possible the account is a 401(K) administered for DirecTV
and they actually have a private money market fund that they call
Directv Grp Fund?


If not, can you create a new file with NO Passport and set it up for
Fidelity access? That would make sure that the access is OFX style
and not Yodlee.

If there is OFX access, it is possible to turn on logging of
incoming OFX files as *RS.txt. The way to turn on that logging is to
create a registry key. That can be made by creating and running a
4-line file called ProvLog5.reg. Then download.

=====begin:provLog5.reg===============
REGEDIT4

[HKEY_CURRENT_USER\Software\Microsoft\Money\14.0\Online]
"FLogProviderData"=dword:00000001
=====end:provLog5.reg===============

I can see your eyes rolling and hear muttering of "here we go
again".

If you got a resulting file in the same folder in your Money file
after download, you make a copy named *.xml. Then you would look at
that file using IE6.

In the file you might see a string such as
<SECNAME>FIDELITY CONTRAFUND</SECNAME>
but with the actual name of the fund. Now you would know for sure
what is coming in from Fidelity.

In a command window, this could be used to make the copy:
copy "FidelityInvestments 950012345 RS.txt" \temp.xml
WITH the quotes (substituting the actual filename) In the above
case, you could enter "c:\temp.xml" without the quotes into the
address box of IE6.


Or do the copying and renaming in Windows Explorer. IE6 formats the
file nicely-- or at least as nicely as you are going to find.
 
C

Cal Learner-- MVP

OK, I see this in the XML file along with many others

</SECID>
<SECNAME>THE DIRECTV GRP FUND</SECNAME>

Is this what you thought it would be?
Whoa... it is what I suspected later. It goes a long way to
explaining things.

Here is an example of a more complete description of a mutual fund
from such a file:

:
:- <MFINFO>
:- <SECINFO>
:- <SECID>
: <UNIQUEID>316071109</UNIQUEID>
: <UNIQUEIDTYPE>CUSIP</UNIQUEIDTYPE>
: </SECID>
: <SECNAME>FIDELITY CONTRAFUND</SECNAME>
: <TICKER>FCNTX</TICKER>
: <UNITPRICE>52.5900000</UNITPRICE>
: <DTASOF>20041002070000.000[-4:EDT]</DTASOF>
:- <CURRENCY>
: <CURRATE>1.000</CURRATE>
: <CURSYM>USD</CURSYM>
: </CURRENCY>
: </SECINFO>
: <MFTYPE>OTHER</MFTYPE>
: <DTYIELDASOF>20041005012230.794[-4:EDT]</DTYIELDASOF>
: </MFINFO>

For a Money Market fund it would have
<UNITPRICE>1.0000000</UNITPRICE>

It would appear that you had such a fund all along and letting Money
generate an AddShares for it would not have been a bad move.

Farther up in the file would be another reference to the <UNIQUEID>
where it had position data for that security. The <UNIQUEID> is the
number that is unique to each fund or stock.

If you post more sections of the file, don't post any
<ACCTID>0000000</ACCTID>
fields. That would be your account ID(s). It is unlikely anybody
could use that info, but there is no point to posting it. Your
password is not in the file.

Fields that start "<DT" are dates in yyyymmdd... format.
 
S

SMERTZ

I can post the entire file after changing the ACCTID if that will help.
What is the field called <TRNUID> for.


Cal Learner-- MVP said:
OK, I see this in the XML file along with many others

</SECID>
<SECNAME>THE DIRECTV GRP FUND</SECNAME>

Is this what you thought it would be?
Whoa... it is what I suspected later. It goes a long way to
explaining things.

Here is an example of a more complete description of a mutual fund
from such a file:

:
:- <MFINFO>
:- <SECINFO>
:- <SECID>
: <UNIQUEID>316071109</UNIQUEID>
: <UNIQUEIDTYPE>CUSIP</UNIQUEIDTYPE>
: </SECID>
: <SECNAME>FIDELITY CONTRAFUND</SECNAME>
: <TICKER>FCNTX</TICKER>
: <UNITPRICE>52.5900000</UNITPRICE>
: <DTASOF>20041002070000.000[-4:EDT]</DTASOF>
:- <CURRENCY>
: <CURRATE>1.000</CURRATE>
: <CURSYM>USD</CURSYM>
: </CURRENCY>
: </SECINFO>
: <MFTYPE>OTHER</MFTYPE>
: <DTYIELDASOF>20041005012230.794[-4:EDT]</DTYIELDASOF>
: </MFINFO>

For a Money Market fund it would have
<UNITPRICE>1.0000000</UNITPRICE>

It would appear that you had such a fund all along and letting Money
generate an AddShares for it would not have been a bad move.

Farther up in the file would be another reference to the <UNIQUEID>
where it had position data for that security. The <UNIQUEID> is the
number that is unique to each fund or stock.

If you post more sections of the file, don't post any
<ACCTID>0000000</ACCTID>
fields. That would be your account ID(s). It is unlikely anybody
could use that info, but there is no point to posting it. Your
password is not in the file.

Fields that start "<DT" are dates in yyyymmdd... format.
 
S

SMERTZ

This may be what you are looking for

"NUMBERS Altered" FITID AND DTTRADE for security

<FITID>20040811OBIB011</FITID>
<DTTRADE>20040811070000.000[-4:EDT]</DTTRADE>
<MEMO>CONTRIBUTION;THE DIRECTV GRP FUND OBIA;as of 09/22/2004</MEMO>
</INVTRAN>
- <SECID>
<UNIQUEID>OBIA</UNIQUEID>
<UNIQUEIDTYPE>CUSIP</UNIQUEIDTYPE>
</SECID>
<UNITS>6.209</UNITS>
<UNITPRICE>10.47593</UNITPRICE>
<TOTAL>-65.04</TOTAL>
<SUBACCTSEC>OTHER</SUBACCTSEC>
<SUBACCTFUND>OTHER</SUBACCTFUND>
</INVBUY>
<BUYTYPE>BUY</BUYTYPE>


SMERTZ said:
I can post the entire file after changing the ACCTID if that will help.
What is the field called <TRNUID> for.


Cal Learner-- MVP said:
OK, I see this in the XML file along with many others

</SECID>
<SECNAME>THE DIRECTV GRP FUND</SECNAME>

Is this what you thought it would be?
Whoa... it is what I suspected later. It goes a long way to
explaining things.

Here is an example of a more complete description of a mutual fund
from such a file:

:
:- <MFINFO>
:- <SECINFO>
:- <SECID>
: <UNIQUEID>316071109</UNIQUEID>
: <UNIQUEIDTYPE>CUSIP</UNIQUEIDTYPE>
: </SECID>
: <SECNAME>FIDELITY CONTRAFUND</SECNAME>
: <TICKER>FCNTX</TICKER>
: <UNITPRICE>52.5900000</UNITPRICE>
: <DTASOF>20041002070000.000[-4:EDT]</DTASOF>
:- <CURRENCY>
: <CURRATE>1.000</CURRATE>
: <CURSYM>USD</CURSYM>
: </CURRENCY>
: </SECINFO>
: <MFTYPE>OTHER</MFTYPE>
: <DTYIELDASOF>20041005012230.794[-4:EDT]</DTYIELDASOF>
: </MFINFO>

For a Money Market fund it would have
<UNITPRICE>1.0000000</UNITPRICE>

It would appear that you had such a fund all along and letting Money
generate an AddShares for it would not have been a bad move.

Farther up in the file would be another reference to the <UNIQUEID>
where it had position data for that security. The <UNIQUEID> is the
number that is unique to each fund or stock.

If you post more sections of the file, don't post any
<ACCTID>0000000</ACCTID>
fields. That would be your account ID(s). It is unlikely anybody
could use that info, but there is no point to posting it. Your
password is not in the file.

Fields that start "<DT" are dates in yyyymmdd... format.
 
C

Cal Learner-- MVP

I can post the entire file after changing the ACCTID if that will help.
What is the field called <TRNUID> for.
I just looked into the spec. It appears to be a number that the
Money request file provides and is passed back in the response. It
doesn't tell me anything useful.


There could be more than one ACCTID if you have more than one
account.

Be aware that fields like :

<BALTYPE>DOLLAR</BALTYPE>
<VALUE>+00000xxxx.xx</VALUE>

provide some info you could x out tho you have already mentioned the
1100 number.


At this point, what I am suspecting is that your money is swept into
a MM fund. That position data is in the file, but Buy and Sell
transactions are not generated. Thus Money offers to do AddShares
and RemoveShares to compensate.

What you and others might do is to let Money generate the AddShares
for a money market and then manually change them into Buy
transactions. Similarly a RemoveShares generated from the position
data could be turned into a Sell transaction. That then would adjust
the Cash Transactions balance.

Alternatively just get into the habit of telling Money to not adjust
the positions.

This is actually making sense to me now, tho it may not be obvious.
Some other threads on Fidelity discuss this, but I was thinking
yours situation was way different.
http://groups.google.com/groups?as_q=fidelity+&num=30&as_scoring=d&hl=en&btnG=Google+Search&as_epq=&as_oq=cash+fcash+money.market&as_eq=&as_ugroup=microsoft.public.*&as_usubject=&as_uauthors=&as_umsgid=&lr=&as_drrb=q&as_qdr=&as_mind=12&as_minm=5&as_miny=1981&as_maxd=19&as_maxm=11&as_maxy=2004&safe=images

So it would be interesting to look at the redacted file.
 
C

Cal Learner-- MVP

This may be what you are looking for

"NUMBERS Altered" FITID AND DTTRADE for security

<FITID>20040811OBIB011</FITID>
<DTTRADE>20040811070000.000[-4:EDT]</DTTRADE>
<MEMO>CONTRIBUTION;THE DIRECTV GRP FUND OBIA;as of 09/22/2004</MEMO>
</INVTRAN>
- <SECID>
<UNIQUEID>OBIA</UNIQUEID>
<UNIQUEIDTYPE>CUSIP</UNIQUEIDTYPE>
</SECID>
<UNITS>6.209</UNITS>
<UNITPRICE>10.47593</UNITPRICE>
<TOTAL>-65.04</TOTAL>
<SUBACCTSEC>OTHER</SUBACCTSEC>
<SUBACCTFUND>OTHER</SUBACCTFUND>
</INVBUY>
<BUYTYPE>BUY</BUYTYPE>
OK. So this is a mutual fund. It is not a public fund, so its CUSIP
is not a real CUSIP, but something internal.

This is a Buy transaction that you have posted here. Somewhere else
in the file is a <INVPOSLIST> ...</INVPOSLIST> which will show how
many <UNITS> (shares) of each investment you have. That is where
Money gets the numbers to compare with what it thinks you have.

Thinking back, I guess I can say that if you are using DTV as a
symbol for that investment in Money, don't. There will be no public
symbol (<TICKER>) available for that investment, so just blank the
symbol for that investment. It is a mutual fund.
 
S

SMERTZ

OK, what do I need to do to turn off the Logging? Find the Reg Key and
change a 1 to a zero or something?

I'm not too comfortable posting any more of the log file as I don't know
what all the crap in there is.

Thanks for the help!! I really appreciate it.
 
Ad

Advertisements

C

Cal Learner-- MVP

OK, what do I need to do to turn off the Logging? Find the Reg Key and
change a 1 to a zero or something?
Exactly. you could change the value in regedit, or you could make
the file described below.


I'm not too comfortable posting any more of the log file as I don't know
what all the crap in there is.

Thanks for the help!! I really appreciate it.
I have learned some stuff in the process. I hope things work well.





=====begin:NoLog5.reg===============
REGEDIT4

[HKEY_CURRENT_USER\Software\Microsoft\Money\14.0\Online]
"FLogProviderData"=dword:00000000
=====end:NoLog5.reg===============
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top