Menu
Sister Sites

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

Attachments: COT Excel Tool - desegregated data
Exit Attachments

COT Excel Tool - desegregated data

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.
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!
Thank Hordane!
Attached Image (click to enlarge)
Click to Enlarge Name: error.JPG Size: 187 KB
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?
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.
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
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
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
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
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
  • Post #31
  • Quote
  • Edited at 2:32pm May 25, 2012 2:17pm | Edited at 2:32pm
I was given this link by a fellow trader. This is some awesome stuff, thanks for sharing your hard work.
appreciate your work Hordane
Enter Signature
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?
  • Post #34
  • Quote
  • Edited at 11:42am Sep 13, 2012 11:27am | Edited at 11: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 ---
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 Images (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
  • Post #36
  • Quote
  • Edited Sep 17, 2012 6:32am Sep 16, 2012 4:16pm | Edited Sep 17, 2012 6: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 ---
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
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
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
thank you so much Bro, my problem is solved.
God be whit you.
0 traders viewing now