Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #9  
Old 05-25-2008, 12:49 AM
Don
Guest
 
Posts: n/a
Default Re: 2007 Deluxe - Stock transactions (buy and sell same day)

Try changing the sell transaction to "sell short" then delete the "add
shares" transaction. Lastly, change the "buy" transaction to "cover short".

I think this works pretty good, but you may want to check that the reports
give the correct results.

Let us know if this works.

"john" <john[at]discussions.microsoft.com> wrote in message
news:C27CB2D7-9F4A-49B3-8A98-DA9746E0FF9D[at]microsoft.com...
- quote -

> Purchased shares of a stock in the morning and then sold them in the
> afternoon for a tidy profit. That evening I downloaded the transactions
> from
> my broker. Money processed the sell transaction first. Because there was
> not any shares presently in the protfolio, money added the shares and the
> sell transaction. Next it processed the buy transaction. (you have no
> control over how the transactions are processed) If you then review the
> protfolio manager you will show the stock still having the number of
> shares
> purchased. 1) the original shares from the purchase 2) the shares added
> by
> money when processing the sell transaction ) less the the shares for
> selling
> the stock. If you go into the transactions and try to delete the add
> shares
> transactions the system gives anerror message that you must first delete
> the
> sell transactions. If you do this you will have a cost for the stock but
> no
> sell value. Therefore I entered a new transaction to remove shares, This
> makes the current protfolio correct when hiding closed transactions. If
> you
> then look at the stock in the closed portfolio it will show the incorrect
> profit/loss. It shows the proceeds as the profit as if your cost bases is
> zero.
> How do you correctly handle stocks bought and sold in the same day?
> The only way I know is to download transactions from your broker right
> after
> you make the purchase. Then download again after you make the sell. This
> routine is not alway possible as you may not have access to money on your
> computer until the evening.
> Any help will be appreciated.
> --
> john



  #8  
Old 05-21-2008, 04:45 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: 2007 Deluxe - Stock transactions (buy and sell same day)

In microsoft.public.money, Wayne Farmer wrote:

- quote -

> Agreed. Wouldn't you think it's about time? Searching this group for
> "negative shares" shows that the problem has been around since 1998.


Yes. However I could think of things that affect more people in ways
without a workaround as easy.

I think many of those with 2000 literal day trades per year would be
on trader status, which I would not expect Money to support anyway.

But it is still irritating or worse to the person who does same-day
round trips even occasionally. Like so many things, it would seem to
be an easy fix. I feel the programmers would love to fix it.
  #7  
Old 05-21-2008, 04:31 AM
Dick Watson
Guest
 
Posts: n/a
Default Re: 2007 Deluxe - Stock transactions (buy and sell same day)

Yup. I see it sometimes for absolutely no apparent reason and don't even day
trade.

"Wayne Farmer" <usenet[at]endymionsystems.com> wrote in message
news:0d93ba03-908c-4acc-a143-490ca33f8e88[at]34g2000hsh.googlegroups.com...
On May 20, 11:14 pm, Cal Learner-- MVP <via_newsgr...[at]please.tnxwrote:
Agreed. Wouldn't you think it's about time? Searching this group for
"negative shares" shows that the problem has been around since 1998.


  #6  
Old 05-21-2008, 04:27 AM
Wayne Farmer
Guest
 
Posts: n/a
Default Re: 2007 Deluxe - Stock transactions (buy and sell same day)

On May 20, 11:14*pm, Cal Learner-- MVP <via_newsgr...[at]please.tnxwrote:
- quote -

> In microsoft.public.money, Wayne Farmer wrote:
> > Thanks, Cal. *That's still a painful solution for Day Traders who may
> > perform a dozen buys and sells of the same stock in one day; wouldn't
> > they need to manually enter all of the buys first?

> Clearly Money does not serve those daytraders so well in that
> regard.


Agreed. Wouldn't you think it's about time? Searching this group for
"negative shares" shows that the problem has been around since 1998.
  #5  
Old 05-21-2008, 04:14 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: 2007 Deluxe - Stock transactions (buy and sell same day)

In microsoft.public.money, Wayne Farmer wrote:

- quote -

> Thanks, Cal. That's still a painful solution for Day Traders who may
> perform a dozen buys and sells of the same stock in one day; wouldn't
> they need to manually enter all of the buys first?


Clearly Money does not serve those daytraders so well in that
regard.


  #4  
Old 05-21-2008, 03:57 AM
Wayne Farmer
Guest
 
Posts: n/a
Default Re: 2007 Deluxe - Stock transactions (buy and sell same day)

On May 20, 10:47*pm, Cal Learner-- MVP <via_newsgr...[at]please.tnxwrote:
- quote -

> In microsoft.public.money, john wrote:
> > Purchased shares of astockin the morning and then sold them in the
> > afternoon for a tidy profit. *That evening I downloaded thetransactionsfrom
> > my broker. *Money processed the sell transaction first. *Because there was
> > not any shares presently in the protfolio, money added the shares and the
> > sell transaction. *Next it processed the buy transaction. *(you have no
> > control over how thetransactionsare processed) If you then review the
> > protfolio manager you will show thestockstill having the number of shares
> > purchased. *1) the original shares from the purchase 2) the shares added by
> > money when processing the sell transaction ) less the the shares for selling
> > thestock. *If you go into thetransactionsand try to delete the add shares
> > transactionsthe system gives anerror message that you must first delete the
> > selltransactions. *If you do this you will have a cost for thestockbut no
> > sell value. *Therefore I entered a new transaction to remove shares, *This
> > makes the current protfolio correct when hiding closedtransactions. *Ifyou
> > then look at thestockin the closed portfolio it will show the incorrect
> > profit/loss. *It shows the proceeds as the profit as if your cost basesis
> > zero.
> > How do you correctly handle stocks bought and sold in the same day? *

> First enter the Buy manually. During download, match the Buy to the
> then-existing transaction.- Hide quoted text -
> - Show quoted text -


Thanks, Cal. That's still a painful solution for Day Traders who may
perform a dozen buys and sells of the same stock in one day; wouldn't
they need to manually enter all of the buys first?
  #3  
Old 05-21-2008, 03:54 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: 2007 Deluxe - Stock transactions (buy and sell same day)

In microsoft.public.money, Wayne Farmer wrote:

- quote -

> John, thanks for asking this question; I have exactly the same problem
> when asking Money Plus to update its investment account from my
> investment broker, if that day I'd bought and sold shares of some
> stock, and I didn't already have shares of that stock. During the
> update, Money Plus informs me that it's imported a Sell transation
> (before it imports the corresponding Buy transaction) that is trying
> to sell shares that aren't there, and so asks me for permission to add
> a extra "Add Shares" transaction to create them. If I say yes, then
> the update completes, but then the "Add Shares" transactions give me
> too many shares. If I try to delete the "Add Shares" transactions,
> Money Plus won't let me, telling me that the sell transaction would
> make the running share balance negative at some point.


If you already have the AddShares, change that to a Buy. Enter the
Commission, Total and Quantity in that or a similar order. Do not
enter the Price manually. Let Money compute that.

For the future, the workaround is to enter the Buy manually first
and match that on the download.
  #2  
Old 05-21-2008, 03:47 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: 2007 Deluxe - Stock transactions (buy and sell same day)

In microsoft.public.money, john wrote:

- quote -

> Purchased shares of a stock in the morning and then sold them in the
> afternoon for a tidy profit. That evening I downloaded the transactions from
> my broker. Money processed the sell transaction first. Because there was
> not any shares presently in the protfolio, money added the shares and the
> sell transaction. Next it processed the buy transaction. (you have no
> control over how the transactions are processed) If you then review the
> protfolio manager you will show the stock still having the number of shares
> purchased. 1) the original shares from the purchase 2) the shares added by
> money when processing the sell transaction ) less the the shares for selling
> the stock. If you go into the transactions and try to delete the add shares
> transactions the system gives anerror message that you must first delete the
> sell transactions. If you do this you will have a cost for the stock but no
> sell value. Therefore I entered a new transaction to remove shares, This
> makes the current protfolio correct when hiding closed transactions. If you
> then look at the stock in the closed portfolio it will show the incorrect
> profit/loss. It shows the proceeds as the profit as if your cost bases is
> zero.
> How do you correctly handle stocks bought and sold in the same day?


First enter the Buy manually. During download, match the Buy to the
then-existing transaction.
  #1  
Old 05-21-2008, 03:47 AM
Wayne Farmer
Guest
 
Posts: n/a
Default Re: 2007 Deluxe - Stock transactions (buy and sell same day)

On May 20, 5:24*pm, john <j...[at]discussions.microsoft.com> wrote:
- quote -

> Purchased shares of a stock in the morning and then sold them in the
> afternoon for a tidy profit. *That evening I downloaded the transactionsfrom
> my broker. *Money processed the sell transaction first. *Because therewas
> not any shares presently in the protfolio, money added the shares and the
> sell transaction. *Next it processed the buy transaction. *(you have no
> control over how the transactions are processed) If you then review the
> protfolio manager you will show the stock still having the number of shares
> purchased. *1) the original shares from the purchase 2) the shares addedby
> money when processing the sell transaction ) less the the shares for selling
> the stock. *If you go into the transactions and try to delete the add shares
> transactions the system gives anerror message that you must first delete the
> sell transactions. *If you do this you will have a cost for the stock but no
> sell value. *Therefore I entered a new transaction to remove shares, *This
> makes the current protfolio correct when hiding closed transactions. *Ifyou
> then look at the stock in the closed portfolio it will show the incorrect
> profit/loss. *It shows the proceeds as the profit as if your cost bases is
> zero.
> How do you correctly handle stocks bought and sold in the same day? *
> The only way I know is to download transactions from your broker right after
> you make the purchase. *Then download again after you make the sell. *This
> routine is not alway possible as you may not have access to money on your
> computer until the evening.
> Any help will be appreciated.
> --
> john


John, thanks for asking this question; I have exactly the same problem
when asking Money Plus to update its investment account from my
investment broker, if that day I'd bought and sold shares of some
stock, and I didn't already have shares of that stock. During the
update, Money Plus informs me that it's imported a Sell transation
(before it imports the corresponding Buy transaction) that is trying
to sell shares that aren't there, and so asks me for permission to add
a extra "Add Shares" transaction to create them. If I say yes, then
the update completes, but then the "Add Shares" transactions give me
too many shares. If I try to delete the "Add Shares" transactions,
Money Plus won't let me, telling me that the sell transaction would
make the running share balance negative at some point.

The only solution I've found is to change the date on the sell
transactions to be the NEXT DAY, so that they happen in time after the
buys. I can then delete the "Add Shares" transactions to get the
right result.

Here's a crazy idea that might work: Before doing the import,
manually create an "Add Shares" transaction that adds, say, 1,000,000
shares of the stock at $0 price. Do the import, and then add a
corresponding "Remove Shares" transaction to remove them.

A better solution might be for transaction updates to include time as
well as date, so that they download in order, and negative share
balances don't occur.

But I think that would be too difficult a change. Instead, Microsoft
Money needs to be changed to not flag a negative share balance as an
error.
 
Old 05-20-2008, 10:53 PM
Steve
Guest
 
Posts: n/a
Default Re: 2007 Deluxe - Stock transactions (buy and sell same day)

=?Utf-8?B?am9obg==?= <john[at]discussions.microsoft.com> wrote in
news:C27CB2D7-9F4A-49B3-8A98-DA9746E0FF9D[at]microsoft.com:

- quote -

> Purchased shares of a stock in the morning and then sold them in the
> afternoon for a tidy profit. That evening I downloaded the
> transactions from my broker. Money processed the sell transaction
> first. Because there was not any shares presently in the protfolio,
> money added the shares and the sell transaction. Next it processed
> the buy transaction. (you have no control over how the transactions
> are processed) If you then review the protfolio manager you will show
> the stock still having the number of shares purchased. 1) the
> original shares from the purchase 2) the shares added by money when
> processing the sell transaction ) less the the shares for selling the
> stock. If you go into the transactions and try to delete the add
> shares transactions the system gives anerror message that you must
> first delete the sell transactions. If you do this you will have a
> cost for the stock but no sell value. Therefore I entered a new
> transaction to remove shares, This makes the current protfolio
> correct when hiding closed transactions. If you then look at the
> stock in the closed portfolio it will show the incorrect profit/loss.
> It shows the proceeds as the profit as if your cost bases is zero.
> How do you correctly handle stocks bought and sold in the same day?
> The only way I know is to download transactions from your broker
> right after you make the purchase. Then download again after you
> make the sell. This routine is not alway possible as you may not
> have access to money on your computer until the evening.
> Any help will be appreciated.


Best practice is to first enter the transactions manually, later do an
optional download from the Financial Institution (FI), and finally match
the downloaded transactions with the manually-entered data.

My observation is that automatic download of transactions is an add-on
convenience. I've never had a problem when I enter things myself and
match them later with downloaded data. I suspect (personal opinion
alert) that the Money designers think the same way, since in the
beginning there _was_ no automatic download. There's a good possibility
that they don't even have control of the order in which transactions are
processed. I bet it's up to the FI how data is put into the data file.

I only download data as a sanity check to make sure the FI and I agree.
--
Steve B.
New Life Home Improvement
  #-1  
Old 05-20-2008, 10:24 PM
john
Guest
 
Posts: n/a
Default 2007 Deluxe - Stock transactions (buy and sell same day)

Purchased shares of a stock in the morning and then sold them in the
afternoon for a tidy profit. That evening I downloaded the transactions from
my broker. Money processed the sell transaction first. Because there was
not any shares presently in the protfolio, money added the shares and the
sell transaction. Next it processed the buy transaction. (you have no
control over how the transactions are processed) If you then review the
protfolio manager you will show the stock still having the number of shares
purchased. 1) the original shares from the purchase 2) the shares added by
money when processing the sell transaction ) less the the shares for selling
the stock. If you go into the transactions and try to delete the add shares
transactions the system gives anerror message that you must first delete the
sell transactions. If you do this you will have a cost for the stock but no
sell value. Therefore I entered a new transaction to remove shares, This
makes the current protfolio correct when hiding closed transactions. If you
then look at the stock in the closed portfolio it will show the incorrect
profit/loss. It shows the proceeds as the profit as if your cost bases is
zero.

How do you correctly handle stocks bought and sold in the same day?

The only way I know is to download transactions from your broker right after
you make the purchase. Then download again after you make the sell. This
routine is not alway possible as you may not have access to money on your
computer until the evening.

Any help will be appreciated.
--
john
 

Tags
2007, buy, day, deluxe, sell, stock, transactions
Similar Threads
Thread Forum Replies Last Post
matching a stock buy with a sell on the same day
kyh: I am trying out the Money Home and Business and imported my investments from my financial institution. I have one stock that was bought and sold on...
Microsoft Money 6 12-05-2007 04:58 PM
same day buy/sell transactions for ms money 2007
george: Hello, can anyone discuss how to handle this. If I buy and sell a stock the same day, MS Money does not seem to add these transactions according...
Microsoft Money 1 12-17-2006 09:31 PM
Exchange fees when you sell a stock???
johnnyk: I have 2004 deluxe and am trying to enter some sell of stock but MS Money doesn't calculate the exchange fee so the total is never right. And if I...
Microsoft Money 1 01-08-2005 04:35 AM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 02:21 AM.