Info!! Calculating The Ability Measure

My previous post illustrated an indicator that I've called the Power Measure. It is a running correlation of toll alter as well as volatility. Several readers bring expressed involvement inward calculating such a measure, as well as thus I idea I'd offering a basic explanation. I volition assume a moderate familiarity with Excel.

Let's role five-minute open-high-low-close data. Column H5N1 inward Excel volition hold upwardly Date; Column B is Time; as well as Columns C, D, E, as well as F are Open, High, Low, as well as Close for the ES futures. In my example, I downloaded the information from e-Signal into Excel as well as arranged the columns every bit above.

For Column G, we'll compute Price Change for the five-minute bar. I calculate that every bit a percent change. The formula inward Excel (cell G3) would await like:

=((f3-f2)/f2)*100

For Column H, we'll compute the Range for the five-minute bar, which volition hold upwardly our proxy for toll volatility. The formula inward Excel (cell H3) would await like:

=((d3-e3)/e3)*100

Now nosotros re-create G3 as well as H3 as well as fill upwardly inward all the G as well as H cells to the cease of the information sample (which, inward my post, was 1 trading day). That volition hand us Price Change as well as Range for each five-minute catamenia during the day.

Now, inward Column I, nosotros calculate the 20-bar correlation betwixt the values of Columns G as well as H; that correlation is our Power Measure. So the formula for jail mobile telephone I22 would await like:

=correl(G3:G22,H3:H22)

Once again, nosotros re-create that jail mobile telephone (I22) as well as fill upwardly inward all the I cells to the cease of the information sample. We at in 1 lawsuit bring a moving 20-period correlation of five-minute data. It's similar a moving average, except that it's a moving correlation. My nautical chart only plotted this moving correlation amongst ES toll to illustrate how the indicator moved through the day.

I promise this explanation is helpful. For those with an interest, my novel book goes into greater exceptional into the role of Excel to calculate marketplace position indicators as well as inquiry historical patterns; that is the theme of Chapter 10.
.