EA - MySQL Tick Data Collector - MT4

专家 积分

工作已完成

执行时间19 天

指定

I am looking for a tick data collecting EA that is able to store tick data into a MySQL database. I am looking to collect tick data from 28 pairs, so I would like it so that the EA only be run on one chart and not every single pair so save computing power, time and energy. 

My database is named "tick_data" and is stored in D:\MySQLdata\tick_data. I have made 28 individual tables to store the tick data, one for each pair. The tables are named after the instrument pair (all lowercase) it is meant to store (for example: eurusd, audjpy, nzdcad, etc). The settings, with the exception of "jpy" pairs, are (date int(8), time int(6), bid decimal(6,5), ask decimal(6,5));. For "jpy" tables, the datatype for the bid and ask are slightly different (date int(8), time int(6), bid decimal(6,3), ask decimal(6,3));. I would like the date to be store in the format of 'ddmmyyyy' and time as 'hhmmss'. As an example it would look something like this:

INSERT INTO eurusd
(date, time, bid, ask)
VALUES (07062012, 024152, 1.24931, 1.24940);

The pairs I am looking to collect data from are: 

eurusd
usdjpy
gbpusd
usdchf
usdcad
audusd
nzdusd
eurchf
eurgbp
eurcad
euraud
eurnzd
eurjpy
gbpjpy
chfjpy
cadjpy
audjpy
nzdjpy
gbpchf
gbpaud
gbpcad
gbpnzd
audchf
audcad
audnzd
cadchf
nzdchf
nzdcad

Because some brokers will have abbreviations after the name of the instrument (for example, IBFX micro names their pairs like: EURUSDm, GBPJPYm, etc) I would like the EA to be able to allow the user to be able to manage around that. What I had in mind was to have each instrument as an "Input" when the EA is ran, then the user can enter the broker's name for the pair. For example, the input for "eurusd" for IBFX would be "EURUSDm" (ex. for Alpari it would just be "EURUSD"). This will tell the EA to collect the tick data from the pair "EURUSDm" and store it in table 'eurusd'.

Thanks for reading! 

 

反馈

1
开发者 1
等级
(41)
项目
124
34%
仲裁
32
13% / 75%
逾期
53
43%
空闲
2
开发者 2
等级
(273)
项目
396
63%
仲裁
70
53% / 26%
逾期
198
50%
空闲
3
开发者 3
等级
(7)
项目
17
18%
仲裁
5
0% / 60%
逾期
9
53%
空闲
4
开发者 4
等级
项目
0
0%
仲裁
0
逾期
0
空闲

项目信息

预算
50 - 150 USD