Re: [GNC] Need better documentation - and maybe more robust functionality - on using Lots
I think many users want the software to do all that thinking for them so they don't have to think about short term vs long term, lots, etc. GnuCash isn't at that level. Developers that want to add that capability would be welcomed to join the ranks. David Carlson On Mon, Jun 24, 2019, 9:25 AM Alton Brantley wrote: > If you’re a day-trader, I can sympathize, put you would probably find the > same issues with other personal accounting programs. > > I use Gnucash to manage 7 different investment portfolios, including > trading options, and I track commission fees, reconcile the lots, adjust > for partial lot sales, and reconcile to the penny with my brokerage > statement every month. > > When opening a transaction for stocks, enter the shares and stock price; > for options, enter contractsx100 and option price. > Create a subaccount for commissions under each brokerage account. I > consider it a prepaid expense (to be realized when I close the transaction. > I call it “Commissions-open.” > > When closing a transaction, do the same. > > On opening a lot, Go to Action->View Lots, Use “New Lot” button to create > new lot, and move the open transaction into it with the double arrows, and > “Close” button. > On closing, select the appropriate lot, and do the same. > > You’ll get a “Realized Gain/Loss” transaction in your stock account. That > will be the “gross gain/loss” based on shares/contracts and prices. > You need to add a split to subtract the “Commissions-open” charges from > the realized gain/loss to get your net realized gain/loss. (Note: easy > check—rename splits for “Commissions-open” in the transactions to > “Commissions-closed”. Commissions-closed should ALWAYS total 0. > Commission-open should always hold unclosed positions.” > > Once I close out an active security, I move it to a subaccount > (Positions-Closed placeholder) under brokerage account. > > For partial position closings, apportion the initial commission by > replacing the commission split with two apportioned splits. > > > > > I luv GnuCash, but not for investments, certainly not for stock trading. > Lot > > selection, forget about it... clearly none of that was a priority for the > > developers and I have zero expectation that will change. Use another > program > > for recording and maintaining bookkeeping for those investments. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Need better documentation - and maybe more robust functionality - on using Lots
If you’re a day-trader, I can sympathize, put you would probably find the same issues with other personal accounting programs. I use Gnucash to manage 7 different investment portfolios, including trading options, and I track commission fees, reconcile the lots, adjust for partial lot sales, and reconcile to the penny with my brokerage statement every month. When opening a transaction for stocks, enter the shares and stock price; for options, enter contractsx100 and option price. Create a subaccount for commissions under each brokerage account. I consider it a prepaid expense (to be realized when I close the transaction. I call it “Commissions-open.” When closing a transaction, do the same. On opening a lot, Go to Action->View Lots, Use “New Lot” button to create new lot, and move the open transaction into it with the double arrows, and “Close” button. On closing, select the appropriate lot, and do the same. You’ll get a “Realized Gain/Loss” transaction in your stock account. That will be the “gross gain/loss” based on shares/contracts and prices. You need to add a split to subtract the “Commissions-open” charges from the realized gain/loss to get your net realized gain/loss. (Note: easy check—rename splits for “Commissions-open” in the transactions to “Commissions-closed”. Commissions-closed should ALWAYS total 0. Commission-open should always hold unclosed positions.” Once I close out an active security, I move it to a subaccount (Positions-Closed placeholder) under brokerage account. For partial position closings, apportion the initial commission by replacing the commission split with two apportioned splits. > I luv GnuCash, but not for investments, certainly not for stock trading. Lot > selection, forget about it... clearly none of that was a priority for the > developers and I have zero expectation that will change. Use another program > for recording and maintaining bookkeeping for those investments. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Need better documentation - and maybe more robust functionality - on using Lots
I luv GnuCash, but not for investments, certainly not for stock trading. Lot selection, forget about it... clearly none of that was a priority for the developers and I have zero expectation that will change. Use another program for recording and maintaining bookkeeping for those investments. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Need better documentation - and maybe more robust functionality - on using Lots
The other problem, which I didn't pursue enough to figure out if it really is a problem, has to do with the company's two-for-1 stock split in the middle of all this. Most of the shares being sold were purchased before the split; others came after the split. As far as I can tell, the "View Lots" module can't adjust for splits. Right now, I have 26 of the 27 lots adding up to 149.813 shares, almost all of which represent one-half of the shares actually sold, because of the 2:1 split. I have found that imported splits from quicken do not work correctly in Lots. What I had to do was re-enter the split in GnuCash from Actions- Stock Splits. After re-entering the split, I would then delete the old split. Once that was completed, Lots handled the gains/loss correctly. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.