InfoQ

News

Financial Functions for .NET

Posted by Jonathan Allen on Dec 26, 2008 06:35 AM

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

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.

Related Sponsor

Red Gate Software makes ingeniously simple tools for over 500,000 SQL Server and .NET professionals.

No comments

Watch Thread Reply

Educational Content

Bindings, Platforms, and Innovation

This presentation focuses on the Internet and separating myth from fact, history from the future, and the mundane from the imaginative. Bob Frankston presents a vision of what could and should be.

  •  Jul 02, 2009,
  •  

Orchestrating Long Running Activities with JBoss / JBPM

This article explores the use of JBoss and jBPM to implement design solutions that effectively address the issue of orchestrating long running activities.

  •  Jul 01, 2009,
  •  

Neo4j - The Benefits of Graph Databases

This presentation covers the use of graph databases as an optimal solution for data that is difficult to fit in static tables, rapidly evolving data or data that has a lot of optional attributes.

Realistic about Risk: Software development with Real Options

This session introduces Real Options and shows how it can help in running your project. Real Options is a decision-making process that can be used to manage risk.

  •  Jun 30, 2009,
  •  

Communication Flexibility Using Bindings

This article discusses the use of bindings on services and references (including the instance of non-configured bindings) as the means to implement SCA communications in a Web and SOA environment.

  •  Jun 30, 2009,
  •  

Writing DSLs in Groovy

After a short introduction to DSLs, Scott Davis plays with the keyboard showing how to approach the creation of a DSL by typing working snippets of Groovy code that get executed.

Scaling Agile with C/ALM (Collaborative Application Lifecycle Management)

IBM Rational and InfoQ present, Scaling Agile with C/ALM, an eBook showing organizations how to become “finely tuned software delivery machines” by enabling team integration and scaling.

Concurrent Programming with Microsoft F#

Amanda Laucher presents a real life enterprise application written in F#. She shows actual code snippets, explaining design decisions and suggesting how to use some of the F# constructs.