EA - MySQL Tick Data Collector - MT4

ClarkFX 2012.06.27 10:04 50 - 150 credits

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!

Experts, Integration

Job completed in 19 days. The portfolio of EricHe contains 221 finished jobs. This developer received 155 feedbacks with an average rate of 4.90.
Do you want to place a new order for EricHe?

MQL4_ORG 2012.06.27 12:05 150 credits from 3 to 5 day(s)

Hello, i can help

EricHe 2012.06.27 12:34 < 150 credits to 10 day(s)

Hi,

I can do this job.

Below is some of the feedbacks from my customers at https://login.mql5.com/en/users/EricHe/feedbacks.

infarm: Each job gives me more confidence in EricHe. Doesn't give up the job until it works as wanted, even if there is little money to loose. Great programmer!! 2012.03.29

infarm: Great programmer. Developes the job as wanted. I recommend him. 2012.03.27

Vos77: My difficult Mql5 modifications were completed on time and without fault. Perfect... Thanks Eric. 2012.03.19

DXanatos: Your willingness to spend time in a meticulous manner to accomplish and bring to life a new form of trading analysis leaves us at a loss for words to describe the gratitude our team has for your contributions. You have set a benchmark by which all other programmers and developers should be measured. 2012.03.18

ghost_jc: Fantastic work on my Zig Zag EA. Work accordingly to my requirements. Will look forward to work with Eric again soon. 2012.03.16

DXanatos: Have been working with EricHe for 5 months, he has earned customer loyalty with his attention to detail and focus superior programming skills... Great Job 2012.03.13

DXanatos: Excellent Work, First Rate all the way.... 2012.03.06

avalon123: Thanks a lot for an excellent job , eriche is a high level programmer, he is not only delivered his work at the time in a professional manner ,but he made an extra parameters which was helpful, without an extra charge,and he is very cooperative and patient ,I give him a five star,and I highly recommend eriche for any programming job, I will be happy to deal with him in the future,thank you. 2012.02.29

porschepilot: Excellent work - Eric meets highest Professional standards in his programming. I can highly recommend working togehter with him. 2012.02.16

stelmar1: Eric understood the details of my requirement and produced an indicator which meets all those requirements well. 2012.02.16

bc678: Thanks to Eric for develope my EA. He is supportive & should look for him on other EA or additional tasks. 2012.01.27

infarm: Good programer, Indicator works as wanted; I can recomend him. 2012.01.24

DXanatos: Just when I think I can't be amazed or impressed any more by Eric's professionalism and tireless dedication to his work, his craft, and his clients; he continues to amaze me. My sincerest gratitude..... 2012.01.21

ghost_jc: Thank you Eric for delivering my EA request as per requirement. Will definitely look forward to your services in the near future

Regards
Eric

Igormq5 2012.06.27 13:20 > 150 credits from 3 day(s)

Ready to delivering the full solution.

d4y47 2012.07.25 09:05 > 100 credits from 5 day(s)

I can do this.

To add comments, please log in or register

	_Techno_	514
	Wahoo	457
	abolk	256
	avoitenko	224
	EricHe	221
	artem_kononov	217
	MrGold166	198
	Im_hungry	184
	Wex	163
	valeryk	144
all developers

Order MQL5 Programs from professional developers

/ EA - MySQL Tick Data Collector - MT4 [finished]

Top developers