CM wrote:

- quote -

I agree and assume that the recent "weirdness" that you, Don Awalt, and
others have noted here is just a symptom of the ongoing integration of
TD and Ameritrade.

Patience is usually the best advice in these situations. I've
personally experienced both your and Don's issue. I haven't had the
guts to turn TD Amertriade online services back on since this recent
onset despite Don's apparent success.

Given my current level of activity with TDAmeritrade, its just easier
to forgo the DirectConnect and fall back on manual entry (for now).

Regards,
JB

Following up my own post in response to a related question in this
thread:

C. Mundi wrote:
- quote -

Here we are a few days later. Since deleting and updating as I
described above (which did imply deleting all transactions for MMDA1),
I have added to a couple positions after Monday's pullback and also
made a cash deposit in my account. And tonight I let MS Money 2007 do
an update. Money is once again thoroughly confused about my cash
balance. Although the 'bank balance' in the upper right corner matches
the sum of my sweep account and my (true) cash account, the "cash"
shown in the account summary is completely wrong. Again, it appears
that MMDA1 transactions are being double-counted.

I don't blame Money for this. Ameritrade has the most nonsensical way
of tracking margin + sweep + cash that I've ever seen. Yes, the
three-day settlement time requires some care to interpret balances
correctly, but that does not explain the complete weirdness of what
actually appears in the Ameritrade transaction history. If anyone has
a 'recipie' for unambiguously deducing Ameritrade online account
balances from Ameritrade's online transaction history, I would
appreciate hearing how. My profession requires me to be good with
ledgers, so I don't think I'm being especially dense about this. I'm
willing to learn.

Thanks and Good Luck,
CM

To repeat, and I just confirmed it again, you CAN change the investment
type in Money 2007. Go to the Account Holdings page for Ameritrade,
right click on the Money Market fund in discussion, and pick Investment
Details. I have a drop down box where I can change the Investment type,
it's currently set to "Mutual Fund". Other choices are Bond, Index, and
Stock. It was originally Stock.

Pierre Ateriaus wrote:
- quote -

I would say the real question is why doesn't Money allow the user to change
the investment type. BTW, this problem occurs in Money 2006 so its not new.
I tried creating a new investment and found no option to create as you
mentioned and as you say there's no way to manually create a mutual fund
account either. When you deleted and updated your account, did you loose
all your historical transactions? How was the new MMDA1 investment
classified?
--
Pierre Aterianus

"C. Mundi" <cmundi[at]gmail.com> wrote in message
news:1164557821.011858.121180[at]l39g2000cwd.googlegroups.com...
- quote -

MMA1 was not an investment type, it was the name of the investment.

Cal Learner-- MVP wrote:
- quote -

In microsoft.public.money, Don Awalt wrote:

- quote -

MMA1 is not one of the Microsoft Money investment types.

- quote -

If you ask, they might switch your sweep account to a different fund
that is working fine with Money. This solves your main problem, and
they might be willing to do this non-standard thing keep you happy.


- quote -

This is very interesting, and it makes a lot of sense. When I
right-clicked on MMDA1 and selected "Investment Details," I found that
the "Investment Type" was set to "Stock" for MMDA1 -- just as you
described. But I was prohibited from changing the "Investment Type"
supposedly because I already had downloaded transactions for MMDA1.

So, after doing a backup, I deleted the MMDA1 "security" from the
account summary. Then I did an online update and -- voila! --
everything is right. The $64K question now is, just how badly will
things get messed up after the next transaction involving my sweep
account?

What's really interesting about this is that the number MS Money 2007
has been reporting for my "Bank Balance" at Ameritrade has matched
MMDA1 all along (before and after deleting MMDA1). I have not looked
at the raw transaction file (And I don't know that I could read it if I
did.) but it almost seems like Ameritrade is sending data for all
accounts (issues, Sweep [as an issue] and Cash [as the sum of sweep and
actual cash]) and that MS Money ends up double-counting because it doe
snot realize that Cash already includes Sweep. This is only a theory,
consistent with what I've seen so far.

Also, although Money 2007 would not allow me to change the "Investment
Type" it did show me the four available types: stock, bond, index fund
and mutual fund. There is no "Money Market" option, though I suppose
"Bond" would be the least-bad choice...

It's pretty clear that Ameritrade and MS Money have still not learned
to place nice. This is unfortunate, since it's in everyone's interest
to make this seamless. I'll be keeping my shoebox for now...

Thanks for your help. I hope this gets resolved Real Soon Now.
CM


Don Awalt wrote:
- quote -

Cal Learner-- MVP wrote:

- quote -

Nope. This Ameritrade account predates TD.

If you are using Money 2007 you can check the type of investment MMA1 is
(acronym for my sweep account) - and mine was set to Stock, which is a
mistake. I changed that and transactions worked properly again. They
have also acknowledged a "problem" with this and are working on it.

I ended up manually modifying the transaction to be correct before I
discovered the change above. I did the above because it kept trying to
download a transaction of $.00 every time I tried - very annoying. It
syncs fine when I download transactions now.

C. Mundi wrote:
- quote -

In microsoft.public.money, C. Mundi wrote:

- quote -

Are you an old TD Waterhouse user, or not?

Hi. I've just started using MS Money, version 2007.

Basic function is fine, except for my brokerage account at TD
Ameritrade. The balance is really screwed up -- by over 10% actually.
The fact that my Ameritrade account uses a money market sweep account
(labeled MMDA1) seems to be relevant. MS Money seems to be confused,
using the sweep account both as a separate ticker *and* as a cash
equivalent. Either one is fine, but not both, since Ameritrade
naturally distinguishes between my cash account and my sweep account.

I'm not doing high finance here. I figure a lot of people must have
initial setup problems. Any clues?

Thanks,
CM