NumXL 1.56 ZEBRA

Today we are excited to announce the release of a new version of NumXL: 1.56 ZEBRA. This new release includes several new features: date rolling and adjustment, U.S. and non-U.S based holidays support, non-western weekends, public and bank holiday calendars.…

Smoothing

This week, we go over time series smoothing functions, highlight its assumptions and parameters, and demonstrate its application through examples. Why should we care? Smoothing is very often used (and abused) in the industry to make a quick visual examination…

ARIMA unplugged

We've featured ARIMA models in a few of our tutorials before, but this week we'll explore them in rich detail, starting with a clear definition of the process and moving on from there.

Keep up with the trends

This week, we tackle the trend issue. No, we aren’t talking about the latest trend in technology or fashion; we’re talking about trend analysis for time series data! Disappointed? Don’t be, this is an exciting and fun topic. Put simply,…

NumXL 1.55 LYNX is here

Today we are excited to announce the release of a new version of NumXL: 1.55 LYNX (1.55.41040.2). This new release is features-rich, as we added several new functionality: trend analysis (for linear, polynomial, logarithmic, and exponential trends), histograms, spectral analysis…

ARMA unplugged

We've featured ARMA models in a few of our tutorials before, but this week we'll explore them in rich detail, starting with a clear definition of the process and moving on from there.

 Predict This

Predict This

The case deals with the predictability of the daily closing EUR/USD exchange rate, given its prior history. First, we constructed a trading strategy where we buy EUR at market open, and close the position (selling EUR) at the market close…