XIRR (PQL  xl)
This function calculates the internal rate of return for a schedule of cash flows that may not be periodic
 Library: PQL \ Spreadsheet \ Financial
 Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
 Solve: This function can be used with the Solve plugin: both as part of the objective function and constraint functions
Syntax
XIRR(values, dates, OPTIONAL guess)
Function Arguments
Name  Description  Type  Optional 
values  Series of cash flows that correspond to a schedule of payments in dates. The first payment is optional and corresponds to a cost or payment that occurs at the beginning of the investment  Number 

dates  Schedule of payment dates that corresponds to the cash flow payments in values  StringOrNumber 

guess  Estimate of the internal rate of return that you guess is close to the result of this function; if omitted, the calculation uses 0.1 (10 percent)  Number  Y 
Comments
This function is the same as the Microsoft Excel 'XIRR' function  using the same inputs, logic and outputs.