In [206]:

    

import matplotlib.pyplot as plt
from matplotlib.finance import candlestick as candlestick
import pandas as pd
import numpy as np
import csvtodb as DB
%matplotlib


    

    




Using matplotlib backend: TkAgg

In [213]:

    

symbol = "SBIN"
Datframe = DB.obtainQuotes(symbol)
x = Datframe.index.searchsorted(datetime.datetime(2011, 1, 1))
size = 100
imageX = 18.5
imageY = 10.5

fig, ax1 = plt.subplots(1,1)
fig.set_size_inches(imageX,imageY)
Datframe1 = Datframe[x : x + size]
quotes = []
i = 0
for date in Datframe1.index:
    appendline = (i,Datframe1['Open'][date],Datframe1['Close'][date],Datframe1['High'][date],Datframe1['Low'][date])
    quotes.append(appendline)
    i=i+1

Datframe1_mean = pd.rolling_mean(Datframe1['Close'],14)
ax1.plot(Datframe1_mean.values)
candlestick(ax1,quotes, width=0.4,colorup='g',colordown='r', alpha=1.0)
ax1.set_xticks(np.arange(0,size)) 
ax1.set_xticklabels(Datframe1.index,rotation=70)
ax1.autoscale_view()
plt.show()


    

In [ ]: