yield function
I compared the speed of the VBA routine with the ATP YIELD function. The VBA
code is 2.33 times FASTER.
But, as I said yesterday, it does have the limitation of fewer options for the
Basis argument. Looking at the formulas in Help, this seems to be relevant in
the calculation of the number of days from settlement to first coupon (the
value DSC).
|