InfoQ

News

Financial Functions for .NET

Posted by Jonathan Allen on Dec 26, 2008

Community
.NET
Topics
Interop ,
Business
Tags
F# ,
Excel ,
Financial Applications

Considering that the .NET framework is easily on the short list for the most popular business application platform, it is surprising that financial functions are largely ignored. Sure there is a handful of methods squirreled away in VisualBasic.Financial, but most developers don’t even think to look there. It is no wonder companies often turn to Excel.

Luca Bolognese wears many hats. He is the lead program manager for C#, VB, and F# languages and compilers, as well as the DLR framework. Yet somehow he was able to take some time to reimplement 50 financial functions from Excel in F#.

The vast majority of the functions were coded to match Excel’s logic. Unfortunately Excel’s methods are designed for backwards compatibility and do not necessarily give the right answers. To wit Luca says,

My goal is to replicate Excel results (right and wrong). Feel free to contribute to the effort by coding what you think is the right solution and I'll add an ExcelCompliant flag to the function to conditionally invoke your code.

The source code can be downloaded from MSDN Code Gallery. It is released under the Microsoft Public License.

No comments

Watch Thread Reply

Educational Content

Brian Marick on 4 Challenges and 5 Guiding Values of Agile Software Development

Brian Marick takes us through a quick tour of the most important values and challenges to adopting Agile successfully (they aren't the typical challenges and values we hear in the community).

Are You a Software Architect?

The line between development and architecture is tricky. Does it exist at all? Is an ivory tower actually needed? There's a balance in the middle, but how do you move from developer to architect?

Agile – A Way of Life and Pragmatic Use of Authority

The word 'authority' sometimes produces an allergic response in hard-line agilists. Freedom and authority – both are bad if misused and both are good if used in right spirit for a noble cause.

Getting Started with Grails, Second Edition

"Getting Started with Grails" brings you up to speed on this modern web framework. Companies as varied as LinkedIn, Wired, and Taco Bell are all using Grails. Are you ready to get started as well?

Using ITIL V3 as a Foundation for SOA Governance

Those familiar with only ITIL V2 often scoff at the thought that ITIL could serve as a governance framework for SOA. With ITIL V3, the focus of the framework shifted towards service-orientation.

Adrian Colyer on AspectJ, tc Server and dm Server

SpringSource CTO Adrian Colyer discusses AspectJ, SpringSource's dm Server and tc Server products, OSGi and Scrum.

Adam Wiggins on Heroku

Heroku's Adam Wiggins talks about Rails, Background Jobs, Add-Ons, Ruby, and how Heroku manages to work around Ruby's inefficiencies using Erlang and other languages.

SOA as an Architectural Pattern: Best Practices in Software Architecture

For Grady Booch the foundation of a good architecture is patterns, SOA being just one of many patterns. In this Second Life presentation, Booch attempts to bring more clarity on what architecture is.