| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Current Yield vs. Yield to Maturity at low prices | Excel Worksheet Functions | |||
| Problem with Yield() function | Excel Worksheet Functions | |||
| what is PAR in the Yield Function | Excel Worksheet Functions | |||
| In Excel, can a function yield a drop-down list? | Excel Worksheet Functions | |||
| yield function | Excel Worksheet Functions | |||
Hybrid Mode
