CalXL

CalXL is an ideal 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, events and economical data announcements, to calculate working days in a holding period, to generate a custom series of dates, etc.

Description
Pricing
Requirements
Resources
EULA
Documentation

Description

CalXL - our latest addition to the SpiderXL Add-ins suite - brings intuitive and powerful date and calendar calculation functions into Microsoft Excel. CalXL is a perfect compliment to our NumXL Add-in financial time series analysis software: Strategists and analysts often desire to exploit the information embedded in the date component of a time series to uncover calenderical drivers in their returns and/or volatilities. For instance: Are returns/volatilities significantly different for those days that precede or succeed a long weekend or fall on economic data release days? Does the number of trading days in a holding period (e.g., weekly, bi-weekly, etc.) affect the returns or volatility? Are returns/volatilities significantly different on days that overlap economic data (e.g., CPI, Employment report, etc.) announcements?

You can use CalXL functions either manually, by typing them into your workbook cells, or by using the CalXL menu and toolbar. Once a spreadsheet is created with CalXL using one data set, running the same analysis for different data (or the same but with new observations) is as simple as copying and pasting.

As a result of CalXL's functionality, Excel does the work for you, allowing you to focus your efforts on devising the proper model, back-testing, and examining scenarios. CalXL's inherent ease-of-use allows you to present your conclusions/recommendations in tractable report form.

All CalXL functions have been intensively tested to guarantee users with fully reliable results.

Dates

Support for Western weekday (i.e., Monday-Friday), and non-Western weekdays (e.g., Sunday-Thursday, Saturday-Wednesday, Saturday-Thursday)
Business Day rolling convention
Common date calculations. For instance; compute number of business days between two dates, returns the N-th weekday in a given month, etc.

Holidays

Support for Government, Bank, and Exchange Holiday Calendars
Support for Islamic and Jewish Holiday Calendars
Support for US Economic Data Announcement Calendars
Support for US and Canadian Corporate Earning, Splits and Dividends Calendars
Support for Ex-Post (Historical) and Ex-Ante (Future) Calendar Events
Calendar Functions - Examine whether a date falls on a given holiday, returns an array of holidays between two dates, etc.

General

Education / Government

Requirements

We highly recommend that you evaluate your computer before installing CalXL products to verify that you meet or exceed the minimum system requirements.

NOTE: CalXL 1.0 is a 32-bit Add-in. Although it can run on a Windows 64-bit platform (Windows XP, Windows Server 2003, and Windows Vista), there may be some feature limitations as noted in the system requirements below.

Component	Requirement
Computer and Processor	500 megahertz (MHz) processor or higher
Memory	512 megabytes (MB) RAM or higher
Hard Disk	7 megabytes (MB); a portion of this disk space will be freed after installation if the original download package is removed from the hard drive
Display	1024x768 or higher resolution monitor
Operating System	Microsoft Windows XP with Service Pack (SP) 3, Windows Vista with SP1, or later
Microsoft Excel	Microsoft Excel 2002-2003 with Service Pack (SP) 2, Microsoft Excel 2007 with SP1, or later
Additional	Requirements and product functionality may vary based on your system configuration and operating system

Resources

Changelog
Tutorials
Whitepapers

Changelog

Tutorials

Whitepapers

EULA

LICENSE AGREEMENT

IMPORTANT: THIS END USER LICENSE AGREEMENT ("EULA") IS A LEGAL AGREEMENT BETWEEN YOU AND SPIDER FINANCIAL. READ IT CAREFULLY BEFORE COMPLETING THE INSTALLATION PROCESS AND USING THE PRODUCT. IT PROVIDES A LICENSE TO USE THE PRODUCT. BY INSTALLING AND USING THE PRODUCT, YOU ARE CONFIRMING YOUR ACCEPTANCE OF THE PRODUCT AND AGREEING TO BECOME BOUND BY THE TERMS OF THIS AGREEMENT. IF YOU DO NOT AGREE TO BE BOUND BY THESE TERMS, DO NOT INSTALL THE PRODUCT.

GRANTOR: SPIDER FINANCIAL CORP [hereafter “SFC”] is an organization incorporated in the state of Illinois, United States of America. SFC’s international headquarters is at 1507 E. 53rd Street, Suite 480, Chicago, Illinois 60615 USA, with subsidiary and affiliate offices in other cities in the USA and other countries. SFC’s primary internet addresses are www.spiderfinancial.com.

PRODUCT: NumXL [hereafter “the Product”] is a set of computer programs, information, tutorials, and help files [hereafter “Product Elements”] designed to assists Microsoft Excel end-users with statistical and/or econometrics functionality.

Grant: SFC hereby grants a nonexclusive license to use this Product on the following terms:(1) the Software may be used only on computers owned, leased, or otherwise controlled by you and only on one computer at a time. (2) Concurrent use on two or more computers is not permitted without separate authorization and the payment of additional license fees. (3) You may not reverse assemble, reverse compile, or otherwise translate the Software. (4) You may make copies of the software for backup purposes. Except as authorized under this License Grant, no copies of the Software or the User Documentation may be made by you or any person under your authority or control.

WARRANTY: SFC warrants that the Product, if used as directed and in conjunction with the operating systems for which it was designed, will substantially achieve the functionality described in the documentation. SFC does not warrant, however, that your use of the Product will be uninterrupted or that its operation will be error free. In no event shall SFC or any Contributors be liable to the licensed user for any special, indirect, incidental, or consequential damages, including (but not limited to) loss of revenues or loss of profits. SFC's sole obligation under this warranty will be, at its sole discretion, to replace any defective media which is provided by SFC to the user and which is reported by the user to SFC within 60 days from the date of shipment.

YOU ARE ADVISED TO PRINT OUT A COPY OF THIS LEGAL AGREEMENT FOR YOUR OWN RECORDS.

Rev: 10 January 2011