Specification
I am looking for metatrader interation with cloud based software platform (something easy to use & easy access like Google SpreadSheet). Preferebly using DLL so that we dont have to key in the url to the webrequest.
The end goal is to use and save data on live.
When the program saving the file to the excel or google sheet, it should save two main element Account detail (1st part) & Trade result (2nd part). This non-tradable EA will only trigger once there are any closing trade.
- Account name
- Acc ID
- Balance
- Equity
- (Balance - Equity) / Balance * 100% = (AKA drawdown %) - Check if the balance is empty or not
- Current Symbol
- Current Timeframe
- Broker time
- Local time
- Broker name
- EA magic number (if dont have then 0)
- EA / Script / indicator name (for testing, make it available as a string input)
- Blank column - To sepererate session (if cant blank then just put a place holder like "-")
- OrderTicket
- OrderOpenTime
- OrderCloseTime
- OrderProfit (in Dollar)
- MAEinDollars
- MFEinDollars
- Holding duration (Close - Open time in minute)
- Holding duration (Close - Open time in hour)
- OrderProfit (in Point)
- MAEinPoints
- MFEinPoints
- TimeOfMAE
- TimeOfMFE
- Blank column - To sepererate session (if cant blank then just put a place holder like "-")
- Parameter list (Source: https://www.mql5.com/en/forum/191721#comment_5693578) - Optional
Input: Download data after Deinit = True;
By default, When the program deinit, it will download the google sheet to local in CSV format. And Print in the expert tab, where is the file location.
Make the program into function that called inside the start(). Soemthing like
int start(){ if(trade has been closed) GoogleSheeet( some parameters ); } void GoogleSheet( some parameters ){ Do something... }
There are the GoogleSheet program is transferable.
Code for Trade result (2nd) part will share privately.
Source code is needed.
Open to any suggestion!
Note: Thep past developer that wroking with me suggested Gogle Dev API (it is not nessary to use it, incase you have better suggestion).