Thread: yield function
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson Myrna Larson is offline
external usenet poster
 
Posts: 863
Default 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).