C# XIRR function

  • Thread starter Thread starter Giri
  • Start date Start date
G

Giri

Does anyone know if there is a XIRR function in the Framework somewhere? Or,
if not, maybe a link to something that I could convert into a function..

Thanks
 
Hi Giri,

Thanks for your understanding.
The XIRR function is not included in .Net Framework, but it is included in
Excel, for more information of algorithm used by the XIRR() function in
excel, you can visit:
http://support.microsoft.com/default.aspx?scid=/servicedesks/bin/kbsea
rch.asp%3FArticle%3D214105

In .Net, I think you should implement the XIRR function yourself.
There is a discussion and sample code in the link below about implement the
XIRR function yourself:
http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Bas
ic/Q_11403739.html

Also, you can download XIRR for windows source code at below:
http://www.geocities.com/alexgutierrezotero/

Hope this helps,

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

--------------------
| From: "Giri" <[email protected]>
| Subject: C# XIRR function
| Date: Wed, 5 Nov 2003 15:42:43 -0000
| Lines: 6
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <#[email protected]>
| Newsgroups: microsoft.public.dotnet.languages.csharp
| NNTP-Posting-Host: 193.67.177.98
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.languages.csharp:196950
| X-Tomcat-NG: microsoft.public.dotnet.languages.csharp
|
| Does anyone know if there is a XIRR function in the Framework somewhere?
Or,
| if not, maybe a link to something that I could convert into a function..
|
| Thanks
|
|
|
 
Thanks, I was already looking at that article.. I guess I'll have to knock
one up myself..

If anyone is interested I'll post the results back here.. (this is something
that microsoft should consider for inclusion in future version of the
FCL....)

Giri
 
Hi Giri,

Thanks for your feedback.
I think you can provide this suggestion to:
http://register.microsoft.com/mswish/suggestion.asp
or mail to: (e-mail address removed)
Your suggestion will be reviewed by us.

Thanks for your understanding.

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

--------------------
| From: "Giri" <[email protected]>
| References: <#[email protected]>
<[email protected]>
| Subject: Re: C# XIRR function
| Date: Thu, 6 Nov 2003 09:55:50 -0000
| Lines: 69
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <eB#[email protected]>
| Newsgroups: microsoft.public.dotnet.languages.csharp
| NNTP-Posting-Host: 193.67.177.98
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.languages.csharp:197132
| X-Tomcat-NG: microsoft.public.dotnet.languages.csharp
|
| Thanks, I was already looking at that article.. I guess I'll have to knock
| one up myself..
|
| If anyone is interested I'll post the results back here.. (this is
something
| that microsoft should consider for inclusion in future version of the
| FCL....)
|
| Giri
|
| | >
| > Hi Giri,
| >
| > Thanks for your understanding.
| > The XIRR function is not included in .Net Framework, but it is included
in
| > Excel, for more information of algorithm used by the XIRR() function in
| > excel, you can visit:
| >
|
http://support.microsoft.com/default.aspx?scid=/servicedesks/bin/kbsea
| > rch.asp%3FArticle%3D214105
| >
| > In .Net, I think you should implement the XIRR function yourself.
| > There is a discussion and sample code in the link below about implement
| the
| > XIRR function yourself:
| >
|
http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Bas
| > ic/Q_11403739.html
| >
| > Also, you can download XIRR for windows source code at below:
| > http://www.geocities.com/alexgutierrezotero/
| >
| > Hope this helps,
| >
| > Best regards,
| > Jeffrey Tan
| > Microsoft Online Partner Support
| > Get Secure! - www.microsoft.com/security
| > This posting is provided "as is" with no warranties and confers no
rights.
| >
| > --------------------
| > | From: "Giri" <[email protected]>
| > | Subject: C# XIRR function
| > | Date: Wed, 5 Nov 2003 15:42:43 -0000
| > | Lines: 6
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| > | Message-ID: <#[email protected]>
| > | Newsgroups: microsoft.public.dotnet.languages.csharp
| > | NNTP-Posting-Host: 193.67.177.98
| > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| > | Xref: cpmsftngxa06.phx.gbl
| microsoft.public.dotnet.languages.csharp:196950
| > | X-Tomcat-NG: microsoft.public.dotnet.languages.csharp
| > |
| > | Does anyone know if there is a XIRR function in the Framework
somewhere?
| > Or,
| > | if not, maybe a link to something that I could convert into a
function..
| > |
| > | Thanks
| > |
| > |
| > |
| >
|
|
|
 
Back
Top