Tâche terminée
Temps d'exécution 19 jours
Spécifications
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!
Répondu
1
Évaluation
Projets
124
34%
Arbitrage
32
13%
/
75%
En retard
53
43%
Gratuit
2
Évaluation
Projets
396
63%
Arbitrage
70
53%
/
26%
En retard
198
50%
Gratuit
3
Évaluation
Projets
17
18%
Arbitrage
5
0%
/
60%
En retard
9
53%
Gratuit
4
Évaluation
Projets
0
0%
Arbitrage
0
En retard
0
Gratuit
Informations sur le projet
Budget
50 - 150 USD