Encerrado

trade reporting

Looking to create an excel program that would take futures trading transaction data and convert it into all kinds of statistics and charts with measures daily, weekly, monthly, and year to date.

## Deliverables

statistics required:

starting and ending equity, equity curve chart, %ROC

# and %of trades: total, wins, losses, break-evens

# and % of long trades, of short trades

average win, average loss, largest win, largest loss

avg. time in trade: Total, wins, losses, break-evens, long, short

Risk measures: sharpe ratio, sortino ratio, risk adjusted return

* * *This broadcast message was sent to all bidders on Thursday Nov 26, 2009 12:29:09 PM:

Hello, Thanks to everyone who replied to my bid request. Many of you have asked questions and following is my answers: There is new data to be added every day and comes from csv file from which I would cut the data and paste into the engine. I will attach a sample file for your review. Preferably I could run the engine on both excel 2003 and 2007, but if it's too complicated then just 2007. For the graphs, the equity curve should be plotted as equity over time, and the other statistical measures can be plotted as pie charts and histograms. I can provide the formulas for the Sharpe and Fortino ratios, the other calculations are all fairly straightforward. Let me know if you have any more questions.

Habilidades: PHP

Ver mais: trade engine, time trade, create charts and graphs, all trade, it project management questions and answers, ROC, create charts csv file, excel 2003 pie chart, php excel date convert, convert excel 2007 excel 2003, risk excel, project risk sample, excel 2003 chart, trade day, project management risk management, risk management chart, return time excel, project management risk, trading engine, excel convert daily monthly, statistical review, excel project graphs, excel paste csv, excel convert monthly data daily, create excel formulas

Acerca do Empregador:
( 0 comentários ) Canada

ID do Projeto: #2987940

14 freelancers estão ofertando em média $318 para este trabalho

amcsummers

See private message.

$63.75 USD in 14 dias
(76 Comentários)
5.8
jal540

See private message.

$195.5 USD in 14 dias
(42 Comentários)
5.7
zenecisvw

See private message.

$170 USD in 14 dias
(34 Comentários)
5.0
sanduandrei

See private message.

$255 USD in 14 dias
(6 Comentários)
4.9
SmartProj

See private message.

$425 USD in 14 dias
(1 Comentário)
4.0
tatasthuinfotech

See private message.

$42.5 USD in 14 dias
(13 Comentários)
3.3
acurass

See private message.

$212.5 USD in 14 dias
(3 Comentários)
2.2
fluentcoder

See private message.

$255 USD in 14 dias
(0 Comentários)
0.0
varunvarma

See private message.

$25.5 USD in 14 dias
(0 Comentários)
0.0
muhammadume

See private message.

$4.25 USD in 14 dias
(0 Comentários)
0.0
teachexcel

See private message.

$42.5 USD in 14 dias
(0 Comentários)
0.0
kraut

See private message.

$340 USD in 14 dias
(1 Comentário)
2.8
binaryromelsl

See private message.

$42.5 USD in 14 dias
(0 Comentários)
0.0
softwarepat

See private message.

$2380 USD in 14 dias
(7 Comentários)
0.0