Debuggability should be improved for sure.
On Wed, Nov 27, 2024, 15:58 Eric Morgan <[email protected]> wrote:
> 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 [email protected].
> To view this discussion visit
> https://groups.google.com/d/msgid/beancount/183f903d-f646-456a-be4a-3773633a0c14n%40googlegroups.com
> <https://groups.google.com/d/msgid/beancount/183f903d-f646-456a-be4a-3773633a0c14n%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 visit
https://groups.google.com/d/msgid/beancount/CAK21%2BhPNfhGow3b2dT%3D9MTEM4qdhSRUBP%2B50zE7R2JbUHGcK4Q%40mail.gmail.com.
