def queryYtdPerf(sym,dbconn):
today = datetime.date.today()
day_ytd = today.replace(month=1,day=1)
#day_ytd = jan1-datetime.timedelta(days=1)
#print sym,day_ytd,today
p0=stockeod.getClosePriceS(sym,day_ytd,dbconn)
if p0==None:#BABA ipo at 2014-9-19
p0=stockeod.getClosePriceB(sym,day_ytd,dbconn)
p1=stockeod.getClosePriceS(sym,today,dbconn)
chg=(p1-p0)*100/p0
return chg
def queryOneDatePerf(sym,thedate,dbconn):
dayago = thedate-datetime.timedelta(days=1)
p0=stockeod.getClosePriceS(sym,dayago,dbconn)
p1=stockeod.getClosePriceS(sym,thedate,dbconn)
chg=(p1-p0)*100/p0
return chg
