FreelanceBölümler

EA which can manage the amount of open position in MT4 from Excel calculations

MQL4 Uzmanlar Entegrasyon

İş tamamlandı

Tamamlanma süresi: 4 gün
Geliştirici tarafından geri bildirim
most wonderful client .
Müşteri tarafından geri bildirim
Thank you Shivam, great work.

Şartname

Dear developer, 

I need an EA which would open* an existing excel file (C:/Book1.xlsm) and read the value of cells in Sheet1: 

   - A1 will represent the calculated (desired) amount of opened position in lots,
   - B1 will show the direction (1 means BUY, -1 means SELL). 

EA should open or close position(s) in MT4 every time Cell A1 or B1 changes their value (recalculated by a formula), in order to adjust the amount of open positions in M4 with Excel calculations. So, there can be 3 possible cases:

   - A1 increases its value => open 1 new position.
   - A1 decreases its value => close one or more positions. Occasionally, some positions will have to be closed partially. Closing order: last opened should close first, etc.
   - B1 (& A1) changes value (direction) => close all opened positions and open 1 new position if A1 > 0. If A1 = 0, no positions should be opened. 


If EA will be attached to EURUSD chart, it will control all EURUSD positions on the account, but it should not interfere with other pairs. EA will be attached to at least 8 pairs, so if it is necessary, I can manually change the magic number or a symbol in EA code (as I will manually change cells location (from A1 to A2) when attaching EA to a second chart, etc.).


Maybe you will find this script helpful, allegedly, it can enable MT4 to exchange data with MS Excel:
https://www.mql5.com/en/forum/25462

*if this is possible, it would be ideal that MT4 can read from an already opened Excel file. 

Thank you and kind regards. 
Ivo

Yanıtlandı

1
Geliştirici 1
Derecelendirme
(68)
Projeler
78
27%
Arabuluculuk
13
31% / 62%
Süresi dolmuş
15
19%
Serbest
Yayınlandı: 4 kod
2
Geliştirici 2
Derecelendirme
(73)
Projeler
132
52%
Arabuluculuk
9
44% / 33%
Süresi dolmuş
63
48%
Serbest
3
Geliştirici 3
Derecelendirme
(219)
Projeler
370
42%
Arabuluculuk
145
17% / 41%
Süresi dolmuş
124
34%
Serbest
Yayınlandı: 38 kod
4
Geliştirici 4
Derecelendirme
(1)
Projeler
16
81%
Arabuluculuk
1
100% / 0%
Süresi dolmuş
2
13%
Serbest
Yayınlandı: 1 makale

Proje bilgisi

Bütçe
50 - 100 USD
Son teslim tarihi
from 7 to 10 gün