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 an MT4 indicator, I want to receive an alert on WhatsApp when the indicator gives a buy or sell signal, I already have an API that will send the message, just send the json with the content, I will pass the API link when I have the proposal: { "symbol": "xauusd", "cellphonenumber": "00000000", "message": "test" }
My Goal: I want to make an EA that makes money using AI.. with zero losses and 100% winning chances and we will continue to upgrade and design the EA until we reach our goal. this could be a long term project
I want a profitable MT4/MT5 with a proven results and test results. Demo and strategy is also an advantage if available. kindly message me if it you have one. The source codes will be demanded when will finally reach a compromise
Trade Mirroring Solution 100 - 150 USD
Hey there! I was wondering if you could help me with copy trading an EA’s action on Cronos markets (uses CTrader) into a prop firm account that I bought with TooOne Trader (uses TradeLocker to execute trades). Actually, I have 3 prop firm accounts with them that I am trying to pass with this particular EA. 1) Each of these 3 accounts is $250,000 (different account numbers that cannot be combined. 2) I currently have
I require an API that links MT5 Data to Excel 1. Data I would like to link is hourly price data for OHLC for Indices and Forex. 2. Ability to input date range. So if I select 2 days and hourly data for GBPUSD, the table will populate in excel (Via an Add-in /API) with 24 rows of which the bottom row is the current live OHLC and hence subject to change until the bar closes 3. I guess this will be via GoogleSheets in
We want to host a trading competition for newer traders where they can trade on demo accounts. We just want to be able to access those demo accounts and to provide a leaderboard (even if the totals are just stored in a database), we can provide the front-end. The idea is to have around 20 participants. Most will be relatively new traders. We are also not a broker, we simply have a few people learning to trade. The
MQL Excel Integration 500 - 750 USD
I am looking for a MQL5 programmer to have Metatrader read my MS Excel signals. There will be a notification CSV/TXT file going from MT to Excel. To let Excel know one of the two orders went live. There will also be a order CSV/TXT file going from Excel to MT. To let MT know of 2 new orders. The order CSV will include 2 orders with Order Type Order buy/sell Order price Order Stop-loss Price Order Target Price Project
Hi I am looking for some developer, who can develop WebPage which can display my open trades position, Trade History and Live Bid/Ask of my Watchlist. Frontend web app for customers/clients where they can login and see (Account info, Watchlist, Positions, History) Control Panel to create users and map user emails to MT5 account numbers etc

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)