NumXL blogs and articles

Read through the articles below to stay up to date with NumXL Pro and topics related to time series, statistics, modeling, forecasting, and many more.

Success

Demystifying Trading Strategy Returns

In this paper, we’ll examine a claim by a portfolio manager (let’s call him trader B) about his ability to generate statistically significant Alpha. Alpha is the excess-return compensation for the risk borne, and thus commonly used to assess active managers’ performances. Using plain summary statistics and empirical distribution plots (e.g. Histogram, QQ-Plot), we identified a single data-point with relatively high-return, and once excluded from the sample, the so-called alpha simply vanished.

Read More »
Featured image for analyst

NumXL Support Update – Tutorial Videos

We are excited to announce a couple of new developments on the NumXL support front: (1) We revamped the ‘Getting Started’ user’s guide, and (2) We are pooling all the NumXL tutorial videos and making them available on a single Youtube channel.

Read More »
NumXL 1.67 MARTHA public availability

Volatility 201 – ARCH Modeling

This week, we’ll take the prior discussion further and develop an understanding of autoregressive conditional heteroskedasticity (ARCH) volatility modeling. Why do we care? Volatility cannot be directly

Read More »
NumXL 1.67 MARTHA public availability

Volatility 102

This week, we continue our on-going series on volatility modeling and forecast. In this issue, we start by defining the various terms in an asset’s

Read More »
NumXL software development and release

NumXL 1.57 (SINGA) has gone into Beta

Today, NumXL 1.57 SINGA has gone into Beta testing in preparation for official release, which is about a week away.

In addition to numerous fixes, NumXL 1.57 comes with an important feature: seasonal adjustment for time series using X11 / X12-ARIMA methodology.

Read More »
That's it, you're all caught up!