Sure, attached is the model. The model accommodates for corporate actions, including dividends, splits, bonuses. However, for buybacks and rights issue, the data needs to be entered manually as these reports are not directly available in Zerodha for extraction. For all the other trades/corporate actions, you would only need to download Zerodha statements and run the model. Please follow the instructions mentioned.
Will be good to know feedback on this.
XIRR Calculator.xlsm (57.8 KB)
Subscribe To Our Free Newsletter |