Excel Application to determine when to Enter and Exit Pair Trading Positions

I will supply a spreadsheet of Closing stock prices for the last 4 years. (250 columns across, 1000 data points (Closing prices) down.) I need someone to create an interface that allows me to enter two stock symbols from the previous page..the application will then perform abunch of functions (Average, St. Deviation, Correlation, etc..) on the pair and using rules I have chosen, determine when over the past 2 years, I would have entered and exited the pair and what type of returns I would have made. All functions are in Excel that we will be using..the only tricky part, (Maybe) will be coding the logic to tell the application when to close a position and calculate the Profit / and or loss on the position. In short, I am looking for a front end to allow me to pick pairs, define rules and determine what the returns would have been on each pair. The only data that needs to be used, and manipulated is closing prices. The only functions that need to be calculated are already standard functions in Excel.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

## Platform

Excel Windows XP

Habilidades: PHP

Veja mais: working positions, pair of points, logic supply, excel form to enter data, application coding prices, coding positions, visual basic form excel, st page on, Pick basic, exit, determine, correlation, software calculate profit, profit loss program program, coding visual basic excel, visual basic excel coding, excel spreadsheet source code, basic excel coding, looking someone php application, profit close, stock spreadsheet excel, application calculate, pick excel, stock excel, correlation code

Acerca do Empregador:
( 8 comentários ) Toronto, Canada

ID do Projeto: #2953808

Concedido a:


See private message.

$127.5 USD em 3 dias
(20 Comentários)

6 freelancers estão ofertando em média $124 para esse trabalho


See private message.

$127.5 USD in 3 dias
(40 Comentários)

See private message.

$85 USD in 3 dias
(9 Comentários)

See private message.

$127.5 USD in 3 dias
(5 Comentários)

See private message.

$106.25 USD in 3 dias
(3 Comentários)

See private message.

$170 USD in 3 dias
(3 Comentários)