Cal Learner- MVP,

Thank you for the suggestions. They seem logical enough that they
just might work. If either of the methods work, I would only need to
manually enter one side of the trade instead of both. This would be a
real time-saver one day when I go nuts day trading :-)

- quote -

In microsoft.public.money, Brucefan wrote:

- quote -

Here are a couple ways I think should work for you:

1. Enter the Buy manually before downloading transactions for that
day. When the downloaded Buy comes in, match it to the existing
entry.

2. If you don't have that Buy entered by the time you download, I
suggest you Void the Sell temporarily. Process the Buy. Then come
back and fix up the voided Sell.

On Mon, 5 Sep 2005 17:31:12 -0700, "William R Wood" <w.wood[at]cox.netwrote:

Bill,

You're so right about MSFT. I used to be a major MSFT supporter also,
but recent issues I've experienced with their software has made me
change my views. I give them credit for some great software like MS
Excel and the OS Windows XP, but I can think of just as many titles
that were dissappointing also. I used to praise the MSFT brand, now I
treat the name as a neutral brand - just another software vendor at
best.

Mike C.

- quote -

Mike,

Glad you figured it out.

I agree that MSFT should fix this issue immediately. If they would stop
wasting time and resources on bloat and advertising and concentrate on
making Money a first class personal finance program all of us would be far
better off. I used to be a major MSFT supporter but the stuff they are
putting out now is shaking my faith and the way they have changed Money for
the worse with silly "features" and advertising plus the automatic cutoff on
auto downloads is going too far. Makes me so mad I am now avoiding MSFT
products whenever possible.

Good trading.

Bill


"Brucefan" <brucefan[at]SwampsOfJersey.com> wrote in message
news:595ph19879u8da41rg5tf5un2vl42c9bup[at]4ax.com...
- quote -

On Mon, 05 Sep 2005 12:46:56 -0500, via_newsgroup[at]please.tnx(Cal
Learner-- MVP) wrote:

Cal Learner- MVP,

Thanks for your suggestions, I was able to find a solution. For the
story, please see my reply to Bill Wood.

Mike C.

Bill,

Cal Learner had mentioned that the direct download from brokers can be
messing things up. However, your test results really prompted me to
do something I thought would be senseless to do. I actually went back
and tried to modify my trade entries (on both buy and sell sides)
manually because I thought maybe I had done something silly, but to no
avail. Then I proceeded to delete both ends of the day trade
completely and entered them back manually. That did the trick!!
Apparently, Money keeps some info downloaded from the broker (which is
invisible to the user) to prevent it from recognizing a buy before a
sell on the same day no matter what you do. By deleting the day
trades completely, I'm able to re-enter them manually to achieve the
desirable result. I'm sure it probably has something to do with the
way my broker reports trades (probably sells are reported before
buys.) Nevertheless, Money should still be able to handle my
situation no matter how trades are being reported by my broker as long
as the trade dates are reported correctly. I hope they can correct
this problem in future updates. Until then, I need to do lots more
work or less day trades :-)

I thank you for your hard work of testing this out for me. I greatly
appreciate it!

Mike C.

On Mon, 5 Sep 2005 11:49:37 -0700, "William R Wood" <w.wood[at]cox.netwrote:

- quote -

Mike,

I just tested 2002 and 2006 and I might be confused but I cannot duplicate
the problem.

As I said before 2002 handles daytrades perfectly. It also handles short
trades perfectly which Quicken would not do.

Just now I entered 4 fake trades of the same stock, 3 buys and one sell.
The first 2 trades I dated 9/3/05 and 9/4/05 using different prices. Then I
entered a third buy on 9/5/05 with another different price, then a sell also
on 9/5/05. When I hit enter to record the sell a box pops up. The box lets
you choose the shares you want to sell. I choose Let Me Specify instead of
FIFO. Click next and a new box pops up listing all of the lots I purchased
including the last purchase the same day, 9/5/05. Then I selected the
9/5/05 lot and those shares were allocated to my sale on 9/5/05. Click
finish and the transaction is properly recorded and Money computes the
correct profit/loss based on the purchase price of the same day buy.

I did the same with Money 2006 on a different computer and it worked the
same way. No problems allocating the same day purchase to the same day sale
and the correct profit was computed.


Do I misunderstand what you are doing?

Regards

Bill Wood



"Brucefan" <brucefan[at]SwampsOfJersey.com> wrote in message
news:dmnoh197k9al1a1ighf7u6ahem17r5p7fe[at]4ax.com...
- quote -

In microsoft.public.money, Brucefan wrote:

- quote -

The problem comes in if you download an OFX file that has both
transactions in the same file. Most brokers do not time stamp the
transactions in the OFX file to a sub-day granularity, altho the
spec allows that to be to the millisecond. If the transactions did
have <DTTRADE> stamped to the second, I don't know if Money would
use that data. Those experiments are a lot of work. I also don't
know if the order that the transactions are placed into the file by
the broker is the order of processing or not. That should be easier
to check, since it does not require the synthesis of a test OFX
file.

I find that in a command window

find "<DTTRADE" "SomeBroker 12345678 RS.txt"

does not have the date/time stamps in chronological order
oldest...newest, as I would have would have anticipated. This find
command is only useful where the OFX file has newline characters.


It would be nice if Money would sift thru the transactions in an OFX
and process the Buy transactions for the same <DTTRADE> before the
Sells.

On Mon, 05 Sep 2005 11:23:36 -0500, via_newsgroup[at]please.tnx(Cal
Learner-- MVP) wrote:

- quote -

regular buys before the sells. How can I expect to find shares to
match if I haven't entered them?? I certainly don't expect Money to
predict the future. I've tried entering the trades manually in
addition to the online download.

- quote -

more of a reason why it should handle day trades.

In microsoft.public.money, Brucefan wrote:

- quote -

Enter your regular Buy before entering your Sell, and you will have
the ability to pick the right lot. I have not experimented to see
if/how the order of the transactions in the same OFX download
matters. If nothing else, you could enter your daytrade Buy
manually.

- quote -

Not at all obvious.

It would not be a logical conclusion even if your premise was true.
Enter your SellShort before your CoverShort.

Jeff,

I've tried that to no avail because what Money does is when you change
something, such as date, amount, # of shares, etc., it forces you to
choose the shares allocation again! Therefore, I can accomplish what
you described exactly. Once I have chosen the shares I wanted by
using a temporary fake date, I would go ahead and complete the
transaction. Everything would be fine for the moment of course. I
would then change the wrong date back to the correct date. That's
when things go awry again :-( It forces me to choose the shares again
as I've changed the details!! I believe I used to use that trick in
the previous versions for years. Annoying, but workable. Now, the so
called extensive error checking proved to be more harmful than good!
Unless there's some kind of override I can choose, I'm SOL. If there
is such an override, please let me know.

Mike C.

On 5 Sep 2005 08:46:19 -0700, "Jeff M" <jamacq[at]gmail.com> wrote:

- quote -

If you're unable to choose the shares you just purchased, a possible
workaround would be to set the date to the next day after the buy, go
through the sell and choose the shares you just purchased. Once the
trade is registered, then go into the register and manually change the
sell date to the correct date.

Hope this helps.

Jeff

Bill,

Thanks very much for confirming my suspicion that Money might not be
able to handle day trades. I do want LIFO in most cases, and I do
have FIFO unchecked. Of course, I can match off any of my available
lots except for ones bought on the same day. I understand that active
traders certainly are in the minority, but it's so easy for them to
allow trades on the same day to be available for sale. Wouldn't that
be the logical thing to do anyway? I guess if Money can't even handle
me selling shares on the same day, obviously, it won't allow short
sales since one would need to sell before one would buy.

Now I might have to check out Quicken, maybe they've changed their
ways since the last time you used it. Again, I don't think I'm
expecting too much from these programs; I just want to be able to sell
the same shares I bought on the same day. It seems to be so trivial
and logical. Does anyone know if the latest Quicken can handle this
simple situation before I go ahead and try?

Mike C.

On Mon, 5 Sep 2005 06:23:01 -0700, "William R Wood" <w.wood[at]cox.netwrote:

- quote -

I traded fulltime (including many daytrades) from 1995 to 2000 and part-time
for a few years thereafter using Money most of that time. I had problems
like yours with Quicken which forced me to switch to Money but Money
versions up to 2002 handled all of my stock, option and bond trades
correctly. There is a setting in Tools/Options to track investments using
FIFO. Do you have this unchecked since you want to track on a LIFO basis?
I stopped "upgrading" at Money 2002 because later versions destroy budget
reports if you are a trader. Transfers from the cash part of investment
accounts to the investment part show up in budget reports as income or
expense. This completely distorts budget reports. So the answer to your
question, could Money developers do something that trivial is, unfortunately
Yes. I don't use 2006 so I can't be sure but you may have the FIFO setting
wrong or there may be a bug.


Regards,

Bill Wood
Fountain Hills, AZ




"Brucefan" <brucefan[at]SwampsOfJersey.com> wrote in message
news:bmmmh1pacgb8uvnnuvrcic6qb84of94knp[at]4ax.com...
- quote -

I'm using Money 2006. I own shares of XYZ at different cost basis
acquired on different dates. At times, I do day trades of XYZ where I
buy and sell the same shares on the same day. For some reason, Money
refuses to allocate the shares I bought on the same day to my sale.
When I sell the shares, it shows me all the shares of XYZ I bought
before (which is fine), but it doesn't list the shares of XYZ I bought
on the same day! The program seems to handle sells before buys on a
given day. I can't believe the Money programmers can possibly
overlook something so trivial. To all the advanced Money users out
there, is there something I can do to match my sale of the shares
bought on the same day?