def get_month_maxdate(stockno):
try:
sql = "select max(date) maxdate from stock_month_data where code='"+stockno+"'"
conn = MySQLdb.connect(host='localhost',user='******',passwd='123456',db='stock')
cursor = conn.cursor()
n = cursor.execute(sql)
maxdate = ''
for r in cursor:
maxdate = r[0]
cursor.close()
conn.close
if maxdate=='':
stockDf =ts.get_stock_basics()
sssj = str(stockDf.ix[stockno]['timeToMarket']) #上市日期YYYYMMDD
return dateutil.convertDate(sssj)
return dateutil.get_next_day(maxdate)
except Exception,e:
print e.message
def get_qfq_maxdate(stockno):
try:
sql = "select max(date) maxdate from stock_qfq_data where code='"+stockno+"'"
engine = create_engine('mysql://*****:*****@127.0.0.1/stock?charset=utf8')
#df.to_sql('inst_detail', engine, if_exists='append')
conn = MySQLdb.connect(host='localhost',user='******',passwd='123456',db='stock')
cursor = conn.cursor()
n = cursor.execute(sql)
maxdate = ''
for r in cursor:
maxdate = r[0][0:10]
cursor.close()
conn.close
if maxdate=='':
stockDf =ts.get_stock_basics()
sssj = str(stockDf.ix[stockno]['timeToMarket']) #上市日期YYYYMMDD
return dateutil.convertDate(sssj)
return dateutil.get_next_day(maxdate)
except Exception,e:
print e.message
