I'm using Excel 2007 on a Win 7 64-bit PC. I'm an options trader and hence use excel for option chain data analysis from the exchange website. Now the exchange is moving to a new website and shutting down the old website in a month. The new website has a system where it updates the data tables on the page itself without a change in the url. So the first issue is that of no unique url assigned to a particular table and i need at least two different set of data at the same time but they load on the same url on the new website. Secondly, when i tried the new website in EXCEL 2007, the page gets a lot of errors and the data table just doesn't load. I'm assuming that maybe its because of the dated office version that i'm using. The browser in excel 2007 might be unable to load certain new kind of websites. I have provided the links to both the websites and the tables i need to import to excel to analyse them. Both the websites have a EXPIRY DATE drop down menu that display their respective expiry's data. Please check that. Let me know how i can import the data from the new website in Excel and analyse that. Any sort of help is appreciated. And if need be i can update to newer versions of office. In that case please let me know which one's best suited for my needs. Thanks.
Old Website Option Chain & New Website Option Chain
Old Website Option Chain & New Website Option Chain