#28 XIRR Function Undefined

open
nobody
None
5
2010-12-05
2010-12-05
Cerin
No

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.

Discussion

  • Comment has been marked as spam. 
    Undo

    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