For the portfolio summary, there is a cash balance beside the current value. Could I confirm if the cash balance is included in the calculation of returns, both XIRR and time-weighted? I’m still trying to understand the cash balance function in stockscafe.
The XIRR value is slightly lower than the % change for ‘P&L + Div + Closed (P&L + Div)’. Is this because XIRR takes into account the transaction fees too?
No, cash balance is not included. If you can see the cash balance, it means that it is included in the computation of Total Capital and Total Portfolio in the Portfolio Summary page.
Personally, I use cash balance to know how much cash I have in each of my trading account. That is how I split my portfolios in StocksCafe. I have “Standard Chartered SGD”, “Standard Chartered USD” and “Standard Chartered HKD” and as dividends are paid out, they are auto-included into Cash Balance and that is how I know how much cash I have without having to login to Standard Character trading account. (If there are too much cash, I am usually tempted to find stocks to buy).
This is a more difficult question to answer. XIRR computes the IRR (Internal rate of return) since inception whereas ‘P&L + Div + Closed (P&L + Div) %’ simply take the current value divide by Max Deployed Cost which does not consider when Max Deployed Cost is achieved. I would choose XIRR anytime
And that was a deliberate choice. Past cash transactions should not be edited often. But of course, if you find a use case where it is important to edit past cash transactions regularly then I should perhaps add that ability.