I finally got the stored proc and the historical price download from Yahoo working. I’m pretty pleased with how it turned out but it takes a while to insert. I inserted every price from August 1988 to today, so it wasn’t an insignificant amount of data but I’m still planning to tweak it to see if I can speed it up.

I also need to clean up the database a bit and make sure the foreign keys are in all of the correct places. I’ve got a table for Stock Info, which contains the Stock ID, the ticker and an ID for the type of security it is (option, equity, future, ect). Then I have a table that stores the price information and it has a reference to the Stock ID that I need to turn into a foreign key.

Now that I’ve finally got data in, I can start playing with the new chart features in MX 7.