NumXL Newsletter - Aug 2009

1. Announcement - NumXL Release Candidate (RC)

NumXL 1.0 RC is ready and available to the general public. Although the new release includes minor fixes, we enhanced the documentation set (i.e. help file, tutorials, and case studies) and added numerous toolbars and wizards to further improve the usability of the software.
Read more on our site >>>

2. White paper - Hypothetical Optimal Strategy: Buy Lo and Sell Hi

The optimal trading strategy is to buy low and sell high. This is easier said than done, and many of us invest lot of effort experimenting with strategies in an attempt to get closer to this end. In this paper, we construct this hypothetical optimal strategy, analyze its returns and capture its time dynamics. The model reveals several interesting properties.
Read more on our site >>>

We conducted our analysis in Microsoft Excel and NumXL Add-in functions.

3. Getting Started - NumXL Tutorial

We're delighted to announce the availability of the NumXL tutorial (i.e. Getting Started). Getting Started with NumXL is designed as a self-study course. In this document, we will demonstrate the basic steps to conduct your own time series analysis, diagnose a model’s residuals and make forecasts, all in Microsoft Excel and using only the NumXL Add-in.

Read more on our site >>>

Q&A

1. How do I use NumXL functions in my Excel sheet?

   A: NumXL allows you to use its functions directly within your Excel sheet in the same way you would with built-in Excel functions. Read more >>>

2. Can I use NumXL in Excel VBAⁱ or in a macro?

   A: NumXL is a high-performance compiled-type Excel Add-in. For this reason, it cannot be called directly from a VBA macro. Nevertheless, Excel provides the "Run" command which can be used to invoke NumXL functions. Read more >>>

3. Why is feature X missing from NumXL? It would be very useful.

   A: We always love to hear from our users with suggestions for new features or enhancements for existing ones. To do so, email a detailed description of the desired feature to support@NumXL.com and include your current contact information for any follow up inquiries.

What's New on SpiderXL.com

		Announcement - Integration for Calendar XL with Wall Street Horizon SPIDER Financial announced its strategic integration for CalendarXL with the Corporate Earning Calendar provided by Wall Street Horizon. Read more >>> Calendar XL 1.0 Alpha released for testing on July 14th, 2009 CalendarXL - the Date & Calendar calculator Add-in for Microsoft Excel - was released for testing on July 14th, 2009. Users who wish to download and test CalendarXL Alpha should visit www.spiderxl.com to get the latest software release. CalendarXL works with all current versions of Microsoft Excel. Read more >>>
		Coming Soon - XHGXL 1.0 XHGXL is an analytical tool for exchange-listed products. XHGXL makes it easy to examine contract specifications and perform related calculations: trading days to expiry, delivery start date, delivery basket, contract size, front-contract symbol, etc. XHGXL will work with all current versions of Microsoft Excel. Read more >>>

Feedback

Please do not reply to this newsletter. If you'd like to contact the editors, send an e-mail to info@spiderxl.com.