Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Tue, 23 Apr 2024 22:50:10 +0000
[User Discussion] - COT in Sierra Chart
View Count: 2093
| [2019-01-13 04:53:25] |
| Halco - Posts: 92 |
|
I've seen requests for COT data to somehow be included in SC, I don't think they ever did it. I have a pretty simple way to chart the data in SC and thought I'd share. You can get the data various places, I'm using a program that's actually for MetaTrader 4 that downloads the data every week in CSV format. I won't post a link unless someone requests it because I don't want to be accused of spamming. (I have no association with the program developer.) It was only $40 and really simplifies things so I thought it well worth the price. I setup Excel to import each currency CSV file with only the columns I want. I convert the short positions of the Non-commercials and Commercials to negatives. You set this up once and that's pretty much it. Just update the data in Excel each week, then copy and paste to a SC spreadsheet once a week. The attached chart is the weekly USD-X with Non-commercials in the second pane, plotted from the spreadsheet study. The Commercials are in the third pane, plotted with the Spreadsheet Formula study. I'm still playing around with it but this is the basic setup. The COT graphs in the chart are currently offset by a few weeks because there are no COT reports during the gov shutdown. http://www.sierrachart.com/image.php?Image=1547354691313.png |
| [2019-06-21 20:14:36] |
| User379468 - Posts: 508 |
|
Halco, thank you, could you please share the program/link?
Date Time Of Last Edit: 2019-06-21 20:14:49
|
| [2022-01-26 08:54:18] |
| User146848 - Posts: 120 |
|
Greetings, i am in need of help. I want to work with the cot data in SC. The quandl solution is pure crap. I want to replicate what Halco does...but with LibreOffice. Pls let me know, if you are willing to guide me through the process. THX |
To post a message in this thread, you need to log in with your Sierra Chart account: