Offer your insights or judgment on the input financial query or topic using your financial expertise. Reply as normal question answering

How can I calculate a “running” return using XIRR in a spreadsheet?
Set your xirr formula to a very tall column, leaving lots of empty rows for future additions. In column C, instead of hardcoding the value, use a formula that tests if it's the current bottom entry, like this: =IF(ISBLANK(A7),-C6, C6) If the next row has no date entered (yet), then this is the latest value, and make it negative. Now, to digress a bit, there are several ways to measure returns. I feel XIRR is good for individual positions, like holding a stock, maybe buying more via DRIP, etc. For the whole portfolio it stinks. XIRR is greatly affected by timing of cash flows. Steady deposits and no withdrawals dramatically skew the return lower. And the opposite is true for steady withdrawals. I prefer to use TWRR (aka TWIRR). Time Weighted Rate of Return. The word 'time' is confusing, because it's the opposite. TWRR is agnostic to timing of cashflows. I have a sample Excel spreadsheet that you're welcome to steal from: http://moosiefinance.com/static/models/spreadsheets.html (it's the top entry in the list). Some people prefer XIRR. TWRR allows an apples-to-apples comparison with indexes and funds. Imagine twin brothers. They both invest in the exact same ideas, but the amount of cash deployed into these ideas is different, solely because one brother gets his salary bonus annually, in January, and the other brother gets no bonus, but has a higher bi-weekly salary to compensate. With TWRR, their percent returns will be identical. With XIRR they will be very different. TWRR separates out investing acumen from the happenstance timing of when you get your money to deposit, and when you retire, when you choose to take withdrawals. Something to think about, if you like. You might find this website interesting, too: http://www.dailyvest.com/