Skip to content

python implementation of Microsoft Excel's XNPV and XIRR

Notifications You must be signed in to change notification settings

FinTechCao/XIRR-and-XNPV

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 

Repository files navigation

XNPV and XIRR

This module contains python implementations of Microsoft Excel's XNPV and XIRR functions. Please see the docstrings for more info. I will just highlight here one note: the XIRR function uses the numerical solver from the scipy.optimize module. If, however, you do not have scipy installed, this module also contains a quick and dirty implementation of the secant method that works the same as the scipy function when there is an answer but does not fail gracefully when no answer is found. The version of XIRR using the locally defined secant_method is commented out, uncomment to use it.

About

python implementation of Microsoft Excel's XNPV and XIRR

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Python 100.0%