Closed

Excel expert and data analyst

Hi

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.

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

Skills: Data Entry, Data Processing, Excel, Statistical Analysis, Statistics

See more: need an excel expert to organize some data for me i need t, i need an excel expert to organize some data for me i need to combine a long list of 1000 items into model units etc this is a s, excel expert to organize data, excel expert exploratory data analysis data visualization, excel and data entry analyst pretoria, excel website data download, expert data png excel, data analysis excel expert needed, need excel expert create macro, expert data scraper need pull data, need excel expert match columns, excel expert need simple solution, microsoft excel data analyst, excel expert data analysis, need someone trade forex, excel worksheet data download, excel data analyst, expert data analyst, data analyst excel regression, excel fetch data web site need log, need excel expert, excel currency data download

About the Employer:
( 15 reviews ) Ellerbek, Germany

Project ID: #16506835

45 freelancers are bidding on average €26 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
(235 Reviews)
7.5
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
(130 Reviews)
6.3
€50 EUR in 1 day
(75 Reviews)
5.9
€23 EUR in 1 day
(23 Reviews)
4.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
(5 Reviews)
3.6
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
(13 Reviews)
3.6
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
(8 Reviews)
3.6
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
(8 Reviews)
3.2
sunprah2018

I am an MBA, and ex-investment banker. I assure all my clients a high quality work in a stipulated time period. My skill set includes the following: 1. Business Analysis 2. Financial Analysis 3. PowerPoint Present More

€50 EUR in 1 day
(4 Reviews)
3.4
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
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
(6 Reviews)
1.9
ManeeRauf7

A proposal has not yet been provided

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

Dear Employer, I understand your needs and I will develop excel suitable for your trading purposes. Thank you.

€14 EUR in 3 days
(3 Reviews)
2.1
€23 EUR in 1 day
(3 Reviews)
1.7
showyoung

A proposal has not yet been provided

€9 EUR in 1 day
(1 Review)
1.4
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
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)
1.0
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