Do I need to use VBA for the following control structure?
Hi all,
I have the following control structure from Matlab, do you think I need VBA
to handle it, or I can just rely on Excel?
Thanks a lot!
-----------------------------------------
for t=1:5;
CumLoss=CumLoss+sum(DefaultTime(:, t));
if (CumLossTotalNotional*Deattachment)
break;
else
PV=PV+y*(TotalNotional-CumLoss)/(1+r)^t;
if t==5
PV=PV+(TotalNotional-CumLoss)/(1+r)^t;
end;
end;
end;
|