Excel spread sheet to calculate probability of profit - repost


I have a stock market trading system that I want some further analysis down on.

I want to know how many trades will be required before I make a profit.

I will provide a list of trades with open date, close date, open price and close price.(can provide more info if required)

What I need to be able to do:

1. Input a date and see what the P&L would be if I started trading at that particular date.

2. How many trades it took before I showed a profit.

3. Calculate what is the minimum number of trades starting at any date before a profit was seen.

4. See what the total return was for the period shown

5. Show the P&L in a chart


1. The trade list contains about 1600 trades but at any one time I can only have 20 trades open.

2. Starting capital will be $100,000 and 5% will be allocated on each trade.

2. Once I have bought the first 20 trades nothing is done until one is sold.

3. Once one is sold the next trade (in date order) is bought. This means we could skip 30 trades before a new one can be bought as we were fully invested prior.

Attached are two files.

1. Shows positions. These are the open and close of the trade on the same line.

2. Shows trades. This is each buy/sell as it happened in date order. Each line shows a buy or a sell.

Skills: Accounting, Data Processing, Excel, Finance, Mathematics

See more: excel spread sheet bought sold profit, calculate probability profit excel, what is a probability, what can i buy and sell for a profit, want excel spread sheet, positions in accounting, p&l analysis excel, p&l analysis, on line market system, on line accounting, make a spread sheet, i want to know accounting, how to make a chart, how to know accounting, data analysis with excel, can 0 be a probability, accounting positions, 3 rules of accounting, how to do data analysis, buy sell on line, accounting price list, trade on market, time sheet, spread, line sheet

About the Employer:
( 0 reviews ) Jakarta, Indonesia

Project ID: #4608099

12 freelancers are bidding on average Rp74230/hour for this job


Highly interested and fully capable to prepare financial dashboard for your trading display all your required fields and profit and loss symbol wise , Please check inbox for details.

Rp87777 IDR / hour
(46 Reviews)

Dear Sir/Madam. Kindly check PM for my bid details. Thanks - Priyal

Rp80000 IDR / hour
(33 Reviews)

I am an Economist graduaded from Athens University of Business and Economics with 4+years experience in financial markets , business and financial analysis.I would be glad to have a chat with pm for furhter details.Tha More

Rp66666 IDR / hour
(9 Reviews)

I am an expert.!!!

Rp76315 IDR / hour
(2 Reviews)

I specialize in developing applications for quantitative finance and I can provide you with the solution.

Rp77777 IDR / hour
(2 Reviews)

Hi, I am experienced and qualified accountant, and working for US based client since last 10 years. I would like to apply for this job postings. I am looking forward to work for you. Thanks US

Rp55555 IDR / hour
(3 Reviews)

Hello, I can help you.

Rp55555 IDR / hour
(2 Reviews)

Depending on how realistic you wish this to be, I've done problems like this in the past. I have over 10 years experience in MS Excel and over 30 years programming experience in 6 computer languages. I also guarantee More

Rp50000 IDR / hour
(0 Reviews)

I have got all the skills you need. My experience in finance, accounting and excel will make me able to fulfill the project perfectly. Sure that if we work together, all goals set by you are accomplished. I have not ye More

Rp30000 IDR / hour
(0 Reviews)

I have previous experience with complicated spreadsheet calculations spread over multiple worksheets, would be eager to assist you with this project.

Rp55555 IDR / hour
(0 Reviews)

Let's start.

Rp88888 IDR / hour
(0 Reviews)


Rp55555 IDR / hour
(0 Reviews)

I'm interrested ..

Rp166666 IDR / hour
(0 Reviews)