Đang Thực Hiện

122875 Create excel spreadsheet

We are looking for an excel whiz.

We need an excel spreadsheet to enter our trades,make certain calculations and graphics and then upload this spreadsheet at the end of each month on our investment fund website for investors to view our results.

We need the following data entries:

-Commodity

-Symbol

-Number Contracts

-Date entry

-Date exit

-Buy/Sell

-Entry Price

-Exit Price

-P&L

-Status

We need the following calculations:

-Total Trades Performed

-Total Profitable Trades

-Total Losing Trades

-Average Win

-Average Loss

-Total Contracts Traded

-Percentage Profitable

-Total Commissions

-R

-R2

We would also like to include charts:

-Bar Chart with % different commodities traded each month

-Bar chart with % profits monthly for past 3 years

All this should be autommatically created based on data entries.

Create rows for an average of 120 trades each month.

If you have experience in this field any suggestions for additional

data,calculations or charts are always [url removed, login to view] looking for an excel whiz

Please include in your bid how we can contact you.

More details and examples will be given on acceptance of bid.

Kỹ năng: Bất kì công việc gì, Nhập liệu

Xem thêm: how we create website, how we can create website, how can l create website, excel whiz, create symbol, buy spreadsheet, p&l experience, whiz, price excel, excel spreadsheet, excel charts, entry l, create spreadsheet, excel website price, excelchart, chart bar chart, create sell, charts excel, excel additional, status create, excel investment, create excel website, website excel spreadsheet, excel price charts, data entry website excel spreadsheet

Về Bên Thuê:
( 14 nhận xét ) Belgium

Mã Dự Án: #1869041

Đã trao cho:

prabirsenuksl

I am a professional in Database management, having experience in Excel, MySql, Access & Oracle.

$55 USD trong 6 ngày
(0 Đánh Giá)
0.0