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
5
Medium Priority
?
555 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 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

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

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

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…
Video by: ITPro.TV
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…

715 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