En cours

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.

Compétences : .NET, Programmation C, MySQL

Voir plus : 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

Concernant l'employeur :
( 25 commentaires ) Ahmedabad, India

N° du projet : #1646060

Décerné à :

drobyshev

Hi. I can help you with this task.

50 $ USD en 2 jours
(15 Commentaires)
4.2

3 freelance font une offre moyenne de $110 pour ce travail

abhinitd

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

250 $ USD en 3 jours
(1 Commentaire)
1.9
srisskto

please check private message

30 $ USD en 3 jours
(0 Commentaires)
0.0