Đ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: excel whiz, buy spreadsheet, whiz, price excel, excel charts, entry l, create spreadsheet, excel website price, create sell, charts excel, excel additional, status create, excel investment, create excel website, website excel spreadsheet, excel price charts, data entry commodities, excel rows, entry trades excel, data entry charts, data entry chart, excel spreadsheet field, past spreadsheet, entries spreadsheet, create enter

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