XIRR Function Undefined
Status: Alpha
Brought to you by:
rvk
Menu
▾
▴
#28 XIRR Function Undefined
XIRR is a standard Excel function. However, when I try to use it inside a Formula() call, I get the error "unknown function: XIRR", because it's undefined in the file ExcelMagic.py
Unfortunately, where these numbers come from appears to be undocumented, so I have no idea how I'd add an entry for the XIRR formula. Please advise.
View and moderate all "bugs Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Bugs"
XIRR is NOT a "standard function". It is part of the "Analysis ToolPak" aka ATP add-in kit. As such, it can't be invoked by the standard function mechanism in pyExcelerator. Consider moving to xlwt (maintained, enhanced fork of pyExcelerator).
I don't actually use Microsoft Excel, so I'm not aware of the various add-in kits. I meant XIRR is a standard function in that it's supported out-of-the-box in OpenOffice.
I did evaluate xlwt. However, it doesn't support XIRR either, and hasn't been updated in nearly 2 years, so it's hardly more maintained.
Yes, xlwt needs a new release. xlwt is maintained, and is receiving enhancements. See www.python-excel.org. See the SVN repo at https://secure.simplistix.co.uk/svn/xlwt/trunk/
AND xlwt 0.7.2 (the latest release) DOES include XIRR ... you must have downloaded an antique version; go to http://pypi.python.org/pypi/xlwt