Yahoo Finance Options Data Scraper (Python or Straight into GSheets)

I need a python programmer to write a simple program to extract stock price data and accompanying call and put option prices from Yahoo finance. I expect your python library to be able to take a list of symbols (from 50 to 150 symbols) and go ahead to download the stock data and option data, for that day, from Yahoo finance for each given symbol, and extract the ‘call’ option chains for different expiration dates and different strike prices. You could check link to have an idea of what data you are downloading: Stock Data: [login to view URL] Options Chain Data: [login to view URL] [login to view URL] I would recommend using YQL or the ystockquote API to download the Yahoo stock data. It is available at [login to view URL] For downloading the call options chain data, I would also recommend using YQL. When the contract is awarded I will provide more precise information on the stock data I wish to retrieve and what call options chain data I wish to retrieve. I will provide the logic for which call options I wish to download (e.g. expiry month, strike price, etc…) On the delivery, I expect you to use regular expression or any other robust method to parse the data in a robust way and please raise an exception if anything goes wrong (for example, your code fails to download the page or your regular expression fails to parse the data). Finally, please document your code about input, output, exceptions raised in your code etc., and make your parsing code easier to accommodate future changes. Upon retrieval of the stock and call options data, I want it written to a csv file database called residing in the same location as the python files. Both tables combined have less than 20 columns. I will run this python program 3 times per day. The python program must not require any arguments. Please include your code a unit test for the following cases: - test your code on four symbols with options: yhoo, msft, goog, spy - any other important functions need at least one test to show it works