All orders
Rules
Specification
Hello,
I will be selecting someone for the job described below based on the clarity of their suggested implementation. Please suggest an approach that you would use if you were creating the tool described for your own use (but take into consideration that the reports required need to be easily analyzed).
I don't know exactly how to design the tool I have in mind and would like your thoughts and opinions on how to get what I want with the best approach you know.
The tool I have in mind will collect data from 5 sources within the MT4 platform, link or export them to either an external web resident database (possibly coded in .net, or php, or ruby on rails) or to a CSV file which would be imported into an Excel macro enabled file which converts the data to a report of the designated elements.
I am not sure of the best solution for data storage and manipulation to produce a report from the data.
What I want is a tool that uses data extracted from the MT4 terminal and 4 different custom indicators to produce "reports" which inform me as the trader what my trading results "mean" in terms of what worked best and what contributed negatively to my results.
I believe the tool should extract the data and then communicate with a database (probably MySQL) and possibly hosted on a VPS (?). It would then need a web application to manipulate the data in the database to produce a report which is the result of analyzing relationships between various elements of the data set.
Here are some details about what I am trying to achieve:
Post Trade Analysis (PTA) Tool Design Parameters
Purpose:
The Post Trade Analysis (PTA) tool’s purpose is to provide the trader with a reliable reporting system which provides insight into the following 5 elements:
1. What are the trader’s actual results?
a. By number of instances
b. By frequency
c. By profit/loss magnitude
d. By clock/calendar reference
e. By chart condition of indicator(s) used at entry/exit
2. Which factors are impacting the trader’s results most positively?
3. Which factors are impacting the trader’s results most negatively?
4. What actions can be taken with greater frequency to improve profitability?
5. What actions can be taken with reduced frequency to improve profitability?
Method:
The PTA will automatically collect and process data from the MT4 platform and several custom designed indicators as its data sources.
The processing performed will consist of relating the appropriate related data points based on their numeric and logical relationships and reporting those numeric and logical relationships as <N> labeled row items formatted into a report, or Excel spreadsheet for the purpose of informed further analysis.
The Data Sources:
1. The MT4 terminal - this is the standard terminal accessed with "control T"
2. The PPP custom indicator - has 6 columns of data which report conditions which exist on the chart, i.e. "range of last 48 bars"
3. The CCI custom indicator - has trend lines of 2 moving averages and a histogram
4. The AMB custom indicator - has SR lines drawn based on specific rules
5. The AFR custom indicator - draws fibos automatically
The Reported Items:
1. General
a. Which pair is most/least profitable?
b. Which direction is most/least profitable?
c. Which order type is most/least profitable? (market, limit, stop)
d. Which exit method is most/least profitable? (automatic, manual)
e. Which hour of the day is most profitable?
f. Which day of the week is most profitable?
g. Which week of the month is most profitable?
h. Which month of the year is most profitable?
i. Median profit in pips?
j. Median profit in $?
k. Median loss in pips?
l. Median loss in $?
m. Gross Win-Loss ratio
n. Distribution % of winners by pair, direction, WTT/CTT, time/calendar of trade, order type
o. Distribution % of losers by pair, direction, WTT/CTT, time/calendar of trade, order type
There are additional elements to a. - o. I would like reported which I will share once you make application for this job.
Thank you for your help in creating the specs for this tool.
Beacon