def symbol_rating_calc(days_behind): end_date_time = datetime.datetime.now() # mysqldb.get_maxdate()[0] start_date_time = end_date_time - relativedelta(days=700) list_symbol=dbdao.get_symbols_list() df_mkt=mongodao.getsymbol_data_temp(constants.MKT_SYMBOL, start_date_time, end_date_time) for symbol in list_symbol: try: df_symbol=mongodao.getsymbol_data_temp(symbol, start_date_time, end_date_time) if df_symbol.empty: return logger.info("Getting Rating for symbol=%s ",symbol) df_result=rating_manager.symbol_rating_calculation(df_symbol,symbol,df_mkt, start_date_time, end_date_time,days_behind) print df_result logger.info("Got Rating for symbol=%s ",symbol) except Exception ,ex: logger.error(ex)
from datetime import timedelta import datetime from pandas.io.data import DataReader import logging.config from MyConfig import MyConfig as cfg import traceback from util import loglib from bl.import_data import dataimport from dao import dbdao logger = loglib.getlogger('historicaldataimport') import sys dataimport.importdata(dbdao.get_symbols_list())
data = json.loads(html) df=pd.DataFrame(data) df.set_index('t',inplace=True) return df dbdao.execute_query(['delete from google_live_indices_symbol','delete from google_live_symbol']) list_symbol=dbdao.get_indices_symbols_list() print list_symbol df=getgoogledata(list_symbol) dbdao.save_dataframe(df, "google_live_indices_symbol") list_symbol=dbdao.get_symbols_list() for i in range(0, len(list_symbol), 40): try: chunk = list_symbol[i:i + 40] df=getgoogledata(chunk) dbdao.save_dataframe(df, "google_live_symbol") logger.info( chunk) except Exception,ex: logger.error(ex) sql_update=""" update live_symbol t1 , google_live_symbol t2 set price_change=t2.c_fix, change_pct=cp_fix, last=l_fix where t1.symbol=t2.t"""