ShareData.py 文件源码

def Cetop(self):
        tdate=[]
        Cetop=[]
        dfxjllb = Tools().ReadSqlData(self.name+"_sina", "xjllbdata")
        dfgg = self.sharedf
        for x in range(0,len(dfxjllb.index)):
            if dfxjllb.loc[x,u'????'][4:] == "0331":
                tdate.append(int(dfxjllb.loc[x, u'????'][:4]+"0430"))
            else:
                if dfxjllb.loc[x, u'????'][4:] == "0630":
                    tdate.append(int(dfxjllb.loc[x, u'????'][:4] + "0831"))
                else:
                    if dfxjllb.loc[x, u'????'][4:] == "0930":
                        tdate.append(int(dfxjllb.loc[x, u'????'][:4] + "1031"))
                    else:
                        if dfxjllb.loc[x, u'????'][4:] == "1231":
                            tdate.append(int(str(int(dfxjllb.loc[x, u'????'][:4]) + 1) + "0430"))
                        else:
                            tdate.append(numpy.NaN)
        dfxjllb['tdate']=tdate
        for x in range(1,len(dfgg.index)+1):
            Cetop.append(float(dfxjllb[dfxjllb[u'tdate']<int(str(dfgg.loc[x,u'date']).replace('-',''))].iloc[0,15:16])/dfgg.loc[x,u'traded_market_value'])
        dfgg['Cetop']=Cetop                                                                                        #
        return dfgg[['date','Cetop']]