close

Yo may want to upgrade you're browser.

You're using an old version of Internet Explorer to browse SpiderXL right now. SpiderXL will work better for you if you upgrade or switch to another browser.

Library

LibraryLearn more about valuing financial derivatives and securities. Spider XL quarterly newsletters highlight what's new in our products solutions, features articles on the latest financial instruments, offers helpful tips for Spider XL users, and offers useful advice for analysts.

Video Tutorials FAQ

Video FAQ's are brief how-to video tutorials that answer frequently asked support questions.

DESC STAT #1

videoA slide-show demonstrating how to use NumXL user interface and functions to generate summary statistics of a given time series. read more

Excel 2007 Version Information

video A presentation showing how to find the version and service pack information in Excel 2007. read more

NumXL Installation

video A presentation showing the steps to install NumXL on your machine. read more

ARMA Analysis

video In this tutorial video, we outline the primary steps to analyze a given data set, propose an ARMAi mode, calibrate the coefficient, and conduct statistical forecast (with confidence interval). read more

#

White-papers

Buy LO & Sell HI - Optimal Strategy

reportIn this paper, we construct a hypothetical strategy that buys at daily LOLowest price for the strategy/holding period and exists at daily HIHighest price for the same strategy/holding period (i.e. optimal strategy), compute and analyze its returns and construct an econometric model to capture time dynamics. Next, using the model, we forecast the strategy returns and examine a relationship between the forecasted returns and actual volatility for the same holding period. Although, the strategy can never be realized, it can help us forecast volatility using a new source of data (i.e. HI-LO). read more

Futures returns and P&L

report In this paper, we examin the issues raised in preparing the returns data  for strategies with futures/options  (e.g. Contract specifications, margin requirement, contract size, leverage, mark-to-market (MTM) etc.). Finally, we define returns on margin and compute strategy's P&LProfit & Loss and max P&L draw throughout the holding period. read more

Strategy's returns and P&L

report This paper discusses the back-testing process of the strategy; we demonstartes the steps, issues and assumptions made during the preparation of the data sample and the calculation of the hypothesized startegy's returns. Finally, we turn our attention to risk aspect of the strategy and application within an established trading environment with common risk management policies. read more

S&P 500 Daily Returns Analysis

report In the paper, we consider the daily log returns for the S&P 500, examine its statistical properties, construct an EGARCHi model, examine several innovationsshocks or noise distribution models (e.g. gaussian, Student's t, GEDi), and verify whether the models assumptions are satisfied. Finally, we forecast daily volatility for out-of-sample. read more

Active Strategy (A) Returns Analysis

report This paper analyze the realized returns of an active trading startegy in an attempt to uncover any time patterns in the time series, i.e. do returns have any predictive information. read more

#