Formula language

Exercise #1 – Counting occurrences of events Exercise #2 – Joining two series Exercise #3 – Disaggregating a series

Exercise #1

Counting occurrences of events Intro If you want to calculate, and highlight on your chart, like this blue line below, the number of occurrences a certain event took place, you can do so by using a formula language. In our example we will calculate how many times the S&P 500 Volatility Index (VIX) has been … Continue reading “Exercise #1”

Case #10

Creating a regression model with a fitted line Objective Limiting the data sample Performing a simple regression analysis Adding a regression line in a scatter chart Solution If you get stuck, use the worksheet to see what to do next. If you need more detailed help, have a look at the learning resources below. The … Continue reading “Case #10”