Version History
Version 2
Initial Release
Version 2.1
Added feature:
1. For adding Demerge (Spin-Off) Transactions.
Version 3
Added feature:
1. Import Data from previous version sheets to this Updated Sheet.
2. Abitility to track ETFs and Mutual Funds.
3. Now Dashboard can show Investments in Stocks, ETFs and Mutual Funds seperatly. 4. Know Standard Deviation at Portfolio Performance Graph.
Tweak:
1. Optimized XIRR and Benchmark Calculations and moved them to Transactions Sheet.
Version 3.1
Added feature:
1. Now filter transactions in Overview sheet using Dates.
Tweak:
1. Sell and Withdraw transactions are now handled using the FIFO method.
Version 3.1.1
Tweak:
1. Updated Scripts
Version 3.2
Added Feature:
1. To view daily, weekly, 1 month, 6 month, 1 year and 5 year portfolio return compared to selected Benchmark
2. To view Live Price, Average Buy Price, Lowest Buy Price and Highest Buy price of an Asset and Asset Types in Overview sheet.
Tweak:
1. Added drop down to view Top 5 and Bottom 5 Stocks, Mutual Funds and ETFs in Dashboard Sheet.
2. Updated Portfolio Performance Chart
3. Added Dividends Income Chart
Fix:
1. Fixed, charges not Including while calculating FIFO
Version 4
Added Feature:
1. Now can filter data based on Sector/Category in Portfolio Sheet.
2. Added a Refresh button in the Overview Sheet that optimizes data in the Transactions Sheet by sorting data chronologically, clearing empty rows between data and recalculate FIFO values.
3. Now Portfolio Sheet can show Trend based on Simple Moving Average.
Tweak:
1. Optimized Formulas.
Fix:
1. Minor Bug Fixes
2. Fixed Errors and updated FIFO Script for more accuracy.
Version 5
Added Feature:
1. Introduced a new Tax sheet for instant STCG and LTCG calculations with a single click.
2. Added the ability to customize tax rates and exemption limits for Stocks, Mutual Funds (Equity, Debt, and ELSS) and ETFs.
3. Can estimate total tax with or without Indexation.
Version 5.1
Added Feature:
1. To view Short Term and Long Term units of an Asset in Overview sheet.
Fix:
1. Errors in Tax script
Version 5.2
Added Feature:
1. Added drop downs in Tax sheet to calculate estimated Taxes for individual Stock, Mutual Funds and ETFs.
Removed:
1. Due to errors removed, Short Term and Long Term units of an Asset in Overview sheet.
Version 6
Added Feature:
1. Added What If feature in the Dashboard sheet, which helps in testing and analyzing how the portfolio would react under different market conditions.
2. Reintroduced Short Term and Long Term units in the Overview sheet (previously formula-based, now script-driven).
3. Added the “Enable Scripts” button in the Disclaimer sheet to enable scripts and add all required triggers with a single click, eliminating the need for manual trigger setup.
Version 6.1
Tweak:
1. In Tax sheet, if Apply Indexation is turned off, instead of value 0 now its shows Cost of Acquisition.
Version 7
Added Feature
1. Can record daily Invested Value, Market Value for every asset in the Portfolio. All this data will be recorded in a new workbook called “Asset History”.
2. Now, Portfolio Performance Graph can show Invested Value along with Market Value.
3. Ability to Import new data without overwriting existing data.
Fix:
1. Fixed errors for SPIN-OFF transactions in FIFO and Tax Script.
Version 8
Added Feature:
1. Ability to change Asset Names in Data Sheets.
2. Added ERASE button to erase all the data in the Portfolio Tracker
Tweak:
2. Instead of fetching the XIRR separately for each asset from the Overview sheet, the script now itself calculates XIRR directly, delivering more faster results.
3. Optimized Formulas.
Version 8.1
Added Feature:
1. Added Portfolio Returns Chart in Dashboard.
2. Now Dashboard can show Portfolio CAGR and Future estimated value.
Fix:
1. Errors in some Scripts.
2. Optimized some Formulas.
If you’re already a supporter and would like to receive the latest updated sheet for free, please contact me through the contact form using the email you used for payment.