[GNC] how to track Futures and Options
Christian Pinedo Zamalloa
chr.pinedo at gmail.com
Sun Dec 16 05:51:23 EST 2018
Thanks Alton for your detailed indications!!
--
Christian
El sáb., 15 dic. 2018 19:07, Alton Brantley <alton.brantley at gmail.com>
escribió:
> I carry options as a stock. Just multiply the contracts by 100 to show
> shares under options.
> Regarding commissions, I have a subaccount under the brokerage account
> labeled “Open Commissions”.
> When I execute an opening transaction, then the commission is debited to
> “Open Commissions”. I think of this as a prepaid expense.
> When I execute a closing transaction, the commission is debited to “Open
> Commissions” also. And here’s the trick.
> When I use the lots function to match the two parts of the transaction, I
> get a realized gain that is then adjusted by
> crediting the two “Open Commissions”.
> (I actually do one additional step, which is to change the above “Open
> Commissions” to “Closed Commissions-CYxx” where xx is the year of the
> realized gain/loss. By doing this, I have an automatic check that I have
> accounted for commissions correctly, as the balance of Closed Commissions
> should always be 0.)
>
> So my accounts look like this:
> Brokerage: AAPL 01/15/2021 230.00 C
>
> Transactions:
> Opening (Sell Call to Open)
> 09/19/2018 SCO AAPL 01/15/2021 230.00 C
> -1200.
> Brokerage:Cash
> 38,379.55
> Brokerage:Open Commissions
> 8.45
> Brokerage:AAPL 01/15/2021 230.00 C -1200. 31.99
> 38,388.00
>
> Closing (Buy Call to Close)
> 11/09/2018 BCC AAPL 01/15/2021 230.00 C
> 0.
> Brokerage:AAPL 01/15/2021 230.00 C 1200. 25.58
> 30,696.00
> Brokerage: Open Commissions
> 12.90
> Brokerage:Cash
> 30,78.90
>
> After matching up lots
> 11/09/2018 Realized Gain AAPL 01/15/2021 230.00 C
> Brokerage:AAPL 01/15/2021 230.00 C
> 7,692.00
> Brokerage:ShtTermCapGain
> 7,670.65
> Brokerage:Open Commissions
> 8.45
> Brokerage:Open Commissions
> 12.90
>
> I then go back to each of the above transactions and change the
> “Brokerage:Open Commissions” to “Brokerage:Closed Commissions-CY18”
> This way, the “Open Commissions” account holds only unclosed transactions,
> and all “Closed Commissions-CYxx” are 0.
>
> (For best results, copy this message into a text file and view with a
> fixed size font so columns match up.)
>
>
>
>
>
>
More information about the gnucash-user
mailing list