Create an MT4 EA that will be attached to a Chart and will provide an ability to invoke a utility to analyze history of transactions on pressing Start button. EA will display following text on the MT4 Chart



Input: Excel file - History of Forex Trade transactions with following columns
* Open Date
* Close Date	
* Symbol	
* Action	
* Lots	
* SL	
* TP	
* Open Price	
* Close Price	
* Pips	
* Profit	
* Duration (DD:HH:MM:SS)	
* Gain

EA Settings
* Leverage (500)
* Source Pair Suffix (like _raw)
* Target Pair Suffix

Objective: Analyze the transactions and generate statistics as follows:
1. For every trade: find the maximum drawdown in Currency % 
2. For all trades together: find the daily drawdown in Currency %
a. Calculate maximum daily and the average.
b. Create separate Excel sheet for the data.
3. For all trades together: find the margin used daily in Currency $ (using given leverage)
a. Calculate maximum daily and the average.
b. Create separate Excel sheet for the data.
Output excel will have the following sheets.
a. Input – history of transactions + Max drawdown of each trade + Max Margin Used for each trade
b. Summary – Statistics
a. Transactions
b. Leverage
c. Max Drawdown in a Day
d. Avg Drawdown in a Day
e. Max Margin Used in a Day (since the beginning)
f. Avg Margin Used in a Day (since the beginning)
g. Profit Loss Ratio % (Ratio of profit vs loss transactions)
c. Daily Drawdowns – since the beginning (for very date since the beginning except weekends)
d. Daily Margin Used – since the beginning (for every date since the beginning except weekends)

Other Conditions:
* Source or target pairs may have suffix. Code needs to take care of that (if there is any suffix used for forex pairs in the input file or the target account)
* Code should be generic to handle all kinds of Forex pairs & CFD symbols.
* Excel output file will use input file name and suffix ‘_o’. If the file exist then add numbers to ‘_o’ as _o1, _o2, etc.
* Provide steps to calculate % gain/loss for a single transaction from a sample file (XAUUSD, GBPUSD or EURUSD)
* Use appropriate comments & error in the code
* I will need source code files for all the code
* I will provide additional input files for testing