Changes to Excel Stockmarket Trading Log

Completed Posted Dec 9, 2010 Paid on delivery
Completed

I have an existing, fully functional stockmarket trading log, designed in Excel. I record the stocks I buy & sell in it. I need some minor changes made to it, including a couple of basic extra features: 1) Add a column that shows the realised % gain/loss for each trade. This is calculated by comparing column D to column K and expressing the difference as a percentage. 2) Show amount of money currently being risked (ie total loss if all open positions hit their stoploss). This is calculated by looking at every row that has a value in D but not K, and then multiplying D minus G by the value of J. 3) Force contents of column B into uppercase

## Deliverables

1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).

## Platform

Must be compatible with all versions of Excel from Excel 97 onwards

Excel Microsoft Access Microsoft Exchange Powerpoint Word

Project ID: #2977376

About the project

10 proposals Remote project Active Dec 10, 2010

Awarded to:

ieinfotech

See private message.

$4.55 USD / hour
(4 Reviews)
2.3

10 freelancers are bidding on average $10/hour for this job

mrrcomputers

See private message.

$22.75 USD / hour
(24 Reviews)
5.0
serkanarslan

See private message.

$13.65 USD / hour
(6 Reviews)
4.0
Virtualworker50

See private message.

$5.46 USD / hour
(14 Reviews)
4.0
ssusavw

See private message.

$10.92 USD / hour
(3 Reviews)
2.9
seenurajan

See private message.

$14.56 USD / hour
(1 Review)
2.0
zshaan07

See private message.

$3.64 USD / hour
(1 Review)
1.2
nithyarajeshg

See private message.

$6.37 USD / hour
(6 Reviews)
0.9
baasvw

See private message.

$10.92 USD / hour
(0 Reviews)
0.0
tcanadayvw

See private message.

$9.1 USD / hour
(0 Reviews)
0.0