Excel expert and data analyst

Hi

No automated offers!

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.

Example

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.

Erik

( 15 reviews ) Ellerbek, Germany

Project ID: #16506835

43 freelancers are bidding on average €25 for this job

schoudhary1553

Hi there..... Warm Greetings We came along with your request for Excel expert and data analyst and we reviewed your project description. We'd like to help you with confidence and satisfying results. We have pr More

€50 EUR in 1 day
(275 Reviews)
7.6
Tanmoy236

I work as a portfolio manager for a Forex Broker named Exness and I believe i can do a great work for you, I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in differen More

€50 EUR in 1 day
(151 Reviews)
6.4
€50 EUR in 1 day
(88 Reviews)
6.0
€23 EUR in 1 day
(35 Reviews)
5.1
supergana

Hi - I went through the files. The key is to crack the history file. It has data in a semicolon delimited format which i may need to understand with your help. Once done we will be able to automate this stuff quite wel More

€39 EUR in 1 day
(22 Reviews)
4.3
soltecke

Regards, We are dedicated to the development of tools and solutions for SMEs and general users using the powerful excel tool. We also do not dedicate to statistical analysis and data science. We can develop More

€24 EUR in 2 days
(11 Reviews)
3.8
€24 EUR in 1 day
(4 Reviews)
3.8
SunniaImran

Urgent Services of Data Entry Web Search Document Formatting Creating Excel Sheet Microsoft PowerPoint etc …………….. Dear Client: If you are in the searching of right FREELANCER for your project then you a More

€23 EUR in 1 day
(13 Reviews)
3.8
RenPerera

Hi. Im interested in doing the project. I will give you the needed analysis of your FOREX transactions. Looking forward to working with you.

€19 EUR in 3 days
(9 Reviews)
3.2
frwebsolutions

Hi, My name is Fedelito Recillo and I am a full-time freelancer. I see your job post and I am interested. I do believe that with my knowledge, skills and experience I can do the job better than the others. I am w More

€34 EUR in 1 day
(1 Review)
2.9
€23 EUR in 1 day
(5 Reviews)
2.3
ManeeRauf7

A proposal has not yet been provided

€24 EUR in 3 days
(1 Review)
2.0
akmsrkfl

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

€23 EUR in 1 day
(7 Reviews)
2.1
showyoung

A proposal has not yet been provided

€9 EUR in 1 day
(1 Review)
1.8
gmcentenom

Hi! I'm Mauricio, BsC in Industrial Engineering and currently studying Computer Science at University of the People, an US-accredited university and Artificial Intelligence Nanodegree at Udacity. I'm proficient in e More

€29 EUR in 1 day
(1 Review)
0.9
charislim

Dear Sir, This is a really simple solution. All you have to do is create multiple tabs that are recorded on a daily basis and have the first tab as a summary page for the overall performances of each day. That way y More

€14 EUR in 1 day
(1 Review)
0.8
excel4free

Hi, I am an excel enthusiast and like taking up projects which interests me. Would you allow me to help with your requirement.

€24 EUR in 3 days
(0 Reviews)
0.0
Floren98

Hallo, My name is Floren. I am a freelance entry beginner data focusing on Excel, world, and other Microsoft office for the purpose of facilitating input data and can check data to be ready to be informed. I once creat More

€12 EUR in 2 days
(0 Reviews)
0.0
sonisrikant

Hi - I can give better result than the one you uploaded. I myself am a stock trader and will be able to provide you with a excel presentation where you can see your yield on a daily basis, filter profit v/s loss, filte More

€26 EUR in 2 days
(0 Reviews)
0.0
hshahariar123

A proposal has not yet been provided

€23 EUR in 2 days
(0 Reviews)
0.0