11.5.4. financialΒΆ

Python equivalents of financial Excel functions.

Functions

args_parser_disc

args_parser_fvschedule

args_parser_intrate

args_parser_received

mirr_args_parser

parse_basis

parse_date

total_depr

Cumulative (total) depreciation up to 'period' (can be fractional), using double-declining (or general 'factor') balance with optional straight-line switchover when SLN gives a higher amount.

xaccrint

xaccrintm

xamordegrc

xamorlinc

xcoupdaybs

xcoupdays

xcoupdaysnc

xcoupncd

xcoupnum

xcouppcd

xcumipmt

xdate2date

xdb

xddb

xdisc

xdollarde

xdollarfr

xduration

xeffect

xfvschedule

xintrate

xirr

xispmt

xmirr

xnominal

xnper

xnpv

xoddfprice

xoddfyield

xoddlprice

xoddlyield

xpduration

xppmt

xprice

xpricedisc

xpricemat

xrate

xreceived

xrri

xsln

xsyd

xtbilleq

xtbillprice

xtbillyield

xvdb

xxirr

xxnpv

xyield

xyielddisc

xyieldmat

formulas

Navigation

Table of Contents

  • 1. What is formulas?
  • 2. Installation
  • 3. CLI Quickstart
  • 4. Basic Examples
  • 5. Advanced Examples
  • 6. Excel Function Coverage
  • 7. Next moves
  • 8. Contributing to formulas
  • 9. Donate
  • 10. Supported by
  • 11. API Reference
    • 11.1. parser
    • 11.2. builder
    • 11.3. errors
    • 11.4. tokens
    • 11.5. functions
      • 11.5.1. comp
      • 11.5.2. date
      • 11.5.3. eng
      • 11.5.4. financial
        • 11.5.4.1. args_parser_disc
        • 11.5.4.2. args_parser_fvschedule
        • 11.5.4.3. args_parser_intrate
        • 11.5.4.4. args_parser_received
        • 11.5.4.5. mirr_args_parser
        • 11.5.4.6. parse_basis
        • 11.5.4.7. parse_date
        • 11.5.4.8. total_depr
        • 11.5.4.9. xaccrint
        • 11.5.4.10. xaccrintm
        • 11.5.4.11. xamordegrc
        • 11.5.4.12. xamorlinc
        • 11.5.4.13. xcoupdaybs
        • 11.5.4.14. xcoupdays
        • 11.5.4.15. xcoupdaysnc
        • 11.5.4.16. xcoupncd
        • 11.5.4.17. xcoupnum
        • 11.5.4.18. xcouppcd
        • 11.5.4.19. xcumipmt
        • 11.5.4.20. xdate2date
        • 11.5.4.21. xdb
        • 11.5.4.22. xddb
        • 11.5.4.23. xdisc
        • 11.5.4.24. xdollarde
        • 11.5.4.25. xdollarfr
        • 11.5.4.26. xduration
        • 11.5.4.27. xeffect
        • 11.5.4.28. xfvschedule
        • 11.5.4.29. xintrate
        • 11.5.4.30. xirr
        • 11.5.4.31. xispmt
        • 11.5.4.32. xmirr
        • 11.5.4.33. xnominal
        • 11.5.4.34. xnper
        • 11.5.4.35. xnpv
        • 11.5.4.36. xoddfprice
        • 11.5.4.37. xoddfyield
        • 11.5.4.38. xoddlprice
        • 11.5.4.39. xoddlyield
        • 11.5.4.40. xpduration
        • 11.5.4.41. xppmt
        • 11.5.4.42. xprice
        • 11.5.4.43. xpricedisc
        • 11.5.4.44. xpricemat
        • 11.5.4.45. xrate
        • 11.5.4.46. xreceived
        • 11.5.4.47. xrri
        • 11.5.4.48. xsln
        • 11.5.4.49. xsyd
        • 11.5.4.50. xtbilleq
        • 11.5.4.51. xtbillprice
        • 11.5.4.52. xtbillyield
        • 11.5.4.53. xvdb
        • 11.5.4.54. xxirr
        • 11.5.4.55. xxnpv
        • 11.5.4.56. xyield
        • 11.5.4.57. xyielddisc
        • 11.5.4.58. xyieldmat
      • 11.5.5. google
      • 11.5.6. info
      • 11.5.7. logic
      • 11.5.8. look
      • 11.5.9. math
      • 11.5.10. operators
      • 11.5.11. stat
      • 11.5.12. text
      • 11.5.13. args2list
      • 11.5.14. args2vals
      • 11.5.15. clean_values
      • 11.5.16. convert2float
      • 11.5.17. convert_nan
      • 11.5.18. convert_noshp
      • 11.5.19. flatten
      • 11.5.20. get_error
      • 11.5.21. get_functions
      • 11.5.22. get_shape
      • 11.5.23. is_complex
      • 11.5.24. is_not_empty
      • 11.5.25. is_number
      • 11.5.26. not_implemented
      • 11.5.27. parse_ranges
      • 11.5.28. raise_errors
      • 11.5.29. replace_empty
      • 11.5.30. return_2d_func
      • 11.5.31. str2complex
      • 11.5.32. text2num
      • 11.5.33. to_number
      • 11.5.34. wrap_func
      • 11.5.35. wrap_impure_func
      • 11.5.36. wrap_ranges_func
      • 11.5.37. wrap_ufunc
      • 11.5.38. xfilter
      • 11.5.39. xfilters
      • 11.5.40. Array
    • 11.6. ranges
    • 11.7. cell
    • 11.8. excel
  • 12. Changelog

Related Topics

  • Documentation overview
    • 11. API Reference
      • 11.5. functions
        • Previous: 11.5.3.18. ximpower
        • Next: 11.5.4.1. args_parser_disc
©2016-2026, Vincenzo Arcidiacono. | Powered by Sphinx 9.0.4 & Alabaster 1.0.0 | Page source