Based on your financial expertise, provide your response or viewpoint on the given financial question or topic. The response format is open.

How can I calculate a “running” return using XIRR in a spreadsheet?
I could not figure out a good way to make XIRR work since it does not support arrays.  However, I think the following should work for you: Insert a column at D and call it "ratio" (to be used to calculate your answer in column E).  Use the following equation for D3: =1+(C3-B3-C2)/C2 Drag that down to fill in the column. Set E3 to: =(PRODUCT(D$3:D3)-1)*365/(A3-A$2) Drag that down to fill in the column. Column E is now your annual rate of return.