goog["EMA5"] = talib.EMA(goog["Close"], 5) #64 goog["EMA10"] = talib.EMA(goog["Close"], 10) #65 goog["EMA15"] = talib.EMA(goog["Close"], 15) #66 goog["EMA20"] = talib.EMA(goog["Close"], 20) #67 goog["EMA50"] = talib.EMA(goog["Close"], 50) #68 goog["EMA100"] = talib.EMA(goog["Close"], 100) #69 goog["EMA200"] = talib.EMA(goog["Close"], 200) #72 goog["maxopen"] = talib.max(goog["open"], 60) #72 goog["maxclose"] = talib.max(goog["Close"], 60) #72 goog["maxhigh"] = talib.max(goog["high"], 60) #72 goog["maxlow"] = talib.max(goog["low"], 60) #72 goog["maxvol"] = talib.max(goog["volume"], 60) #72 rev_goog = goog.sort(ascending=0) rev_goog2 = rev_goog[:2500]#.to_string() counter = 0 #for quote in rev_goog2: for quote in rev_goog2.itertuples(): if counter > 0: #print len(quote) #for i in range(0, len(quote)): # print quote[i] #print quote sql3 = "INSERT INTO `stock`.`stock_new` (`ticker`, `qdate`, `open`, `high`, `low`, `close`, `volume`, `adj_Close`, `NDC`, `close_1`, `close_2`, `close_3`, `close_4`, `close_5`, `close_6`, `close_7`, `close_8`, `close_9`, `close_10`, `Open_1`, `Open_2`, `Open_3`, `Open_4`, `Open_5`, `Open_6`, `Open_7`, `Open_8`, `Open_9`, `Open_10`, `High_1`, `High_2`, `High_3`, `High_4`, `High_5`, `High_6`, `High_7`, `High_8`, `High_9`, `High_10`, `Low_1`, `Low_2`,`Low_3`, `Low_4`, `Low_5`, `Low_6`, `Low_7`, `Low_8`, `Low_9`, `Low_10`, `Volume_1`, `Volume_2`, `Volume_3`, `Volume_4`, `Volume_5`, `Volume_6`, `Volume_7`, `Volume_8`, `Volume_9`, `Volume_10`, `SMA5`, `SMA10`, `SMA15`, `SMA20`, `SMA50`, `sMA100`, `SMA200`, `EMA5`, `EMA10`, `EMA15`, `EMA20`, `EMA50`, `EMA100`, `EMA200`) VALUES (" sql3 = sql3 + "\"" + str(ticker[0]) sql3 = sql3 + "\", \"" + str(quote[0]) + "\"" #sql3 = sql3 + ", " + str(quote[1]) + ", " + str(quote[2]) + ", " + str(quote[3]) + ", " + str(quote[4]) + ", " + str(quote[5]) + ", " + str(quote[6]) + ", " + str(quote[7]) + ", " + str(quote[8]) + ", " + str(quote[9]) + ", " + str(quote[10]) + ", " + str(quote[11]) + ", " + str(quote[12]) + ", " + str(quote[13]) + ", " + str(quote[14]) + ", " + str(quote[15]) + ", " + str(quote[16]) + ", " + str(quote[17]) + ", " + str(quote[18]) + ", " + str(quote[19]) + ", " + str(quote[20]) + ", " + str(quote[21]) + ", " + str(quote[22]) + ", " + str(quote[23]) + ", " + str(quote[24]) + ", " + str(quote[25]) + ", " + str(quote[26]) + ", " + str(quote[27]) + ", " + str(quote[28]) + ", " + str(quote[29]) + ", " + str(quote[30]) + ", " + str(quote[31]) + ", " + str(quote[32]) + ", " + str(quote[33]) + ", " + str(quote[34]) + ", " + str(quote[35]) + ", " + str(quote[36]) + ", " + str(quote[37]) + ", " + str(quote[38]) + ", " + str(quote[39]) + ", " + str(quote[40]) + ", " + str(quote[41]) + ", " + str(quote[42]) + ", " + str(quote[43]) + ", " + str(quote[44]) + ", " + str(quote[45]) + ", " + str(quote[46]) + ", " + str(quote[47]) + ", " + str(quote[48]) + ", " + str(quote[49]) + ", " + str(quote[50]) + ", " + str(quote[51]) + ", " + str(quote[52]) + ", " + str(quote[53]) + ", " + str(quote[54]) + ", " + str(quote[55]) + ", " + str(quote[56]) + ", " + str(quote[57]) + ", " + str(quote[58]) + ", " + str(quote[59]) + ", " + str(quote[60]) + ", " + str(quote[61]) + ", " + str(quote[62]) + ", " + str(quote[63]) + ", " + str(quote[64]) + ", " + str(quote[65]) + ", " + str(quote[66]) + ", " + str(quote[67]) + ", " + str(quote[68]) + ", " + str(quote[69]) + ", " + str(quote[70]) + ", " + str(quote[71])+ ")" for x in range(1,71):
if tick_val < 0: text = str(int(tick_val)).replace("-", "Romney+") else: text = "Obama+"+str(int(tick_val)) return text # <codecell> from pandas import lib from matplotlib.ticker import FuncFormatter fig, axes = plt.subplots(figsize=(12,8)) data = group[["poll_date", "obama_spread"]] data = pandas.concat((data, national_data2012[["poll_date", "obama_spread"]])) data.sort("poll_date", inplace=True) dates = pandas.DatetimeIndex(data.poll_date).asi8 loess_res = sm.nonparametric.lowess(data.obama_spread.values, dates, frac=.2, it=3) dates_x = lib.ints_to_pydatetime(dates) axes.scatter(dates_x, data["obama_spread"]) axes.plot(dates_x, loess_res[:,1], color='r') axes.yaxis.get_major_locator().set_params(nbins=12) axes.yaxis.set_major_formatter(FuncFormatter(edit_tick_label)) axes.grid(False, axis='x') axes.hlines(0, dates_x[0], dates_x[-1], color='black', lw=3) axes.margins(0, .05) # <codecell>