Attach showing part of the perl code that write stock information to MySQL database. The completed code should able to read input list of stock to monitor from a text file, analyse SGX daily stock price in HTML file and write price and other information into a MySQL database.
At present, the program is able to analyse sgx HTML file and write data into MySQL. But the column alignment is a bit out.
Software used/installed
Perl - version 5.10
DBI
DBD-mysql
Heidi GUI for MySQL
Future work
Create a java program that reads from DB and display previous stock price record.
No comments:
Post a Comment