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()
