def plot_yesterday_zt(type_name='zrzt', current=datetime.datetime.now().strftime('%Y%m%d')): engine = get_engine('db_zdt') table_name = type_name table = '{}{}'.format(current, table_name) try: df = pd.read_sql(table, engine) except Exception as e: logger.error(e) return for i in range(len(df)): code = df.iloc[i]['代码'] name = df.iloc[i]['名称'] plot_stock_line(api,code, name, table_name=table_name, current=current, start='2018-07-01', save=True)
def plot_yesterday_zt(type_name='zrzt', current=datetime.datetime.now().strftime('%Y%m%d')): engine = get_engine('db_zdt') table_name = type_name table = '{}{}'.format(current, table_name) try: df = pd.read_sql(table, engine) except Exception as e: logger.error('table_name >>> {}{}'.format(current,table_name)) logger.error(e) return for i in range(len(df)): code = df.iloc[i]['代码'] name = df.iloc[i]['名称'] plot_stock_line(api,code, name, table_name=table_name, current=current, start='2018-07-01', save=True)
def plot_yesterday_zt(self, api, type_name='zrzt', current=datetime.datetime.now().strftime('%Y%m%d')): start_data = datetime.datetime.now() + datetime.timedelta(days=-200) start_data = start_data.strftime('%Y-%m-%d') table = f'{current}{type_name}' df = self.get_data(table) for i in range(len(df)): code = df.iloc[i]['代码'] name = df.iloc[i]['名称'] plot_stock_line(api, code, name, table_type=type_name, current=current, root_path=self.image_path, start=start_data, save=True)
def plot_yesterday_zt(type_name='zrzt', current=datetime.datetime.now().strftime('%Y%m%d')): engine = DB.get_engine('db_zdt', 'qq') table_name = type_name table = '{}{}'.format(current, table_name) try: df = pd.read_sql(table, engine) except Exception as e: logger.error('table_name >>> {}{}'.format(current, table_name)) logger.error(e) return start_data = datetime.datetime.now() + datetime.timedelta(days=-200) start_data = start_data.strftime('%Y-%m-%d') for i in range(len(df)): code = df.iloc[i]['代码'] name = df.iloc[i]['名称'] plot_stock_line(api, code, name, table_name=table_name, current=current, start=start_data, save=True)
''' def plot_yesterday_zt(): engine = get_engine('db_zdt') table_name = 'zrzt' table = '{}{}'.format(datetime.datetime.now().strftime('%Y%m%d'), table_name) try: df = pd.read_sql(table, engine) except Exception, e: print e return for i in range(len(df)): code = df.iloc[i][u'代码'] name = df.iloc[i][u'名称'] plot_stock_line(code, name, table_name=table_name, start='2018-01-01', save=True) if __name__ == '__main__': current = datetime.datetime.now().strftime('%Y%m%d') path = os.path.join(os.path.dirname(__file__), 'data', current) if not os.path.exists(path): os.mkdir(path) os.chdir(path) plot_yesterday_zt()