Cal,

- quote -

It seems to be a mixed bag - some of the AddShares entries have memos
with "positions adjusted to match balance", but some have
"Dividends:ExxonMobil..." Hard to tell.

- quote -

This one didn't work - that's what I had tried before, and it wouldn't
let me change from mutual fund to a stock. However, this one....

- quote -

This worked like gangbusters. I guess I just don't have a twisted
enough mind <g> , but it never occurred to me to switch the STOCK to a
mutual fund, since it is, of course, really a stock. And, further,
once I changed it to a mutual fund and combined it with the ESOP, even
after I did a download from Smith Barney (where the stock resides), it
didn't have a problem with it. I guess Money only looks at the symbol,
which was the same as the holdings there, so it didn't even blink.

Now, I do have to be careful with the un-exercised stock options she
has left, as when I looked at the details for that investment in the
Portfolio Manager, the link to XOM got broken, and it wasn't on the
drop down list to be reselected, but resorting to the backup fixed
that.

So, thanks, you actually managed to get something done that I didn't
think was going to be possible.

- quote -

I have a degree in Computer Science and have built my own PCs for
nearly 20 years, so I am well aware of the need for backups and such.
So, to answer your question, I am not at ALL prepared for a hard drive
failure. <g> Given all the digital pictures I have recently
accumulated on my drive, I really need to do that.

Thanks again.

Tim

In microsoft.public.money, ttfitz[at]gmail.com wrote:

- quote -

It may be that only the balance info is downloaded, and that the
AddShares and RemoveShares are generated by Money. You could tell
that by the dates on the transactions being when you processed the
info in Money rather than a fixed time on the calendar.


- quote -

Based on
http://www.microsoft.com/money/bankD...id=7445&type=1, I
expect that it is direct OFX download. That means there could well
be a problem in just changing the security from mutual fund to
stock, and then trying to download later.

If you want to try this, keep an extra backup/copy of your file to
be able to undo the tries. There are at least a couple different
things to consider trying:


1A. In your Money 2007, try changing the "ExxonMobil Company ESOP
Stock" to a stock from mutual fund using the drop-down list in the
investment Details. Then Combine With XOM. Then try your Citistreet
download. If there is no error, that is good. You would be done.
There is a good chance that the download will show an error due to
the type mismatch. In that case, go to the details for XOM and
select ManageCombinedInvestments near the bottom. Tick the
"ExxonMobil Company ESOP Stock" checkbox. Click Remove. All
occurrences of "ExxonMobil Company ESOP Stock" will now appear as
XOM. When you next download from Citistreet, it will treat
"ExxonMobil Company ESOP Stock" as a new investment. If you can set
it up and tell Money it is a stock, then you should be where you
want to be. You would Combine that with XOM. If you can't, which
seems likely, then there it may be time to revert to that
backup/copy you made.

1B. Or continuing from 1A, an alternative may be doable for you.
When you download again, let it re-define "ExxonMobil Company ESOP
Stock" fund. But during the processing, do *not* let Money take the
default of generating an adjustment of AddShares or RemoveShares.
Use the radio button that says you will handle any adjustments on
your own. I hope there are no new AddShares required, but if there
are, you would have to generate them yourself. Change any Buy
transactions from "ExxonMobil Company ESOP Stock" to XOM with the
drop-down list.



2. In #1 I was assuming that XOM is also held in an account where
you do direct download from a broker as you do with Citistreet. If
it is hand-entered, there is another possibility: Change XOM to a
mutual fund. Then you could do the CombineWith. I suspect that it
would have the same problem with the mismatched type during download
to that account if you do that download.

Let us know what you find out. You might want to maintain two
differently-named files concurrently while you are working out the
process. The MRU list at the bottom of the File menu will aid in
switching among most recently used files. If you have Money ask
before backups, it will speed the switch, because you can avoid
unneeded backups.

Speaking of backups, are you prepared for a hard drive failure? :-o


- quote -

Cal,

- quote -

The only transactions it has are "Add shares", "Remove shares", and
"Buy". As the transactions are dividends reinvested, all the share
amounts are fractional. And yeah, since the only transactions now are
quarterly (when dividends are paid), I'd like to keep better track.

- quote -

As far as I can tell, it appears to track the stock price. The latest
transaction, date of 6/11/2007, has a price of $83.651335/share, and
Marketwatch shows XOM opening at $82.68, with a day range of
$82.34-83.85. When I log onto the website tonight, it shows the value
per share at $91.94, which is the closing price Friday for XOM.

- quote -

I'm not sure on the terms used (not certain what "via OFX server"
means), but the accounts are serviced by Citistreet, so they are part
of the automatic online update that I run - in other words, I don't
log onto the website and select some sort of "download file" option
like I have to on some accounts.

- quote -

Oh, yeah, it's hard to complain too much when you're on such a sweet
ride. Frankly, we have too much exposure on this stock, but I'm having
a hard time getting rid of some of it. As my wife says, if you have
too much of one thing, ExxonMobil is a good one to have too much of.

Tim

In microsoft.public.money, ttfitz[at]gmail.com wrote:

- quote -

Do you mean it has transactions such as "L-Term Cap Gains Dist"? If
that is the case it is probable that "ExxonMobil Company ESOP Stock"
is not the same as Exxon Mobile common stock. So your action in that
case would be to leave the symbol blank. Let Money deduce the price
from the latest transaction. I understand that you probably would
like to watch the numbers updated more frequently.

When you do get position and activity info, does it actually specify
a number of shares, and if so does it seem to track the actual
prices of XOM on the particular date? I would suspect there is a
variance.



- quote -

How are you downloading that information? The answer is that if it
is via OFX server, and the OFX file identifies this as a mutual
fund, then you would have to intervene to change things. And it may
not even be appropriate anyway.

I agree that it would be nice if you could combine a mutual fund
with a stock for this kind of thing. Even so, you probably have a
pretty good smile on your face anyway. ;-)

Let me start by saying, I've done searches on this newsgroup, read a
number of folks complaining of the same problem I am running into, and
am completely familiar with the concept of having a single
"investment" in Money, and selecting it in two different accounts. I
just say that because I want folks to read the details carefully for
my problem, instead of giving the stock answer that applies in almost
all of these situations. I'm also aware that the answer to my question
may end up being, "You can't do that", which is fine.

Okay, here's the situation - my wife worked for ExxonMobil, and while
there she received stock options - some of which have been exercised
and the stock kept, as well as having her employer make contributions
of stock to a ESOP in her 401k. The 401k has online updates available
with the online services, but it reports the investment as "ExxonMobil
Company ESOP Stock", rather than just a purchase of XOM. Since I
already have the stock in our portfolio with the symbol XOM, it won't
let me assign that symbol to the ESOP investment. I've also tried
changing the name of the stock to match the reported ESOP, but it
tells me I've already got an investment of that name. I've tried
combining the two, but the ESOP doesn't appear in the list of things
I'm allowed to combined it with (probably because Money thinks the
ESOP is a mutual fund, and it ALSO won't allow me to switch it to a
stock, because there are transactions on it that don't match what
Money thinks constitutes a stock).

All I want to do here is have my automatic updates get the updated
stock price for XOM and assign it to the ESOP, without my having to
manually update the price. Is there any way for this to work?

Thanks in advance for any help.

Tim