XIRR Calculation in SQL

XIRR Calculation in SQL

Post by Ganesh Gopa » Fri, 12 Oct 2001 07:13:30



Is there any SQL for calculating the XIRR function? - this
is a financial function to calculate the internal rate of
return for cash flows.  Any help would be greatly
appreciated.

Thanks
GG

 
 
 

XIRR Calculation in SQL

Post by Keith Wo » Sun, 14 Oct 2001 03:08:03


No such function in SQL. Analysis Server (OLAP) and Excel has IIR  - don't know if this is the same.
Perhaps other posters may know of some TSQL code to do this but I couldn't find any.
-Keith

=========================
*  This posting is provided "AS IS" with no warranties, and confers no rights.                
*  You assume all risk for your use. ? 2001 Microsoft Corporation. All rights reserved
*                                                                                      
*  Please do not send email directly to this alias.                                    
=========================
--------------------
|>Content-Class: urn:content-classes:message


|>
|>Is there any SQL for calculating the XIRR function? - this
|>is a financial function to calculate the internal rate of
|>return for cash flows.  Any help would be greatly
|>appreciated.
|>
|>Thanks
|>GG
|>