CalendarXL (Coming Soon)

CalendarXL - our latest addition to the SpiderXL Add-ins suite - brings intuitive and powerful date and calendar calculation functions into Microsoft Excel. CalendarXL 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 CalendarXL functions either manually, by typing them into your workbook cells, or by using the CalendarXL menu and toolbar. Once a spreadsheet is created with CalendarXL using one data set, running the same analysis for different data (or the same but with new observations) is as simple as copying & pasting.

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

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