def calculate_technicals(start,end): end_date_time = datetime.datetime.now() # mysqldb.get_maxdate()[0] start_date_time = end_date_time - relativedelta(days=constants.DAYS_FOR_TECHNICALS) list_symbol=dbdao.get_symbols_list_limit(start,end) list_symbol=['MSFT'] hist_dates= dbdao.get_historical_dates() days_behind=100 df_mkt=mongodao.getsymbol_data(constants.MKT_SYMBOL, start_date_time, end_date_time) if(start=='0'): dbdao.execute_query(["drop table df_technical","truncate table df_history","truncate table df_alerts"]) df_technicals = technical_manager.calculate_technical(df_mkt,constants.MKT_SYMBOL,df_mkt, start_date_time, end_date_time, hist_dates,days_behind) frames=[df_technicals] for symbol in list_symbol: try: df_symbol=mongodao.getsymbol_data(symbol, start_date_time, end_date_time) if df_symbol.empty: continue logger.info("Getting Technicals for symbol=%s ",symbol) df_technicals_new = technical_manager.calculate_technical(df_symbol,symbol,df_mkt, start_date_time, end_date_time, hist_dates,days_behind) frames.append(df_technicals_new) logger.info("Got Technicals for symbol=%s ",symbol) except Exception ,ex: logger.error(ex) logger.error( traceback.format_exc())
from bl import stats_manager from dao import dbdao from util import loglib import pandas as pd #dbdao.execute_query(["Delete from fin_stats_symbol"]) import sys print sys.argv start,end=sys.argv[1],sys.argv[2] print start,end list_symbol=dbdao.get_symbols_list_limit(start, end) for symbol in list_symbol: #list_function=[stats_manager.get_IncomeStatement(symbol),stats_manager.get_BalanceSheet(symbol),stats_manager.get_CashFlow(symbol)] list_function=[stats_manager.get_BalanceSheet(symbol)] for function_name in list_function: function_name
from bl import stats_manager from dao import dbdao from util import loglib import pandas as pd #dbdao.execute_query(["Delete from fin_stats_symbol"]) import sys print sys.argv start, end = sys.argv[1], sys.argv[2] print start, end list_symbol = dbdao.get_symbols_list_limit(start, end) for symbol in list_symbol: #list_function=[stats_manager.get_IncomeStatement(symbol),stats_manager.get_BalanceSheet(symbol),stats_manager.get_CashFlow(symbol)] list_function = [stats_manager.get_BalanceSheet(symbol)] for function_name in list_function: function_name