playing with ipython notebook and yahoo stock data

long_term_growth_10k.py

# -*- coding: utf-8 -*-
# <nbformat>2</nbformat>

# <codecell>

import datetime as dt
import pandas as pd

# <codecell>

symbol = 'vcadx'
starting_value = 10000

# <codecell>

symbol_pd = pd.read_csv('yahoo-data/' + symbol + '.csv', names=None, index_col='Date', parse_dates=True)
symbol_pd = symbol_pd.sort_index()

# <codecell>

adj_close = symbol_pd['Adj Close']
first_price = adj_close.ix[0]
shares = starting_value / first_price

# <codecell>

adj_close = adj_close * shares

# <codecell>

adj_close.plot()