Better NN EA development - page 51

 

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'

Files:
cre1.txt  1 kb
create1.txt  13 kb
imp1.txt  5 kb
 

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

Files:
cre2.txt  1 kb
imp2.txt  1 kb
 

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

 

Hi Barna.

Are you still Forward testing your EA?

Regards.

 
odirlei:
Hi Barna.

Are you still Forward testing your EA?

Regards.

No I stopped the forwrd test.

I have last results:

 

Spaghetti Indicator !!! (28 Pair Relative Strength )

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 )

 

Thank You. It is a great work.

Please see in your e-mail inbox my answer.

OnTheRoad:
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 )
 

Nn

Now I am try to do these items:

1- Indic: try to make some indic for my manual tradings, ( the result for two of them are promising )

2- EA : try to make some EA ( not based on NN ), ( now optimizing two of them )

3- NN : train to trade in turning points ( making good training data such as stablized ZigZags or Candle patterns for reversal or continuation etc... ).

 

GBPUSD_.csv

Moving averages for attributes

http://betterea.googlecode.com/files/GBPUSD1_.rar

Files:
 

EURUSD_.csv

Moving averages for attributes

http://betterea.googlecode.com/files/EURUSD1_.rar

Files:
attr2.jpg  43 kb
Reason: