{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","XIRR Calculator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Steps to follow for XIRR calculator"]
["Step 1: Save this macro file in a new, separate folder"]
["Step 2:\n\nGo to Console -> Reports -> Tradebook\n\nDownload all 'Tradebooks' from Console across years (starting from first investment) in the same folder. Please ensure to download all trades from current FY, going all the way back to the first purchase. You can keep on changing the 'Date Range'. Ensure 'Equity' is selected under 'Segment'."]
["Step 3:\n\nGo to Console -> Reports -> Downloads -> Dividend Statements\n\nDownload all 'Dividend Statements' from Console across years in the same folder."]
["Step 4: Download 'Holdings' from Zerodha in the same folder, by clicking on 'Download' on the 'Holdings' of Kite page"]
["Step 5: Press 'Calculate XIRR' in XIRR Calculator sheet"]
["Output: XIRR is calculated in cell M3"]
[]
["This calculator accounts for the corporate actions in the following manner:"]
["+ Stock Bonuses: Accounted for"]
["+ Splits: Accounted for"]
["+ Dividends: Accounted for"]
["+ Buybacks: Not accounted directly as these reports are not available in Zerodha. However, you may add these manually at the end after running the model. Insert the following fields:\n    - Date of buyback in column C\n    - Quantity of buyback in column I\n    - Price of buyback in column J\n    - For all buyback rows, insert 'sell' in column G\n    - Drag down formula from column K across all buyback rows"]
["+ Rights issue: Not accounted directly as these reports are not available in Zerodha. However, you may add these manually at the end after running the model. Insert the following fields:\n    - Date of rights issue in column C\n    - Quantity of rights issued in column I\n    - Price of rights issued in column J\n    - For all rights issue rows, insert 'buy' in column G\n    - Drag down formula from column K across all rights issue rows"]
[]
["To Note: Please make sure that the files are on hard disk and not synced to any cloud folder like Sharepoint, Dropbox, etc."]

{"sheet":"XIRR Calculator","index":1,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
["Symbol","ISIN","Trade Date","Exchange","Segment","Series","Trade Type","Auction","Quantity","Price","Cashflow"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"XIRR(K3:K2061, C3:C2061)","v":{"$error":"#NUM!"}}]