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
6 freelancers are bidding on average $167 for this job
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.
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.