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
