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

MQL4 Experts Integration

Job finished

Execution time 4 days
Feedback from employee
most wonderful client .
Feedback from customer
Thank you Shivam, great work.

Specification

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

Responded

1
Developer 1
Rating
(68)
Projects
78
27%
Arbitration
13
31% / 54%
Overdue
15
19%
Working
2
Developer 2
Rating
(73)
Projects
132
52%
Arbitration
9
44% / 33%
Overdue
64
48%
Free
3
Developer 3
Rating
(219)
Projects
370
42%
Arbitration
145
17% / 41%
Overdue
124
34%
Free
4
Developer 4
Rating
(1)
Projects
16
81%
Arbitration
1
100% / 0%
Overdue
2
13%
Free
Similar orders
I have a License system for ea and indicator based on a wordpress plugin which uses a DLL to communicate with the license server. written in c++ The system works fine when running on newer windows OS from win 11 to win 8, but throws the error "Access violation read to 0x00000000" when running on older windows like window 7 and older vps like windows 2012 server R2. I need this issue fixed for the vps to work on all
I want to find a Developer to perform this work and settle payments in this Application. I undertake not to communicate with Applicants anywhere else except this Application, including third-party messengers, personal correspondence or emails. I understand that violators will be banned from publishing Orders in the Freelance service. I have read the Rules of using the Freelance service and accept them. I agree
ICT, SMC, PAMETNI NOVAC KONCEPTI, PAMETNI NOVAC, koncept pametnog novca, podrška i otpor, analiza trenda, radnja cijena, tržišna struktura, blokovi naloga, BOS/CHoCH, blokovi razbijača , pomak momentuma, zona ponude i potražnje/blokovi naloga , jaka neravnoteža, HH/LL/HL/LH, jaz fer vrijednosti, FVG, Zone premije i popusta , Fibonacci retracement, OTE, Likvidnost na strani kupnje, Likvidnost na strani prodaje
I'm looking for someone to help me implement the MetaQuotes web API in Laravel: - Create clients - Create users - Change passwords accounts - Create deposits and withdrawals I'm using a library, but it's only giving me problems
I need the following help wih the set up I have a TradingView paid license I have a script running in TradingView generating Alerts - see a screenshot example Then I have PineConnector which should be able to take those Alerts and deliver to MT4 And then there is MT4 installed with running PineConnector on it Yet somehow I cannot get those Alerts, including Trade set up, from TradingView to MT4. Please let me know if
Hello, I have an existing Expert Adviseo for Metatrader 5 that still contains a few errors. (The MQL5 code is present.) I would like to have these errors fixed. If necessary I would add a few more features to the EA
I need EA which can copy telegram signals to MT5 The EA should have the following 1. take profit 2. take loss 3. Break even 4. trailing stop 5. Stop trading if amount reaches 6. Accept buy stop , sell stop , sell limit and buy limit
I need a tool: Can convert any strategy of PineScript into .mql5 without bugs Automation convert for multiple strategy of PineScript files into multiple .mql5 files Programming can write in Python/C++ I have some PineScripts file to test (in attached files, with their names can find in TradingView -> Indicator -> search by name) I want to backtest all community strategy of TradingView, so that the tool need to be

Project information

Budget
50 - 100 USD
VAT (19%): 9.5 - 19 USD
Total: 59.5 - 119 USD
For the developer
45 - 90 USD
Deadline
from 7 to 10 day(s)