Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

xirr in coldfusion

Posted on 2010-08-16
Medium Priority
555 Views
does anyone know to write this excel xirr forumula in coldfusion
0
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
• 2
• 2

LVL 52

Accepted Solution

_agx_ earned 2000 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

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

ID: 33472540
no solution
0

LVL 52

Expert Comment

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

Question has a verified solution.

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

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…
Today, I was working on some optimization and spam-stopping techniques when I encountered Ben Nadel's post to reduce spam feature using Math (http://www.bennadel.com/blog/197-How-I-Stop-Spammers-On-My-ColdFusion-Blog.htm). While this method is not o…
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses
Course of the Month7 days, 11 hours left to enroll