#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.


  • Comment has been marked as spam. 

    You can see all pending comments posted by this user  here

    Anonymous - 2011-02-04

    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).

  • Cerin

    Cerin - 2011-02-04

    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.


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks