Up, what you are trying to do is pushing the boundaries on what a spreadsheet can do. It could be done, but....
A better approach would be to go down the database route for data storage. So this may mean further learning for you. If you're using excel, I assume you have MS Access. It can be a bit of a toy, but is a good place to start laerning. You would then import the daily data into a table and export data as required to excel for graphing and other statistical work. If you really learn access and VB then it can be all done in access.
I assume you'll ultimately want to compare this data with share prices etc. This then is way past the amount of data that access can handle. You'll then need to move onto Oracle (paid for) or MySQL or PostGreSQL (latter two are free open source and better run on Linux/Unix). The learning on access will still be usefull when/if you move to these real database engines. As an example I store the entire ASX for the last 10 years in a MySQL DB with automatic data loading each day.
A final comment, it's great that you are looking at data and learning not only how to use an application like excel but also how to look at what data is available and how you can interpret that data to get meaningful information. It's a long process and sometimes can appear frustrating. Keep up the work and it will reward you in the long run with new skills and a better appreciation of what is happening in the market.
