Hello, Thanks Andreas, still don't think this is who a whole investment portfolio IRR/Performance should be tracked.
Let's say I want to track the performance of my Interactive Brokers Portfolio [Assets:Investments:IBKR], what I would expect as cash flows/date pairs to be used for IRR calculations are only based on money inflows/outflows of this whole portfolio, not single money [buy/sell] of each commodity within the portfolio. Please let me know if I'm making myself clear Thanks Pablo On Sun, Aug 20, 2023 at 11:51 PM Andreas Gerstmayr <[email protected]> wrote: > Hi Pablo, > > Am 19.08.23 um 09:37 schrieb Pablo Osers: > > Great news and many thanks! > > > > Re asking a question from before, is there a way to create a report > > based on the overall performance of a portfolio, meaning, taking into > > account only incoming/outgoing cashflows for a specific set of accounts, > > instead of getting a per commodity report. > > > > Example: > > > > * Assets:Investments:IBKR > > * Assets:Investments:IBKR:Cash > > * Assets:Investments:IBKR:IWDA > > * Assets:Investments:IBKR:CSPX > > If all your investments have the same cost currency, adding a new group > in your beangrow config should work: > > group { > name: "Entire Portfolio" > investment: "Assets:Investments:IBKR:*" > } > > > Cheers, > Andreas > > > > > > So getting a report of the performance of the > > account Assets:Investments:IBKR, meaning, taking > > deposited/withdrawal cashflows and current value of all its children > > (commodity+cash) accounts > > > > I haven't been able to reproduce such report in beangrow > > > > Many thanks > > Pablo > > > > On Wednesday, August 16, 2023 at 11:38:45 PM UTC+2 [email protected] > > wrote: > > > > Hi Stefano, > > > > Am 16.08.23 um 17:12 schrieb Stefano Mihai Canta: > > > Thank you, Andreas! > > > > > > I am running a small example, how do I get reinvested dividends > > to show > > > up in the charts? If I split up the dividend transaction so that > the > > > dividend amount goes into the cash account first and then from > > the cash > > > account to the commodity, I get the dividend amount to show up in > > the > > > beangrow chart, but not when the dividend is reinvested directly > > into > > > the commodity. > > > > > > 2023-06-23 * "reinvest" "[VTSAX] Vanguard Total Stock Market > > Index Fund" > > > Assets:Investments:Retirement:VTSAX 0.878 VTSAX > > {105.48974943052393 USD} > > > Income:Retirement:Investments:VTSAX:Dividend -92.62 USD > > > > > > vs > > > > > > 2023-06-23 * "reinvest" "[VTSAX] Vanguard Total Stock Market > > Index Fund" > > > Assets:Investments:Retirement:VTSAX 0.878 VTSAX > > {105.48974943052393 USD} > > > Assets:Investments:Retirement:Cash -92.62 USD > > > > > > 2023-06-23 * "reinvest" "[VTSAX] Vanguard Total Stock Market > > Index Fund" > > > Assets:Investments:Retirement:Cash 92.62 USD > > > Income:Retirement:Investments:VTSAX:Dividend -92.62 USD > > > > > > Thoughts? > > > > I think the second way is the correct way. If it is a distributing > ETF, > > the dividends will be paid out to your cash account first, and then > you > > have to create a new transaction to buy more shares. > > > > You can use > > > > 1980-05-12 custom "fava-extension" "fava_portfolio_returns" "{ > > 'beangrow_config': 'beangrow.pbtxt', > > 'beangrow_debug_dir': '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 > < > 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 12, 2023 at 11:07 AM Andreas Gerstmayr > > <[email protected] > > > <mailto:[email protected]>> 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-portfolio-returns> > > > <https://github.com/andreasgerstmayr/fava-portfolio-returns > > <https://github.com/andreasgerstmayr/fava-portfolio-returns>> > > > > > > Currently the report is almost identical to the one generated by > > > beangrow, with an additional Profit and Loss chart (market value - > > > spent > > > amount over time) and some interactivity (mouse tooltips etc.). > > > > > > Ideally I'd like to keep all/most calculations in beangrow, and > put > > > only > > > the report/frontend code in the Fava extension. My goal is to > > > explicitly > > > not reinvent the wheel of computing the portfolio returns :). > > > > > > > > > [1] https://github.com/beancount/beangrow > > <https://github.com/beancount/beangrow> > > > <https://github.com/beancount/beangrow > > <https://github.com/beancount/beangrow>> > > > > > > Cheers, > > > Andreas > > > > > > -- > > > 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] > > > <mailto:beancount%[email protected]>. > > > To view this discussion on the web visit > > > > > > https://groups.google.com/d/msgid/beancount/d43aec17-b973-6a00-8c42-f592afd85f45%40gerstmayr.me > < > https://groups.google.com/d/msgid/beancount/d43aec17-b973-6a00-8c42-f592afd85f45%40gerstmayr.me> > < > https://groups.google.com/d/msgid/beancount/d43aec17-b973-6a00-8c42-f592afd85f45%40gerstmayr.me > < > https://groups.google.com/d/msgid/beancount/d43aec17-b973-6a00-8c42-f592afd85f45%40gerstmayr.me > >>. > > > > > > -- > > > 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] > > > <mailto:[email protected]>. > > > To view this discussion on the web visit > > > > > > https://groups.google.com/d/msgid/beancount/CAMzm8_q3DYvKq%3DXYZyWjf-kwf7%3D58JVnK1%2B%2B_%2B%3DKJFjYjd7qrw%40mail.gmail.com > < > https://groups.google.com/d/msgid/beancount/CAMzm8_q3DYvKq%3DXYZyWjf-kwf7%3D58JVnK1%2B%2B_%2B%3DKJFjYjd7qrw%40mail.gmail.com> > < > https://groups.google.com/d/msgid/beancount/CAMzm8_q3DYvKq%3DXYZyWjf-kwf7%3D58JVnK1%2B%2B_%2B%3DKJFjYjd7qrw%40mail.gmail.com?utm_medium=email&utm_source=footer > < > https://groups.google.com/d/msgid/beancount/CAMzm8_q3DYvKq%3DXYZyWjf-kwf7%3D58JVnK1%2B%2B_%2B%3DKJFjYjd7qrw%40mail.gmail.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] > > <mailto:[email protected]>. > > To view this discussion on the web visit > > > https://groups.google.com/d/msgid/beancount/6bbe4b9f-de5b-4b35-a262-adcb6c0108b7n%40googlegroups.com > < > https://groups.google.com/d/msgid/beancount/6bbe4b9f-de5b-4b35-a262-adcb6c0108b7n%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/CAPi%3D8UgKHBixCB%2BXs3udX5e%3DU9pMAp_S%3Ddh_Z8GcQTcboVr%3D-w%40mail.gmail.com.
