January 26th, 2012: We are excited to announce today the launch of NumXL release 1.52 (1.52.40934.5). The new release is updated according to the suggestions from customers including: improved functionality and usability for the Generalized Linear Model (GLM), and a few more miscellaneous fixes/enhancement. For a complete lists of the changes, please refer to the NumXL release notes.

We highly recommend our users to download and install this release.

January 20th, 2012 : The SpiderXL Team is happy to announce a new maintenance release for NumXL (1.51.40927.3). This release primarily addresses the issues that our international users have been experiencing with NumXL on non-English (e.g. Spanish) versions of Microsoft Excel (see prior blog for more details). Furthermore, this release includes few minor fixes and enhancements. For a details lists of the changes, please refer to NumXL release notes

As always, we highly recommend all our users to download and install the new release. You can find the the installer file for the new release on download site.

January 17th,2012 : Several users with Spanish version of Excel reported issues with the formulas generated by NumXL Wizard. The issues are due primarily to the locale or regional settings (e.g. decimal point interpretation).

Going forward, Our Team is working to resolve those issues as high priority, and a new release is scheduled in the very near future.

December 28, 2011: The SpiderXL Team released a new maintenance patch (III) for NumXL 1.51 ORB (1.51.40905.1). This release is a hot fix for the Airline model forecasting function.

We strongly recommend our users to download and install the latest NumXL release.

December 21, 2011: The SpiderXL Team is pleased to announce a new and more robust help desk support option for our users. This will help with easier maintenance and support for bugs for all of our products, feature/enhancement requests, general support requests, and more.

The help desk is available 24/7/365. No account is needed when creating tickets, all you need is your email.

November 11, 2011: The SpiderXL Team release a new maintenance patch for NumXL 1.51 ORB. The released addresses the problems experienced by few users while activating their keys.

We strongly recommend our users to download and install the latest NumXL release.

October 3, 2011: We are pleased to announce a new promotional price for NumXL - originally $300, it is now available for a limited time for only $200. Volume pricing has also been adjusted to reflect the new price.

We are working diligently to release the highly anticipated NumXL 2.0 (Black Widow), after which NumXL will be available at the original (non-promotional) price. Please, keep in mind, all purchases come with a free upgrade for a full 12 months, so customers who purchase NumXL 1.51 (ORB) now are entitled for a free upgrade to NumXL 2.0!

September 23, 2011: The NumXL team has released NumXL 1.51 (ORB). NumXL ORB is a maintenance release, and comes with the following:

• Improvement product diagnosis and troubleshooting
• Major enhancement on the license key management
  • Look up and retrieve existing license key
  • Generate new trial license key
• Various minor fixes

We strongly recoomend our users to download and update to the latest version.

September 14, 2011: It has come to our attention that some users who directly download from our site have warning message saying that the program is corrupted. To avoid this, we recommend our users to download the program and save onto their local disk (or desktop), not a network drive, before launching it.

For more information, please check our frequently asked questions. If you need assistance, contact our support team.

August 19th, 2011: For any user who needed a more convenient way to activate their license key, we are pleased to announce that online license key activation is now available. Like the manual activation in the License Manager, you must provide:

1. your email
2. your host ID (which you can get in the manual activation)
3. and your license key.

With those three pieces, your activation code will be immediately given to you. You will be able to activate within minutes, without needing to contact our support team to get the activation code. It is available every day, all day.

Use the online manual activation here.

August 18th, 2011: We are happy to announce the launch of a special discount offer exclusive for students and/or parents shopping for students. Through this program, students are entitled to a deeply discounted copy of NumXL for only $50.

To qualify for this sale, simply email us at sales@spiderfinancial.com from your valid “.edu” e-mail account, and we will send you the promotion code to use at our online checkout store.

If you do not have an .edu address, please contact one of our sales representative at 1 888-427-9486.

June 14th, 2011: We are happy to announce the release of the long awaited version for NumXL 1.5. NumXL 1.5 is a bridge between 1.0 and 2.0, with a number of fixes, enhancements, and new features; support for Airline model, added new wizard for forecasting, and revamped the online and offline documentation. For a complete list of changes, please check out our Change-log page

The new release is available online on our website. We strongly recommend all users to download and install NumXL 1.5 to enjoy the new features and the minor fixes included.

10-29-2010: Over the past week, we moved our web-site to a dedicated server to improve overall performance. During this transition, users may have experienced and/or reported a problem with the license key activation using the direct method.

We have identified the issue and corrected it. Please accept our apologies for any inconvenience. We thank you for your patience with us. We truly appreciate it.

We have just released Service Pack 3 (SP3) for NumXL 1.0 which addresses two main issues:

1. The support issue of the Installer for NumXL 1.0 giving an error message when trying to install NumXL 1.0 with Microsoft Excel 2010; and
2. A compile error message that pops up for Excel 2002 (XP) users.

For a full list of changes in this release, please check out the NumXL change log.

Users who would like to use Excel 2010 or 2002 (XP) with NumXL should download and reinstall NumXL 1.0 from our website. This new version will automatically include SP3.

A new maintenance release of NumXL is now available. This new release is compatible with Excel/Office 2010. No code changes were needed to NumXL itself, but a few tweaks to the installer program were necessary.

Users who would like to use Excel 2010 with NumXL should download the new package from our website.

The NumXL 2.0 Beta program will be available for download in one to two more weeks. For the moment, we are putting together our NumXl 2.0 Beta testing team list and we are asking our most motivated users to review our Beta Testing Agreement and contact us at beta@spiderfinancial.com indicating your willingness to join the NumXL 2.0 Beta Testing Team.

You will then be notified when the Beta version of NumXL 2.0 becomes available for download in the next two weeks.

In a constant effort to improve solution quality and response time regarding user issues, we have added a new service to our live support - on demand remote desktop support. On demand remote desktop is a remote support tool that enables instant, secure, and trouble-free connections between remote computers over the web and to any point on the globe.

Using state-of-the-art software from TechInline, our support team can quickly view, diagnose, and fix issues related to our products on your remote desktop without pre-installing software.

Although, NumXL 2.0 is not officially out, this article will give you a good head start on the new features in NumXL 2.0.

1. Summary Statistics (support for missing observations)
   1. Mean, Median, Quantile, Quartile, SD, Skew, Kurtosis, count 
   2. Range, IQR, MD, MAD, MIN, MAX, RMD, RMS, GINI and long-run variance
   3. ACFⁱ, PACFⁱ
   4. Correlation (Spearman, Pearson and Kendall), exponential-weighted correlation, cross-correlation
2. Data Transformation (support for missing observations)
   1. smoothing function (e.g.
      moving average, exponential, kernel Gaussian smoothing, etc.)
   2. LAG, DIFF, fractional difference, Add, Sub, Scale
   3. Transformation (BoxCox Optimal Transform)
   4. Filter: Low-Pass High-Pass, Band-Pass, Band-Stop, and ARMA Filter
   5. Fourier transform, Wavelet transform
3. Statistical Distributions
   1. Histogram
   2. Normal, Student's t, Chi-square, Fischer-Snedecor (F-dist), Gamma, Poisson, Weibull, Exponential, Beta, Laplace, power exponential (GEDⁱ) and Log Normal distributions
   3. PDF, CDF, InvCDF
   4. P-Value and Critical Value
   5. MAD, SD, Skew and Kurtosis
   6. Fourier transform,
      Wavelet transform
4. Parametric Modeling
   1. ARMA, ARMAX, ARIMAⁱ, ARFIMAⁱ, AirLine
   2. GARCHⁱ, E-GARCH, GARCH-Mⁱ, TGARCH, IGARCH, GJR GARCH, NGARCH, and QGARCH
   3. IID
   4. COMPLEX Models (e.g. ARMA-GARCH, ARFIMA-GARCH, etc)
5. Model Functions
   1. Spectral Density function
   2. Goodness of fit - LLFⁱ, AICⁱ, Bayesian Information Criterion (BIC/SIC), SSE, SAD
   3. Impulse Response Function (IRF)
   4. Calibration and error estimation of model coefficient
   5. Simulation
6. Statistical tests (support for missing observations)
   1. White noise, Normality and ARCH Tests
   2. Unit-root tests - ADF and KPSSⁱ
   3. Co-integration test
   4. Correlation test (Pearson, Spearman, and Kendall)
   5. Long-memory test (Local Whittle Estimate, GPH)
7. Covariance Analysis
   1. Covariance matrix, exponential-weighted covariance matrix
   2. Covariance to Correlation matrix transform
   3. Matrix positive-definite test

Furthermore, the functionality offered through the menus, tool-bars and form wizards has been revised to enhance the usability of both the existing and new functions.

We are excited to announce the launch of our newly-updated website. The new site includes a few new functionality features (e.g. Live Support) and enhances access to product information, support and resources. A clearer structure, simplified navigation and improved search functions make finding answers and information easier than before.

If you experience any problems using the new website, or if you have any suggestions, please contact us at webmaster@spiderfinancial.com.

NumXL 2.0 (Beta) will be further delayed to address a few issues raised during our preliminary tests and to add new advanced models (e.g. ARFIMA, IGARCH, etc). The delay will allow our engineers to continue working on those enhancement and to apply patches for all known problems. Fortunately, there are no relatively big new issues, so it should be a short delay.

Tentatively, we are looking at the third week of March 2010 for a release date.

We are actively working on the second maintenance release of NumXL 1.0. The new release includes several important fixes for reported issues, new functions, and few minor function enhancements.

For a complete list of changes, please visit the NumXL change-log page.

The new release will be posted online by the end of January 26th, 2010 (GMT-6). We recommend all users to download this update for the fixes included. 

[October 1st, 2009] SPIDER Financial has announced the official release of NumXL - the econometrics analytical software - version 1.0 to the general public.

What's changed in this release?

The latest release includes a few minor fixes, revised documentation (i.e. help file, tutorials, and case studies) and enhanced user-interfaces (UI), improving the usability of the software. To see a full list of changes in this release, please check release notes.

How to download and install NumXL 1.0

The official release is available for download on our website. We recommend all users download this update for the minor fixes included. You can download and install NumXL 1.0 at the NumXL 1.0 Download site.

NOTE: Before you install the new version, please uninstall the old version on your machine.

License Agreement

NumXL 1.0 is released under a freeware license agreement. Users are advised to review the license agreement.

NumXL 1.0 will be delayed to iron out issues detected at the last moment. The delay will allow our engineers to continue working on those issues and to apply patches for other known problems. Fortunately, there are no relatively big new issues, so it should be a short delay.

Tentatively, we are looking at the end of September 2009 for a release date.

  NumXL - the econometrics analytics software - is currently under active development in preparation for its RC Release on July 24th, 2009.

What's changed in this release?

Although the new release includes few minor fixes, we have redesigned its documentation (i.e. help file, tutorials, and case studies) and made available an extensive set of user-interfaces (UI), natively improving the usability of the software. To see a full list of changes in this release, please check the release notes.

How to download and install 1.0 RC

The RC release will be available for download on July 24th. We recommend all users download this update for the minor fixes included. You can download and install NumXL 1.0 RC at the NumXL 1.0 Download site.

NOTE: Before you install the new version, please uninstall the old version on your machine.

License agreement

The NumXL is released under freeware license agreement. Users are advised to review the license agreement.

Chicago - July 8th, 2009 - SPIDER financial announced the start date of ALPHA testing for the company’s date and calendar analytics software - CalendarXL 1.0.

CalendarXL is a perfect compliment to NumXL and financial time series analysis; It provides advanced Date & Calendar calculation functions within Microsoft Excel, making it easy to examine past or predict future holidays or economical data announcements, to calculate working days in a holding period, to generate a custom series of dates, etc.

Users who wish to download and try the functions in CalendarXL Alpha should visit our CalendarXL Homepage .

How to download and install 1.0 ALPHA

We recommend all users download this update for the minor fixes included. You can download and install CalendarXL 1.0 ALPHA now at the CalendarXL 1.0 Download site.

License agreement

The official release of CalendarXL will be released under our commercial license agreement. Users are advised to review the license agreement.

Exchange-listed futures are increasingly used in active strategies; they offer leverage, efficient access to illiquid physical markets, and risk management tools. In this paper, we illustrate the issues and procedure related to incorporating futures in our strategy (e.g. Contract specifications, Margin requirement, contract size, leverage, mark-to-market (MTM) etc.). We define returns on margin and closely examine the P&L draw throughout the day.

The white-paper and the supporting financial model are available on our website to all of our registered users.

Developing a trading strategy is an iterative process; it begins with forming few trading ideas, back-testing, and drawing conclusions or forming new ideas and starting over. This paper discusses the back-testing process of the strategy; we demonstrate the steps, issues and assumptions made during the preparation of the data sample and the calculation of the hypothesized strategy's returns. Finally, we turn our attention to risk aspect of the strategy and its application within an established trading environment with common risk management policies.

The white-paper and the supporting financial model are available on our website to all our registered users.