I want to build an application that will suck down end of day financial trading data, keep the historical data, and calculate certain statistics. I'm doing this mainly because I'm too cheap to pay money for other charting software and to learn to use MySQL.
First, I need to populate the database and I'm wondering if, with a large CSV file of (for example) all of the date, open, high, low, close and volume information for all symbols on the NASDAQ (for a single day), is there a way to have MYSQL create a table per symbol and;
Next, populate each symbol/table with the historical information from something Yahoo!Finance (I have an Excel Marco that will do this sort of)?
Then, each day at 5:00 grab the latest daily end of day file and update the database (each symbols table)?
From this data I will then want to do a bunch of other things but this is a good place to start. Thanks in advance.
First, I need to populate the database and I'm wondering if, with a large CSV file of (for example) all of the date, open, high, low, close and volume information for all symbols on the NASDAQ (for a single day), is there a way to have MYSQL create a table per symbol and;
Next, populate each symbol/table with the historical information from something Yahoo!Finance (I have an Excel Marco that will do this sort of)?
Then, each day at 5:00 grab the latest daily end of day file and update the database (each symbols table)?
From this data I will then want to do a bunch of other things but this is a good place to start. Thanks in advance.
Comment