First of all, I would like to sincerely thank Harsha Devulapalli and Sharmi, who have done the fantastic job in coming up with this google sheet.
I have made slight modification and it is working very well. I am facing a challenge with one particular formula in the sheet - relating to CAGR calculation. As per my sheet, CAGR calculation is only throwing up 0% and is not calculating the actual CAGR. I have attached a link to my amended google sheet.
I would highly appreciate, if you can guide me as to what error I am making in the CAGR calculation (Column W) in Holdings sheet.
Thanking in advance.
Google sheet link - my googlesheet link
Regards