Hi,
Attaching the sheet developed using various sources including posts after going through excel forum.
However, in the attached sheet, I would require the number of days a scrip is held before selling it off and the XIRR for the scrip. Highlighted in yellow in excel
Alternate suggestions to arrive at the value are welcome!
Thanks
Capital gains UDC.xlsm