Thursday, July 9, 2009

Strongly untyped - System.Objects as input parameters

Now you can enjoy the flexibility of untyped parameters - define your function as accepting objects (System.Object) and pass instance of any type.

Friday, June 26, 2009

Feel Free: Excel4Net eliminates licensing fee!

We are working on a release a new (2.0.7) version which will be a license and a fee free.

Yes, full-featured Excel4Net will be available for download - completely free of charge at http://excel4net.com/Download.aspx since the 1st of July 2009.

Stay tuned!

Saturday, June 13, 2009

ISDA has released a beta version of the FpML Schema LiveSearch application

ISDA has just released a beta of FpML Schema LiveSearch application:

http://www.fpml.org/tools/livesearch_tool/

It is a web application you can use to browse and analyze the FpML schema rapidly and efficiently.

I have tried it - very slick and quick for a web app.

Sunday, May 10, 2009

Excel4Net v.2.0.6 is out there!

A new version of Excel4Net - v.2.0.6 was released!

You can download it from here: http://www.excel4net.com/Download.aspx

I'll post about all new feature over the next week.

Stay tuned!

Wednesday, May 6, 2009

Stability issues with Excel 2007 has been resolved in Excel4Net v.2.0.6

Some users reported stability issues when Excel4Net v.2.0.5 is being used with Excel 2007.

These issues has been resolved in v.2.0.6.

If you're using Excel4Net v.2.0.5 and experiencing the similar issues, you can wait for a week or so for the official release, or please email me at admin@excel4net.com and I'll send you download link for a Excel4Net v.2.0.6, so you can start using it ahead of the others.

Thank you.

Sunday, April 26, 2009

Excel4Net v.2.0.6

A new version of Excel4Net is just a few days away, so what to expect?

*You'll be able to create objects and store them in a spreadsheet - by calling a constructor or a method which returns the object.

*Once object is created, it could be passed as parameter to other spreadsheet functions.

*You can also be able to use objects as a this parameter to the instance methods.

*New automatic parameter conversion - e.g. automatic conversion of DateTime object to QLNet.Date (*1)


p.s. QLNet.Date is a part of the QLNet, which is an open source / free library for quantitative finance, which could be downloaded from www.qlnet.org

Thursday, April 23, 2009

New release: v2.0.5 - release candidate

The important news is v.2.0.5 is a release candidate, so the beta period is almost over!

Based on the overall feedback we found that Excel4Net is quite stable state and though the current version is a stable enough to be promoted to release status, we decided to give it some more time.

In a short, the only new feature of this release is the ability to cache results of function calls, thus eliminating a need to perform calculation if the result is already in the cache.

This new "caching" feature will come really handy if you constantly finding yourself waiting for the whole spreadsheet re-calculation to finish, just because of the change in one cell.

The caching is 100% parameter-based, so please use it with deterministic functions only.

To specify that a call results needs to be cached, just use a"$cached" string as a first parameter to a func()-tion:

NON-cached version:

=func("BlackScholes", "Price", ...)

fast, cached version:

=func("$cached", "BlackScholes", "Price", ...)


This is all for today.

p.s. in a few days I will post about really cool features of the next (2.0.6) version.

Stay tuned.