Markov Algorithm For Time Series. Table of Contents

In order to go from continuous data to a discretized dataset that can be used for State-Transition modeling, I need a mapping function. Here I will use the percentile function. Excel has a percentile function. What I am going to do is create a rolling 8-day window to get the percentile of the current value within the 8-day window. In this case, I am using excel.