topic Qlik Sense: XIRR - what method is used? in App Development

topic Qlik Sense: XIRR - what method is used? in App Development https://community.qlik.com/t5/App-Development/Qlik-Sense-XIRR-what-method-is-used/m-p/2062267#M87128 <DIV class="MessageInResponseTo lia-component-message-view-widget-in-response-to lia-component-in-response-to"> </DIV> <DIV id="bodyDisplay" class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"> <DIV class="lia-message-body-content"> <P>Hi Folks,</P> <P>Does anyone know what methodology Qlik Sense uses to solve XIRR or IRR?  Newton's method? </P> <P>If possible, initially looking for a brief description - ideally similar level of detail to what MS provides for Excel: <A title="Description of the algorithm used by the XIRR() function in Excel" href="https://learn.microsoft.com/en-us/office/troubleshoot/excel/algorithm-of-xirr-funcation?ranMID=46130&ranEAID=mP6UMnc5Ozo&ranSiteID=mP6UMnc5Ozo-TknMsGQ_KjrvtkvtfmoyRg&epi=mP6UMnc5Ozo-TknMsGQ_KjrvtkvtfmoyRg&irgwc=1&OCID=AID2200057_aff_7806_1243925&tduid=(ir__q2gyeydjt0kfbwuhewf90u2uxn2x6prt2t3alxio00)(7806)(1243925)(mP6UMnc5Ozo-TknMsGQ_KjrvtkvtfmoyRg)()&irclickid=_q2gyeydjt0kfbwuhewf90u2uxn2x6prt2t3alxio00" target="_blank" rel="noopener">link</A></P> <P>Any help is appreciated.  Thanks.</P> </DIV> </DIV> Wed, 19 Apr 2023 22:25:38 GMT F-M 2023-04-19T22:25:38Z Qlik Sense: XIRR - what method is used? https://community.qlik.com/t5/App-Development/Qlik-Sense-XIRR-what-method-is-used/m-p/2062267#M87128 <DIV class="MessageInResponseTo lia-component-message-view-widget-in-response-to lia-component-in-response-to"> </DIV> <DIV id="bodyDisplay" class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"> <DIV class="lia-message-body-content"> <P>Hi Folks,</P> <P>Does anyone know what methodology Qlik Sense uses to solve XIRR or IRR?  Newton's method? </P> <P>If possible, initially looking for a brief description - ideally similar level of detail to what MS provides for Excel: <A title="Description of the algorithm used by the XIRR() function in Excel" href="https://learn.microsoft.com/en-us/office/troubleshoot/excel/algorithm-of-xirr-funcation?ranMID=46130&ranEAID=mP6UMnc5Ozo&ranSiteID=mP6UMnc5Ozo-TknMsGQ_KjrvtkvtfmoyRg&epi=mP6UMnc5Ozo-TknMsGQ_KjrvtkvtfmoyRg&irgwc=1&OCID=AID2200057_aff_7806_1243925&tduid=(ir__q2gyeydjt0kfbwuhewf90u2uxn2x6prt2t3alxio00)(7806)(1243925)(mP6UMnc5Ozo-TknMsGQ_KjrvtkvtfmoyRg)()&irclickid=_q2gyeydjt0kfbwuhewf90u2uxn2x6prt2t3alxio00" target="_blank" rel="noopener">link</A></P> <P>Any help is appreciated.  Thanks.</P> </DIV> </DIV> Wed, 19 Apr 2023 22:25:38 GMT https://community.qlik.com/t5/App-Development/Qlik-Sense-XIRR-what-method-is-used/m-p/2062267#M87128 F-M 2023-04-19T22:25:38Z