def rowToORM(row): obj = Model() obj.boxOffice = toFloat(row.loc['BoxOffice']) # 实时票房(万) obj.irank = toInt(row.loc['Irank']) # 排名 obj.movieName = toStr(row.loc['MovieName']) # 影片名 obj.boxPer = toFloat(row.loc['boxPer']) # 票房占比 ( % ) obj.movieDay = toInt(row.loc['movieDay']) # 上映天数 obj.sumBoxOffice = toFloat(row.loc['sumBoxOffice']) # 累计票房(万) tsString = str(row.loc['time']) obj.time = None try: obj.time = parse(tsString) minute = obj.time.minute if minute >= 30: minute = 30 else: minute = 0 tsString = obj.time.strftime("%Y-%m-%d %H") tsString = "{pre}:{min:02d}:00".format(pre=tsString, min=minute) obj.time = parse(tsString) except: logging.warning( "Fail to get date from {} from {}. Using {} as Fallback".format( __name__, tsString, obj.time)) if obj.movieName == "其它": return None return obj
def rowToORM(row, year, quarter): obj = Model() obj.code = toStr(row.loc['code']) # 股票代码 obj.name = toStr(row.loc['name']) # 股票名称 obj.year = int(year) # 分配年份 obj.quarter = int(quarter) tsString = str(row.loc['date']) obj.report_date = None try: obj.report_date = parse(tsString) except: logging.warning( "Fail to get date from {} from {}. Using {} as Fallback".format( __name__, tsString, obj.report_date)) obj.nums = toInt(row.loc['nums']) # 基金家数 obj.nlast = toInt(row.loc['nlast']) # 与上期相比(增加或减少了) obj.count = toFloat(row.loc['count']) # 基金持股数(万股) obj.clast = toFloat(row.loc['clast']) # 与上期相比 obj.amount = toFloat(row.loc['amount']) # 基金持股市值 obj.ratio = toFloat(row.loc['ratio']) # 占流通盘比率 return obj
def rowToORM(row, year, month): obj = Model() obj.year = year obj.month = month obj.avgPrice = toInt(row.loc['avgboxoffice']) # 平均票价 obj.avpPeoPle = toInt(row.loc['avgshowcount']) # 场均人次 obj.boxOffice = toFloat(row.loc['boxoffice']) # 单日票房(万) obj.box_pro = toFloat(row.loc['box_pro']) # 月度占比 obj.iRank = toInt(row.loc['Irank']) # 排名 obj.movieName = toStr(row.loc['MovieName'])[0:Model.TEXT_MAX_LENGTH] # 影片名 if obj.movieName == "其他" or obj.movieName == "其它": return None obj.womIndex = toFloat(row.loc['WomIndex']) # 口碑指数 obj.days = toInt(row.loc['days']) tsString = str(row.loc['releaseTime']) obj.time = None try: obj.releaseTime = parse(tsString) except: logging.warning( "Fail to get date from {} from {}. Using {} as Fallback".format( __name__, tsString, obj.releaseTime)) if obj.releaseTime is None: return None return obj
def rowToORM(row): obj = Model() obj.year = int(row.loc['year']) obj.gdp_yoy = toFloat(row.loc['gdp_yoy']) # 国内生产总值 obj.pi = toFloat(row.loc['pi']) # 第一产业献率( %) obj.si = toFloat(row.loc['si']) # 第二产业献率( %) obj.industry = toFloat(row.loc['industry']) # 其中工业献率( %) obj.ti = toFloat(row.loc['ti']) # 第三产业献率( %) return obj
def rowToORM(row): obj = Model() tsString = str(row.loc['date']) obj.exe_date = None try: obj.exe_date = parse(tsString) except: logging.warning( "Fail to get date from {} from {}. Using {} as Fallback".format( __name__, tsString, obj.exe_date)) obj.before = toFloat(row.loc['before']) obj.now = toFloat(row.loc['now']) obj.changed = toFloat(row.loc['changed']) return obj
def rowToORM(row): obj = Model() obj.year = int(row.loc['year']) obj.gdp = toFloat(row.loc['gdp']) # 国内生产总值(亿元) obj.pc_gdp = toFloat(row.loc['pc_gdp']) # 人均国内生产总值(元) obj.gnp = toFloat(row.loc['gnp']) # 国民生产总值(亿元) obj.pi = toFloat(row.loc['pi']) # 第一产业(亿元) obj.si = toFloat(row.loc['si']) # 第二产业(亿元) obj.industry = toFloat(row.loc['industry']) # 工业(亿元) obj.cons_industry = toFloat(row.loc['cons_industry']) # 建筑业(亿元) obj.ti = toFloat(row.loc['ti']) # 第三产业(亿元) obj.trans_industry = toFloat(row.loc['trans_industry']) # 交通运输仓储邮电通信业(亿元) obj.lbdy = toFloat(row.loc['lbdy']) # 批发零售贸易及餐饮业(亿元) return obj
def rowToORM(row, date: datetime): obj = Model() obj.date = date obj.timestamp = date obj.avgPrice = toInt(row.loc['AvgPrice']) # 平均票价 obj.avpPeoPle = toInt(row.loc['AvpPeoPle']) # 场均人次 obj.boxOffice = toFloat(row.loc['BoxOffice']) # 单日票房(万) obj.boxOffice_Up = toFloat(row.loc['BoxOffice_Up']) # 环比变化 ( % ) obj.iRank = toInt(row.loc['IRank']) # 排名 obj.movieDay = toInt(row.loc['MovieDay']) # 上映天数 obj.movieName = str(row.loc['MovieName'])[0:Model.TEXT_MAX_LENGTH] # 影片名 obj.sumBoxOffice = toFloat(row.loc['SumBoxOffice']) # 累计票房(万) obj.womIndex = toFloat(row.loc['WomIndex']) # 口碑指数 obj.pk = "{name}_{date}".format(name=obj.movieName, date=dateTimeToTsStr(date)) return obj
def rowToORM(row): obj = ClassifiedSt() obj.code = toStr(row.loc['code']) obj.name = toStr(row.loc['name']) ts = datetime.datetime.fromtimestamp(row.loc['date'].value / 1000000000) obj.date = ts.date() obj.weight = toFloat(row.loc['weight']) # obj.pk = "{code}_{date}".format(code=obj.code,date=dateTimeToTsStr(ts)) return obj
def rowToORM(row): obj = Model() obj.code = toStr(row.loc['code']) # 股票代码 obj.name = toStr(row.loc['name']) # 股票名称 obj.year = int(row.loc['year']) # 分配年份 tsString = str(row.loc['report_date']) obj.report_date = None try: obj.report_date = parse(tsString) except: logging.warning( "Fail to get date from {} from {}. Using {} as Fallback".format( __name__, tsString, obj.report_date)) obj.divi = toFloat(row.loc['divi']) # 分红金额(每10股) obj.shares = toFloat(row.loc['shares']) # 转增和送股数(每10股) return obj
def rowToORM(row, year, month): obj = Model() obj.code = toStr(row.loc['code']) # 股票代码 obj.name = toStr(row.loc['name']) # 股票名称 obj.year = int(year) # 分配年份 obj.month = int(month) tsString = toStr(row.loc['date']) obj.report_date = None try: obj.report_date = parse(tsString) except: logging.warning( "Fail to get date from {} from {}. Using {} as Fallback".format( __name__, tsString, obj.report_date)) obj.count = toFloat(row.loc['count']) obj.ratio = toFloat(row.loc['ratio']) return obj
def rowToORM(row): obj = Model() tsString = str(row.loc['date']) obj.exe_date = None try: obj.exe_date = parse(tsString) except: logging.warning("Fail to get date from {} from {}. Using {} as Fallback". format(__name__, tsString, obj.exe_date)) obj.loan_type = row.loc['loan_type'][0:Model.TEXT_MAX_LENGTH] obj.rate = toFloat(row.loc['rate']) return obj
def rowToORM(row): obj = Model() obj.year = int(row.loc['year']) obj.m2 = toFloat(row.loc['m2']) # 货币和准货币(亿元) obj.m1 = toFloat(row.loc['m1']) # 货币(亿元) obj.m0 = toFloat(row.loc['m0']) # 流通中现金(亿元) obj.cd = toFloat(row.loc['cd']) # 活期存款(亿元) obj.qm = toFloat(row.loc['qm']) # 准货币(亿元) obj.ftd = toFloat(row.loc['ftd']) # 定期存款(亿元) obj.sd = toFloat(row.loc['sd']) # 储蓄存款(亿元) obj.rests = toFloat(row.loc['rests']) # 其他存款(亿元) return obj
def rowToORM(row, code: str, currentStr: str): tsStr = "{}T{}".format(currentStr, toStr(row.loc['time'])) # timestamp = datetime.fromisoformat(tsStr) # Only for py3.7+ timestamp = parser.parse(tsStr) timestamp = timestamp - timedelta(seconds=TIME_ZONE_OFFSET_SECONDS) typeStr = toStr(row.loc['type']) influxPoint = { "measurement": "share_tick", "tags": { "code": code }, "time": timestamp, "fields": { "price": toFloat(row.loc['price']), "change": toFloat(row.loc['change']), "volume": toInt(row.loc['volume']), "amount": toInt(row.loc['amount']), "type_buy": typeStr == '买盘', "type_sell": typeStr == '卖盘', "type_neutral": typeStr == '中性盘' } } return influxPoint
def rowToORM(row): obj = Model() obj.code = toStr(row.loc['code']) # 股票代码 obj.name = toStr(row.loc['name']) # 股票名称 obj.date = datetime.now() tsString = str(row.loc['ipo_date']) obj.ipo_date = None try: obj.ipo_date = parse(tsString) except: logging.info( "Fail to get date from {} from {}. Using {} as Fallback".format( __name__, tsString, obj.ipo_date)) tsString = str(row.loc['issue_date']) obj.issue_date = None try: obj.issue_date = parse(tsString) except: logging.info( "Fail to get date from {} from {}. Using {} as Fallback".format( __name__, tsString, obj.issue_date)) if obj.code is None or obj.ipo_date is None: return None obj.amount = toInt(row.loc['amount']) # 发行数量(万股) obj.markets = toInt(row.loc['markets']) # 上网发行数量(万股) obj.price = toFloat(row.loc['price']) # 发行价格(元) obj.pe = toFloat(row.loc['pe']) # 发行市盈率 obj.limit = toFloat(row.loc['limit']) # 个人申购上限(万股) obj.funds = toFloat(row.loc['funds']) # 募集资金(亿元) obj.ballot = toFloat(row.loc['ballot']) # 网上中签率( %) return obj
def rowToORM(row): obj = Model() tsString = str(row.loc['month']) strs = tsString.split('.') if len(strs) < 2: obj.year = None obj.month = None logging.warning("Fail to get date from deposit rate. Using None as Fallback") else: obj.year = int(strs[0]) obj.month = int(strs[1]) obj.ppiip = toFloat(row.loc['ppiip']) # 工业品出厂价格指数 obj.ppi = toFloat(row.loc['ppi']) # 生产资料价格指数 obj.qm = toFloat(row.loc['qm']) # 采掘工业价格指数 obj.rmi = toFloat(row.loc['rmi']) # 原材料工业价格指数 obj.pi = toFloat(row.loc['pi']) # 加工工业价格指数 obj.cg = toFloat(row.loc['cg']) # 生活资料价格指数 obj.food = toFloat(row.loc['food']) # 食品类价格指数 obj.clothing = toFloat(row.loc['clothing']) # 衣着类价格指数 obj.roeu = toFloat(row.loc['roeu']) # 一般日用品价格指数 obj.dcg = toFloat(row.loc['dcg']) # 耐用消费品价格指数 return obj
def rowToORM(row): obj = Model() tsString = toStr(row.loc['month']) strs = tsString.split('.') if len(strs) < 2: obj.year = None obj.month = None logging.warning( "Fail to get date from deposit rate. Using None as Fallback") else: obj.year = int(strs[0]) obj.month = int(strs[1]) obj.cpi = toFloat(row.loc['cpi']) # cpi return obj
def rowToORM(row): obj = Model() obj.year = int(row.loc['year']) obj.end_for = toFloat(row.loc['end_for']) # 最终消费支出贡献率( %) obj.for_rate = toFloat(row.loc['for_rate']) # 最终消费支出拉动(百分点) obj.asset_for = toFloat(row.loc['asset_for']) # 资本形成总额贡献率( %) obj.asset_rate = toFloat(row.loc['asset_rate']) # 资本形成总额拉动(百分点) obj.goods_for = toFloat(row.loc['goods_for']) # 货物和服务净出口贡献率( %) obj.goods_rate = toFloat(row.loc['goods_rate']) # 货物和服务净出口拉动(百分点) return obj
def rowToORM(row): obj = Model() tsString = str(row.loc['date']) obj.date = None try: obj.date = parse(tsString) except: logging.warning( "Fail to get date from {} from {}. Using {} as Fallback".format( __name__, tsString, obj.exe_date)) obj.rON = toFloat(row.loc['ON']) # 隔夜拆放利率 obj.r1W = toFloat(row.loc['1W']) # 1周拆放利率 obj.r2W = toFloat(row.loc['2W']) # 2周拆放利率 obj.r1M = toFloat(row.loc['1M']) # 1个月拆放利率 obj.r3M = toFloat(row.loc['3M']) # 3个月拆放利率 obj.r6M = toFloat(row.loc['6M']) # 6个月拆放利率 obj.r9M = toFloat(row.loc['9M']) # 9个月拆放利率 obj.r1Y = toFloat(row.loc['1Y']) # 1年拆放利率 return obj
def rowToORM(row, date: datetime): obj = Model() obj.attendance = toFloat(row.loc['Attendance']) # 上座率 obj.avgPeople = toFloat(row.loc['AvgPeople']) # 场均人次 obj.cinemaName = toStr( row.loc['CinemaName'])[0:Model.TEXT_MAX_LENGTH] # 影院名称 obj.iRank = toFloat(row.loc['RowNum']) # 排名 obj.todayAudienceCount = toFloat(row.loc['TodayAudienceCount']) # 当日观众人数 obj.todayBox = toFloat(row.loc['TodayBox']) # 当日票房 obj.todayShowCount = toFloat(row.loc['TodayShowCount']) # 当日场次 obj.price = toFloat(row.loc['price']) # 场均票价(元) obj.pk = "{name}_{date}".format(name=obj.cinemaName, date=dateTimeToTsStr(date)) obj.date = date obj.timestamp = date return obj
def rowToORM(row): obj = Model() tsString = str(row.loc['date']) obj.date = None try: obj.date = parse(tsString) except: logging.warning( "Fail to get date from {} from {}. Using {} as Fallback".format( __name__, tsString, obj.exe_date)) obj.rON_5 = toFloat(row.loc['ON_5']) # 隔夜拆放利率 obj.rON_10 = toFloat(row.loc['ON_10']) # 隔夜拆放利率 obj.rON_20 = toFloat(row.loc['ON_20']) # 隔夜拆放利率 obj.r1W_5 = toFloat(row.loc['1W_5']) # 1周拆放利率 obj.r1W_10 = toFloat(row.loc['1W_10']) # 1周拆放利率 obj.r1W_20 = toFloat(row.loc['1W_20']) # 1周拆放利率 obj.r2W_5 = toFloat(row.loc['2W_5']) # 2周拆放利率 obj.r2W_10 = toFloat(row.loc['2W_10']) # 2周拆放利率 return obj
def rowToORM(row, year, quarter): obj = Model() obj.code = toStr(row.loc['code']) # 股票代码 obj.name = toStr(row.loc['name']) # 股票名称 obj.type = toStr(row.loc['type']) obj.year = int(year) # 分配年份 obj.quarter = int(quarter) tsString = str(row.loc['report_date']) obj.report_date = None try: obj.report_date = parse(tsString) except: logging.warning( "Fail to get date from {} from {}. Using {} as Fallback".format( __name__, tsString, obj.report_date)) obj.pre_eps = toFloat(row.loc['pre_eps']) # 分红金额(每10股) obj.range = toStr(row.loc['range'])[0:255] # 转增和送股数(每10股) return obj
def rowToORM(row): obj = Model() tsString = str(row.loc['quarter']) strs = tsString.split('.') if len(strs) < 2: obj.year = None obj.quarter = None logging.warning("Fail to get date from deposit rate. Using None as Fallback") else: obj.year = int(strs[0]) obj.quarter = int(strs[1]) obj.gdp_yoy = toFloat(row.loc['gdp_yoy']) # 国内生产总值同比增长( %) obj.pi = toFloat(row.loc['pi']) # 第一产业增加值(亿元) obj.pi_yoy = toFloat(row.loc['pi_yoy']) # 第一产业增加值同比增长( %) obj.si = toFloat(row.loc['si']) # 第二产业增加值(亿元) obj.si_yoy = toFloat(row.loc['si_yoy']) # 第二产业增加值同比增长( %) obj.ti = toFloat(row.loc['ti']) # 第三产业增加值(亿元) obj.ti_yoy = toFloat(row.loc['ti_yoy']) # 第三产业增加值同比增长( %) return obj
def rowToORM(row, code): obj = Model() obj.code = code # VDPP, obj.name = toStr(row.loc['name']) # observation, obj.industry = toStr(row.loc['industry']) obj.area = toStr(row.loc['area']) obj.pe = toFloat(row.loc['pe']) obj.outstanding = toFloat(row.loc['outstanding']) obj.totals = toFloat(row.loc['totals']) obj.totalAssets = toFloat(row.loc['totalAssets']) obj.liquidAssets = toFloat(row.loc['liquidAssets']) # 流动资产 obj.fixedAssets = toFloat(row.loc['fixedAssets']) # 固定资产 obj.reserved = toFloat(row.loc['reserved']) # 公积金 obj.reservedPerShare = toFloat(row.loc['reservedPerShare']) # 每股公积金 obj.esp = toFloat(row.loc['esp']) # 每股收益 obj.bvps = toFloat(row.loc['bvps']) # 每股净资 obj.pb = toFloat(row.loc['pb']) # 市净率 tsString = str(row.loc['timeToMarket']) # 上市日期 if len(tsString) < 8: obj.timeToMarket = None else: year, mon, day = int(tsString[:4]), int(tsString[4:6]), int( tsString[6:]) datetime_object = datetime(year, mon, day) obj.timeToMarket = datetime_object obj.undp = toFloat(row.loc['undp']) # 未分利润 obj.perundp = toFloat(row.loc['perundp']) # 每股未分配 obj.rev = toFloat(row.loc['rev']) obj.profit = toFloat(row.loc['profit']) obj.gpr = toFloat(row.loc['gpr']) obj.npr = toFloat(row.loc['npr']) obj.holders = toFloat(row.loc['holders']) # 股东人数 return obj
def rowToORM(row, year, quarter): obj = ReportMain() obj.code = toStr(row.loc['code']) # 代码 obj.name = toStr(row.loc['name']) # 名称 obj.year = year # year obj.quarter = quarter # quarter tsString = "{:04d}-{:s}".format(year, row.loc['report_date']) if quarter >= 4: tsString = "{:04d}-{:s}".format(year + 1, row.loc['report_date']) obj.report_date = datetime(year=year, month=quarter * 3, day=1) + timedelta(days=32) try: obj.report_date = parse(tsString) # 发布日期 if obj.report_date.month // 3 + 1 < quarter: if quarter < 4: obj.report_date = datetime(year=obj.report_date.year + 1, month=obj.report_date.month, day=obj.report_date.day) except ValueError: obj.report_date = datetime(year=year, month=quarter * 3, day=1) + timedelta(days=32) logging.warning( 'Parse date {} for code {}({}) on {}Q{} failed using fallback {}.'. format(tsString, obj.code, obj.name, year, quarter, obj.report_date)) pass obj.eps = toFloat(row.loc['eps']) # 每股收益 obj.eps_yoy = toFloat(row.loc['eps_yoy']) # 每股收益同比(%) obj.bvps = toFloat(row.loc['bvps']) # 每股净资产 obj.roe = toFloat(row.loc['roe']) # 净资产收益率(%) obj.epcf = toFloat(row.loc['epcf']) # 每股现金流量(元) obj.net_profits = toFloat(row.loc['net_profits']) # 净利润(万元) obj.profits_yoy = toFloat(row.loc['profits_yoy']) # 净利润同比(%) obj.distrib = toFloat(row.loc['distrib']) # 分配方案 obj.net_profit_ratio = toFloat(row.loc['net_profit_ratio']) # 净利率(%) obj.gross_profit_rate = toFloat(row.loc['gross_profit_rate']) # 毛利率(%) obj.business_income = toFloat(row.loc['business_income']) # 营业收入(百万元) obj.bips = toFloat(row.loc['bips']) # 每股主营业务收入(元) obj.arturnover = toFloat(row.loc['arturnover']) # 应收账款周转率(次) obj.arturndays = toFloat(row.loc['arturndays']) # 应收账款周转天数(天) obj.inventory_turnover = toFloat(row.loc['inventory_turnover']) # 存货周转率(次) obj.inventory_days = toFloat(row.loc['inventory_days']) # 存货周转天数(天) obj.currentasset_turnover = toFloat( row.loc['currentasset_turnover']) # 流动资产周转率(次) obj.currentasset_days = toFloat( row.loc['currentasset_days']) # 流动资产周转天数(天) obj.mbrg = toFloat(row.loc['mbrg']) # 主营业务收入增长率(%) obj.nprg = toFloat(row.loc['nprg']) # 净利润增长率(%) obj.nav = toFloat(row.loc['nav']) # 净资产增长率 obj.targ = toFloat(row.loc['targ']) # 总资产增长率 obj.epsg = toFloat(row.loc['epsg']) # 每股收益增长率 obj.seg = toFloat(row.loc['seg']) # 股东权益增长率 obj.currentratio = toFloat(row.loc['currentratio']) # 流动比率 obj.quickratio = toFloat(row.loc['quickratio']) # 速动比率 obj.cashratio = toFloat(row.loc['cashratio']) # 现金比率 obj.icratio = toFloat(row.loc['icratio']) # 利息支付倍数 obj.sheqratio = toFloat(row.loc['sheqratio']) # 股东权益比率 obj.adratio = toFloat(row.loc['adratio']) # 股东权益增长率 obj.cf_sales = toFloat(row.loc['cf_sales']) # 经营现金净流量对销售收入比率 obj.rateofreturn = toFloat(row.loc['rateofreturn']) # 资产的经营现金流量回报率 obj.cf_nm = toFloat(row.loc['cf_nm']) # 经营现金净流量与净利润的比率 obj.cf_liabilities = toFloat(row.loc['cf_liabilities']) # 经营现金净流量对负债比率 obj.cashflowratio = toFloat(row.loc['cashflowratio']) # 现金流量比率 return obj
def rowToORM(row): obj = Model() tsString = str(row.loc['month']) strs = tsString.split('.') if len(strs) < 2: obj.year = None obj.month = None logging.warning( "Fail to get date from deposit rate. Using None as Fallback") else: obj.year = int(strs[0]) obj.month = int(strs[1]) obj.m2 = toFloat(row.loc['m2']) # 货币和准货币(广义货币M2)(亿元) obj.m2_yoy = toFloat(row.loc['m2_yoy']) # 货币和准货币(广义货币M2)同比增长( %) obj.m1 = toFloat(row.loc['m1']) # 货币(狭义货币M1)(亿元) obj.m1_yoy = toFloat(row.loc['m1_yoy']) # 货币(狭义货币M1)同比增长( %) obj.m0 = toFloat(row.loc['m0']) # 流通中现金(M0)(亿元) obj.m0_yoy = toFloat(row.loc['m0_yoy']) # 流通中现金(M0)同比增长( %) obj.cd = toFloat(row.loc['cd']) # 活期存款(亿元) obj.cd_yoy = toFloat(row.loc['cd_yoy']) # 活期存款同比增长( %) obj.qm = toFloat(row.loc['qm']) # 准货币(亿元) obj.qm_yoy = toFloat(row.loc['qm_yoy']) # 准货币同比增长( %) obj.ftd = toFloat(row.loc['ftd']) # 定期存款(亿元) obj.ftd_yoy = toFloat(row.loc['ftd_yoy']) # 定期存款同比增长( %) obj.sd = toFloat(row.loc['sd']) # 储蓄存款(亿元) obj.sd_yoy = toFloat(row.loc['sd_yoy']) # 储蓄存款同比增长( %) obj.rests = toFloat(row.loc['rests']) # 其他存款(亿元) obj.rests_yoy = toFloat(row.loc['rests_yoy']) # 其他存款同比增长( %) return obj
def rowToORM(row): obj = Model() tsString = str(row.loc['date']) obj.date = None try: obj.date = parse(tsString) except: logging.warning("Fail to get date from {} from {}. Using {} as Fallback". format(__name__, tsString, obj.exe_date)) obj.bank = str(row.loc['bank']) obj.rON = toFloat(row.loc['ON']) # 隔夜拆放利率 obj.rON_B = toFloat(row.loc['ON_B']) # 隔夜拆放买入价 obj.rON_A = toFloat(row.loc['ON_A']) # 隔夜拆放卖出价 obj.r1W_B = toFloat(row.loc['1W_B']) # 1周买入 obj.r1W_A = toFloat(row.loc['1W_A']) # 1周卖出 obj.r2W_B = toFloat(row.loc['2W_B']) # 买入 obj.r2W_A = toFloat(row.loc['2W_A']) # 卖出 obj.r1M_B = toFloat(row.loc['1M_B']) # 买入 obj.r1M_A = toFloat(row.loc['1M_A']) # 卖出 obj.r3M_B = toFloat(row.loc['3M_B']) # 买入 obj.r3M_A = toFloat(row.loc['3M_A']) # 卖出 obj.r6M_B = toFloat(row.loc['6M_B']) # 买入 obj.r6M_A = toFloat(row.loc['6M_A']) # 卖出 obj.r9M_B = toFloat(row.loc['9M_B']) # 买入 obj.r9M_A = toFloat(row.loc['9M_A']) # 卖出 obj.r1Y_B = toFloat(row.loc['1Y_B']) # 买入 obj.r1Y_A = toFloat(row.loc['1Y_A']) # 卖出 return obj