This command gives me a list of the different purchases of that position at
different prices. So if I bought some Filecoin at $5.77 and other at $7.83
(just as an example) it separates each of them out in the output 1.134 FIL
{5.77 USD}, 3.345 FIL {7.83 USD}. Is there a way to get the total number
of shares across all accounts regardless of price (or maybe with an average
price)?
I see where I can get a sum total of the amount I spent on a position by
using SELECT sum(cost(position)) but I don't see anything on getting a
total number of a specific commodity (as a total).
On Sunday, February 25, 2024 at 12:20:45 PM UTC-5 bl...@furius.ca wrote:
> (No need to apologize, there are no dumb questions here - but maybe just
> not much time for detailed answers.)
> Use beanquery:
> https://github.com/beancount/beanquery
>
> https://docs.google.com/document/d/1s0GOZMcrKKCLlP29MD7kHO4L88evrwWdIO0p4EwRBE0/
>
>
> On Sun, Feb 25, 2024 at 12:18 PM CDT <doc...@gmail.com> wrote:
>
>> I'm new to Python, coding and Beancount, so I don't mean to sound like a
>> dunce when I ask - where do I use "SELECT sum(position) WHERE currency =
>> 'BTC'?
>>
>> Is that to be put in a script I create or is that used in Bean-Query or
>> Bean-Report or something else?
>>
>> On Saturday, February 24, 2024 at 3:25:34 PM UTC-5 bl...@furius.ca wrote:
>>
>>> Just SELECT sum(position) WHERE currency = 'BTC'?
>>>
>>> On Sat, Feb 24, 2024 at 2:46 PM CDT <doc...@gmail.com> wrote:
>>>
>>>> I have some commodities (lets just use BTC as an example) spread out
>>>> over many different accounts.
>>>>
>>>> Is there a command to get a grand total on a specific commodity (like
>>>> BTC) regardless of the account hierarchy?
>>>>
>>>> I couldn't find anything on this.
>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Beancount" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to beancount+...@googlegroups.com.
>>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msgid/beancount/9b8133d0-e942-44cd-bc80-db773878aa9en%40googlegroups.com
>>>>
>>>> <https://groups.google.com/d/msgid/beancount/9b8133d0-e942-44cd-bc80-db773878aa9en%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>> --
>> You received this message because you are subscribed to the Google Groups
>> "Beancount" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to beancount+...@googlegroups.com.
>>
> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/beancount/3b6fada2-18e8-45e1-9318-5f665424840bn%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/beancount/3b6fada2-18e8-45e1-9318-5f665424840bn%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>
--
You received this message because you are subscribed to the Google Groups
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/22cb0c16-b8bf-44eb-8a1f-18bc417f8c1cn%40googlegroups.com.
