In microsoft.public.money, Jonathan Altman wrote:

- quote -

Another test that might be simpler that wading thru OFX files is to
create a new empty test file with File-> New. Name it something like
test1.mny.

Click Decline during the process, and then tell it to skip setup.

Then file-> Import that OFX file, letting Money create a new
Investment account. See what comes in during that process, paying
special attention to whatever is not a known non-MM holding.

PMJI, especially since I have no experience with sweep accounts or even with
downloaded MMF accounts (I manually input all my MMF transactions). BUT I
do get automated downloads from a Dreyfus Bond fund. I have discovered that
when a dividend is declared and reinvested it shows up first as an Add
Shares (and not a Buy or Reinvest Dividend) in my downloaded transactions
just like your problem. However, if I simply don't accept the Add Shares
transaction, but leave it there, after another download a day or two, it
changes to (or rather is replaced by) a Revinvest Dividend transaction which
I then accept. If you have not done so, I would suggest waiting out your
problem for a few days and see what happens.
--
Peace,
BobJ

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:d8ds13l5o3kopm7ejpsqkounhlhu17l27j[at]4ax.com...
- quote -

In microsoft.public.money, Jonathan Altman wrote:

- quote -

miss, since there is no text in that section that would identify the
security; there is the CUSIP and the amount. The amount would vary
depending on when the file was from, but the amount should be fairly
distinctive. Mutual fund balances are usually to three decimal
places, and stocks to zero.

- quote -

No. The closest you can get is using that specially-made OFX file.

- quote -


The MMDA security does not appear anywhere between <POSLIST> and </POSTLIST(actually <POSLIST> and </POSTLIST> don't appear either, what actually shows
up is <INVPOSLIST> and </INVPOSTLIST> , but i assume that's the same).

The only 2 places where the MMDA seems to appear are:
1) <AVAILCASH> 6304.6</AVAILCASH> and
2) as noted above,
<BAL<NAME> MoneyMarketBalance</NAME<DESC> MoneyMarketBalance</DESC<BALTYPE> DOLLAR</BALTYPE<VALUE> 6304.6</VALUE<DTASOF> 20070405120000</DTASOF</BAL
Is there any way to just completely eliminate the old security that Money
was originally associating transactions for MMDA1 with so that when it sees
transactions for MMDA1 now it will let me specify the new money market
security that i created and gave the MMDA1 symbol to?

In microsoft.public.money, Jonathan Altman wrote:

- quote -

search on the number of shares. The position information will be
surrounded by a <POSSTOCK> </POSSTOCK> pair, or a <POSMF> </POSMFpair (or something else). What set of tags is used?


- quote -

In microsoft.public.money, Jonathan Altman wrote:

- quote -

While I agree, the difference is not all that great to me.

- quote -

Thanks. If it helps, I see this being useful to others.

- quote -

That would be done individually in the register entry.

- quote -

Submitted "other" for "real". I think the difference has to do with
how they enter the data into the OFX, and I think that is close to
your statement. Money follows the OFX.

- quote -

Got it. I think i'd prefer not to do this - showing the buys/sells is more
accurate. I'll try what you suggest below...although we're getting pretty
technical here...is there no way to just permanently remove the old stock
altogether and permanently, rather than try to trick Money into "forgetting"
it?

Also, in light of the process you describe, will i be able to change the
AddShares to a Buy? Because even if I get the transaction to correctly
associate itself with the new MMDA security, i want it to Buy, not Add so
that my cash balance is accurate.

- quote -

Worth noting here, for Ameritrade users, that I'm pretty sure the MMDA is in
fact a "real" MMF. Why they choose to call it an MMDA i have no idea, but i
think this issue has to do with how the security is being treated by Money
rather than how it is treated by the financial community (SIPC, FDIC, etc.)

In microsoft.public.money, Jonathan Altman wrote:

- quote -

Sorry about the magnitude of it all.

- quote -

The method 2 is to not have any transactions for the MMF in the
register. Just let the cash balance represent the swept funds.


- quote -

Ideally you would get that other real MMF. I don't know how
important you are to TDA, but you might be surprised.

OK. Here is the method that I *hope* will make any AddShares be for
an MMF. It is still going to be less than ideal I think. Make sure
of your backup situation, in case you want to undo something.

The plan is that you make Money associate that "stock" with
something else with a different (fake) CUSIP. Then when Money want
to add shares of something next it will not remember what the CUSIP
was associated with. It will ask if that something is already in
your file under a different name. You will then say it is really the
MMF that you have created. Based on what you have posted regarding
your OFX file, there is nothing observed to tie the position to a
stock rather than an MMF.


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.

Feel free to suggest improvements to this procedure.


========================Begin dis_sk.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> 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> ZzzzA
</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 -


Can you remind me how to do the other kind of sweep (we've exchanged enough
messages here that i'm no longer sure). To answer your questions:
-If i were to accept the add shares transaction that Money wants to create,
i would effectively be double-counting since i would have both teh cash
balance and the add shares, but no purchase of MMDA shares (and hence no
reduction in cash balance). I avoided this by voiding the add shares
transaction before it ever got entered and then setting up a purchase
transaction. But I'd like to avoid having to do this every time there's a
cash deposit followed by an MMDA sweep. Ideally I'd just like Money to
recognize the add shares as a purchase instead of an add shares. Anything i
can pull from the OFX to provide you information on how to change this?
-I did confirm that Money thinks the security it is working with here is a
stock by looking at the details. I don't know how or why it did this, but as
i said before, it seems to have resurrected the security that i deleted (it
didn't ask me to define the security that it wanted to add shares of, even
though in theory that security no longer exists in money and its ticker has
been assigned to the new security i created).

- quote -

I'll look at this and set it up if there are particular things you'd like me
ot pull from the OFX log.

In microsoft.public.money, Jonathan Altman wrote:

- quote -

If you were to always select to not have Money adjust your positions
during download processing, I think you could use what I described
as method 2: swept funds are just implied by the cash balance in the
cash transactions register. You would do that continually. If you
ever forgot, then you could just delete/void any AddShares or
RemoveShares that are generated. With the AddShares in place, is
Money double-counting the value of your cash holdings somehow?

There is a way that I think should disassociate that position data
from old. The hope would be then that the AddShares and RemoveShares
generated were at least for a proper MMF type. Can you confirm that
Money thinks this is a stock by right-clicking one of those
AddShares and looking at the details?

The need would become moot if you were switched to the other type of
sweep. Even then, it would be nice to continue to define the
solution for the almost-a-MMF sweep.

- quote -

To collect a log of the OFX download continually, see
http://support.microsoft.com/kb/911941/en-us. Use the method where
you use the Provlogs.reg file.

<snip

"Cal Learner-- MVP" wrote:

- quote -

Unfortunately this didn't work as planned. I've now had a new MMDA
transaction download and somehow what occurred is that rather than
identifying the MMDA security that i created, Money somehow resurrected the
old MMDA security that i had deleted. Furthermore, rather than treating the
purchase of the MMDA (as a result of sweeping some dividend income) as a
"buy", Money treated it as an "add shares." So two problems here: i) Money is
adding, not buying and ii) it's adding shares of the old (i thought no longer
existant) security which is a stock, not a money market fund. Please let me
know how to fix this as it's going to be a major annoyance for all future
Ameritrade MMDA transactions (which happen a lot as a result of dividend
sweeping).

- quote -

I'm not sure i understand how to do this. I created the logs that i was
working with before by holding control-shift during an update process.

- quote -

the computer i use for microsoft money is different from the one i have at my
office, so i'll have to go through this process over the weekend. i'll post
something once i've had a chance to go through the steps you've outlined.

In microsoft.public.money, Jonathan Altman wrote:

- quote -

The former. I meant that I am not currently in the same boat. I have
experience with very similar things, but I am not using that sweep
at TDA, so I am not currently dealing with that particular problem.
So I am not in the position of successfully or unsuccessfully
dealing with that same issue.

- quote -

OK. That's clear. It's a good paradigm to include the BUYs and
SELLs. The biggest downside that I see of having that fund as a
stock would largely be a whole lot of bogus schedule D entries. You
could minimize the other downsides by manually setting the price to
$1 if it was not already that way.

See below.

- quote -

What I would like to see is how that fund is currently described in
the OFX download. If it is describe as a stock, and if the
transactions are represented as <BUYSTOCK> and <SELLSTOCK> rather
than <BUYSMF> and <SELLMF> , it may not be possible to simply change
that over. There still could be a happy outcome, but let's check the
details.

To collect a log of the OFX download, see
http://support.microsoft.com/kb/911941/en-us. With Money 2004, I
think you can use the method described at the top as well as the
simpler method shown for Money 2001 and earlier at the bottom.

Then edit that log file with a text editor such as Notepad.

Find the description of the security in question near the bottom of
the file.


Here are two examples:
================A MoneyFund=================================
<MFINFO<SECINFO<SECID<UNIQUEID> 941550105
<UNIQUEIDTYPE> CUSIP
</SECID<SECNAME> (CMFMZ) TDAM MONEY MARKET PORTFOLIO (SWEEP)
<TICKER> CMFMZ
</SECINFO</MFINFO=====================A Stock==================================
<STOCKINFO<SECINFO<SECID<UNIQUEID> 594918104
<UNIQUEIDTYPE> CUSIP
</SECID<SECNAME> MICROSOFT CORP
<TICKER> MSFT
</SECINFO</STOCKINFO
================================================== =============

Figure out whether that security is currently downloaded as a stock
or as a fund. "MF" does double duty, and applies to Money Funds and
Mutual Funds.
Note that if you had transactions of the first example, each
transaction would contain this line:
<UNIQUEID> 941550105

It is the UNIQUEID that ties together the transactions with the
descriptions.

Based on what you are seeing, we can discuss a potential solution.


- quote -

I don't understand what you mean when you say you're not dealing with that.
Are you saying you don't encounter the same issue or you're no longer
attempting at address this issue by posting responses? I only referenced the
prior conversation because it is an issue that every Ameritrade user has
encountered if they had an account prior to last September and kept it open
once Ameritrade put a money market account in place. I'd certainly appreciate
any help you can provide in sorting this out as it would make my account
tracking in Money much more user-friendly and accurate. Please let me know
how i can help in describing the problem and working towards a solution.
Apologies if the description below is overly basic or in any way unclear, i'm
just trying to be as accurate and detailed as possible. Happy to clarify as
necessary.

What happens, mechanically, is that every time there is a deposit to cash
(dividend, etc.) there is a transaction downloaded which increases the cash
balance. There is then a second transaction showing a purchase of the MMDA
security (money market fund, sweep account, whatever we want to call it)
which obviously reduces the cash balance by the same amount. Per your earlier
responses to this message string, ideally i'd like to code the money market
account as a money market account, instead of a stock (which is what it is
currently set to be - this was the default and i didn't catch it beforehand).
I'm running into two problems there, though:

1) I can't change the type of security once it's set. I'd be happy to delete
the MMDA investment and manually recreate all of the relevant transactions,
but before i do that, i want to understand how to deal with the following:
2) I have a long series of cash transactions in this account prior to the
date when Ameritrade instituted a money market sweep account. Given this I'm
not sure how to avoid confusion between the true cash account and the sweep
account.

Finally, since any future downloads are likely to consist of this
multiple-transaction structure (dividend deposited to cash, cash used to buy
money market security), how do i ensure that whatever i set up with work
appropriately with these downloads.

Thanks

In microsoft.public.money, Jonathan Altman <Jonathan
Altman[at]discussions.microsoft.com> wrote:

- quote -

I am not dealing with that, but I am wondering what the current
situation is.

What do you download today from TD Ameritrade regarding your sweep
account? Are there transactions downloaded each time you have a
dividend etc? Or is there some kind of monthly transaction
downloaded? What kind of transactions?

I'm several months behind here. I also have Ameritrade and money 2004 and
have been wrestling with the same issue on the MMDA/MMF (they're the same
thing, it's just semantics). When i initially downloaded the MMDA
transactions, Money treated the MMDA as a stock. I can't seem to change the
investment type to money market, so i'm not sure how to fix this. Gregg (or
others), i'm curious how you handled this, especially since i have a lot of
cash transactions that predate the creation of the MMDA account. What's the
best solution?

"GreggC" wrote:

- quote -

Thanks Chris, you're reply makes a lot of sense, I think I'll take your
advise and leave the switch to an MMDA as a cash account

"Chris Cowles" wrote:

- quote -

Regardless of all the banter about what a MMDA is and if/how it differs
from a MMF, I'd just ignore the transactions. In Money, just leave the
cash/mmf/mmda balance in the Cash account. When/if you get earnings from
the cash/mmda/mmf account, they'll just get deposited.

If you choose not to ignore the sweep transactions, every time you make a
transaction in the account, you'll have to buy or sell the cash/mmda/mmf
holdings first, then use the proceeds for the transaction that instigated
the trade.

If you ignore the sweep transactions, earnings
(dividends/interest/whatever) will deposit into your Cash account in Money.
You'll show the total income in your portfolio views, but not as a rate of
return. I do that for my Fidelity accounts. Dividends on FDRXX are
deposited, but buys and sells are not. (That's how Fidelity transaction
downloads work, as well.)

If you're not so obsessed with whether your 'cash' is actually in cash or
the funds you describe, it works fine. If you really want Money to show the
balance in MMDA shares vs cash, you have to do a lot of work. To me,
there's little value in doing so.
--
Chris Cowles
Gainesville, FL


"GreggC" <GreggC[at]discussions.microsoft.com> wrote in message
news:0D28E613-56CA-45A2-BE69-DE0BF288463E[at]microsoft.com...
- quote -

In microsoft.public.money, GreggC wrote:

- quote -

http://www.investorwords.com/5665/mo...t_account.html
has a definition also.

Good luck.


- quote -

As per TD Ameritrade:

What is a Money Market Deposit Account (MMDA)?

A Money Market Deposit Account (MMDA) is a cash sweep vehicle that earns
equal or greater interest on cash balances than it otherwise would in a
brokerage account when the money is not currently invested in securities.
Learn more about interest rates for Money Market Deposit Accounts.

If you have an MMDA, the available cash balance in your brokerage account is
automatically moved, or swept, into this account each day where it earns
interest at an equal or higher rate than it would in a TD AMERITRADE
brokerage account. The cash is automatically moved back into your brokerage
account when you place an order or request a withdrawal.

Balance information for an MMDA will appear in the Balance and Positions
area of the Web site. It will also appear on your monthly statement under the
heading Money Market Deposit Account Activity.

Balances in a Money Market Deposit Account is held at TD Bank USA, N.A., an
affiliate of TD AMERITRADE, where it is protected by The Federal Deposit
Insurance Corporation(FDIC) for up to $100,000 in non-retirement accounts and
up to $250,000 for IRAs and certain other retirement accounts.*

The FDIC insures money based on the account owner, not the individual
account. This means that if you have more than one account at TD Bank
(including certificates of deposit) the FDIC covers the combined value of
these accounts. If you hold an MMDA, please make sure you know the extent of
your FDIC coverage and that you monitor your entire deposit at TD Bank,
including the money held in the MMDA, to make sure it does not exceed that
limit.

Cash held in an MMDA is part of your buying power, which means you can use
it any time to place an order for a security you intend to hold overnight.
However, the balance in an MMDA is not included in day trade buying power,
which means it can't be used to purchase securities you intend to sell that
same day. If your account gets flagged as a pattern day trader, cash you hold
in an MMDA will be automatically moved into TD AMERITRADE Cash. Learn more
about how pattern day trader accounts are flagged.

The Federal Deposit Insurance Corporation (FDIC) insures



"Cal Learner-- MVP" wrote:

- quote -