@GraH - Guido thank you for your time and efforts. I still look forward for your kind help.
@Luke M
I am trying to build a portfolio tracking sheet customized specifically for tracking mutual fund. Where I came across a problem that I will explain again in detail here.
Sheet will be consists...
@GraH - Guido @NARAYANK991 @Hui @Luke M @Debraj @Somendra Misra
I need you guys help. Please have a look into the question. Your time and efforts are very well appreciated. Thanks in advance.
Hi,
Even if it is 1 sell, 3 sell or may be more it should calculate weighted average. Automatically in case of 1 sell it will be sell nav.
Gormula need to find no of sell iteration in column D and take weighed average of NAV and units alloted against the sell value.
Also the same formula...
GraH - Guido,
Attached file as you have asked. I have mentioned the problem in the initial message. The Yellow cell should return to the correct value depending on the conditions explained above.
Hoping this get resolved. Thanks in advance.
Hi all,
I am preparing my own spreadsheet to track the Mutual funds folio. I have come across a situation where I am unable to find the solution. I will try to explain the problem here. Please refer the attached screenshot.
Now I want excel to automatically find a NAV from column F in...
Thanks @Lori
The first solution worked.
I am sorry being so demanding here but we have to do SHIFT+CTRL+ENTER every time after clicking on that cell and even the formulae cannot be dragged.
If any solutions which will take care of the above That would be very great. Thanks in advance.
Hey everyone,
I am fairly new to this forum. I was searching similar solution & this has solved purpose. But I have 2 different data sets in different columns against which I have to calculate XIRR.
Currently I am using following formula...