Retrieve stock option data from the web into excel or a csv

I want to provide a column of stock symbols in excel, from american stock exchanges, and retrieve stock option data for each stock. The data will go in a row alongside the stock symbol. For each stock symbol I need to get: Current stock price call option bid price call option ask price strike price strike date I only need one call option bid price, ask price, strike price and strike date (expiry date) for each stock. I want the Call option only, not Puts. The call option should be the longest time frame, or furthest away in days BUT must be less than 8 months away. Typically it will be 4 to 6 months. The call option is to be the first option with a strike price 'out of the money', so if the current price is $10, an 'out of the money' option would have a strike price ABOVE $10, say $11. Here's an example and see attached "table" excel file. I provide the stock symbol TSN. The script should retrieve the following. Current price: $40.03 (can get from yahoo, [login to view URL] or [login to view URL] see below) Looking at the stock options available for TSN (in the link above) we see that there are options expiring in Mar 14 | Apr 14 | May 14 | Jul 14 | Oct 14 | Jan 15 | Jan 16. I want to look at the date furthest away, but less than 8 months. In this case I want to look at the Oct 14 options. Looking at the Oct 14 options, we can see the Call options, and find the first one 'out of the money'. With a current price of $40.03, the Call opiton I need has a strike price of $41.00. From this we can see the current bid price, $2.40 and ask price $2.65. Current stock price $40.03 call option bid price $2.40 call option ask price $2.65 strike price $41.00 (ABOVE current price) strike date October 18th, 2014 (options expire on the 3rd saturday of the month, October 18th, 2014 in this case) There is already a vba script that does something similar, but it downloads too much data for my needs and isn't in the format i need. [login to view URL] Also, all of the stock option data can be downloaded from this site in a table. See attached "data" excel file for an example. [login to view URL] - just enter the stock symbol on the left and click the "list all options..." radio box. To understand the data from the cboe website: 14 Oct 41.00 (TSN1418J41) Call options are on the left side of the table under the "calls" heading TSN is the stock option 1418J is the expiry date, October 18th 2014 (yyddm) A is January, B is February etc. to J for October 41.00 is the strike price $41.00