No automated offers!
Please read below before replying!
I trade in FOREX and I need someone to analyze my trade performance.
You will get my trading data with times for the single trades.
What I am interested in is seeing daily performance compared to the
1. Total exposed margin for the day
2. The max exposed margin during the day.
9 am to 10 am I trade CHF/USD. Margin is 50€ and I close with a profit of 10€
11 am to 1 pm I trade USD/JPY. Margin is 50€ and I close with a profit of 5€.
There are three ways of calculating this:
1. Total margin 100€. Profit 15€. Yield 15%
2. Win first trade 10€ compared to margin 50€ = 20% yield.
Win second trade 5€ compared to margin 50€ = 10% yield
Average yield = (10+20)/2= 15%
3. Since the trades were not at the same time, only max. 50€ was exposed at any given time
So the calculation should be margin 50€ with a win of 15€ so the yield is 30%.
I will need this analysis for around 200 trades first, a sample of a history download is enclosed.
The end-result could look like the performance excel table enclosed, but not necessarily. If you are good at this, you will probably suggest something better.
If you are really good, you might even be able to program excel til filter out the simultaneous open trades.
This first job is very small, but if I am satisfied, I would like to use you on a weekly basis.
I look forward to hearing from you.
43 freelancers are bidding on average €25 for this job
Hello, I am interested in your project. I did a similar kind job for a client. I can start whenever you want. Please send me a message so that we can discuss more. Thanks