COT Excel Tool - desegregated data | Page 2 | Forex Factory

Options

Go to
Permalinks
Print Thread

Similar Threads

MT4 to Excel through Excel RTD (Finally!) 612 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

  • #21
  • Apr 2, 2012 3:53am Apr 2, 2012 3:53am
It a great program. However when I tried to run the COT update it gave me an error on my MAC computer.

From the DEBUG it says, the line NSWFN(Aplication.GetOpenFilename.......etc has an error. Someone in google says that the MAC does not support the command.

What can I do to (something simple that is ) on the Debug that will enable this good tool to work on my MAC.

I would appreciate your assistance.
  • #22
  • Apr 15, 2012 12:32am Apr 15, 2012 12:32am
Anyone update the new files please! How to get old data from CFTC? I was downloaded the files with all 2012 COT data, but the program cannot update this file. Many thank!
  • #23
  • Apr 15, 2012 2:40am Apr 15, 2012 2:40am
Thank Hordane!
Attached Image (click to enlarge)
Click to Enlarge Name: error.JPG Size: 187 KB
  • #24
  • Apr 16, 2012 2:23am Apr 16, 2012 2:23am
Quoting nkune
Anyone update the new files please! How to get old data from CFTC? I was downloaded the files with all 2012 COT data, but the program cannot update this file. Many thank!
How did you produce that bug, what steps did you take exactly?
  • #25
  • Apr 16, 2012 8:39pm Apr 16, 2012 8:39pm
Hi Hordane! It's because Exel version...But I still cannot update data from 03/16/2012 to 04/06/2012.
Could you update new files with latest COT data? I'll post new files with latest data every week for everyone here.
  • #26
  • Apr 18, 2012 8:04am Apr 18, 2012 8:04am
Hello, could you change the file to show data like this picture?
Attached Image (click to enlarge)
Click to Enlarge Name: eur-cot.jpg Size: 126 KB
  • #27
  • Apr 18, 2012 9:01am Apr 18, 2012 9:01am
Quoting nkune
Hello, could you change the file to show data like this picture?
You can select the lines, right click to change line to "column type" or you can select each line and use the menu above to do the same thing.....
Attached Image (click to enlarge)
Click to Enlarge Name: cot chart.jpg Size: 309 KB
Markets are not efficient, rather they are effective - Jones
  • #28
  • Apr 18, 2012 11:03pm Apr 18, 2012 11:03pm
Thank you! I was modified layout just for my trading styles. I only watching the speculative does. For the layout change axis to the right...(sorry my English). Just take a look the picture.
Attached Image (click to enlarge)
Click to Enlarge Name: COT.JPG Size: 131 KB
  • #29
  • Apr 19, 2012 3:09am Apr 19, 2012 3:09am
Quoting nkune
Thank you! I was modified layout just for my trading styles. I only watching the speculative does. For the layout change axis to the right...(sorry my English). Just take a look the picture.
yes, you can change the layout of the axis by selecting the area and "right click" to find the "Format Axis" ..........
Attached Image (click to enlarge)
Click to Enlarge Name: cot chart.jpg Size: 226 KB
Markets are not efficient, rather they are effective - Jones
  • #30
  • Apr 22, 2012 1:20pm Apr 22, 2012 1:20pm
Hi Hordane,

Thanks for your hard work. It is a great tool.

But when I try to add more charts into the worksheet, I cannot enlarge the worksheet to accomodate the new chart. I have to squeeze the chart since the available space is from A:1 to AC:43.

Is there any way to enlarge the space of the worksheet?
Attached Image (click to enlarge)
Click to Enlarge Name: chart.jpg Size: 231 KB
  • #31
  • Edited 1:32pm May 25, 2012 1:17pm | Edited 1:32pm
I was given this link by a fellow trader. This is some awesome stuff, thanks for sharing your hard work.
  • #32
  • May 29, 2012 12:40pm May 29, 2012 12:40pm
appreciate your work Hordane
Enter Signature
  • #33
  • Sep 10, 2012 7:29am Sep 10, 2012 7:29am
came across this while searching for COT analysis,
great effort...
would like to know if you guys are still using this?
any comments on the effectiveness of this tool?
  • #34
  • Edited 10:42am Sep 13, 2012 10:27am | Edited 10:42am
  •  sym
  • Joined Apr 2011 | Status: Working... (too much) :) | 356 Posts
Hi Hordane

thanks for your awesome work but
it looks like the file is corrupted, it can't run macros and import new data. (I use excel 2007)

Could you please reload it???

Thanks
Attached Image (click to enlarge)
Click to Enlarge Name: Senza titolo-1 copia.jpg Size: 52 KB
--- nothing to say ---
  • #35
  • Sep 13, 2012 4:59pm Sep 13, 2012 4:59pm
Quoting sym
Hi Hordane

thanks for your awesome work but
it looks like the file is corrupted, it can't run macros and import new data. (I use excel 2007)

Could you please reload it???

Thanks
Hi Sym,
I too use excel 2007, and I have had no problems. I have re downloaded the file after reading your post, and it is still working fine. The file is definitely not corrupted. I think you may need to adjust your "Macro Security" settings. If you go to the "developer" tab, you will find an option to adjust your Macro settings. (See attached images). However, if memory serves me right, by default, when first installed (excel) the "developer tab" might not be shown. Its is also possible that not all versions of excel 2007 have the "developer" tab. If you don’t have the developer option, you can still access the "macro security" settings by right clicking the "Microsoft office" icon, and selecting "Trust Center" (image also included). I hope one of these fixes will do the job for you, it is definitely a great tool!
Attached Image(s) (click to enlarge)
Click to Enlarge Name: Untitled picture.jpg Size: 191 KB
Click to Enlarge Name: Untitled picture1.jpg Size: 157 KB
Click to Enlarge Name: Untitled picture2.jpg Size: 188 KB
Markets are not efficient, rather they are effective - Jones
  • #36
  • Edited Sep 17, 2012 5:32am Sep 16, 2012 3:16pm | Edited Sep 17, 2012 5:32am
  •  sym
  • Joined Apr 2011 | Status: Working... (too much) :) | 356 Posts
Quoting mzvega
Hi Sym,
I too use excel 2007, and I have had no problems. I have re downloaded the file after reading your post...
Thank you mzvega
I'll try it. :-)


edit: the problem was I didn't install VBA. Now it's OK. thanks
--- nothing to say ---
  • #37
  • Sep 21, 2012 10:23pm Sep 21, 2012 10:23pm
Hi Hordane,

Your worksheet seems to be just the thing I've been looking for. Unfortunately, when I try to run it, I get the following error message:

"Run-time error '91:
Object variable or With block variable not set."

I'm working on Excel 2010.

Do you have any suggestions on how I can fix this problem?

Kind regards,

drofwarc
  • #38
  • May 4, 2013 1:33pm May 4, 2013 1:33pm
hi there

anybody use this file ?
I have some problems when i import new data the cot charts become a straight line in the end .


http://www.pcmupload.com/di/L8VU/untitled.jpg
  • #39
  • May 5, 2013 2:38pm May 5, 2013 2:38pm
Quoting lucifer_ques
hi there anybody use this file ? I have some problems when i import new data the cot charts become a straight line in the end . {image}
It appears you have a gap in your data. It looks like yor missing the cot data from about 3/15/2012 to the current. You can solve that by using the last worksheet in the "COT Excel Tool - desegregated data" called "Historical Data Import". You can download a file of all Data from 2006-2012 and the 2013 to current. Just cut & paste the data of both sheets into one file. (you can add data from one sheet and paste it into the other). Then sort the data by currency, then by date. Then copy the data to line 3 of the "Historical Data Import" worksheet. Do each currency separately. Paste the data, click the "calculate" button, then click "Copy historical data" button, and tell it what sheet to populate with the new data. Click reset and do the next currency. The instructions on the "Historical Data Import" worksheet (last page) should be self explanatory
you can find the historical data files here:
http://www.cftc.gov/MarketReports/Co...ssed/index.htm
Markets are not efficient, rather they are effective - Jones
  • #40
  • May 7, 2013 1:50am May 7, 2013 1:50am
thank you so much Bro, my problem is solved.
God be whit you.
0 traders viewing now