In general, beancount documentation is very thorough, this is one of great advantages of the tool, along with functionality
On Tuesday, December 1, 2020 at 12:13:26 PM UTC+1 Chary Chary wrote: > Martin, > > thanks. It helps! > > Regarding documentation, does it make sense to insert in it links to a > relevant parts of the source code (like you pointed me now to). So, whilst > it will probably mot meet google documentation quality requirements, it > will definitely help users. > > Unfortunately google docs, whilst being very good for real time > collaboration, do not have "offline draft version" feature (like wiki), > which makes it difficult to contribute and/or submit pull request. > > > On Tuesday, December 1, 2020 at 5:38:43 AM UTC+1 [email protected] wrote: > >> The query code is not super well documented (nor well tested). It was >> intended originally as a proof of concept and grew to become the main >> interface. >> I'm going to rewrite it completely in v3, with documentation. >> For now you can use the source code: >> >> https://github.com/beancount/beancount/blob/master/beancount/query/query_env.py >> >> >> >> On Mon, Nov 30, 2020 at 7:17 PM Chary Chary <[email protected]> wrote: >> >>> Patrick, >>> >>> I am still puzzled with your example. >>> >>> What is this *only *function, for instance, where is it documented? >>> >>> >>> On Monday, November 30, 2020 at 5:20:23 PM UTC+1 [email protected] >>> wrote: >>> >>>> Hi, >>>> >>>> >>>> this is bean-query, I just limited it to the select part, for your case >>>> it would be something like >>>> >>>> >>>> number(only("CHF", convert(sum(value(position, #"2020-12-31")), "CHF", >>>> #"2020-12-31"))) WHERE account ~'Expenses' >>>> >>>> >>>> Regards, >>>> >>>> Patrick >>>> >>>> >>>> On 30.11.2020 16:02, Chary Chary wrote: >>>> >>>> Patrick, >>>> >>>> thanks for the answer, but I am afraid I do not have enough knowledge >>>> to understand your answer. >>>> >>>> What you shave show is not a bean-query language, this looks time >>>> elements of python code >>>> >>>> Can you in this case give me some broader and complete source of code >>>> and I will try to get my head around >>>> >>>> Regards. >>>> >>>> On Sunday, November 29, 2020 at 4:58:33 PM UTC+1 [email protected] >>>> wrote: >>>> >>>>> Hi, >>>>> >>>>> Do you have different currencies? Here is a (complex) example that I >>>>> run to value and convert with a specific year. >>>>> >>>>> number(only("CHF", convert(sum(value(position, #"2020-12-31")), "CHF", >>>>> #"2020-12-31"))) >>>>> >>>>> Let's deconstruct that from the inner parts >>>>> >>>>> sum(value(position, #"2020-12-31")) >>>>> this sums up the value of a position (using prices from 2020-12-31) >>>>> >>>>> convert(..., "CHF", #"2020-12-31") >>>>> convert everything to CHF with FX as of 2020-12-31 >>>>> >>>>> number(only("CHF", ...)) >>>>> Now take only the CHF out of this (as everything was converted to CHF, >>>>> this is actually only CHF)) and then take the number >>>>> >>>>> >>>>> If you don't have different currencies or prices involved it becomes a >>>>> lot simpler and you can drop those parts. >>>>> >>>>> >>>>> Regards, >>>>> >>>>> Patrick >>>>> >>>>> >>>>> On 29.11.2020 16:50, Chary Chary wrote: >>>>> >>>>> Hi, everybody >>>>> >>>>> is there a way to get a single number report with bean-query >>>>> >>>>> e.g. I want all Expenses for all the period in one number. >>>>> >>>>> The maximum I got so far is listing all expense accounts and their >>>>> balance. To to get a total expenses I would have to dump it all in Excel >>>>> and sum there. >>>>> >>>>> So, I want something like >>>>> >>>>> SUM(COST(position)) WHERE account ~'Expenses' >>>>> >>>>> But this does not work >>>>> >>>>> Regards. >>>>> >>>>> -- >>>>> 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 [email protected]. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/beancount/31497363-986a-4745-a202-526236c532d8n%40googlegroups.com >>>>> >>>>> <https://groups.google.com/d/msgid/beancount/31497363-986a-4745-a202-526236c532d8n%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 [email protected]. >>>> >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/beancount/3ca0d4b1-d0ad-4d8c-be56-01a449ec4c90n%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/beancount/3ca0d4b1-d0ad-4d8c-be56-01a449ec4c90n%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 [email protected]. >>> >> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/beancount/5545ee62-b2fd-4f06-be60-2cd4317fc808n%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/beancount/5545ee62-b2fd-4f06-be60-2cd4317fc808n%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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/7133e2ae-86ac-41a0-8675-0d69dd59f781n%40googlegroups.com.
