Charting Open Interest from the COT reports

[blackeye555]

Hi everyone,

I'm trying to chart in Excel the Open Interest from the Commitment of Traders reports.

How would you implement this?

"...taking a stochastic of the net of commercial longs minus shorts divided by the total open interest of the last 26 weeks."

The quote above is from Larry William's book about COT reports.Unfortunately I don't know exactly what the "stochastic" he refers to is.

How would you approach this? Or what would be the formula for the stochastic?

 

[Rhody Trader]

My read on what Larry is saying is that you're trying to figure out how much of the total open interest is from the Commercials and plot that over 26 periods. I think by "stochastic" he just means a line.

 

[blackeye555]

you're brilliant! if you put it like that, it makes a lot more sense,i don't know why i didn't think about it that way.thanks so much.