Đang Thực Hiện

Simple .NET application to extract records from db

Extract Stock Signals App

Signal Extractor feature should extract all data row in which sree_signal column has 1 or -1 value stored. it should extract all values of that row and store in new table called stock_signals

1 Mysql DB Connection

1.1 Allow user to set mysql db connection with following values.

1.1.1 Host

1.1.2 Port

1.1.3 Database Name

1.1.4 Table Name

1.1.5 Username

1.1.6 Password

1.2 it should store the settings.

2 Signal Extractor Features

2.1 Extract following values for each data row.

2.1.1 Symbol_id

2.1.2 quote_date

2.1.3 price_open

2.1.4 price_high

2.1.5 price_low

2.1.6 price_close

2.1.7 price_adj_close

2.1.8 volume

2.1.9 L

[url removed, login to view] L_AVG

[url removed, login to view] sree_signal

[url removed, login to view] sree_price

2.2 make symbol_id and quote_date primary key

2.3 Allow user to set whether to scan entire db for signal extraction.

2.4 Extract the data from table called tbl_quote

3 Daily Update

3.1 Everyday the program should update the data by extracting new signals which are stored in db and extract it into stock_signals table.

3.2 Allow user to set time of update for everyday.

3.3 Program should run in windows tray 24/7.

4 Compatibility

4.1 Program should run on Windows Xp, Vista, 7 , server 2003 and server 2008 platform

4.2 Program should be compiled into exe ease of use.

4.3 Connection to db should be closed once daily update is finished.

5 Buy & Sell Signals report

5.1 this will count number of 1 and -1 value of all the rows in stock_signals table and store the result in new table called stock_signal_trend

5.2 Store following data into new table.

5.2.1 date

5.2.2 total_buy = count all stocks which has last signal on or before date is 1 value in sree_signal column.

5.2.3 total_sell = count all stocks which has last signal on or before date is -1 value in sree_signal column.

Kỹ năng: .NET, Lập trình C, MySQL

Xem thêm: vista 20 programming, vista 10 programming, 3.1 .net, windows net application, tray, Extract, db, windows net use username password, mysql net, net app server, daily report app, simple database app windows, sell database application, stocks data, daily application, mysql update values, simple connection, net windows app, result application, mysql windows server 2008, update values mysql, simple table app, extract records, buy sell app, report server net

Về Bên Thuê:
( 25 nhận xét ) Ahmedabad, India

Mã Dự Án: #1646060

Đã trao cho:

drobyshev

Hi. I can help you with this task.

$50 USD trong 2 ngày
(15 Đánh Giá)
4.2

3 freelancer đang chào giá trung bình $110 cho công việc này

abhinitd

Hey, I can start on it right now. I attached my prev work profile. Cheers!

$250 USD trong 3 ngày
(1 Đánh Giá)
1.9
srisskto

please check private message

$30 USD trong 3 ngày
(0 Đánh Giá)
0.0