Tick Data To OHLC data converter

I have a a large amount of currency tick data stored in an SQL server database as well as text files.

I need this data converted into a higher time frame for creating open, high, low , close (OHLC) charts.

The program will take the data in a format of :

01/01/04 07:43:01 1.258700 1.259700

01/01/04 07:47:51 1.258500 1.259500

01/01/04 17:46:14 1.258600 1.259600

and create OHLC bars of a specified time frame. The time frames will vary from 1 min to daily.

## Deliverables

I would like the program to work like this.

1. Read the tick data from the SQL server data base.

The table structure is as follows.

ID (Int)



PriceDateTime (datetime)

2. Process the data to form a complete bar with the OHLC and close Bid, close Ask values data structure.

Have an option to build a bar of any time frame from the following time frames.

1 min, 5 min, 15min, 30min, 1hr, 3 hr, 4hr, 1 day,

The 1 day bar will need to start at [url removed, login to view] for each day

The 3 hr bar will need a start time of 00:00

3. Once we have the complete bar save it a new table in the sql server data base with a format of PriceDateTime, O, H, L , C, Bid, Ask.

-Things to consider. There may not be a tick for each exact open or close. e,g The 1 day bar open at [url removed, login to view] but the closest tick may be 3.59am. If this is the case we need to choose the closest tick to use as the open. This may be the same for other time frames as well.

Any other questions/suggestion let me know.

Habilidades: PHP

Veja mais: sql ohlc, tick data ohlc, ohlc, tick data ohlc converter, tick ohlc, sql ohlc tick, tick data converter, use of data structure, table data structure, questions of data structure, process data structure, new data structure, need of data structure, data structure with c, data structure questions, data structure in, c with data structure, c data structure, c and data structure, basic of data structure

Acerca do Empregador:
( 27 comentários ) East Victoria Park, Australia

ID do Projeto: #3665346

Concedido a:


See private message.

$127.5 USD em 17 dias
(60 Comentários)

4 freelancers estão ofertando em média $175 nesse trabalho


See private message.

$382.5 USD in 17 dias
(6 Comentários)

See private message.

$106.25 USD in 17 dias
(14 Comentários)

See private message.

$85 USD in 17 dias
(7 Comentários)