Is it possible to get functions' source code from Microsoft?

[wangjl]

I'm developing a financial tool, in which I want to
implement all Excel's financial functions. But when I
implement ODDFPRICE, ODDFYIELD according to the help
document which provides some formulas, I got a wrong
result, that is to say, not equal to the Excel's result.
Can I get source code about how Excel implements these
functions?
Where and how can I get help?
Thanks very much!

 

[alfaboost]

As long as i know we cannot get source code about those functions
because it's confidential. But i like to know too if anybody knows
about that things. Thank you

 

[John Wilson]

alfaboost & wangjl,

Geeze....don't you guys (gals), have real names like John, Joe,
Harry or Thaddeus (Gwendolyn, maybe)????

What you're looking for is in the Analysis ToolPak.
Yes, it is password protected, so you cant get to see it (easily).

I could post the code here but I'd probably get into a lot of trouble
by doing so, so I won't.

What I can tell you is there are ways to crack that password
protection. A search of Google will turn up many links to
programs that will crack that password (for a fee). A more
extensive search will turn up ways to do it for free.

If MS "REALLY" wanted to keep it protected, they'd have
done a better job of encrypting their password scheme.

Do your homework, good luck with your search.

John

 

[Harlan Grove]

. . . ODDFPRICE, ODDFYIELD . . . ....
Can I get source code about how Excel implements these
functions?

Microsoft share its source code with outsiders? What planet do you live on?

FWIW, the Gnome Project's Gnumeric spreadsheet includes these functions, so
you could look at how they're implemented. But they're under GPL, so if you
use their code, you may be obliged to release your project under the GPL.

 

[Harlan Grove]

What you're looking for is in the Analysis ToolPak.
Yes, it is password protected, so you cant get to see it (easily).

....

??!

The bulk of the ATP's functionality is provided by

<officedir>\Library\Analysis\ANALYS32.XLL

How do you unprotect an XLL?