Ravi Srikant
New Member
Hi
Im looking to calculate the XIRR's for multiple stock purchases (individual and combined). I have a pivot table to which I have connected a Slicer. I want my table on the Analysis sheet M4
9 to be populated with the Invested amount, Current Amount and IRR. Problem is whenever i change the Slicer value the output of the formula changes. I want a data table like feature where I can see the values for each stock individually as well on a combined basis.
Im looking to calculate the XIRR's for multiple stock purchases (individual and combined). I have a pivot table to which I have connected a Slicer. I want my table on the Analysis sheet M4
9 to be populated with the Invested amount, Current Amount and IRR. Problem is whenever i change the Slicer value the output of the formula changes. I want a data table like feature where I can see the values for each stock individually as well on a combined basis.