Financial functions

Financial functions can be used in the load script and in chart expressions to calculate payments and interest rates.

For all the arguments, cash that is paid out is represented by negative numbers. Cash received is represented by positive numbers.

Listed here are the arguments that are used in the financial functions (excepting the ones beginning with range-).

Note: For all financial functions it is vital that you are consistent when specifying units for rate and nper. If monthly payments are made on a five-year loan at 6% annual interest, use 0.005 (6%/12) for rate and 60 (5*12) for nper. If annual payments are made on the same loan, use 6% for rate and 5 for nper.

Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?