more historical data CSV format file can download from this url
neuraltrader - Google Code

betterea - Google Code

historical data in csv format.
FXDD
2005.01.10 - 2008.11.14

AUDUSD CSV files m1 m5 h1 h4
EURCHF CSV files m1 m5 h1 h4
EURJPY CSV files m1 m5 h1 h4
EURUSD CSV files m1 m5 h1 h4
GBPUSD CSV files m1 m5 h1 h4

Creating SQLite3 database from csv files:
1.Export MT4 data to csv file. (script Close_toFile2.mq4)
2.Create SQLite3 database:
$ sqlite3 date4 <444.txt
3.Import csv files in SQLite3 tables:
$ sqlite3 date4 <444_add.txt

Attached Files

	Close_to_File2.mq4 (3.4 KB, 37 views)
	444.txt (2.9 KB, 19 views)
	444_add.txt (1.2 KB, 19 views)

Creating MySql database from csv files:
1.Export MT4 data to csv file. (script Close_toFile2.mq4)
2.Create MySql database:
$ mysqladmin --user='root' --password='botvos' create mt4data1
$ mysql --user='root' --password='botvos' mt4data1 < create1.txt
3.Import csv files in MySql tables:
$ mysqlimport --local --fields-terminated-by=',' --lines-terminated-by='\r\n' --user='root' --password='botvos' --delete --columns='time,open,low,high,close,volume' mt4data1 '/home/barnix/cpp/date2/eurusd/EURUSD240.csv'

Attached Files

	cre1.txt (125 Bytes, 11 views)
	create1.txt (12.6 KB, 11 views)
	imp1.txt (4.2 KB, 10 views)

FXDD Symbolset:
1.Copy forexall.set file to files directory
2.Run SymbolList_fromSet.mq4 script
SYMBOL, POINT, DIGITS, SPREAD, STOPLEVEL, LOTSIZE, TICKVALUE, TICKSIZE, SWAPLONG, SWAPSHORT, STARTING, EXPIRATION, TRADEALLOWED, MINLOT, LOTSTEP,MAXLOT,MARGININIT,MARGINMAINTENANCE, MARGINREQUIRED
USDCHF,0.0001,4,3,4,100000,8.54773912,0.0001,0,-4.95,0,0,1,0.01,0.01,50,0,0,500
GBPUSD,0.0001,4,4,4,100000,10,0.0001,3.4,-5.44,0,0,1,0.01,0.01,50,0,0,752.85
USDJPY,0.01,2,3,4,100000,10.98177026,0.01,-2.7,0,0,0,1,0.01,0.01,50,0,0,500
EURUSD,0.0001,4,2,4,100000,10,0.0001,3.14,-5.49,0,0,1,0.01,0.01,50,0,0,673.55
AUDUSD,0.0001,4,5,4,100000,10,0.0001,10,-14.62,0,0,1,0.01,0.01,50,0,0,333.7
USDCAD,0.0001,4,5,4,100000,8.10372771,0.0001,-6.3,3.15,0,0,1,0.01,0.01,50,0,0,500
EURCHF,0.0001,4,4,4,100000,8.54773912,0.0001,3.23,-8.6,0,0,1,0.01,0.01,50,0,0,673.5
EURGBP,0.0001,4,3,4,100000,15.053,0.0001,0,-2.08,0,0,1,0.01,0.01,50,0,0,673.5
EURJPY,0.01,2,5,4,100000,10.98177026,0.01,4.24,-7.8,0,0,1,0.01,0.01,50,0,0,673.5
EURCAD,0.0001,4,9,10,100000,8.10372771,0.0001,0,-4.2,0,0,1,0.01,0.01,50,0,0,673.5
EURAUD,0.0001,4,8,10,100000,6.669,0.0001,-8.92,3.98,0,0,1,0.01,0.01,50,0,0,673.5
GBPCHF,0.0001,4,9,10,100000,8.54773912,0.0001,2.36 ,-6.17,0,0,1,0.01,0.01,50,0,0,752.75
GBPJPY,0.01,2,9,4,100000,10.98177026,0.01,4.56,-7.87,0,0,1,0.01,0.01,50,0,0,752.75
CHFJPY,0.01,2,4,10,100000,10.98177026,0.01,-2.59,0,0,0,1,0.01,0.01,50,0,0,427.33

MARGINREQUIRED
You want to buy 100,000 Euros with a current price of 1.35 USD, and your broker requires a 1% margin.
Required Margin = 100,000 x 1.35 x 0.01 = $1,350.00 USD.
marginRequired = Lots * MarketInfo(Symbol(), MODE_MARGINREQUIRED);
Maximum Lot Size = AccountFreeMargin() / MARGINREQUIRED
TICKVALUE
Lot to lose 100 points= AccountFreeMargin() / 100 / TICKVALUE

Attached Files

	forexall.set (112 Bytes, 17 views)
	SymbolList_fromSet.mq4 (3.6 KB, 28 views)
	SymbolList_fromSet_mini.mq4 (3.6 KB, 26 views)

3.Import csv file to Mysql
a.)
Create tables Symbols_Normal and Symbols_Mini
mysql --user='root' --password='botvos' mt4data1 < create2.txt
b.)Import csv data
mysqlimport --local --verbose --fields-terminated-by=',' --lines-terminated-by='\r\n' --user='root' --password='botvos' --delete --columns='symbol, point, digits, spread, stoplevel, lotsize, tickvalue, ticksize, swaplong, swapshort, start, expiration, tradeallowed, minlot, lotstep, maxlot, margininit, marginmaintenance, marginrequired' mt4data1 '/home/barnix/cpp/date2/Symbols_Mini.csv'

Download MYSql database from:
http://code.google.com/p/betterea/downloads/list

Attached Files

	cre2.txt (126 Bytes, 13 views)
	imp2.txt (745 Bytes, 12 views)

Hi Barna.

Are you still Forward testing your EA?

Regards.

No I stopped the forwrd test.
I have last results:

Attached Images

DetailedStatement.gif (6.9 KB, 673 views)

Attached Files

DetailedStatement.htm (123.0 KB, 21 views)

Hi Barna,
here is a link to my two Indicators, (Sentiment_all_v2 , Sentiment_Cpair_v2 )
set them as post1 on MIG demo, use TF1h , TF5m ,setting 5,2,2 , 144,
crossing white to 0 level in TF5m in direction of TF1h, good entry and exit,
notice, it needs powerfull pc,
OTR
regards.

Spaghetti Indicator !!! (28 Pair Relative Strength )

Attached Images

ej_m5_09.gif (24.6 KB, 626 views)

Attached Files

	Sentiment_Cpair_v2.mq4 (9.0 KB, 79 views)
	Sentiment_Cpair_v2.ex4 (7.3 KB, 47 views)
	Sentiment_all_v2.ex4 (38.9 KB, 63 views)
	Activity_indic_1.mq4 (5.3 KB, 68 views)

Thank You. It is a great work.
Please see in your e-mail inbox my answer.