Category Archives: Uncategorized

Getting started with F# and Excel-DNA in finance

Bram Jochems has written a friendly  ‘Getting Started’ post, discussing how to use F# with Excel-DNA in a finance context. His add-in with various F# / Excel-DNA helper utilities, and a bunch of quantitative finance-related UDFs, including option pricing function and … Continue reading

Posted in Uncategorized | Tagged ,

Streaming real-time data to Excel

Gert-Jan van der Kamp has posted a very nice end-to-end example on CodeProject, showing how to create a WCF service and Excel-DNA add-in to stream real-time data into Excel. The example uses to use the Reactive Extensions support in Excel-DNA … Continue reading

Posted in Uncategorized | Tagged , , ,

F# and R in Excel

Natallie Baikevich has posted some very pretty examples of using F# with Excel-DNA. One function uses the R type provider to easily expose a feature from an R package as an UDF in Excel. Have a look at the write-up, and … Continue reading

Posted in Uncategorized | Tagged ,

Excel-DNA NuGet Package Updated

I’ve updated and improved the Excel-DNA NuGet package. (NuGet is the Visual Studio package manager that makes it easy to download and install external libraries into your projects.) To turn your Class Library project into an Excel add-in, just open Tools … Continue reading

Posted in Uncategorized | Tagged

Excel-DNA Version 0.30 Released

Excel-DNA Version 0.30 has now been released on CodePlex. The download is available from http://exceldna.codeplex.com/releases/view/95861. This version implements support for RTD-based asynchronous worksheet functions based on a thread-safe RTD base class – ExcelRtdServer. The asynchronous support is designed to (optionally) integrate … Continue reading

Posted in Uncategorized | Tagged

Patrick O’Beirne’s guide for Excel VBA to VB.NET migration

Patrick O’Beirne is an Excel guru who has recently been migrating some add-ins from VBA to .NET using Excel-DNA. He has some posts on the migration, including a great list of the language and interop differences to be aware of … Continue reading

Posted in Uncategorized

Excel-DNA version 0.29 – RC available

I have posted a release candidate of Excel-DNA version 0.29 to the CodePlex site. The download is available at http://exceldna.codeplex.com/releases/view/66405. I will wait a week or two for some confirmation that this version works correctly before setting this release to … Continue reading

Posted in Uncategorized

Financial Analytics Suite (FinAnSu) – made with Excel-DNA

I recently noticed a very nice add-in developed by Bryan McKelvey called FinAnSu. The whole add-in is generously available under the MIT open source license, and is a fantastic example of what can be built with Excel-DNA. FinAnSu uses a … Continue reading

Posted in Uncategorized