Today I present a simple function to extract Earnings Estimates from Yahoo Finance. If you have any questions feel free to leave it in the comments. 

This code uses Python 3 on Windows 8.1 but could be easily adapted for Python 2 by changing the 'urllib' import. 

First we import the necessary packages into our programming environment. 

import pandas as pd
import urllib as u
from bs4 import BeautifulSoup as bs
import warnings

I also suppress warnings for the deprecation warning for the Pandas "Dataframe.convert_objects()"method within the scraper function that follows. 

This function takes the Yahoo Finance URL with our symbol of interest and uses BeautifulSoup to parse the resulting HTML. I also added some formatting code to clean up the readability of the headers. 

def _get_eps_estimates(url):
        html_source = u.request.urlopen(url).read()
        soup = bs(html_source, 'lxml')
        # table
        table = soup.find_all('table', attrs={'class': 'yfnc_tableout1'})
        header = [th.text for th in table[0].find_all(class_='yfnc_tablehead1')]
        header_title = header[0]
        header_cols = header[1:5]
        index_row_labels = header[-5:]
        body = [[td.text for td in'td')] for row in table[0].find_all('tr')]
        body = body[1:]
        df = pd.DataFrame.from_records(body)
        df = df.ix[:, 1:]
        df.index = index_row_labels
        header_cols = pd.Series(header_cols)
        header_cols = header_cols.str.replace(
            'Year', 'Year ').str.replace('Qtr.', 'Qtr. ')
        df.columns = header_cols
        eps_est = df.convert_objects(convert_numeric=True)
    except Exception as e:
    return eps_est

Now let's test the function using the proper URL. I'm using the symbol 'SWKS' in this example.

symbol = 'SWKS'

base_url = r'{}+Analyst+Estimates'.format(symbol)
eps_est = _get_eps_estimates(base_url)

Your output should appear like the following:

Stocks - Pre Earnings Equity Grade (week of 07.21.14)

With the iVC reports showing some preliminary promise, I thought it would be worthwhile to begin tracking any potential predictive ability of the grading system. It's late so it's likely I'll have to update this post with better prose after I get some sleep. See this week's pre-earnings grades below. The reports are available for sale through the shop. 

equity grades_pre earnings week of 7.21.14