• Home
  • Forums
  • Trades
  • News
  • Calendar
  • Market
  • Brokers
  • Login
  • Join
  • User/Email: Password:
  • 3:57am
Menu
  • Forums
  • Trades
  • News
  • Calendar
  • Market
  • Brokers
  • Login
  • Join
  • 3:57am
Sister Sites
  • Metals Mine
  • Energy EXCH
  • Crypto Craft

Options

Bookmark Thread

First Page First Unread Last Page Last Post

Printable Version

Similar Threads

favorite journal tool: app, web, excel, google? 1 reply

Is there a tool for transferring MT4 trade history into excel? 13 replies

MT4-Excel Price Alert Tool By Binyamin 18 replies

Spread tool in excel 0 replies

COT data to Excel. 4 replies

  • Trading Discussion
  • /
  • Reply to Thread
  • Subscribe
  • 17
Attachments: COT Excel Tool - desegregated data
Exit Attachments

COT Excel Tool - desegregated data

  • Last Post
  •  
  • 1 23 Page 4
  • 1 23 Page 4
  •  
  • Post #61
  • Quote
  • Apr 11, 2019 4:23pm Apr 11, 2019 4:23pm
  •  Jeff59FX
  • Joined Mar 2018 | Status: Member | 170 Posts
Hello MoshiM and everyone else...
What IS the best time to trade FX and commodities that the COT Report shows. Those big orders/contracts we see listed in the report. I feel timing play a Major factor.

Thank you MoshiM for those EXCELLENT Excel spreadsheets! I just discovered them I Only have Excel 2007 and I can't update.

Thanks again,
Jeff
Happily Married to MY College Sweet Heart!
  • Post #62
  • Quote
  • Edited at 3:59am Apr 12, 2019 3:49am | Edited at 3:59am
  •  MoshiM
  • Joined Dec 2016 | Status: Member | 97 Posts
Quoting Jeff59FX
Disliked
Hello MoshiM and everyone else... What IS the best time to trade FX and commodities that the COT Report shows. Those big orders/contracts we see listed in the report. I feel timing play a Major factor. Thank you MoshiM for those EXCELLENT Excel spreadsheets! I just discovered them I Only have Excel 2007 and I can't update. Thanks again, Jeff
Ignored
It is still possible for you to update the Workbook. You will have to download the data manually. I will send you an adjusted script for sorting the data in the next few days with instructions on what steps you will have to take but for now I will update the spreadsheets in the Dropbox folder when the data comes out.

To answer your question: I wouldn't say that the COT data provides any CONSISTENT indication of market timing. What it will do however is help align you with whether it is better to be bullish,bearish or neutral depending on how well you understand the different groups. You would then have to decide for yourself both the timing and under what conditions you wish to enter.

As for me, I aim for when there is a reversal of position trends off extremes or just reversals in general depending on the CONTEXT(Fundamentals,Technicals etc) of the market. Once I see this, then I can take my time entering into my full position size if price trends more and more in my favored direction. This may mean entering into my first position the Monday after the data releases or maybe several weeks or months later if there is a persistent trend counter to which side I wish to be on.
2
  • Post #63
  • Quote
  • Apr 12, 2019 9:50am Apr 12, 2019 9:50am
  •  Jeff59FX
  • Joined Mar 2018 | Status: Member | 170 Posts
Quoting MoshiM
Disliked
{quote} It is still possible for you to update the Workbook. You will have to download the data manually. I will send you an adjusted script for sorting the data in the next few days with instructions on what steps you will have to take but for now I will update the spreadsheets in the Dropbox folder when the data comes out. To answer your question: I wouldn't say that the COT data provides any CONSISTENT indication of market timing. What it will do however is help align you with whether it is better to be bullish,bearish or neutral depending on...
Ignored
Thank you MoshiM for the information and feedback. I have been looking at the opening and closing times in All markets. Your Excel spreadsheets are really excellent as I am learning More on how important the CoT report every week!

Thank you very much!

Jeff
Happily Married to MY College Sweet Heart!
  • Post #64
  • Quote
  • Nov 18, 2019 5:33am Nov 18, 2019 5:33am
  •  swayyy
  • | Joined Nov 2019 | Status: Member | 2 Posts
Hello,

I am new to trading and I chanced upon your really awesome excel file.

May I ask how the file can be updated? There is about 6-7 years worth of data missing and your instructions only allow the update of the most recent data.

Hopefully this thread isn't dead and there will be some answers!
  • Post #65
  • Quote
  • Edited at 7:47pm Nov 19, 2019 7:17pm | Edited at 7:47pm
  •  MoshiM
  • Joined Dec 2016 | Status: Member | 97 Posts
Quoting swayyy
Disliked
Hello, I am new to trading and I chanced upon your really awesome excel file. May I ask how the file can be updated? There is about 6-7 years worth of data missing and your instructions only allow the update of the most recent data. Hopefully this thread isn't dead and there will be some answers!
Ignored
I assume your question is addressed to the original thread creator so I can't help you there if your interested in their file, but the link I posted in this thread {also found on my profile} links to both an update-able and current COT Excel file. Please note that the update functionality for MAC users is limited as I haven't figured out how to automatically download and extract the contents of a zip file if you've gone several weeks without updating the file but Weekly updates will work just fine depending on your version of Excel {Recently got this to work}. Also read the ReadMe File and any other notes.
  • Post #66
  • Quote
  • Nov 19, 2019 8:01pm Nov 19, 2019 8:01pm
  •  swayyy
  • | Joined Nov 2019 | Status: Member | 2 Posts
Quoting MoshiM
Disliked
{quote} I assume your question is addressed to the original thread creator so I can't help you there if your interested in their file, but the link I posted in this thread {also found on my profile} links to both an update-able and current COT Excel file. Please note that the update functionality for MAC users is limited as I haven't figured out how to automatically download and extract the contents of a zip file if you've gone several weeks without updating the file but Weekly updates will work just fine depending on your version of Excel {Recently...
Ignored

Thank you Moshi! I got it to work!
  • Post #67
  • Quote
  • Apr 15, 2020 2:44pm Apr 15, 2020 2:44pm
  •  johncena12
  • | Joined Apr 2020 | Status: Junior Member | 2 Posts
anyone has this cot spreadsheet?
Attached Image (click to enlarge)
Click to Enlarge

Name: spread.png
Size: 493 KB
  • Post #68
  • Quote
  • Jun 6, 2020 7:01pm Jun 6, 2020 7:01pm
  •  Bear.J
  • | Joined Mar 2020 | Status: Macro never lies Ω | 17 Posts
Really Grat Work Moshi ! I've watched you COT workbooks and are very brilliant !
Russell lloyd - Macro never lies
  • Post #69
  • Quote
  • Jun 28, 2020 4:53pm Jun 28, 2020 4:53pm
  •  elijahFx
  • | Joined Jun 2020 | Status: Member | 3 Posts
Thanks bro! it will be a great help for me, need to study how to read this tho
  • Post #70
  • Quote
  • Last Post: Aug 23, 2020 3:46am Aug 23, 2020 3:46am
  •  hasanaali
  • | Joined Apr 2020 | Status: Junior Member | 1 Post
Quoting johncena12
Disliked
anyone has this cot spreadsheet? {image}
Ignored
do you find this cot spreadsheet? plz share
  • Trading Discussion
  • /
  • COT Excel Tool - desegregated data
  • Reply to Thread
    • 1 23 Page 4
    • 1 23 Page 4
0 traders viewing now
Top of Page
  • Facebook
  • Twitter
About FF
  • Mission
  • Products
  • User Guide
  • Media Kit
  • Blog
  • Contact
FF Products
  • Forums
  • Trades
  • Calendar
  • News
  • Market
  • Brokers
  • Trade Explorer
FF Website
  • Homepage
  • Search
  • Members
  • Report a Bug
Follow FF
  • Facebook
  • Twitter

FF Sister Sites:

  • Metals Mine
  • Energy EXCH
  • Crypto Craft

Forex Factory® is a brand of Fair Economy, Inc.

Terms of Service / ©2021