Solved

xirr in coldfusion

Posted on 2010-08-16
5
546 Views
Last Modified: 2012-05-10
does anyone know to write this excel xirr forumula in coldfusion excel formula
0
Comment
Question by:mugsinc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 52

Accepted Solution

by:
_agx_ earned 500 total points
ID: 33468302
I don't know the answer. But for what it's worth, here's my $0.02 ...

As suggested in this thread, it doesn't sound like this is the type of function you should duplicate yourself.  As with any homespun code, the more complex the function, the greater the likelihood of logic errors and inaccurate results. So ultimately it may be a losing proposition in terms of time expenditure.

If it were me, I would look for an existing java or C# library that has an implementation of that function and call it from CF.  Obviously you could also call Excel, via Office Automation. But that's usually not recommended for servers (and most people don't have Office installed on servers anyway)

http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_21528323.html#a15589569
0
 
LVL 1

Author Comment

by:mugsinc
ID: 33471448
There is a class built on php which works. But it seems difficult to replicate on cf due to the 12 decimal restriction cf has.
0
 
LVL 1

Author Closing Comment

by:mugsinc
ID: 33472540
no solution
0
 
LVL 52

Expert Comment

by:_agx_
ID: 33474034
With all due respect, sometimes the answer is: there isn't a solution or there isn't an easy answer. As was pointed out in the thread linked above, this is one of those cases.

As far as a "12 decimal restriction" ColdFusion is capable of representing larger numbers. You can use any of the java class, from witin CF, that supports larger numbers. For example java.math.BigDecimal.

In my opinion, this question should be archived for others seeking to do the same in the future. I'm not concerned with receiving any points for my comment.  In fact I waited to post and only commented to let you know why you didn't receive more responses. But ultimately IMO, accepting that comment and then saying "no solution" and assigning a "C" grade because you're displeased that there's no easy answer is not an appropriate way to close the thread.
0

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

PROBLEM:  How to open a cfwindow or run a function on double click of a cfgrid row. One of my clients wanted to be able to double click on a row item to get more detailed information about a transaction and to be able to modify the line items i…
This is an updated version of a post made on my blog over 3 years ago. It is unfortunately, still very relevant as we continue to see both SQLi (SQL injection) and XSS (cross site scripting) attacks hitting some of the most recognizable website and …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question