def run_strategy(smaPeriod): host='149.171.37.73' userName='******' password='******' database='sydneyexchange' cnx = mysql.connector.connect(); pandasResult = None try: #get cnx used for connecting DB cnx = connectMysqlDB.cnxStock(host=host,userName=userName,password=password,database=database).connect() #write anything you want to do in the workingSpace pandasResult = workingSpace(cnx) finally: cnx.close() #print pandasResult # Load the yahoo feed from the CSV file #feed = yahoofeed.Feed() #feed.addBarsFromCSV("orcl", "orcl-2000.csv") instrument = 'orcl' #df = data.DataReader(instrument, 'yahoo', datetime.datetime(2011,1,1), datetime.datetime(2012,1,1)) feed = pandas_feed_mysql.DataFrameBarFeed(pandasResult, instrument, barfeed.Frequency.DAY) #print feed # Evaluate the strategy with the feed. myStrategy = MyStrategy(feed, "orcl", smaPeriod) myStrategy.run() print "Final portfolio value: $%.2f" % myStrategy.getBroker().getEquity()
def collectData(): host='149.171.37.73' userName='******' password='******' database='sydneyexchange' cnx = mysql.connector.connect(); try: #get cnx used for connecting DB cnx = connectMysqlDB.cnxStock(host=host,userName=userName,password=password,database=database).connect() # collecting IBM historical data sql = ('select Date , AdjClose, (Volume * AdjClose / Close) AdjVolume from newyorkexchange.aapl_historicalquotes_newyork where Date > \'2010-1-1\'') df = connectMysqlDB.query(cnx).pandasQuery(sql) finally: cnx.close() return df
def main(): # set connection info host='149.171.37.73' userName='******' password='******' database='sydneyexchange' cnx = mysql.connector.connect(); try: #get cnx used for connecting DB cnx = connectMysqlDB.cnxStock(host=host,userName=userName,password=password,database=database).connect() #write anything you want to do in the workingSpace workingSpace(cnx) finally: cnx.close() print ("finish")
''' # import mysql.connector import connectMysqlDB # from mysql.connector import cursor # import pandas as pd # import pandas.io.sql as psql import pylab as p host='149.171.37.73' userName='******' password='******' database='sydneyexchange' cnx = connectMysqlDB.cnxStock(host=host,userName=userName,password=password,database=database).connect() sql = ("SELECT * from aac_historicalquotes_sydney") df = connectMysqlDB.query(cnx).pandasQuery(sql) print(df.head(100)) df['Open'].hist() p.show() train_data = df.head(100) test_data = df.head(); cnx.close() #cnx = mysql.connector.connect(user='******', password='******', host='149.171.37.73', database='sydneyexchange') # cursor = cnx.cursor()