COT Report Analysis - a thread on market sentiment - Page 174
Page 174 of 432 FirstFirst ... 74 124 164 172 173 174 175 176 184 224 274 ... LastLast
Results 1,731 to 1,740 of 4314
  1. #1731
    Join Date
    Oct 2014
    Location
    Hungary
    Posts
    356
    Quote Originally Posted by peterma View Post
    Here is this index in action in July and Sep, it gave a clear warning of the 2 pullbacks in the S&P, and unlike the others it is very precise in timing.

    The red line is the S&P, you can see that July 24, the beginning of the first pull back the Russell 2000 had already fallen, likewise on Sep 18.

    If it gave a clear heads up at the top, then I wonder will it give a heads up at the bottom.

    Attachment 67638

    Russell 2000 Rebound Gains Support From Dollar: Chart of the Day - Bloomberg
    I wonder whether we could use the COT to find possible tops and bottoms. The Russel 2000 is included in the report. I might look into it later.
    Last edited by BBalazs; 10-22-2014 at 04:04 AM.

  2. #1732
    Join Date
    Nov 2011
    Posts
    2,497
    Yeah, but I'd suggest if it is the traded instrument then great, it has it's own vix also.

    It's real power is measuring shifts in stock investor risk sentiment, the reality is as suggested, the greater risk stocks are sold off first in a decreasing risk appetite environment, when it was seen that the reality is that the US economy is not about to implode, that there was little prospect of "a perfect storm" then risk appetite quickly increased, "buy the stock bargains with the greater risk - quickly before everyone else gets in."

    Had the small caps been still falling last week then it is most likely the S&P would be at best consolidating, probably still falling.

    Now back to CRB watching, it could herald the next major shift.

  3. #1733
    Join Date
    Oct 2014
    Location
    Hungary
    Posts
    356

    Default Willco and Silver

    Morning guys!

    I decided to let the tutorial rest for a while. At least until somebody finish the latest volume.

    I'm trying to make it a habit of mine, to make a study once or twice a week related to the COT report. It is a great exercise, and gives you a general idea of how responsive different markets to the report.

    In my last study, I examined the relationship between OI readings and price. We came to the conclusion, that market bottoms (highs) usually came hand-in-hand with low (high) OI readings.

    Today, I'm taking the study one step further to see how Willco fared in 15 years. My test subject is once again, Silver.

    Here is the chart of XAGU/USD from 2000 to 2014

    Name:  1.jpg
Views: 280
Size:  22.2 KB

    I calculate Willco with 1,5 years (80 weeks) variable, so that is what I'm going to use here too. If anyone wants to experiment with different variables, be my guest.

    Name:  12.jpg
Views: 287
Size:  54.5 KB

    I have marked the instances with green line when Willco stepped over the 90% line. As you can see for yourself, almost 100% of the time Commercials became extremely bullish, the price of Silver skyrocketed.

    Attachment 67691

    Interestingly enough, they are just as precise with short positions.

    Name:  33344.png
Views: 255
Size:  76.6 KB

    Let us add the Net Positions and mark only those instances when both indicators flashed an extreme condition. Longs are right on the money, that is obvious. Despite the fact that silver was in an uptrend for a prolonged period, Commercials were picking tops pretty good as well.

    Conclusion: Commercials rock! The 2 indicators combined together might warn us about major trend changes/continuations.

    Off-topic: It would be nice if some of us used pictures as illustrations. I really liked Peter's Russel 2000 and S&P 500 comparison. I believe that the matter deserves more attention.

    Edit: I used new pictures because in the last 3, I accidentally used Silver chart from 1998 to 2014 instead of 2000 to 2014. Sorry about that.

    I have no idea how the last pic got here. I cant remove it -_-
    Attached Images Attached Images  
    Last edited by BBalazs; 10-22-2014 at 09:05 AM.

  4. #1734
    Join Date
    Nov 2013
    Posts
    1,393
    Hi BB,

    I made the whole tutorial. Wow, it took some time, but it is nothing compared to the time you had to develop this system and excel sheet. It is a very nice work!

    I do not want to be picky, but there is a small typing mistake. Please correct it. Anyone being fit with excel would see it easily, but if someone did not work much with it, well it can cause some small problems. Here is what to check: post 1720, Step3 in the formula an “F” is missing.

    In post 1733 the first attachment does not work.

    Doing all the steps you wrote, I came to the conclusion that I have to buy silver soon. :-) What a surprise.

    I have decided to try this analysis on the weekend. This means I will not do the analysis until now, I will just check rookies writeup on currencies, I want to make the next step. I will only analyse 1 commodity, but I believe doing this the first time will keep me busy. I think I will do US Crude oil. After doing the work a couple of times I do think that the process will speed up.

    And thanks for the larger sprint screens, showing how to make the second template. This last Willco writing was also cool. Now I am ready for the last part of the tutorial.

    FE

  5. #1735
    Join Date
    Nov 2013
    Posts
    1,393
    Guys,

    I think you have seen that I do not post too much in the last days. It is not because I am not there. I am just very busy with many forex tasks at the same time. I do not start new conversations until I am done with the current works. There might be a bit of slow down in the posts as I see, but we all use our time for gaining knowledge and learning and we will have better analysis in the future. I think this invested time and work with have a huge payout.

    Everyone should keep up working hard and the nice write-ups from Peter and Mike keep the thread live until everyone is done with the different work to do.

    FE

  6. #1736
    Join Date
    Oct 2014
    Location
    Hungary
    Posts
    356

    Default Database Tutorial VIII.

    I assume that you have completed the previous parts of the tutorial, so we can move onto displaying the data using Excel charts.

    It is going to be a walk in the park compared what you've been through

    Net Positions

    The best way to illustrate the action of the different entities in the last X years is using a simple line chart.

    Name:  1.jpg
Views: 235
Size:  53.8 KB

    Insert the chart. Once the black field appears, right click on it, then "Select Data".

    Name:  2.jpg
Views: 229
Size:  34.0 KB

    Depending on the years you wish to display, select the desired interval's Commercial and Non-Commercial Net Position fields. (You might wish to include Nonreportables, although they are going to be a flat line compared to Hedgers & Funds.

    Name:  3.jpg
Views: 234
Size:  114.0 KB

    On the day of this writing, to display 3 years of data, we have to move back to 2011.10.11.

    Name:  4.jpg
Views: 231
Size:  32.7 KB

    To see the date for each value, select the interval from column B. (Black circle)
    For Legend Entries, edit Series 1 & 2 to Commercial and Non-Commercial.

    Name:  5.jpg
Views: 226
Size:  31.5 KB

    Once done, yours should look like this. (probably with different colors)

  7. #1737
    Join Date
    Oct 2014
    Location
    Hungary
    Posts
    356

    Default Database Tutorial IX.

    Following the logic in the last Tutorial, you should be able to figure out the rest of the graphs yourself.

    Here's a little help though.

    Name:  6.png
Views: 246
Size:  50.3 KB

    Oh, almost forgot. Displaying the COT Index is a little tricky, so I shall give you a little help there.

    Once you select the data you want to see on the chart, you'll probably notice that something amiss.

    Name:  7.jpg
Views: 236
Size:  27.8 KB

    That does not look good, does it? The reason for this appearance is the the chart is centered around zero without fixed limits. Here's the way to solve the problem.

    Name:  8.jpg
Views: 240
Size:  33.4 KB

    Right click on the Horizontal Lines, then select "Format Axis"

    Name:  9.jpg
Views: 239
Size:  45.1 KB

    Apply the following settings. That should do the trick!

    Well, that is all for now. Wish you luck with your database!

  8. #1738
    Join Date
    Sep 2013
    Location
    USA. Pittsburgh, Pa.
    Posts
    958
    Hey guys.
    Wednesday results.

    USD: +6 -0 1///+2 -0 1
    AUD: +5 -0 2///+3 -0 2
    JPY : +4 -1 2///+1 -0 2
    CAD: +4 -2 1///+3 -1 1
    GBP: +2 -4 1///+1 -2 0
    CHF: +1 -4 2///+1 -2 0
    EUR: +1 -5 1///+1 -2 0
    NZD: +0 -7 0///+0 -5 0

    Well this one was EVEN.
    USD and AUD on top today.
    And there goes NZD down. (figures...I guess now is a good time huh?)

    00 GMT
    Name:  2014-10-22_2004.jpg
Views: 228
Size:  18.9 KB

    Mike

  9. #1739
    Join Date
    Nov 2013
    Posts
    1,393
    Hi BB,

    as today I will finish the tutorial and can start working with the analysis, the question about the database and especially on your database are coming into my mind.

    Here are the questions I have:

    1. With Philip, we were working on the Currency Cross COT Index. The question is if you also worked it out how to manage it in your database to make charts based on that. It would be a great tools to use the COT Report on the crosses too, and not only on US pairs. To see more information on the issue, please check the Briese book on page 131 and page 132. I am though quite sure that you already worked it out or at least know what I am talking about.

    2. The other thing is refreshing your database. I wanted to know what method do you find the best to refresh your database? Do you download the compressed COT report every week and then for example you just take the one column of silver for the given week and enter it into your database? Or do you write just the numbers out? What method does best work for you?

    3. How did you handle your trades? If you analysed the COT report all alone, it had to be a huge work to analyse all markets. So I guess you either focused yourself on specific commodities or you analysed every week different products. For this reason I think a team can reach better results, because if we have enough dedicated people, then we will be able to analyse the whole market on a weekly basis and be up to date with all signals at the same time.

    Have a nice afternoon everyone and keep working with the tutorial,

    FE

  10. #1740
    Join Date
    Oct 2014
    Location
    Hungary
    Posts
    356
    Quote Originally Posted by ForExchange View Post
    Hi BB,

    as today I will finish the tutorial and can start working with the analysis, the question about the database and especially on your database are coming into my mind.

    Here are the questions I have:

    1. With Philip, we were working on the Currency Cross COT Index. The question is if you also worked it out how to manage it in your database to make charts based on that. It would be a great tools to use the COT Report on the crosses too, and not only on US pairs. To see more information on the issue, please check the Briese book on page 131 and page 132. I am though quite sure that you already worked it out or at least know what I am talking about.

    2. The other thing is refreshing your database. I wanted to know what method do you find the best to refresh your database? Do you download the compressed COT report every week and then for example you just take the one column of silver for the given week and enter it into your database? Or do you write just the numbers out? What method does best work for you?

    3. How did you handle your trades? If you analysed the COT report all alone, it had to be a huge work to analyse all markets. So I guess you either focused yourself on specific commodities or you analysed every week different products. For this reason I think a team can reach better results, because if we have enough dedicated people, then we will be able to analyse the whole market on a weekly basis and be up to date with all signals at the same time.

    Have a nice afternoon everyone and keep working with the tutorial,

    FE
    Question #1: To be honest, I had no intention to create COT Cross Indexes but since you asked, I'll give it a try.

    "The futures markets for cross-rates—currency pairs that do not include the dollar—are not well enough established to provide a usable COT data base. So I simply combine the COT data for two futures contracts to create the COT Cross Indexes. To get the correct combination, multiply the quote currency times −1 before adding."

    Let's take EUR/JPY for instance.

    Euro FX - Commercial longs: 54,556 | Commercial shorts: 210,178
    Japanese Yen - Commercial longs: 192,234 | Commercial shorts: 47,395

    Cross Index - Commercial longs: 54,556+(-192,234)=(-137,678) | Commercial shorts: 210,178+(-47,395)=(162,783)

    Well, that does it. I'm not sure about -137,678 though. Maybe you have to take it's absolute value. From these numbers, you are able to calculate the important indicators. I'll look into the matter more, once I have some spare time.

    Question #2: I simply write the numbers out until I find a programmer who is able to automatize the process. I Ctrl+C - Ctrl+V last week's row, re-type the Report Date and the Long / Short positions. The calculations are automatic.

    Question #3: It actually takes about 10 seconds to know whether that particular instrument deserves attention during next week or not. That's what COT Index extremes are for! If there are other confirmations (Movement Index, OI low/high, Willco), even better.

    Update report -> Look for extremes -> Analyze chart using TA.

Forum Sponsors

Similar Threads

  1. Replies: 0
    Last Post: 05-29-2009, 04:50 AM
  2. Market Sentiment Seems to be Driven by Swine Flu Concerns
    By ACMforex in forum The Analyst Arena
    Replies: 0
    Last Post: 04-28-2009, 09:15 AM
  3. Trading in Japanese Market Hours
    By javierpuga in forum Newbie Island
    Replies: 3
    Last Post: 07-31-2008, 11:23 AM
  4. Replies: 0
    Last Post: 09-25-2007, 09:51 AM
  5. Do trading systems affect market movement?
    By broberson in forum Forextown
    Replies: 10
    Last Post: 02-28-2007, 08:01 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
"To be successful you have to be selfish, or else you never achieve. And once you get to your highest level, then you have to be unselfish."
Michael Jordan