By crick on
I have installed the stockapi module and the stock module on my site. I was wondering if anyone who might be familiar with the stockapi module could help me out on what i'd like to do with it.
Currently, when the cron is run, stockapi updates the information in the fields current_price, change_amt, opening, high, low, volume, last_date, last_time, and updated. I would like to store all the old information in addition to the new information. So if the module is configured to fetch new data every 10 minutes, at the end of every trading day the database would have 40 new sets of the above mentioned fields for each stock symbol.
Any insight into this would be greatly appreciated.
Comments
i think what i need to do is
i think what i need to do is have the stock module create a new table for every new symbol that is looked up, and that table contain the fields that will be updated. is it possible to created tables within tables or are my stock symbol tables going to have to be located in the main table list of the database?
Sorry if I say some dumb things, I know very little about mysql and php.