Awarded

Get Web live data for excel analysis - option

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]

(webA)

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.

For example:

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.

Skills: C++ Programming, Excel, MySQL, Visual Basic

See more: live data excel, information website, hsi data excel, hsi option data, extract data web, hsi excel data, graph use data, what graph, web page build, top graph, top data, grap on, graph top, for graph, first graph, contract excel, ask excel, a grap, web page open, web hk, webb, weba, top grap, time stamp, save excel

About the Employer:
( 0 reviews ) Hong Kong

Project ID: #1248544

6 freelancers are bidding on average $428 for this job

srinichal

I am an expert in automation and scrapping. I look forward to deliver the same

$520 USD in 8 days
(64 Reviews)
6.5
Fenrir32

Check pmb please

$350 USD in 10 days
(41 Reviews)
5.7
Netkunte

We have experiance in the domain which you have requirement.

$500 USD in 10 days
(3 Reviews)
4.0
rajelensoft

Ready to start. Please see PMB for bidding details.

$400 USD in 7 days
(3 Reviews)
3.7
ahmedsobherfan

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

$250 USD in 2 days
(3 Reviews)
1.6
dimvas

25 years experience in building custom web and desktop applications. Please check PM

$550 USD in 10 days
(1 Review)
3.9