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