|
#9
| |||
| |||
| 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
| |||
| |||
| In microsoft.public.money, Wayne Farmer wrote: - quote - > Agreed. Wouldn't you think it's about time? Searching this group for
Yes. However I could think of things that affect more people in ways> "negative shares" shows that the problem has been around since 1998. 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
| |||
| |||
| 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
| |||
| |||
| On May 20, 11:14*pm, Cal Learner-- MVP <via_newsgr...[at]please.tnxwrote: - quote - > In microsoft.public.money, Wayne Farmer wrote:
Agreed. Wouldn't you think it's about time? Searching this group for> > 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. "negative shares" shows that the problem has been around since 1998. |
|
#5
| |||
| |||
| In microsoft.public.money, Wayne Farmer wrote: - quote - > Thanks, Cal. That's still a painful solution for Day Traders who may
Clearly Money does not serve those daytraders so well in that> 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? regard. |
|
#4
| |||
| |||
| On May 20, 10:47*pm, Cal Learner-- MVP <via_newsgr...[at]please.tnxwrote: - quote - > In microsoft.public.money, john wrote:
Thanks, Cal. That's still a painful solution for Day Traders who may> > 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 - 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
| |||
| |||
| In microsoft.public.money, Wayne Farmer wrote: - quote - > John, thanks for asking this question; I have exactly the same problem
If you already have the AddShares, change that to a Buy. Enter the> 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. 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
| |||
| |||
| In microsoft.public.money, john wrote: - quote - > Purchased shares of a stock in the morning and then sold them in the
First enter the Buy manually. During download, match the Buy to 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? then-existing transaction. |
|
#1
| |||
| |||
| 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
John, thanks for asking this question; I have exactly the same problem> 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 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. |
| | |||
| |||
| =?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
Best practice is to first enter the transactions manually, later do an> 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. 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
| |||
| |||
| 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 | |
| |