Further testing shows that prices are used to determine IRR, so my example
wasn't complete. Thus you don't need to answer my question. Perhaps I had a
problem with price data.
On Wednesday, November 27, 2024 at 9:53:33 PM UTC+1 Eric Morgan wrote:
> This is an attempt at making my original question easier to answer by
> providing a minimal example.
>
> Here is a beancount file with one purchas and sale.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *option "operating_currency" "SEK"2010-01-01 custom "fava-extension"
> "fava_portfolio_returns" "{ 'beangrow_config':
> '/data/beancount/beangrow.pbtxt',}"2010-01-01 open Assets:MIPS
> MIPS2010-01-01 open Assets:Cash:SEK
> SEK2010-01-01 commodity MIPS price: "SEK:yahoo/MIPS.ST
> <http://MIPS.ST>"2022-07-08 * "Purchase MIPS" Assets:MIPS
> 453.0 MIPS @ 464.8 SEK Assets:Cash:SEK
> -210655.0 SEK2022-08-08 * "Sale MIPS" Assets:MIPS
> -453.0 MIPS @ 608.0 SEK Assets:Cash:SEK
> 275325.0 SEK*
> Here is a beangrow config file with one investment and group
>
>
>
>
>
>
>
>
>
> *investments { investment { currency: "MIPS" asset_account:
> "Assets:MIPS" cash_accounts: "Assets:Cash:SEK" }}*
>
>
>
>
>
> *groups { group { name: "stocks.MIPS" investment: "Assets:MIPS"
> currency: "SEK" }}*
>
> Here is the output
>
>
>
>
>
>
>
>
>
> *Investment stocks.MIPSUnits -Cash In
> 210655.0 SEKCash Out 275325.0 SEKMarket Value
> -Returns 64670.0 SEKYield 30.70
> %IRR -100.00 %*
>
> I would expect that since the investment returned 30% in a month, the
> annual IRR should be higher than 30%. Does -100% indicate a bug in beangrow
> or am I thinking incorrectly about this?
> On Sunday, November 3, 2024 at 12:09:23 AM UTC+1 Eric Morgan wrote:
>
>> Here is another attempt at inserting images
>>
>> [image: 20241102_23h47m09s_grim.png]
>>
>> [image: 20241102_23h51m09s_grim.png]
>> On Sunday, November 3, 2024 at 12:07:13 AM UTC+1 Eric Morgan wrote:
>>
>>> I'm using the beangrow plugin for fava. It shows the following numbers.
>>> I've double checked that yield is correct using a different library. But I
>>> don't understand why IRR is -100.00%. My calculations suggest it should
>>> be 285.78%.
>>>
>>> [image: 20241102_23h47m09s_grim.png]
>>>
>>> Here is the same data visualized with the beangrow tool.
>>>
>>> [image: 20241102_23h51m09s_grim.png]
>>>
>>> Here is the beangrow config file
>>>
>>> investments {
>>> investment {
>>> currency: "MIPS"
>>> asset_account: "Assets:MIPS"
>>> cash_accounts: "Assets:Cash:SEK:BankA:AccountA"
>>> cash_accounts: "Assets:Cash:SEK:BankB:AccountB"
>>> }
>>> groups {
>>> group {
>>> name: "stocks.MIPS"
>>> investment: "Assets:MIPS"
>>> currency: "SEK"
>>> }
>>> }
>>>
>>> Here are the entries on that account copied from fava
>>>
>>> 2022-06-22
>>> Open
>>> Assets:MIPS
>>> 2022-06-22
>>> *
>>> Purchase MIPS
>>> si
>>> 108057.6 SEK
>>> 108057.6 SEK
>>> signature:
>>> ASSET_CASH_EXPENSES_INCOME
>>> Assets:MIPS
>>> 224.0 MIPS
>>> 461.7 SEK
>>> Assets:Cash:SEK:BankB:AccountB
>>> -103480.0 SEK
>>> Income:Financial:Rounding:SEK:BankB:AccountB
>>> 0.20 SEK
>>> Expenses:Comissions:SEK:BankB:AccountB
>>> 59.0 SEK
>>> 2022-06-22
>>> *
>>> Purchase MIPS
>>> si
>>> 120600.0 SEK
>>> 228657.6 SEK
>>> signature:
>>> ASSET_CASH_EXPENSES_INCOME
>>> Assets:MIPS
>>> 250.0 MIPS
>>> 458.7 SEK
>>> Assets:Cash:SEK:BankB:AccountB
>>> -114738.0 SEK
>>> Income:Financial:Rounding:SEK:BankB:AccountB
>>> Expenses:Comissions:SEK:BankB:AccountB
>>> 63.0 SEK
>>> 2022-06-22
>>> *
>>> Purchase MIPS
>>> si
>>> 120600.0 SEK
>>> 349257.6 SEK
>>> signature:
>>> ASSET_CASH_EXPENSES_INCOME
>>> Assets:MIPS
>>> 250.0 MIPS
>>> 460.6 SEK
>>> Assets:Cash:SEK:BankB:AccountB
>>> -115213.0 SEK
>>> Income:Financial:Rounding:SEK:BankB:AccountB
>>> Expenses:Comissions:SEK:BankB:AccountB
>>> 63.0 SEK
>>> 2022-06-22
>>> *
>>> Purchase MIPS
>>> si
>>> 117705.6 SEK
>>> 466963.2 SEK
>>> signature:
>>> ASSET_CASH_EXPENSES_INCOME
>>> Assets:MIPS
>>> 244.0 MIPS
>>> 456.1 SEK
>>> Assets:Cash:SEK:BankB:AccountB
>>> -111349.0 SEK
>>> Income:Financial:Rounding:SEK:BankB:AccountB
>>> -0.40 SEK
>>> Expenses:Comissions:SEK:BankB:AccountB
>>> 61.0 SEK
>>> 2022-06-22
>>> *
>>> Purchase MIPS
>>> si
>>> 96480.0 SEK
>>> 563443.2 SEK
>>> signature:
>>> ASSET_CASH_EXPENSES_INCOME
>>> Assets:MIPS
>>> 200.0 MIPS
>>> 457.6 SEK
>>> Assets:Cash:SEK:BankB:AccountB
>>> -91579.0 SEK
>>> Income:Financial:Rounding:SEK:BankB:AccountB
>>> Expenses:Comissions:SEK:BankB:AccountB
>>> 59.0 SEK
>>> 2022-06-22
>>> *
>>> Purchase MIPS
>>> si
>>> 14472.0 SEK
>>> 577915.2 SEK
>>> signature:
>>> ASSET_CASH_EXPENSES_INCOME
>>> Assets:MIPS
>>> 30.0 MIPS
>>> 456.7 SEK
>>> Assets:Cash:SEK:BankB:AccountB
>>> -13760.0 SEK
>>> Income:Financial:Rounding:SEK:BankB:AccountB
>>> Expenses:Comissions:SEK:BankB:AccountB
>>> 59.0 SEK
>>> 2022-07-04
>>> *
>>> Purchase MIPS
>>> si
>>> 134790.0 SEK
>>> 673051.4 SEK
>>> signature:
>>> ASSET_CASH_EXPENSES_INCOME
>>> Assets:MIPS
>>> 300.0 MIPS
>>> 446.1 SEK
>>> Assets:Cash:SEK:BankB:AccountB
>>> -133904.0 SEK
>>> Income:Financial:Rounding:SEK:BankB:AccountB
>>> Expenses:Comissions:SEK:BankB:AccountB
>>> 74.0 SEK
>>> 2022-07-08
>>> *
>>> Purchase MIPS
>>> si
>>> 212728.8 SEK
>>> 916189.6 SEK
>>> signature:
>>> ASSET_CASH_EXPENSES_INCOME
>>> Assets:MIPS
>>> 453.0 MIPS
>>> 464.8 SEK
>>> Assets:Cash:SEK:BankB:AccountB
>>> -210655.0 SEK
>>> Income:Financial:Rounding:SEK:BankB:AccountB
>>> 1.60 SEK
>>> Expenses:Comissions:SEK:BankB:AccountB
>>> 99.0 SEK
>>> 2022-08-08
>>> *
>>> Sale MIPS
>>> si
>>> -277326.6 SEK
>>> 917075.6 SEK
>>> signature:
>>> ASSET_CASH_EXPENSES_INCOME
>>> Assets:MIPS
>>> -453.0 MIPS
>>> 608.0 SEK
>>> Assets:Cash:SEK:BankB:AccountB
>>> 275325.0 SEK
>>> Income:Financial:Rounding:SEK:BankB:AccountB
>>> Expenses:Comissions:SEK:BankB:AccountB
>>> 99.0 SEK
>>> 2022-08-22
>>> *
>>> Sale MIPS
>>> si
>>> -820005.2 SEK
>>> signature:
>>> ASSET_CASH_EXPENSES_INCOME
>>> Assets:MIPS
>>> -1498.0 MIPS
>>> 540.0 SEK
>>> Assets:Cash:SEK:BankA:AccountA
>>> 808721.0 SEK
>>> Income:Financial:Rounding:SEK:BankA:AccountA
>>> Expenses:Comissions:SEK:BankA:AccountA
>>> 199.0 SEK
>>>
>>> The Yield and IRR has been correct for other investments I've looked at
>>> in my data.
>>>
>>> Appreciate any help on this. Thanks!
>>
>>
--
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 beancount+unsubscr...@googlegroups.com.
To view this discussion visit
https://groups.google.com/d/msgid/beancount/183f903d-f646-456a-be4a-3773633a0c14n%40googlegroups.com.
