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.3 Database Name
1.1.4 Table Name
1.2 it should store the settings.
2 Signal Extractor Features
2.1 Extract following values for each data row.
[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.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.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.