943,879 Members | Top Members by Rank

Web Development > ASP > Problem with XIRR calculation with ASP and EXCEL
Ad:
  • ASP Discussion Thread
  • Unsolved
  • Views: 5172
  • ASP RSS
Permalink
Dec 6th, 2006
0

Problem with XIRR calculation with ASP and EXCEL

Expand Post »
Hello All,

I need a help from you all ,I have a big problem right now I am developing a stock market related site where I have to calculate XIRR return of investment and this is in built function of excel So wht I want is to take data from sql server insert that data in excel file there i want to calculate XIRR formula and then again retrive data from that excel and put it in again in sql server. I try to make that XIRR Function in sql server but it is taking too much time to execute.

Please can anybody helo me in this matter ??

Thanks well in advance.

With Regards

Jatin Surati
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
jatin_surati is offline Offline
2 posts
since Dec 2006
Permalink
Dec 31st, 2006
0

Re: Problem with XIRR calculation with ASP and EXCEL

If you knwo the VBA, ou can create a macro in EXCEL and when ever the data is entered into a specified columns then the macro calculates te IRR and put it back into a specified cell. And you can get the data again from the EXCEL sheet using the ASP.
Reputation Points: 9
Solved Threads: 1
Junior Poster in Training
msaqib is offline Offline
91 posts
since Sep 2004
Permalink
Jan 1st, 2007
0

Re: Problem with XIRR calculation with ASP and EXCEL

Hello Muhammad Saqib,

Thank you for your kind intrest in my problem, now We try by macro but with asp we are not able to do this,Can you show me some sample site where this code is available?

With Regards
Jatin
Reputation Points: 10
Solved Threads: 0
Newbie Poster
jatin_surati is offline Offline
2 posts
since Dec 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in ASP Forum Timeline: Getting Multiple Values From A Select
Next Thread in ASP Forum Timeline: A Funky ASP/SQL "opportunity"





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC