Recent content by AlexesDad

We are intending to release the first alpha of XLW5 anyday now. For XLW5 we would like to distribute user contributed projects that may be helpful and informative to the rest of the xlw user community. We require the contributed source code to be open source but you are free to choose any...

Some youtube videos contributed by users:

Yes you can call a VBA function from C++ through the Excel C API. You need to call the function xlUDF .... you should find a reference to it in Steve Daltons book. We will be putting a service for executing VBA functions into the current version of XLW in development.

We have just released an updated development snapshot of XLW (XLW-5DEV) The major changes compared to the previous Dev5 release are: Excel 2010 support 64-bit xll support Improved multi-threading stability XLOPER string fixes You can grab it from here...

Welcome. Do look at the examples packaged with XLW, you may find them useful. There is also one that downloads market data into the spreadsheet from yahoo that students often find helpful

Hi M, Which version of Visual Studio do you have installed ? Express or PRO ? Do you have Visual Studio C++ installed ? Because it is required and if you do not you will need to install it and it should work.

When XLW is installed, to extract a C# xll template you need to go to the menu : XLW -> xlw-5DEV -> xlwDotNet -> Extract XLW .NET xll template to extract a C# template. If you are going to : XLW -> xlw-5DEV -> xlw -> Extract XLW xll template then this indeed will only give you C++ options.

Hi, Which version of xlw are you using ? I have only just commenced work on the next version, XLW 5. XLW 4 does not have support for Visual Studio 2010. Development snapshots for ver 5 are available here: http://sourceforge.net/projects/xlw/files/xlw/xlw 5DEV/ Support for C# xlls has only...

XLW 4.0 released XLW 4.0 has been released. It can be downloaded from http://xlw.sourceforge.net/ Feedback and suggestions would be welcome on the xlw-users mailing list.

I would opt for the second edition. http://www.amazon.com/Patterns-Derivatives-Pricing-Mathematics-Finance/dp/0521721628/ref=sr_1_1?ie=UTF8&s=books&qid=1251555975&sr=1-1

XLW Hi Naos, One alternative option to writing UDFs you may find interesting is XLW. If you're more interested in FE and want to spend your time coding Monte Carlo or PDE engines and pricing analytics then it may be more appropriate. However if you're more interested in development of GUIs...

Assuming ($S_t = S_0e^{\sigma W_t + \mu t} $) and ($T_2>T_1$) then ($\frac{S_{T_2}}{S_{T_1}} = e^{\sigma \large(W_{T_2} - W_{T_1}\right) + \mu \large({T_2} - {T_1}\right) }$) and it follows from Ito that the drift is ($ \large(\mu - \frac{1}{2}\sigma^2\right)\large({T_2} -...

There are two software solutions I can suggest for building .NET XLL's which are free. XLW ExcelDNA Since I only know XLW well, I can only give you details for that. Have a look at the following video clip ( there is no sound and it may require you to fullscreen it)...

I am not sure if this really is a difficult issue. There are various ways that.NET software can be deployed and the best method depends on your constraints. Here are three methods that I have used. 1. Package the software as an .msi package. Pro: If you have a COM assembly you can have it...

For me, even if the only extra functional benefits the 'supposed' thousands of lines of code brought to the table were the ability to provide documentation in the function wizard, they'd be worth their weight in gold. ..... oh lets not mention deployment and RegAsm ;-) Including ExcelDNA ?