Spreadsheet: 885235d1734678531-error-in-weighted-average-formula-book1-wavg-error
Sheet: Fair Value

Date | FY | Shares | Buy | Sell | Rate | [NAME]. | Net Qty. | Amt | Differential cost | [NAME] | [NAME] | [NAME] | Buy Seq | [NAME] | Dividend | Capital Gain | Bal. Stock | Stamp Duty | POH (years) | Type of Schemes  (tax purpose) | [NAME] | LTCG/STCG |  | Total Cost
2020-04-01 00:00:00 |  | HL | 43533.748 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2020-04-06 00:00:00 |  | HL |  | 25572.627 | 3910.4312 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2020-04-07 00:00:00 |  | HL |  |  | 3910.3839 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2020-05-17 00:00:00 |  | HL |  |  | 3933.2799 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2020-05-27 00:00:00 |  | HL |  |  | 3938.4833 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2020-06-11 00:00:00 |  | HL |  |  | 3943.1717 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2020-06-28 00:00:00 |  | HL |  |  | 3950.4883 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2020-07-08 00:00:00 |  | HL | 21495.49247586005 |  | 3954.1197
2020-07-29 00:00:00 |  | HL |  |  | 3961.2371 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2020-08-18 00:00:00 |  | HL |  |  | 3968.8724 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2020-08-26 00:00:00 |  | HL |  |  | 3971.3655 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2020-09-13 00:00:00 |  | HL |  |  | 3977.1371 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2020-09-28 00:00:00 |  | HL |  |  | 3982.3645 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2020-10-08 00:00:00 |  | HL | 25084.179 |  | 3986.3773
2020-10-08 00:00:00 |  | HL | 28846.805 |  | 3986.3773
2020-11-01 00:00:00 |  | HL |  |  | 3995.0218 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2020-11-19 00:00:00 |  | HL |  |  | 4001.2239 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2020-11-25 00:00:00 |  | HL |  |  | 4003.6149 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2020-12-10 00:00:00 |  | HL |  |  | 4007.5944 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2021-01-12 00:00:00 |  | HUST | 5793335.656 |  | 11.8406 |  |  |  |  |  |  |  |  |  |  |  |  | 3429.83
2021-01-27 00:00:00 |  | HL |  |  | 4022.7159 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2021-02-16 00:00:00 |  | HL |  |  | 4030.0608 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2021-03-24 00:00:00 |  | HL |  |  | 4042.5932 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2021-04-07 00:00:00 |  | HMM | 33494.587 |  | 4478.1117 |  |  |  |  |  |  |  |  |  |  |  |  | 7497.63 |  |  |  |  |  |  |  | Gain on Mf | 1461.812555719167
2021-04-07 00:00:00 |  | HF | 1303657.99 |  | 38.3517 |  |  |  |  |  |  |  |  |  |  |  |  | 2499.88
2021-04-07 00:00:00 |  | HL | 47304.818 |  | 4048.011
2021-04-07 00:00:00 |  | HUST | 7531004.203 |  | 11.95 |  |  |  |  |  |  |  |  |  |  |  |  | 4499.78
2021-04-15 00:00:00 |  | HL |  |  | 4050.613 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2021-05-18 00:00:00 |  | HL |  |  | 4061.9708 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2021-05-31 00:00:00 |  | HL |  |  | 4066.7096 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2021-06-21 00:00:00 |  | HL |  |  | 4074.4043 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2021-06-28 00:00:00 |  | HL |  |  | 4077.1661 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2021-08-12 00:00:00 |  | HL |  |  | 4094.4593
2021-08-30 00:00:00 |  | HL |  |  | 4101.3789
2021-10-13 00:00:00 |  | HF | 1769442.728 |  | 39.5585 |  |  |  |  |  |  |  |  |  |  |  |  | 3500
2021-10-13 00:00:00 |  | HL | 31577.697 |  | 4116.62384 |  |  |  |  |  |  |  |  |  |  |  |  | 6500
2021-10-26 00:00:00 |  | HL |  |  | 4120.7822 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Liquid
2021-11-25 00:00:00 |  | HL |  |  | 4133.4327 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Money Mkt
2021-12-07 00:00:00 |  | HMM |  |  | 4594.1589
2021-12-10 00:00:00 |  | HMC |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  | 1500
2021-12-28 00:00:00 |  | HL |  |  | 4146.4596
2022-01-06 00:00:00 |  | HL |  |  | 4150.3177
2022-01-31 00:00:00 |  | HL |  |  | 4159.4685 |  |  |  |  |  |  |  |  |  |  |  |  | 7499
2022-02-16 00:00:00 |  | HL |  |  | 4166.4947
2022-02-20 00:00:00 |  | HL |  |  | 4168.0948
2022-02-23 00:00:00 |  | HN100 |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  | 1000
2022-02-24 00:00:00 |  | HL |  |  | 4169.6226
2022-03-01 00:00:00 |  | HL |  |  | 4171.6336
2022-03-15 00:00:00 |  | HL | 11968.439 |  | 4177.4454 |  |  |  |  |  |  |  |  |  |  |  |  | 2499.88
2022-03-23 00:00:00 |  | HL |  |  | 4180.7605
2022-03-23 00:00:00 |  | HL |  |  | 4180.7605
2022-03-30 00:00:00 |  | HL |  |  | 4183.6751
2022-04-11 00:00:00 |  | HL | 68026.895 |  | 4189.31 |  |  |  |  |  |  |  |  |  |  |  |  | 14249
2022-05-24 00:00:00 |  | HL | 16165.404 |  | 4206.3038 |  |  |  |  |  |  |  |  |  |  |  |  | 3399.83
2022-06-28 00:00:00 |  | HL |  |  | 4225.0121
2022-07-13 00:00:00 |  | FC | 9522.835 |  | 1050.055 |  |  |  |  |  |  |  |  |  |  |  |  | 499.98
2022-08-17 00:00:00 |  | HL |  |  | 4253.746
2022-08-17 00:00:00 |  | HL |  |  | 4253.746
2022-09-21 00:00:00 |  | HL |  |  | 4274.6354
2022-09-29 00:00:00 |  | HUST |  |  | 12.6648
2022-10-17 00:00:00 |  | FC | 8584.367 |  | 1164.85 |  |  |  |  |  |  |  |  |  |  |  |  | 500
2022-10-17 00:00:00 |  | HL | 9319.072 |  | 4292.0581 |  |  |  |  |  |  |  |  |  |  |  |  | 2002
2022-10-18 00:00:00 |  | HL |  |  | 4292.8573 |  |  |  |  |  |  |  |  |  |  |  |  | 7497
2022-10-19 00:00:00 |  | HL | 11644.936 |  | 4293.4973 |  |  |  |  |  |  |  |  |  |  |  |  | 2499
2022-10-27 00:00:00 |  | HL |  |  | 4299.0133
2022-11-16 00:00:00 |  | HL |  |  | 4314.3564
2022-11-17 00:00:00 |  | DSP | 2221242.364 |  | 16.8816 |  |  |  |  |  |  |  |  |  |  |  |  | 1874.91
2022-11-17 00:00:00 |  | DSP | 455005.31 |  | 16.4825 |  |  |  |  |  |  |  |  |  |  |  |  | 374.98
2022-11-17 00:00:00 |  | TTA | 11254.9832 |  | 3331.6909 |  |  |  |  |  |  |  |  |  |  |  |  | 1874.91
2022-11-17 00:00:00 |  | TTA | 2293.782 |  | 3269.5463 |  |  |  |  |  |  |  |  |  |  |  |  | 374.98
2022-12-14 00:00:00 |  | HL |  |  | 4335.8964
2022-12-14 00:00:00 |  | HL |  | 17020.70187839359 | 4335.8964
2023-01-05 00:00:00 |  | HL |  |  | 4354.4049
2023-01-05 00:00:00 |  | HNG | 2962522.227 |  | 10.126 |  |  |  |  |  |  |  |  |  |  |  |  | 1500
2023-01-05 00:00:00 |  | HUST | 3102712.69 |  | 12.8913 |  |  |  |  |  |  |  |  |  |  |  |  | 2000
2023-01-05 00:00:00 |  | FC | 8079.764 |  | 1237.598 |  |  |  |  |  |  |  |  |  |  |  |  | 500
2023-01-05 00:00:00 |  | SMUSD | 1495.182 |  | 5015.8619 |  |  |  |  |  |  |  |  |  |  |  |  | 374
2023-01-05 00:00:00 |  | SMUSD | 7387.145 |  | 5076.132 |  |  |  |  |  |  |  |  |  |  |  |  | 1877
2023-01-31 00:00:00 |  | HL | 32011.532 |  | 4373.2053 |  |  |  |  |  |  |  |  |  |  |  |  | 6999
2023-02-14 00:00:00 |  | HL |  |  | 4384.2697
2023-03-17 00:00:00 |  | FC | 8348.278 |  | 1197.792 |  |  |  |  |  |  |  |  |  |  |  |  | 499
2023-03-31 00:00:00 |  | HNG |  |  | 10.2981 |  |  |  |  |  |  |  |  |  |  |  |  | 5000
2023-04-06 00:00:00 |  | HL |  |  | 4431.9616
2023-04-06 00:00:00 |  | FC | 8217.623 |  | 1216.836 |  |  |  |  |  |  |  |  |  |  |  |  | 500
2023-04-28 00:00:00 |  | HL |  |  | 4446.1801
2023-05-17 00:00:00 |  | HL |  | 7842.125 | 4463.0761
2023-07-30 00:00:00 |  | HL |  |  | 4524.4162 |  |  |  |  |  |  |  |  |  |  |  |  | 5000
2023-08-10 00:00:00 |  | HL |  |  | 4533.2057
2023-08-14 00:00:00 |  | HDFC-234 | 3999800.1 |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  | 1999
2023-08-17 00:00:00 |  | HL |  |  | 4538.9882
2023-09-12 00:00:00 |  | HL |  |  | 4560.8219
2023-10-11 00:00:00 |  | SMUSD | 2365.971 |  | 5282.9795 |  |  |  |  |  |  |  |  |  |  |  |  | 624
2023-10-11 00:00:00 |  | SMUSD | 7001.545 |  | 5355.6926 |  |  |  |  |  |  |  |  |  |  |  |  | 1877
2023-10-11 00:00:00 |  | SAO | 584170.688 |  | 29.9555 |  |  |  |  |  |  |  |  |  |  |  |  | 875
2023-10-11 00:00:00 |  | SAO | 1663272.633 |  | 31.5627 |  |  |  |  |  |  |  |  |  |  |  |  | 2625
2023-10-11 00:00:00 |  | DSP | 2307722.364 |  | 17.9822 |  |  |  |  |  |  |  |  |  |  |  |  | 2075
2023-10-11 00:00:00 |  | DSP | 771050.739 |  | 17.5077 |  |  |  |  |  |  |  |  |  |  |  |  | 675
2023-10-11 00:00:00 |  | FC | 6910.724 |  | 1446.954 |  |  |  |  |  |  |  |  |  |  |  |  | 500
2023-11-07 00:00:00 |  | HL | 15187.557 |  | 4608.8059 |  |  |  |  |  |  |  |  |  |  |  |  | 3498
2023-11-24 00:00:00 |  | HDFC-234 | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 655567
2024-01-16 00:00:00 |  | HL | 42802.089 |  | 4672.4355 |  |  |  |  |  |  |  |  |  |  |  |  | 10000
2024-02-16 00:00:00 |  | HUST |  |  | 13.9467
2024-03-11 00:00:00 |  | HL |  |  | 4723.4842
2024-05-10 00:00:00 |  | FC | 11316.279 |  | 1767.277 |  |  |  |  |  |  |  |  |  |  |  |  | 14249
2024-05-12 00:00:00 |  | HL | 66891.91 |  | 4783.5979 |  |  |  |  |  |  |  |  |  |  |  |  | 3399.83
2024-05-16 00:00:00 |  | HM | 2999850.007 |  | 10
2024-05-21 00:00:00 |  | HDFC-234 | 0 | 0 | 0
2024-06-12 00:00:00 |  | HMM |  | 17663.16938391906 | 5378.4232
2024-07-18 00:00:00 |  | FC | 4960.138 |  | 2015.972
2024-07-18 00:00:00 |  | HA | 5311255.126 |  | 18.827 |  |  |  |  |  |  |  |  |  |  |  |  | 2002
2024-07-18 00:00:00 |  | HST | 3288779.119 |  | 30.4049 |  |  |  |  |  |  |  |  |  |  |  |  | 7497
2024-09-12 00:00:00 |  | HMM |  | 9301.386623900846 | 5477.9222 |  |  |  |  |  |  |  |  |  |  |  |  | 2499
2024-09-12 00:00:00 |  | HL |  | 9003.9057 | 4897.8745
2024-10-14 00:00:00 |  | HL | 30428.389 |  | 4929.3606
2024-11-18 00:00:00 |  | HL |  | 20154.744 | 4961.6111
2024-12-11 00:00:00 |  | HF |  | 1400217.034 | 48.5639 |  |  |  |  |  |  |  |  |  | 1504324.78 |  |  | 4751
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6999
Total