I want to start a project for personal use only.
I would like to get the real data from this website
[url removed, login to view]
First, I would like to extract the live data from this web for analyzing the information by excel. Even plot graph for it.
I want to extract the data from the web site with the top 20 high volume of option product vs change in time.
Contract Bid Ask Last Traded High Low Volume Prev. Day Settlement Price Net Change Prev. Day Open Interest
HSI C Oct-11 - 19000 173 200 195 301 180 300 293 -98 4,069
When extract the data of this option, ADD the current time stamp on the following column. At the same time will extract the next web page information for the particular product.
This is next webpage
[url removed, login to view] (webB)
Contract Month Bid Ask Last Traded High Low Volume Prev. Day Settlement Price Net Change Prev. Day Open Interest
HSI Oct-11 18,431 18,436 18,432 18,666 18,333 95,759 18,612 -180 90,476
By only grap the particular products such as HSI Oct-11, Last traded figures and volume with the same Time stamp
Then once the volume changes, the extract data will be taken action again and insert an second row with time stamp, then do calculation on the difference between [url removed, login to view] and Volume.Now. And place it under [url removed, login to view] column. And also grap WebB's information as stated above.
Using those data to add some calculation formula to analysis the detail and plot graph.
For the other top 19 volume products will be the same procedures. And if the top 20 volumes changes during the time, the existing top 20 volume will not be deleted. And build a save function for record the whole activities, and the second day all record will be reset.
That is what I want to do.
Thank you very much.
6 freelancers are bidding on average $428 for this job
Hello, i am expert in programing i can do application to scrape the data from the 2 pages then do the required analysis , save to excel payment after job completion Regards