CalendarXL (Coming Soon)

CalendarXL - our latest addition to SpiderXL Add-ins suite - brings intuitive and powerful date and calendar calculation functions into Microsoft Excel. CalendarXL is a perfect compliment to NumXL Add-in and financial time series analysis: 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 it in your workbook cells, or 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 CalendatXL'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 ease of use allows you to present your conclusions/recommendations in a tractable report.

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