Re: Totals for a specific commodity

2024-02-25 Thread CDT
Thank you Dan. That worked. On Sunday, February 25, 2024 at 2:22:07 PM UTC-5 dan...@grinta.net wrote: > On 25/02/24 18:58, CDT wrote: > > 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 > >

Re: Totals for a specific commodity

2024-02-25 Thread Daniele Nicolodi
On 25/02/24 18:58, CDT wrote: 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

Re: Totals for a specific commodity

2024-02-25 Thread CDT
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

Re: Totals for a specific commodity

2024-02-25 Thread CDT
Thank you. That worked. 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 > >

Re: Totals for a specific commodity

2024-02-25 Thread Martin Blais
(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 wrote: > I'm

Re: Totals for a specific commodity

2024-02-25 Thread CDT
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

Re: Totals for a specific commodity

2024-02-24 Thread Martin Blais
Just SELECT sum(position) WHERE currency = 'BTC'? On Sat, Feb 24, 2024 at 2:46 PM CDT 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

Totals for a specific commodity

2024-02-24 Thread CDT
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