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.

Entrada de datos Odd Jobs

Nº del proyecto: #1869041

Sobre el proyecto