There are couple of issues. In particular, one needs to - duplicate the desired transaction-specific data for each row (perhaps that's okay) - if the balance is to be rendered, if this balance contains multiple currencies, somehow replicate the row data for each of these - if you want to calculate anything, you'll have to aggregate by currency - convert to cost or market value if necessary. So there's no straightforward general answer... depends what you're trying to do.
However, a basic table report can be produced with something like this: bean-query $L 'select date, flag, maxwidth(description, 64), account, number, currency' In order to export, this would be great: bean-query -f csv $L 'select date, flag, maxwidth(description, 64), account, number, currency' But I haven't implemented shell output to CSV yet. On Sun, Aug 14, 2016 at 12:02 AM, Alex Johnstone <[email protected]> wrote: > Ah yes, now that I think about it, it's not as straight forward as I > originally (didn't) think. > > My intent was to get some of the data into a spreadsheet to do some > forecasting, when a foreign account is likely to get low so I can start > preparing a transfer. Plus general trending and charting of various > categories to see what's been happening over time. > > I feel like I may need to write a script to output data from beancount > when it meets certain criteria for what I'm looking for. > > -- > 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 post to this group, send email to [email protected]. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/beancount/60512c29-710e-4b55-9b47-c6ff44e9db1e%40googlegroups.com > <https://groups.google.com/d/msgid/beancount/60512c29-710e-4b55-9b47-c6ff44e9db1e%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- 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 post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhNaUMSF9asDnprQfZmEKdsUremTyMX7vBwTDDFkTr1SAQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
