Tag Archives: Excel

FsCheck and co: Testing Excel Financial Functions

[This blog was moved here] Excel Financial Functions library is a .NET library written by Luca Bolognese that provides the full set of financial functions from Excel. It can be used from both F# and C# as well as from other ...

Excel-DNA: Three Stories

[This blog was moved here] Intro: Simulation A couple of days ago I found a spreadsheet, potentially quite an interesting one. In theory, it should run a simple simulation (50000 paths by default) written in VBA - I'd say it's several minutes ...

Days and Ghost Refinements

[This blog was moved here] Let's look at the simple function, which calculates the number of days between dates, when there're 30 days in a month (and 360 in a year). Something like this F# code: 1: let days360 sy sm sd ...