I believed it'd be a good idea to chart that the COT report in my own so I know precisely how it's calculated and I do not need to rely on incomplete free charts or pay for a subscription service.

I created 2 charts for every pair based on Larry William's formulas to get a three year index along with a 26 week interval index.

I would like to chart the Open Interest too (seems like no other free service does that? Maybe I am incorrect?)

However, I am a little stuck and I am hoping you can help.

How would you interpret this paragraph from Larry's book about COT reports:

Quote Originally Posted by ;
We are confronted with a difficulty as we delve into the COT readings of their advertisements. It's this: How do we track their long positions or their positions? As I#8217;ve shown from the previous chapters, it seems that both sides of the equation can be utilized. The resolution is easy. Let#8217;s use both the buying and selling!

What I mean by this is that the very best view can be garnered from taking the net long/short position of these wise men and putting that into the point of view of OI with the following formula. I have it.

Stochastic Custom (COT Commercials/Open Interest, vara)

What the formula is doing is carrying a stochastic of the web of commercial longs minus shorts divided by the overall interest of the last many weeks. ( Vara is personal computer talk for a factor ). You and this factor can play a excellent deal to see what number of months.

While it changes from time to time and market to market, '' I have begun to believe that, all things considered, a 26-week window to take this dimension is the very best, across the board. In the old days, as I have discussed, we utilized a. In this time of markets, however, a world full of adjustments and instant news, I have defaulted into the one-half or 26-week year window to receive our view on the way the advertisements are investing their money.
I have connected the spreadsheet I made.

I am confused about the formula for the stochastic he cites and about what the total open interest of the last 26 weeks. means.

Is that a sum? Or difference? Something else?

If you understand what exactly that stochastic he's talking about is, and about what columns from the report to apply it, please calculate it for a row or some in my dictionary and that I will do the rest.

I will then repost the comprehensive spreadsheet and describe how to translate the information.

Instead, just tell me what the formula to the stochastic would be and about what columns from the report to apply it (which open curiosity columns, the total open interest all and also the changes in open interest or others?)


Edit:

Okay, I believe I figured out what Willi was trying to say.I've uploaded a new spreadsheet comprising:

Charted COT Commercial NonCommercial positions indexes for 26 months 3 year intervals, and Open Interest for 26 months, 1 year and 3 year intervals.

If you've some tips on how we could improve this, I would love to hear about it.

Ps: mexican peso is missing since I do not plan to trade it anytime soon, so I figured I would save time if I didn't chart cot for it also.



https://www.forexsoutheast.asia/atta...1305930036.xls