VBA programming with Yahoo finance and website table

I am currently using a vba code to retrive stock options quotes from yahoo finance.

I would someone to change the code to retrive every option chain for every stock or ETF. It takes about 10 seconds to get all the quotes for one symbol. Retriving one at a time. With 3000+ I need a faster way. I also want the data to be stacked meaning the puts side of the option chain below the calls. When viewing option quotes on the Yahoo finance site you can choose between "Expand to Straddle View..." or "Expand to Stacked View...". I want the stacked view for sorting.

I am building a website and think things works run faster if the data goes right to a table on the website bypassing excel.

The code I am using is from [url removed, login to view] (Yahoo)

[url removed, login to view]

I would also like a control to start and stop the macro to only run during market hours.

I would also like to table to retrive attitional data about the underlying stock like: Current price

next date for earning announcment

Dividend amount paid

Dividend date



Skills: PHP, Software Architecture, Visual Basic, Website Design

See more: yahoo finance programming, yahoo data current date vba, yahoo stock earning date vba, vba code download yahoo options quotes, vba yahoo finance, yahoo-finance, website price quotes, visual programming website, visual basic programming code, vba with, vba programming using excel, vba get data from website, vba excel programming, start programming, start php programming, quotes about programming, programming with php, programming with data, programming with c++, programming with c, programming symbol, programming quotes, programming meaning, programming change, price for vba for excel

About the Employer:
( 0 reviews ) United States

Project ID: #2511892

6 freelancers are bidding on average $167 for this job


I look forward to discuss further as I am an expert in similar apps

$180 USD in 8 days
(109 Reviews)

Dear sir, I am ready to start this job. please check PMB.

$120 USD in 10 days
(32 Reviews)

Please see PM

$350 USD in 5 days
(2 Reviews)

Hi, It sounds like an interesting project and I would like to work on it. I can offer you a cheap rate because I am new to the site and would like the experience but I will deliver what you need. Cheers.

$50 USD in 10 days
(1 Review)

Hi.. I would like to work for your project. I am experienced in VBA and have done many projects. Since I am new to this site , I need some jobs in my profile .. I guarantee quality deliverable in the lowest price.

$150 USD in 8 days
(0 Reviews)

Happy to work on this project. Past experience in working, example attached

$150 USD in 5 days
(0 Reviews)