Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 561
  • Last Modified:

xirr in coldfusion

does anyone know to write this excel xirr forumula in coldfusion excel formula
0
mugsinc
Asked:
mugsinc
  • 2
  • 2
1 Solution
 
_agx_Commented:
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
 
mugsincAuthor Commented:
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
 
mugsincAuthor Commented:
no solution
0
 
_agx_Commented:
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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now