EXCEL Analysis Toolpack - Financial Functions

[rvBasic]

1. Is there any place where I can find the formula or algorithms behind the Financial Functions (as imlemented by MS)?

2. More specifically: I'm looking for the formula that MS uses to implement the YIELDMAT function.

3. The problem: YIELDMAT returns #NUM! when the settlement date equals the issue date. When the settlement date is ONE day above the issue date, the functions returns a value. The equal condition does not seem to be forbidden by MS'description of the YIELDMAT function in the Help files. _________________________________
In theory, there is no difference between theory and practice. In practice, there is. [attributed to Yogi Berra]

 

[rvBasic]

A google search through the MS KBS revealed the following articles: Q213939 for XL 2000 and Q149236 for previous versions. Both contain essentially references to books from which the formulas are derived.

Alas, I do not possess these books!

However MS comes to the rescue as far as the financial functions are concerned: Both articles point to another KBS article Q117813:Equations for Financial Functions.

But: bad luck again? This page cannot be found!

I would appriciate if someone could turn up this page

The Q213939 article even offers a helpfull advice:

For more information about algorithms used in the Analysis ToolPak, click Microsoft Excel 2000 Help on the Help menu, type analysis tools in the Office Assistant or the Answer Wizard, click Search, then select Supplemental information about statistical methods and algorithms, and then click Search to view "Supplemental information about statistical methods and algorithms."

Perhaps somebody can help me demystifying this procedure, as I get no further than finding a description of the function (what it is supposed to do, how to call it) but not of the algorithm used.



_________________________________
In theory, there is no difference between theory and practice. In practice, there is. [attributed to Yogi Berra]