473,508 Members | 2,236 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

C# XIRR function

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
Nov 15 '05 #1
3 9863

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...%2Fbin%2Fkbsea
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/Prog...ges/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" <gt******@prologis.com>
| 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: <#8**************@TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.dotnet.languages.csharp
| NNTP-Posting-Host: 193.67.177.98
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP12.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
|
|
|

Nov 15 '05 #2
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

""Jeffrey Tan[MSFT]"" <v-*****@online.microsoft.com> wrote in message
news:SM**************@cpmsftngxa06.phx.gbl...

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...%2Fbin%2Fkbsea 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/Prog...ges/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" <gt******@prologis.com>
| 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: <#8**************@TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.dotnet.languages.csharp
| NNTP-Posting-Host: 193.67.177.98
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP12.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
|
|
|

Nov 15 '05 #3

Hi Giri,

Thanks for your feedback.
I think you can provide this suggestion to:
http://register.microsoft.com/mswish/suggestion.asp
or mail to: ms****@microsoft.com
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" <gt******@prologis.com>
| References: <#8**************@TK2MSFTNGP12.phx.gbl>
<SM**************@cpmsftngxa06.phx.gbl>
| 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**************@TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.dotnet.languages.csharp
| NNTP-Posting-Host: 193.67.177.98
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP10.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
|
| ""Jeffrey Tan[MSFT]"" <v-*****@online.microsoft.com> wrote in message
| news:SM**************@cpmsftngxa06.phx.gbl...
| >
| > 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...%2Fbin%2Fkbsea
| > 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/Prog...ges/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" <gt******@prologis.com>
| > | 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: <#8**************@TK2MSFTNGP12.phx.gbl>
| > | Newsgroups: microsoft.public.dotnet.languages.csharp
| > | NNTP-Posting-Host: 193.67.177.98
| > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP12.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
| > |
| > |
| > |
| >
|
|
|

Nov 15 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
14908
by: domeceo | last post by:
can anyone tell me why I cannot pass values in a setTimeout function whenever I use this function it says "menu is undefined" after th alert. function imgOff(menu, num) { if (document.images) {...
5
2811
by: phil_gg04 | last post by:
Dear Javascript Experts, Opera seems to have different ideas about the visibility of Javascript functions than other browsers. For example, if I have this code: if (1==2) { function...
2
7661
by: laredotornado | last post by:
Hello, I am looking for a cross-browser way (Firefox 1+, IE 5.5+) to have my Javascript function execute from the BODY's "onload" method, but if there is already an onload method defined, I would...
2
12664
by: sushil | last post by:
+1 #include<stdio.h> +2 #include <stdlib.h> +3 typedef struct +4 { +5 unsigned int PID; +6 unsigned int CID; +7 } T_ID; +8 +9 typedef unsigned int (*T_HANDLER)(void); +10
8
5077
by: Olov Johansson | last post by:
I just found out that JavaScript 1.5 (I tested this with Firefox 1.0.7 and Konqueror 3.5) has support not only for standard function definitions, function expressions (lambdas) and Function...
3
3628
by: Beta What | last post by:
Hello, I have a question about casting a function pointer. Say I want to make a generic module (say some ADT implementation) that requires a function pointer from the 'actual/other modules'...
1
5351
by: Carlos | last post by:
I'm getting RPC error when I try to register analys32.xll in the VB program. ErrorCode=-2147417851 Message="El servidor lanzó una excepción. (Exception from HRESULT: 0x80010105...
2
5300
by: f rom | last post by:
----- Forwarded Message ---- From: Josiah Carlson <jcarlson@uci.edu> To: f rom <etaoinbe@yahoo.com>; wxpython-users@lists.wxwidgets.org Sent: Monday, December 4, 2006 10:03:28 PM Subject: Re: ...
1
4060
by: InfosysAnil | last post by:
Hi, I was trying to access the Microsoft Excel's XIRR Function from my C# code, but the error i get on using the following code is "No overload method for Run contains 3 arguments" ...
0
7227
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7127
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7391
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7054
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
1
5056
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4713
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3188
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1564
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
424
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.