Hi,
I'm generating an income statement (with only my expenses) like this:
SELECT account, sum(position) FROM OPEN ON 2023-03-01 CLOSE ON 2023-03-30
WHERE account ~ "Expenses" GROUP BY 1 ORDER BY 1
But I have some subdivisions of my accounts that I would like to report one
level up.
For example
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
pur
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:Fees68.59 USD
Assets:Investing:InterBr:Cash
