Is it fine to combine several small stock purchase transactions in one?

51 views
Skip to first unread message

Bman Q

unread,
Mar 11, 2023, 3:23:53 PM3/11/23
to Beancount
When buying low volume stock often i have to split purchase in many 1-3k buy limit orders (which in turn often getting split in 5+ execution trades, some of the trades can be just 8 stock lol), so basically what for normal stock can be 1 buy transaction i can have 50+ transactions with with purchase price different couple of cents, example:

;; 2023-01-09 * "Buy 100 AAA Inc."
;;   Assets:Investing:InterBr:Cash  -138 USD

;; 2023-01-09 * "Buy 100 AAA Inc."
;;   Assets:Investing:InterBr:Cash  -137 USD

Is it fine to combine them in one? Like this:

2023-01-26 * "Buy AAA Inc; Jan 9 - Jan 11"
  Assets:Investing:InterBr:AAA                                 14,063 AAA {1.39215461 USD}
  Expenses:Investing:InterBr:Fees                               -68.59 USD
  Assets:Investing:InterBr:Cash                             -19,646.46 USD

In filed csv files i have all the 'mini' transactions if i would ever need them, plus i have them in my brokerage. I'd prefer not to have them in beancount cause they obscure big picture (for me it's 1 buy transaction)

Bman Q

unread,
Mar 11, 2023, 3:34:03 PM3/11/23
to Beancount
messed up date and fees sign, meant:

2023-01-11 * "Buy AAA Inc; Jan 9 - Jan 11"
  Assets:Investing:InterBr:AAA                                 14,063 AAA {1.39215461 USD}
  Expenses:Investing:InterBr:Fees                                68.59 USD

  Assets:Investing:InterBr:Cash                             -19,646.46 USD

Daniele Nicolodi

unread,
Mar 12, 2023, 10:16:54 AM3/12/23
to bean...@googlegroups.com
On 11/03/23 21:23, Bman Q wrote:
> When buying low volume stock often i have to split purchase in many 1-3k
> buy limit orders (which in turn often getting split in 5+ execution
> trades, some of the trades can be just 8 stock lol), so basically what
> for normal stock can be 1 buy transaction i can have 50+ transactions
> with with purchase price different couple of cents, example:
>
> ;; 2023-01-09 * "Buy 100 AAA Inc."
> ;;   Assets:Investing:InterBr:Cash  -138 USD
>
> ;; 2023-01-09 * "Buy 100 AAA Inc."
> ;;   Assets:Investing:InterBr:Cash  -137 USD
>
> Is it fine to combine them in one? Like this:
>
> 2023-01-26 * "Buy AAA Inc; Jan 9 - Jan 11"
>   Assets:Investing:InterBr:AAA                                 14,063
> AAA {1.39215461 USD}
>   Expenses:Investing:InterBr:Fees                               -68.59 USD
>   Assets:Investing:InterBr:Cash                             -19,646.46 USD

What do you mean with "fine"? It is fine as long as the aggregated
transactions preserve enough information for your bookkeeping needs.
From a Beancount point of view, there is nothing wrong with that.

Cheers,
Dan

Reply all
Reply to author
Forward
0 new messages