Closed

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

Sector

Thanks

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

See more: yahoo finance programming, vba yahoo finance, website price quotes, visual programming website, visual basic programming code, vba with, vba programming using excel, vba get data website, vba excel programming, start php programming, quotes programming, programming data, programming symbol, programming quotes, programming meaning, programming change, price building website, php visual programming, php programming price, paid programming, excel vba macro programming, excel programming vba, vba programming finance, vba time, vba right

About the Employer:
( 0 reviews ) United States

Project ID: #2511892

6 freelancers are bidding on average $167 for this job

srinichal

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

$180 USD in 8 days
(109 Reviews)
7.0
rajibdebslg

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

$120 USD in 10 days
(32 Reviews)
4.6
gshiels

Please see PM

$350 USD in 5 days
(2 Reviews)
4.0
aaronshawpro

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)
1.0
jus4ujith

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)
0.0
ankurb43

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

$150 USD in 5 days
(0 Reviews)
0.0