Supongamos que he invertido en un fondo mutuo (un fondo líquido) donde he realizado múltiples compras y reembolsos / canjes. Por ejemplo, considere las siguientes transacciones (en formato csv):
NAV Date,Transaction,Fund House,Scheme,Amount,NAV,Units,Balance Units,Remarks
20-05-2019,Purchase,ICICI Pru,Liquid Fund,"25,00,000.00",279.7851,"8,935.43","8,935.43",
25-06-2019,Purchase,ICICI Pru,Liquid Fund,"25,00,000.00",280.02,"8,927.93","17,863.36",
12-08-2019,Purchase,ICICI Pru,Liquid Fund,"30,00,000.00",282.4699,"10,620.60","28,472.43",
13-08-2019,Switch Out,ICICI Pru,Liquid Fund,"30,00,000.00",282.5045,"10,619.30","17,864.66",Switched out to Ultra Short Term
20-08-2019,Purchase,ICICI Pru,Liquid Fund,"30,00,000.00",282.8117,"10,607.77","28,472.43",
22-08-2019,Switch Out,ICICI Pru,Liquid Fund,"30,00,000.00",282.9057,"10,604.24","17,868.19",Switched out to Ultra Short Term
17-09-2019,Redeem,ICICI Pru,Liquid Fund,"15,00,000.00",284.0449,"5,280.86","12,587.33",
03-10-2019,Purchase,ICICI Pru,Liquid Fund,"25,00,000.00",284.7262,"8,780.37","21,367.70",
03-10-2019,Purchase,ICICI Pru,Liquid Fund,"25,00,000.00",284.7262,"8,780.37","30,148.06",
09-10-2019,Switch Out,ICICI Pru,Liquid Fund,"85,92,602.22",285.0134,"30,148.06",0,
Ahora, ¿cómo calculo el rendimiento en el fondo para las transacciones generales?
