FOREX COT Data With Z-Scores | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

Are these good Z-Scores? Which is better? 5 replies

Using trading system expectancy scores 1 reply

EA scores 98% but 1 trade blows it all 11 replies

COT Data 1 reply

COT data question 0 replies

Attachments: FOREX COT Data With Z-Scores
Exit Attachments

FOREX COT Data With Z-Scores

  • #1
  • First Post: Apr 17, 2019 8:00am Apr 17, 2019 8:00am
Is anyone interested in this?

I find the Z-Scores useful

Attached Image (click to enlarge)
Click to Enlarge Name: COT.png Size: 49 KB


Thanks Jack
  • #2
  • Apr 21, 2019 12:23pm Apr 21, 2019 12:23pm
Sure Jack, I am interested in your Z-Scores & COT reports. If you start posting this info, many will follow you. Subscribed. Saw your Z-scores and COT report explanatios in WTI Oil.

Looking forward to your postings.

Regards!
  • #3
  • Apr 21, 2019 7:31pm Apr 21, 2019 7:31pm
Quoting gdpls
Sure Jack, I am interested in your Z-Scores & COT reports. If you start posting this info, many will follow you. Subscribed. Saw your Z-scores and COT report explanatios in WTI Oil. Looking forward to your postings. Regards!
Great! Happy you are getting some value.

I'll be posting my COT reports and Implied Vol data over at https://www.forexfactory.com/showthr...5#post12231495 so you may want to subscribe over there instead.

COT reports every Tuesday and Implied Volatility Tuesdays and Thursdays.

As macro/fundamentals are a big part of my trading I'm hoping a community starts to build that bounces different ideas of each other. I will also have my trading results posted there for proof of profitable macro process.

Thanks for your reply gdpls and good luck with the coming trading week, Keep in touch.

Jack
  • #4
  • Apr 21, 2019 7:47pm Apr 21, 2019 7:47pm
Quoting data.trade
{quote} Great! Happy you are getting some value. I'll be posting my COT reports and Implied Vol data over at https://www.forexfactory.com/showthr...5#post12231495 so you may want to subscribe over there instead. COT reports every Tuesday and Implied Volatility Tuesdays and Thursdays. As macro/fundamentals are a big part of my trading I'm hoping a community starts to build that bounces different ideas of each other. I will also have my trading results posted there for proof of profitable macro process. Thanks for your reply...
Are you manually inputting the statistics from the CFTC website or is your spreadsheet automatically pulling the data from their site?
  • #5
  • Edited 8:25pm Apr 21, 2019 8:10pm | Edited 8:25pm
Quoting NPSystems
{quote} Are you manually inputting the statistics from the CFTC website or is your spreadsheet automatically pulling the data from their site?
Within their weekly releases, the CFTC does not include any form of statistics beyond a basic overview of who owns what and what percentage of Open Interest they account for.
If the intent behind your post was to figure out how to easily get the data from the CFTC into Excel then use of Power Query (available in Excel 2016 and downloadable for 2010 & 2013) via its Web Query function can easily refresh and import the data (message me if you have an older version). Then you can use a macro(if you want to move lots of data to specific Worksheets) or manually copy and paste the data into a separate table (or don't if you wish) and then use a formula to calculate whatever you want.
As an example http://bit.ly/CFTCMM
  • #6
  • Apr 21, 2019 9:10pm Apr 21, 2019 9:10pm
Quoting NPSystems
{quote} Are you manually inputting the statistics from the CFTC website or is your spreadsheet automatically pulling the data from their site?
z-scores are calculated by a spreadsheet but the original data has to be entered in manually. I do plan on having something coded that will pull the data for me automatically. In saying this I have a huge amount of other algos i need to be programmed first that take up much more time and these will take priority.

Thanks for your input I hope my data is of some value.

Jack
  • #7
  • Apr 21, 2019 11:33pm Apr 21, 2019 11:33pm
Interesting topic. Subscribed. Please keep going....
Simplicity is the ultimate sophistication - Leonardo da Vinci
  • #8
  • Apr 22, 2019 6:04am Apr 22, 2019 6:04am
Quoting heispark
Interesting topic. Subscribed. Please keep going....
Great heispark! il be posting all my data over at https://www.forexfactory.com/showthr...5#post12231495

trying to keep it all in the same place.

thanks for the support mate

jack
  • #9
  • Last Post: Apr 23, 2019 8:13am Apr 23, 2019 8:13am
COT and Implied vol has been posted over at https://www.forexfactory.com/showthr...6#post12235326

GBP looks interesting

Thanks
Jack
0 traders viewing now