Solved

xirr in coldfusion

Posted on 2010-08-16
5
539 Views
Last Modified: 2012-05-10
does anyone know to write this excel xirr forumula in coldfusion excel formula
0
Comment
Question by:mugsinc
  • 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

The technique is by far very Simple! How we can export the ColdFusion query results to DOC file?  Well before writing this I researched a lot in Internet but did not found a good Answer anyways!  So i thought now i should share my small snippet w…
CFGRID Custom Functionality Series -  Part 1 Hi Guys, I was once asked how it is possible to to add a hyperlink in the cfgrid and open the window to show the data. Now this is quite simple, I have to use the EXT JS library for this and I achiev…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

786 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