Performance Calculations hampered by "Deposit Account" use

[bentrim71]

Is your feature request related to a problem? Please describe.
Yes - a lot of users have found issues calculating returns and gains.
That problem appears to be directly related to the use of a depost account for cash that accrues separately from the current portfolio holdings.

Describe the solution you'd like
As opposed to a "deposit account," simply map each broker dealer's internal CASH ticker symbol (in the case of Charles Schwab in the United States, $CASH)
Describe alternatives you've considered
this works best

Additional context
I can explain better over email if you like!

Great product

[mierin12]

Could you give an example, the description of the problem is vague.

You can calculate the performance of securities accounts without their deposit accounts.

[bentrim71]

Actually, while you can calculate the performance of the securities account without their deposit accounts, you shouldn’t: When calculating money-weighted returns, the firm must value portfolios at least annually and as of the period end for any period for which performance is calculated. When calculating money-weighted returns, the firm must: a. Calculate annualized since-inception money-weighted returns. b. Calculate money-weighted returns using daily external cash flows. c. Include stock distributions as external cash flows and value stock distributions at the time of distribution. Example – Kommer account. In 2019 EUR 10,000 was deposited on Jan 1 and an additional EUR 500 on April 1. Thus, the performance is actually 14.68% for the year. The Kommer file presents another issue, with the incorrect historical data being pulled from Yahoo Finance. The ISIN IE00B1YZSC51 is for IMEU.AS, the historical quotes are for IQQY.DE which does not reflect dividends. BEB From: mierin12 ***@***.***> Sent: Sunday, October 13, 2024 4:43 AM To: portfolio-performance/portfolio ***@***.***> Cc: Brent Bentrim ***@***.***>; Author ***@***.***> Subject: Re: [portfolio-performance/portfolio] Performance Calculations hampered by "Deposit Account" use (Issue #4280) Could you give an example, the description of the problem is vague. You can calculate the performance of securities accounts without their deposit accounts. — Reply to this email directly, view it on GitHub<#4280 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BMA2QKZHKLNFY55ZR4JW4L3Z3IXCZAVCNFSM6AAAAABPZCT4BSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIMBYHA4DMNZUGY>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>>

[mierin12]

Hello,
How do you get 14.68 % ?
For 2019, in kommer whole portfolio, the IRR that I get from PP is 14.73% (not 14.86% as you mentioned in the other thread, 14.86% is the TWR, not the MWR / IRR).

Excel's XIRR gives 14.7288 so as PP.