Watch V7

Forgot to mention that this line in FindNAV returns an error when NAV is 0.
y(j, 4) = Range("SipAmt") / x(i, 3)  'Units
I have changed to ignore (skip) by
      If x(i, 3) <> 0 Then
        y(j, 4) = Range("SipAmt") / x(i, 3)  'Units
      End If
But I don't know if that is the correct method.

is there any instance where NAV is Zero ? as logically NAV never became Zero..please let me know any where NAV is print zero...all this is still Raw data i will update all historical data then only this WB is worth to show some conclusive result. as i have only one Scheme data is older than 20 years and calculating based on that scheme. others have 10 year data but still that is correct & Accurate.

Thanks

Perfect & Thank you Very Much ....Really Appreciated

Nav values 0
Axis: G808
Axis: J812
Axis: M524
DSP: V6

yes seen NAV 0...dont know how it is on Mutual fund registered site.....what approach we did for that error ......we taken next NAV Date?

Then change in module M06_RollingSipFindNav

   If (AddDate = True) Then
      cMonth = Month(x(i, 2))
      y(j, 1) = x(i, 1)                    'Scheme
      y(j, 2) = x(i, 2)                    'Date
      y(j, 3) = x(i, 3)                    'NAV
      If x(i, 3) <> 0 Then
        y(j, 4) = Range("SipAmt") / x(i, 3)  'Units
      End If
      j = j + 1
   End If

Select allOpen in new window

To

   If (AddDate = True) Then
      If x(i, 3) <> 0 Then
        cMonth = Month(x(i, 2))
        y(j, 1) = x(i, 1)                    'Scheme
        y(j, 2) = x(i, 2)                    'Date
        y(j, 3) = x(i, 3)                    'NAV
        y(j, 4) = Range("SipAmt") / x(i, 3)  'Units
        j = j + 1
      Else
        SuccessfulOnce = False
      End If
   End If

Select allOpen in new window

to ignore that date, and use the next.

Help needed in fundz watch file ...added 2 more sheets ......totally different functionality...may i post link here?

Please post and I will look at it.

Here it is....Thanks