Re: How to get last day of month in BQL

Hi! I'm trying to get a report of the market value of my assets at the end of each month:     SELECT year, month,     CONVERT(LAST(balance),   'USD', DATE_ADD(DATE(year, month+1, 1), -1)) AS market_value,     CONVERT(COST(LAST(balance)), 'USD', DATE_ADD(DATE(year, month+1, 1), -1))

How to get last day of month in BQL

Hi! I'm trying to get a report of the market value of my assets at the end of each month: SELECT year, month, CONVERT(LAST(balance), 'USD', DATE_ADD(DATE(year, month+1, 1), -1)) AS market_value, CONVERT(COST(LAST(balance)), 'USD', DATE_ADD(DATE(year, month+1, 1), -1)) AS

Re: beancount > prometheus > grafana

Am 12.09.23 um 04:52 schrieb Josh D: Is anyone utilizing a Prometheus exporter to track, store, and graph your financial metrics in Grafana? It would be interesting to (1) store / track them over time, (2) do all sort of maths, like savings rate, runway (how long can you last without income),

Re: Portfolio Returns in Fava (based on beangrow)

Please let me know if I'm making myself clear Thanks Pablo On Sun, Aug 20, 2023 at 11:51 PM Andreas Gerstmayr <mailto:andr...@gerstmayr.me>> wrote: Hi Pablo, Am 19.08.23 um 09:37 schrieb Pablo Osers: > Great news and many thanks! > > Re asking a qu

Re: Portfolio Returns in Fava (based on beangrow)

tolio_returns.html#handling-transactions-using-the-signature> <https://beancount.github.io/docs/calculating_portolio_returns.html#handling-transactions-using-the-signature <https://beancount.github.io/docs/calculating_portolio_returns.html#handling-transactions-using-the-signature>>

Re: Portfolio Returns in Fava (based on beangrow)

turns.html#handling-transactions-using-the-signature <https://beancount.github.io/docs/calculating_portolio_returns.html#handling-transactions-using-the-signature> explains how beangrow is categorizing and handling transactions. Cheers, Andreas > > Stefano

Re: Portfolio Returns in Fava (based on beangrow)

': 'debug', }" to instruct beangrow to write debug files to the debug folder. https://beancount.github.io/docs/calculating_portolio_returns.html#handling-transactions-using-the-signature explains how beangrow is categorizing and handling transactions. Cheers, Andreas Stefano On Sat, Aug

Re: Portfolio Returns in Fava (based on beangrow)

, at 09:07, Andreas Gerstmayr wrote: Hi all, I developed a Fava extension which integrates portfolio reports generated by the excellent beangrow library [1] in Fava: https://github.com/andreasgerstmayr/fava-portfolio-returns <https://github.com/andreasgerstmayr/fava-portfo

Portfolio Returns in Fava (based on beangrow)

Hi all, I developed a Fava extension which integrates portfolio reports generated by the excellent beangrow library [1] in Fava: https://github.com/andreasgerstmayr/fava-portfolio-returns Currently the report is almost identical to the one generated by beangrow, with an additional Profit and

Re: Custom dashboards in Fava

Hi Fin, Am 18.03.23 um 19:05 schrieb fin: Andreas Gerstmayr wrote: Hi, hello, i hope it uses the environment variable BEAN_ROOT if that is defined? The plugin currently doesn't use this environment variable. I looked at the beancount and fava sources, and neither reads or sets

Re: Custom dashboards in Fava

Hi, Am 16.03.23 um 10:07 schrieb Josh D: Looks great! Where should the dashboards.yaml file be saved for the plugin to locate it? by default the plugin looks for a dashboards.yaml file in the same directory where Fava was started, for example if you run "fava personal.beancount", the

Custom dashboards in Fava

Hi everyone, I've written a new Fava extension which may be of interest to some of you interested in additional Fava charts. It allows creating custom dashboards in Fava, combining Beancount queries and Apache ECharts. The dashboards are defined in a `dashboards.yaml` configuration file,

Re: Loss reported as profit

rds. Tono. On 26 Feb 2021, 13:47 +0100, Andreas Gerstmayr , wrote: I also didn't like seeing my net profit as negative (even though it's positive), so I added an option to fava to flip the sign of the Income, Liabilities and Equity accounts: https://github.com/beancount/fava/pull/1214 Keep in m

Re: Loss reported as profit

I also didn't like seeing my net profit as negative (even though it's positive), so I added an option to fava to flip the sign of the Income, Liabilities and Equity accounts: https://github.com/beancount/fava/pull/1214 Keep in mind though that it will only flip the signs in the user interface