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"""
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())
