Menu
Sister Sites

Options

Bookmark Thread

First Page First Unread Last Page Last Post

Print Thread

Similar Threads

MT4 to Excel through Excel RTD (Finally!) 560 replies

COT Data Excel linked to MT4 Indicator 1 reply

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

Spread tool in excel 0 replies

COT data to Excel. 4 replies

Attachments: COT Excel Tool - desegregated data
Exit Attachments

COT Excel Tool - desegregated data

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
Quoting Jeff59FX
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
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.
Quoting MoshiM
{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...
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!
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
Quoting swayyy
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!
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.
Quoting MoshiM
{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...

Thank you Moshi! I got it to work!
anyone has this cot spreadsheet?
Attached Image (click to enlarge)
Click to Enlarge Name: spread.png Size: 493 KB
Really Grat Work Moshi ! I've watched you COT workbooks and are very brilliant !
Russell lloyd - Macro never lies
Thanks bro! it will be a great help for me, need to study how to read this tho
Quoting johncena12
anyone has this cot spreadsheet? {image}
do you find this cot spreadsheet? plz share
  • Post #71
  • Quote
  • Last Post: Jun 8, 2021 9:09am Jun 8, 2021 9:09am
I'm getting Visual basic runtime error 13.
0 traders viewing now