The Sql Cot report

hello,

i have created a sqlite database with all data since 1986.

it 's the first step in the creation of a little app for study the cot.

the advantage of a sql database in the language sql because it permit to ask easily and quickly the information.

the second step is to provide some helpers function for make a dahboard and i need you for collect all of pertinent information with this database.

for exemple when the non commercial net short cross the non commercial long , we could generate an alert...

so all of your suggestion are welcome.

ps : send me a mp if you want the database. (size about 100 mo).

Thats amazing. always liked the idea of a cot indi but was never happy with some of the versions out there.
Does the data get automatically put onto the sql database?

If so then as you say the next step is to get the data in an mt4 format.

Hanover did a similar thing with the news indi.
he built a database that automatically downloads from external source. the data was called through mt4 by a script. might be a good idea to look into if itll help

regards

yes te data was automatically into the database when the report was posted.

for the moment, i did not plan to realize an mt4 indicator but a stand alone application, because i think it could be more profitable in a more flexible environment.

just an exemple it could be interessent to compare the cot evolution between the gold and the euro. and this kind of thing is not the philosophy of metatrader.

I just finished the same stuff with disaggregared COT data since 2006.

so if somebody want the database send me a pm

url to get the database of 02/09/2011 :
http://pagesperso-orange.fr/cotdata/cot30082011.zip

soon a little app comes with it.

url to get the database of 09/09/2011 :
http://pagesperso-orange.fr/cotdata/cot07092011.zip

url to get the database of 16/09/2011 :
http://pagesperso-orange.fr/cotdata/cot16092011.zip

new low in euro in diff between nonommercial long and non commercial short for 2011

url to get the database of 16/09/2011 :
http://pagesperso-orange.fr/cotdata/cot23092011.zip

new low again in euro in diff between nonommercial long and non commercial short for 2011 (-79460)

url to get the database of 30/09/2011 :
http://pagesperso-orange.fr/cotdata/cot30092011.zip

url to get the database of 04/10/2011 :
http://pagesperso-orange.fr/cotdata/cot04102011.zip

url to get the database of 11/10/2011 :
http://pagesperso-orange.fr/cotdata/cot11102011.zip

url to get the database of 18/10/2011 :
http://pagesperso-orange.fr/cotdata/cot18102011.zip

url to get the database of 25/10/2011 :
http://pagesperso-orange.fr/cotdata/cot25102011.zip

url to get the database of 01/11/2011 :
http://pagesperso-orange.fr/cotdata/cot01112011.zip