Serving the Quantitative Finance Community

Search found 103 matches

  • 1
  • 2
  • 3
  • 4
  • 5
  • 7
by Govert
May 19th, 2016, 3:04 pm
Forum: Programming and Software Forum
Topic: The future for Excel VBA
Replies: 35
Views: 9836

The future for Excel VBA

<r>QuoteOriginally posted by: fulmerspotQuoteOriginally posted by: GovertQuoteOriginally posted by: fulmerspotI did play with this before deciding to use C# and therefore ExcelDNA on my current project. I suspect it will be a while yet before Microsoft can demise the C API but if the [UdfClass] inte...
by Govert
May 14th, 2016, 10:34 am
Forum: Programming and Software Forum
Topic: The future for Excel VBA
Replies: 35
Views: 9836

The future for Excel VBA

<r>QuoteOriginally posted by: fulmerspotI did play with this before deciding to use C# and therefore ExcelDNA on my current project. I suspect it will be a while yet before Microsoft can demise the C API but if the [UdfClass] interface becomes available on the next version then I'd use that to keep ...
by Govert
December 29th, 2014, 4:22 pm
Forum: Programming and Software Forum
Topic: Excel DNA + Excel 2010 + VS Express 2010
Replies: 30
Views: 39654

Excel DNA + Excel 2010 + VS Express 2010

<t>The Express editions are a bit weird.The easiest way to get started would be to install a current VS version (like the free Visual Studio 2013 Community Edition), create a new "Class Library" project and then install the "Excel-DNA" package from the NuGet package manager. That should give you a p...
by Govert
November 24th, 2014, 7:57 pm
Forum: Programming and Software Forum
Topic: Microsoft takes .NET open source and cross-platform + VS Pro now free for individuals
Replies: 35
Views: 7550

Microsoft takes .NET open source and cross-platform + VS Pro now free for individuals

<t>QuoteOriginally posted by: FastExcelLooks to me like the Office Programmability team does not understand or care about Excel programmabilityPerhaps they understand it perfectly:Excel runs everywhere, but is only powerful and extensible (with VBA and real add-ins) on Windows.-GovertExcel-DNA - Fre...
by Govert
June 30th, 2014, 8:45 pm
Forum: Programming and Software Forum
Topic: Is this a stupid idea?
Replies: 6
Views: 5632

Is this a stupid idea?

<t>What about making a client-side version of (part of) your server library, but keeping it in Python and exposing to Excel via an add-in?Your add-in might have some UDF functions that give direct data-access from worksheet formulae, or return a 'handle' of some sort that are like object references,...
by Govert
March 11th, 2014, 8:05 pm
Forum: Programming and Software Forum
Topic: c# 2D plotting libraries
Replies: 2
Views: 6201

c# 2D plotting libraries

I'd recommend OxyPlot.It's open-source, and the core charting library has a number of front-ends, including WPF, WinForms, GTK# and the Xamarin toolkits.-GovertExcel-DNA - Free and easy .NET for Excel
by Govert
December 3rd, 2013, 8:13 am
Forum: Programming and Software Forum
Topic: XLW5 design/implementation question
Replies: 10
Views: 7837

XLW5 design/implementation question

<t>Registering a function as a macro- sheet function does indeed give it additional power - for example you are able to call the XlfGetXXX information functions.However, it still does not allow the function to call xlSet, which is the API to set cell values, or other functions that modify the sheet....
by Govert
December 2nd, 2013, 7:26 pm
Forum: Programming and Software Forum
Topic: XLW5 design/implementation question
Replies: 10
Views: 7837

XLW5 design/implementation question

<r>My experience is from working on Excel-DNA, which is a .NET library for making Excel add-ins that also talks to Excel. Since Excel-DNA is also based on the Excel C API, the interaction with Excel is the same as from a native C/C++ add-in. The discussion here is also related to a blog post from a ...
by Govert
November 22nd, 2013, 9:40 am
Forum: Programming and Software Forum
Topic: C# Numerical Library
Replies: 14
Views: 33674

C# Numerical Library

ILNumerics is a good one for a high-performance managed implementation (like C, not like tuned MKL, though) and friendly if you're coming from MATLAB.You'd have to tell us what you think about the vector multiplication, though.-GovertExcel-DNA - Free and easy .NET for Excel
by Govert
November 8th, 2013, 9:27 am
Forum: Programming and Software Forum
Topic: C# Quiz
Replies: 27
Views: 10551

C# Quiz

<r>Generic arithmetic is indeed problematic with .NET. F# has a compile-time approach, but that won't help you in C#.Google will find quite a few approaches using interface constraints. Here's one write-up: <URL url="http://www.codeproject.com/Articles/8531/Using-generics-for-calculationsOne"><LINK_...
by Govert
September 28th, 2013, 2:18 pm
Forum: Programming and Software Forum
Topic: Using Excel as a frontend for R
Replies: 3
Views: 8303

Using Excel as a frontend for R

<r>Throwing in F# just to use the type provider seems a bit gratuitous.Maybe just glue R.NET directly through an Excel-DNA C# (or VB.NET) wrapper. There is a write-up on this (with some Japanese): <URL url="http://mockquant.blogspot.com/2011/07/another-way-to-use-r-in-excel-for-net.html.Of"><LINK_TE...
by Govert
November 14th, 2012, 5:51 pm
Forum: Programming and Software Forum
Topic: Which Platform/Language for proprietary systems
Replies: 10
Views: 11839

Which Platform/Language for proprietary systems

<t>Add-In Express is great if you need to make add-ins for various Office apps, especially Outlook, and don't want to use VSTO. It is also good for targeting older Office versions - they essentially have version-independent interop assemblies, a bit like NetOffice, and there are wizards for making a...
by Govert
October 13th, 2012, 10:23 am
Forum: Programming and Software Forum
Topic: ExcelDna - open-source Excel/.Net integration
Replies: 15
Views: 132415

ExcelDna - open-source Excel/.Net integration

<r>Hi Daniel,We have all kinds of support for RTD from Excel-DNA just waiting for you to write about!It depends how deep you want to dig. For basic RTD background, read the original RTD FAQ from 10 years ago. It is still the best background article by far.Then for implementing an RTD server, the bes...
by Govert
October 11th, 2012, 9:00 pm
Forum: Programming and Software Forum
Topic: F# Talk - "New Generation GPU Accelerated Financial Quant Libraries"
Replies: 9
Views: 13392

F# Talk - "New Generation GPU Accelerated Financial Quant Libraries"

<r>As a follow-up to the original post, there is a talk on the F# / CUDA matchup in London next week:<URL url="http://www.meetup.com/FSharpLondon/events/83105582/Now">http://www.meetup.com/FSharpLondon/events/83105582/Now</URL> we just need someone to make a user-friendly front-end to those super-fa...
by Govert
October 9th, 2012, 1:25 pm
Forum: Programming and Software Forum
Topic: Excel tricks
Replies: 134
Views: 79710

Excel tricks

<r>There are some workarounds for the array resizing problem - they're ugly but can be made fairly reliable.Basically you first check whether the calling range is the right size. If not then schedule a macro to run after calculation is complete, and have the macro change the size of the array formul...
  • 1
  • 2
  • 3
  • 4
  • 5
  • 7