def execute():
query_result = chaxun()
for row in query_result:
codeItem = row[1]
print time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())) + "=====" + codeItem
try:
macd_30,macdsignal_30,macdhist_30,jsonResult_30,result_30,mairuresult_30,maichuresult_30 = MACD(codeItem, '30')
macd_60,macdsignal_60,macdhist_60,jsonResult_60,result_60,mairuresult_60,maichuresult_60 = MACD(codeItem, '60')
macd_D,macdsignal_D,macdhist_D,jsonResult_D,result_D,mairuresult_D,maichuresult_D = MACD(codeItem, 'D')
macd_W,macdsignal_W,macdhist_W,jsonResult_W,result_W,mairuresult_W,maichuresult_W = MACD(codeItem, 'W')
upperband_30, middleband_30, lowerband_30, jsonResult_b_30, result_bl_30,mairuresult_bl_30,maichuresult_bl_30 = BBANDS(codeItem, '30')
upperband_60, middleband_60, lowerband_60, jsonResult_b_60, result_bl_60,mairuresult_bl_60,maichuresult_bl_60 = BBANDS(codeItem, '60')
upperband_D, middleband_D, lowerband_D, jsonResult_b_D, result_bl_D,mairuresult_bl_D,maichuresult_bl_D = BBANDS(codeItem, 'D')
upperband_W, middleband_W, lowerband_W, jsonResult_b_W, result_bl_W,mairuresult_bl_W,maichuresult_bl_W = BBANDS(codeItem, 'W')
jsonDic = {}
jsonDic['90_Time'] = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time()))
jsonDic['02Code'] = '_' + codeItem
jsonDic['03Name'] = common.gupiaomingcheng(codeItem)
jsonDic['04涨跌幅'] = common.zhangdiefu(codeItem)
jsonDic['041备注信息'] = row[5]
jsonDic['042板块信息'] = row[6]
jsonDic['051日买入信息'] = mairuresult_D + ' ' + mairuresult_bl_D
jsonDic['052时买入信息'] = mairuresult_60 + ' ' + mairuresult_bl_60
jsonDic['06卖出信息'] = maichuresult_60 + ' ' + maichuresult_D + ' ' + maichuresult_bl_60 + ' ' + maichuresult_bl_D
jsonDic['07上升通道'] = result_D + ' ' + result_bl_D
#jsonDic['验证_MACD_30'] = '%.3f' % macd_30[-1] + '_' + '%.3f' % macd_30[-2] + '_' + '%.3f' % macd_30[-3]
#jsonDic['验证_MACD_60'] = '%.3f' % macd_60[-1] + '_' + '%.3f' % macd_60[-2] + '_' + '%.3f' % macd_60[-3]
#jsonDic['验证_MACD_D'] = '%.3f' % macd_D[-1] + '_' + '%.3f' % macd_D[-2] + '_' + '%.3f' % macd_D[-3]
#jsonDic['验证_MACD_W'] = '%.3f' % macd_W[-1] + '_' + '%.3f' % macd_W[-2] + '_' + '%.3f' % macd_W[-3]
#jsonDic['验证_布林_30'] = '%.3f' % middleband_30[-1] + '_' + '%.3f' % middleband_30[-2] + '_' + '%.3f' % middleband_30[-3]
#jsonDic['验证_布林_60'] = '%.3f' % middleband_60[-1] + '_' + '%.3f' % middleband_60[-2] + '_' + '%.3f' % middleband_60[-3]
#jsonDic['验证_布林_D'] = '%.3f' % middleband_D[-1] + '_' + '%.3f' % middleband_D[-2] + '_' + '%.3f' % middleband_D[-3]
#jsonDic['验证_布林_W'] = '%.3f' % middleband_W[-1] + '_' + '%.3f' % middleband_W[-2] + '_' + '%.3f' % middleband_W[-3]
jsonParam = dict(jsonResult_30.items() + jsonResult_60.items() + jsonResult_D.items()
+ jsonResult_W.items() + jsonResult_b_30.items() + jsonResult_b_60.items()
+ jsonResult_b_D.items() + jsonResult_b_W.items() + jsonDic.items())
insertRecord_param(jsonParam, collectionName)
except (IOError, TypeError, NameError, IndexError,Exception) as e:
logging.error("error:" + codeItem)
print e
def execute():
query_result = ['000980','601633','600686','601777','000572','000625']
for codeItem in query_result:
xinhao = ''
print time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())) + "=====" + codeItem
try:
macd_30,macdsignal_30,macdhist_30,jsonResult_30,result_30,mairuresult_30,maichuresult_30 = MACD(codeItem, '30')
macd_60,macdsignal_60,macdhist_60,jsonResult_60,result_60,mairuresult_60,maichuresult_60 = MACD(codeItem, '60')
macd_D,macdsignal_D,macdhist_D,jsonResult_D,result_D,mairuresult_D,maichuresult_D = MACD(codeItem, 'D')
macd_W,macdsignal_W,macdhist_W,jsonResult_W,result_W,mairuresult_W,maichuresult_W = MACD(codeItem, 'W')
upperband_30, middleband_30, lowerband_30, jsonResult_b_30, result_bl_30,mairuresult_bl_30,maichuresult_bl_30 = BBANDS(codeItem, '30')
upperband_60, middleband_60, lowerband_60, jsonResult_b_60, result_bl_60,mairuresult_bl_60,maichuresult_bl_60 = BBANDS(codeItem, '60')
upperband_D, middleband_D, lowerband_D, jsonResult_b_D, result_bl_D,mairuresult_bl_D,maichuresult_bl_D = BBANDS(codeItem, 'D')
upperband_W, middleband_W, lowerband_W, jsonResult_b_W, result_bl_W,mairuresult_bl_W,maichuresult_bl_W = BBANDS(codeItem, 'W')
jsonDic = {}
jsonDic['90_Time'] = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time()))
jsonDic['02Code'] = '_' + codeItem
jsonDic['03Name'] = common.gupiaomingcheng(codeItem)
jsonDic['04涨跌幅'] = common.zhangdiefu(codeItem)
jsonDic['051日买入信息'] = mairuresult_D + ' ' + mairuresult_bl_D
#print mairuresult_D + ' ' + mairuresult_bl_D
jsonDic['052时买入信息'] = mairuresult_60 + ' ' + mairuresult_bl_60
#if (mairuresult_D !='' and (mairuresult_60 != '' or mairuresult_bl_60 != '')):
if (mairuresult_60 != '' or mairuresult_bl_60 != ''):
i = 0
for i in [0] :
xinhao = xinhao + codeItem + '买入信号出现：<br>' + mairuresult_D + '<br> ' + mairuresult_60 + '<br>' + mairuresult_bl_60 + ' '
email_util.sendMail(codeItem + '买入信号出现：<br>' + mairuresult_D + '<br>' + mairuresult_60 + '<br>' + mairuresult_bl_60, codeItem + '买入，谨慎谨慎再谨慎')
i = i + 1
time.sleep(3)
jsonDic['06卖出信息'] = maichuresult_60 + ' ' + maichuresult_D + ' ' + maichuresult_bl_60 + ' ' + maichuresult_bl_D
#print maichuresult_60 + ' ' + maichuresult_D + ' ' + maichuresult_bl_60 + ' ' + maichuresult_bl_D
if (maichuresult_60 != '' or maichuresult_bl_60 != ''):
j = 0
for j in [0] :
xinhao = xinhao + codeItem + '卖出信号出现：<br>' + maichuresult_D + '<br>' + maichuresult_60 + '<br>' + maichuresult_bl_60 + ' '
email_util.sendMail(codeItem + '卖出信号出现：<br>' + maichuresult_D + '<br>' +maichuresult_60 + '<br>' + maichuresult_bl_60, codeItem + '卖出，果断果断再果断')
j = j + 1
time.sleep(3)
jsonDic['07上升通道'] = result_D + ' ' + result_bl_D
jsonDic['验证_MACD_30'] = '%.3f' % macd_30[-1] + '_' + '%.3f' % macd_30[-2] + '_' + '%.3f' % macd_30[-3]
jsonDic['验证_MACD_60'] = '%.3f' % macd_60[-1] + '_' + '%.3f' % macd_60[-2] + '_' + '%.3f' % macd_60[-3]
jsonDic['验证_MACD_D'] = '%.3f' % macd_D[-1] + '_' + '%.3f' % macd_D[-2] + '_' + '%.3f' % macd_D[-3]
jsonDic['验证_MACD_W'] = '%.3f' % macd_W[-1] + '_' + '%.3f' % macd_W[-2] + '_' + '%.3f' % macd_W[-3]
jsonDic['验证_布林_30'] = '%.3f' % middleband_30[-1] + '_' + '%.3f' % middleband_30[-2] + '_' + '%.3f' % middleband_30[-3]
jsonDic['验证_布林_60'] = '%.3f' % middleband_60[-1] + '_' + '%.3f' % middleband_60[-2] + '_' + '%.3f' % middleband_60[-3]
jsonDic['验证_布林_D'] = '%.3f' % middleband_D[-1] + '_' + '%.3f' % middleband_D[-2] + '_' + '%.3f' % middleband_D[-3]
jsonDic['验证_布林_W'] = '%.3f' % middleband_W[-1] + '_' + '%.3f' % middleband_W[-2] + '_' + '%.3f' % middleband_W[-3]
jsonParam = dict(jsonResult_30.items() + jsonResult_60.items() + jsonResult_D.items()
+ jsonResult_W.items() + jsonResult_b_30.items() + jsonResult_b_60.items()
+ jsonResult_b_D.items() + jsonResult_b_W.items() + jsonDic.items())
insertRecord_param(jsonParam, collectionName)
except (IOError, TypeError, NameError, IndexError,Exception) as e:
logging.error("error:" + codeItem)
print e
xiaomowang = '<br>=============================='
xiaomowang = xiaomowang + '<br>卖出信号：<br>' + maichuresult_W + '<br>' + maichuresult_D + '<br>' + maichuresult_60 + '<br>' + maichuresult_bl_60 + '<br>' + maichuresult_bl_D
xiaomowang = xiaomowang + '<br>买入信号：<br>' + mairuresult_W + '<br>' + mairuresult_D + '<br> ' + mairuresult_60 + '<br>' + mairuresult_bl_60 + '<br>' + mairuresult_bl_D
xiaomowang = xiaomowang + '<br>=============================='
xiaomowang = xiaomowang + '<br>60验证：' + '%.3f' % macd_60[-1] + '_' + '%.3f' % macd_60[-2] + '_' + '%.3f' % macd_60[-3]
xiaomowang = xiaomowang + '<br>D验证：' + '%.3f' % macd_D[-1] + '_' + '%.3f' % macd_D[-2] + '_' + '%.3f' % macd_D[-3]
xiaomowang = xiaomowang + '<br>W验证：' + '%.3f' % macd_W[-1] + '_' + '%.3f' % macd_W[-2] + '_' + '%.3f' % macd_W[-3]
caozuo = ''
if xinhao.__contains__('买入'):
caozuo = '【操作】买入'
elif xinhao.__contains__('卖出'):
caozuo = '【操作】卖出'
caozuo2 = ''
if xinhao.__contains__('V型翻转'):
caozuo = '【操作】买入点'
toDataFrame_param_content({}, '★★★★★My_Code_' + common.gupiaomingcheng(codeItem) + '_' + common.zhangdiefu(codeItem) + '_' + time.strftime('%Y-%m-%d_%H:%M', time.localtime(time.time())) + '#'+ caozuo +',【主题】中国汽车品牌#',xinhao + xiaomowang, collectionName)
elif xinhao.__contains__('下降1') or xinhao.__contains__('上穿'):
caozuo = '【操作】卖出点'
#toDataFrame_param_content({}, '★★★★★My_Code_JSON_Mongo_' + time.strftime('%Y-%m-%d_%H:%M', time.localtime(time.time())) + '#【长期关注】'+ common.gupiaomingcheng(codeItem) + caozuo + caozuo2 +'#',xinhao + xiaomowang, collectionName)
return xinhao
def execute_param():
query_result = ['000980','601633','600686','601777','000572','000625']
xinhao = ''
for codeItem in query_result:
print time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())) + "=====" + codeItem
try:
macd_30,macdsignal_30,macdhist_30,jsonResult_30,result_30,mairuresult_30,maichuresult_30 = MACD(codeItem, '30')
macd_60,macdsignal_60,macdhist_60,jsonResult_60,result_60,mairuresult_60,maichuresult_60 = MACD(codeItem, '60')
macd_D,macdsignal_D,macdhist_D,jsonResult_D,result_D,mairuresult_D,maichuresult_D = MACD(codeItem, 'D')
macd_W,macdsignal_W,macdhist_W,jsonResult_W,result_W,mairuresult_W,maichuresult_W = MACD(codeItem, 'W')
upperband_30, middleband_30, lowerband_30, jsonResult_b_30, result_bl_30,mairuresult_bl_30,maichuresult_bl_30 = BBANDS(codeItem, '30')
upperband_60, middleband_60, lowerband_60, jsonResult_b_60, result_bl_60,mairuresult_bl_60,maichuresult_bl_60 = BBANDS(codeItem, '60')
upperband_D, middleband_D, lowerband_D, jsonResult_b_D, result_bl_D,mairuresult_bl_D,maichuresult_bl_D = BBANDS(codeItem, 'D')
upperband_W, middleband_W, lowerband_W, jsonResult_b_W, result_bl_W,mairuresult_bl_W,maichuresult_bl_W = BBANDS(codeItem, 'W')
jsonDic = {}
jsonDic['90_Time'] = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time()))
jsonDic['02Code'] = '_' + codeItem
jsonDic['03Name'] = common.gupiaomingcheng(codeItem)
jsonDic['04涨跌幅'] = common.zhangdiefu(codeItem)
jsonDic['051日买入信息'] = mairuresult_D + ' ' + mairuresult_bl_D
#print mairuresult_D + ' ' + mairuresult_bl_D
jsonDic['052时买入信息'] = mairuresult_60 + ' ' + mairuresult_bl_60
print '买入mairuresult_bl_60!='':'
print mairuresult_bl_60 != ''
if ( mairuresult_bl_60 != ''):
i = 0
for i in [0] :
xinhao = xinhao + codeItem + '买入信号出现：<br>' + mairuresult_D + '<br> ' + mairuresult_60 + '<br>' + mairuresult_bl_60 + ' '
email_util.sendMail(codeItem + '买入信号出现：<br>' + mairuresult_D + '<br>' + mairuresult_60 + '<br>' + mairuresult_bl_60, codeItem + '买入，谨慎谨慎再谨慎')
i = i + 1
time.sleep(3)
jsonDic['06卖出信息'] = maichuresult_60 + ' ' + maichuresult_D + ' ' + maichuresult_bl_60 + ' ' + maichuresult_bl_D
#print maichuresult_60 + ' ' + maichuresult_D + ' ' + maichuresult_bl_60 + ' ' + maichuresult_bl_D
print '卖出mairuresult_bl_60!='':'
print maichuresult_bl_60 != ''
if ( maichuresult_bl_60 != ''):
j = 0
for j in [0] :
xinhao = xinhao + codeItem + '卖出信号出现：<br>' + maichuresult_D + '<br>' + maichuresult_60 + '<br>' + maichuresult_bl_60 + ' '
email_util.sendMail(codeItem + '卖出信号出现：<br>' + maichuresult_D + '<br>' +maichuresult_60 + '<br>' + maichuresult_bl_60, codeItem + '卖出，果断果断再果断')
j = j + 1
time.sleep(3)
jsonDic['07上升通道'] = result_D + ' ' + result_bl_D
jsonDic['验证_MACD_30'] = '%.3f' % macd_30[-1] + '_' + '%.3f' % macd_30[-2] + '_' + '%.3f' % macd_30[-3]
jsonDic['验证_MACD_60'] = '%.3f' % macd_60[-1] + '_' + '%.3f' % macd_60[-2] + '_' + '%.3f' % macd_60[-3]
jsonDic['验证_MACD_D'] = '%.3f' % macd_D[-1] + '_' + '%.3f' % macd_D[-2] + '_' + '%.3f' % macd_D[-3]
jsonDic['验证_MACD_W'] = '%.3f' % macd_W[-1] + '_' + '%.3f' % macd_W[-2] + '_' + '%.3f' % macd_W[-3]
jsonDic['验证_布林_30'] = '%.3f' % middleband_30[-1] + '_' + '%.3f' % middleband_30[-2] + '_' + '%.3f' % middleband_30[-3]
jsonDic['验证_布林_60'] = '%.3f' % middleband_60[-1] + '_' + '%.3f' % middleband_60[-2] + '_' + '%.3f' % middleband_60[-3]
jsonDic['验证_布林_D'] = '%.3f' % middleband_D[-1] + '_' + '%.3f' % middleband_D[-2] + '_' + '%.3f' % middleband_D[-3]
jsonDic['验证_布林_W'] = '%.3f' % middleband_W[-1] + '_' + '%.3f' % middleband_W[-2] + '_' + '%.3f' % middleband_W[-3]
jsonParam = dict(jsonResult_30.items() + jsonResult_60.items() + jsonResult_D.items()
+ jsonResult_W.items() + jsonResult_b_30.items() + jsonResult_b_60.items()
+ jsonResult_b_D.items() + jsonResult_b_W.items() + jsonDic.items())
#insertRecord_param(jsonParam, collectionName)
except (IOError, TypeError, NameError, IndexError,Exception) as e:
logging.error("error:" + codeItem)
print e
return xinhao
def execute2(all_code_index, all_title, all_time):
all_code = DataFrame(
{
'codeitem': all_code_index,
'hangye': all_title,
'time': all_time
},
index=all_code_index)
all_code_drop = all_code.drop_duplicates('codeitem')
all_code_time = DataFrame(all_time, index=all_code_index, columns=['time'])
for codeItem in all_code_drop['codeitem']:
print time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(
time.time())) + "=====" + codeItem
try:
macd_30, macdsignal_30, macdhist_30, jsonResult_30, result_30, mairuresult_30, maichuresult_30 = MACD(
codeItem, '30')
macd_60, macdsignal_60, macdhist_60, jsonResult_60, result_60, mairuresult_60, maichuresult_60 = MACD(
codeItem, '60')
macd_D, macdsignal_D, macdhist_D, jsonResult_D, result_D, mairuresult_D, maichuresult_D = MACD(
codeItem, 'D')
macd_W, macdsignal_W, macdhist_W, jsonResult_W, result_W, mairuresult_W, maichuresult_W = MACD(
codeItem, 'W')
upperband_30, middleband_30, lowerband_30, jsonResult_b_30, result_bl_30, mairuresult_bl_30, maichuresult_bl_30 = BBANDS(
codeItem, '30')
upperband_60, middleband_60, lowerband_60, jsonResult_b_60, result_bl_60, mairuresult_bl_60, maichuresult_bl_60 = BBANDS(
codeItem, '60')
upperband_D, middleband_D, lowerband_D, jsonResult_b_D, result_bl_D, mairuresult_bl_D, maichuresult_bl_D = BBANDS(
codeItem, 'D')
upperband_W, middleband_W, lowerband_W, jsonResult_b_W, result_bl_W, mairuresult_bl_W, maichuresult_bl_W = BBANDS(
codeItem, 'W')
real_D, tableresult_ma_d_20 = MA(codeItem, 'D', 20)
real_60, tableresult_ma_60_20 = MA(codeItem, '60', 20)
jsonDic = {}
jsonDic['00_20天线信息'] = tableresult_ma_d_20
jsonDic['00_60分钟信息'] = tableresult_ma_60_20
jsonDic['01_日买入信息'] = mairuresult_D + ' ' + mairuresult_bl_D
jsonDic['01_时买入信息'] = mairuresult_60 + ' ' + mairuresult_bl_60
jsonDic[
'02_卖出信息'] = maichuresult_60 + ' ' + maichuresult_D + ' ' + maichuresult_bl_60 + ' ' + maichuresult_bl_D
jsonDic['03_上升通道'] = result_D + ' ' + result_bl_D
jsonDic['90_Time'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
jsonDic['90_原始Time'] = all_code_drop.loc[codeItem, 'time']
jsonDic['04_Code'] = codeItem
#jsonDic['02Code2'] = '_' + codeItem
jsonDic['05_Name'] = common.gupiaomingcheng(codeItem)
jsonDic['06_所属行业'] = all_code_drop.loc[codeItem, 'hangye']
jsonDic['07_涨跌幅'] = common.zhangdiefu(codeItem)
#jsonDic['验证_MACD_30'] = '%.3f' % macd_30[-1] + '_' + '%.3f' % macd_30[-2] + '_' + '%.3f' % macd_30[-3]
#jsonDic['验证_MACD_60'] = '%.3f' % macd_60[-1] + '_' + '%.3f' % macd_60[-2] + '_' + '%.3f' % macd_60[-3]
#jsonDic['验证_MACD_D'] = '%.3f' % macd_D[-1] + '_' + '%.3f' % macd_D[-2] + '_' + '%.3f' % macd_D[-3]
#jsonDic['验证_MACD_W'] = '%.3f' % macd_W[-1] + '_' + '%.3f' % macd_W[-2] + '_' + '%.3f' % macd_W[-3]
#jsonDic['验证_布林_30'] = '%.3f' % middleband_30[-1] + '_' + '%.3f' % middleband_30[-2] + '_' + '%.3f' % middleband_30[-3]
#jsonDic['验证_布林_60'] = '%.3f' % middleband_60[-1] + '_' + '%.3f' % middleband_60[-2] + '_' + '%.3f' % middleband_60[-3]
#jsonDic['验证_布林_D'] = '%.3f' % middleband_D[-1] + '_' + '%.3f' % middleband_D[-2] + '_' + '%.3f' % middleband_D[-3]
#jsonDic['验证_布林_W'] = '%.3f' % middleband_W[-1] + '_' + '%.3f' % middleband_W[-2] + '_' + '%.3f' % middleband_W[-3]
jsonParam = dict(jsonResult_30.items() + jsonResult_60.items() +
jsonResult_D.items() + jsonResult_W.items() +
jsonResult_b_30.items() +
jsonResult_b_60.items() + jsonResult_b_D.items() +
jsonResult_b_W.items() + jsonDic.items())
insertRecord_param(jsonParam, collectionName2)
except (IOError, TypeError, NameError, IndexError, Exception) as e:
logging.error("error:" + codeItem)
print e
zhishu_code_index = num.array(['399006', '399001', '000001'])
for codeItem in zhishu_code_index:
print time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(
time.time())) + "=====" + codeItem
try:
macd_30, macdsignal_30, macdhist_30, jsonResult_30, result_30, mairuresult_30, maichuresult_30 = MACD(
codeItem, '30')
macd_60, macdsignal_60, macdhist_60, jsonResult_60, result_60, mairuresult_60, maichuresult_60 = MACD(
codeItem, '60')
macd_D, macdsignal_D, macdhist_D, jsonResult_D, result_D, mairuresult_D, maichuresult_D = MACD(
codeItem, 'D')
macd_W, macdsignal_W, macdhist_W, jsonResult_W, result_W, mairuresult_W, maichuresult_W = MACD(
codeItem, 'W')
upperband_30, middleband_30, lowerband_30, jsonResult_b_30, result_bl_30, mairuresult_bl_30, maichuresult_bl_30 = BBANDS(
codeItem, '30')
upperband_60, middleband_60, lowerband_60, jsonResult_b_60, result_bl_60, mairuresult_bl_60, maichuresult_bl_60 = BBANDS(
codeItem, '60')
upperband_D, middleband_D, lowerband_D, jsonResult_b_D, result_bl_D, mairuresult_bl_D, maichuresult_bl_D = BBANDS(
codeItem, 'D')
upperband_W, middleband_W, lowerband_W, jsonResult_b_W, result_bl_W, mairuresult_bl_W, maichuresult_bl_W = BBANDS(
codeItem, 'W')
real_D, tableresult_ma_d_20 = MA(codeItem, 'D', 20)
real_60, tableresult_ma_60_20 = MA(codeItem, '60', 20)
jsonDic = {}
jsonDic['00_20天线信息'] = tableresult_ma_d_20
jsonDic['00_60分钟信息'] = tableresult_ma_60_20
jsonDic['01_日买入信息'] = mairuresult_D + ' ' + mairuresult_bl_D
jsonDic['01_时买入信息'] = mairuresult_60 + ' ' + mairuresult_bl_60
jsonDic[
'02_卖出信息'] = maichuresult_60 + ' ' + maichuresult_D + ' ' + maichuresult_bl_60 + ' ' + maichuresult_bl_D
jsonDic['03_上升通道'] = result_D + ' ' + result_bl_D
jsonDic['90_Time'] = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(time.time()))
jsonDic['04_Code'] = codeItem
#jsonDic['02Code2'] = '_' + codeItem
jsonDic['05_Name'] = common.gupiaomingcheng(codeItem)
jsonDic['07_涨跌幅'] = common.zhangdiefu(codeItem)
#jsonDic['验证_MACD_30'] = '%.3f' % macd_30[-1] + '_' + '%.3f' % macd_30[-2] + '_' + '%.3f' % macd_30[-3]
#jsonDic['验证_MACD_60'] = '%.3f' % macd_60[-1] + '_' + '%.3f' % macd_60[-2] + '_' + '%.3f' % macd_60[-3]
#jsonDic['验证_MACD_D'] = '%.3f' % macd_D[-1] + '_' + '%.3f' % macd_D[-2] + '_' + '%.3f' % macd_D[-3]
#jsonDic['验证_MACD_W'] = '%.3f' % macd_W[-1] + '_' + '%.3f' % macd_W[-2] + '_' + '%.3f' % macd_W[-3]
#jsonDic['验证_布林_30'] = '%.3f' % middleband_30[-1] + '_' + '%.3f' % middleband_30[-2] + '_' + '%.3f' % middleband_30[-3]
#jsonDic['验证_布林_60'] = '%.3f' % middleband_60[-1] + '_' + '%.3f' % middleband_60[-2] + '_' + '%.3f' % middleband_60[-3]
#jsonDic['验证_布林_D'] = '%.3f' % middleband_D[-1] + '_' + '%.3f' % middleband_D[-2] + '_' + '%.3f' % middleband_D[-3]
#jsonDic['验证_布林_W'] = '%.3f' % middleband_W[-1] + '_' + '%.3f' % middleband_W[-2] + '_' + '%.3f' % middleband_W[-3]
jsonParam = dict(jsonResult_30.items() + jsonResult_60.items() +
jsonResult_D.items() + jsonResult_W.items() +
jsonResult_b_30.items() +
jsonResult_b_60.items() + jsonResult_b_D.items() +
jsonResult_b_W.items() + jsonDic.items())
insertRecord_param(jsonParam, collectionName2)
except (IOError, TypeError, NameError, IndexError, Exception) as e:
logging.error("error:" + codeItem)
print e
def strategy002(query_result, zhuti, collectionName):
for codeItem in query_result:
xinhao = ''
print time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time())) + "=====" + codeItem
try:
# MACD
macd_30, macdsignal_30, macdhist_30, jsonResult_30, result_30, mairuresult_30, maichuresult_30 = MACD(codeItem, '30')
macd_60, macdsignal_60, macdhist_60, jsonResult_60, result_60, mairuresult_60, maichuresult_60 = MACD(codeItem, '60')
macd_D, macdsignal_D, macdhist_D, jsonResult_D, result_D, mairuresult_D, maichuresult_D = MACD(codeItem,'D')
macd_W, macdsignal_W, macdhist_W, jsonResult_W, result_W, mairuresult_W, maichuresult_W = MACD(codeItem,'W')
macd_M, macdsignal_M, macdhist_M, jsonResult_M, result_M, mairuresult_M, maichuresult_M = MACD(codeItem,'M')
# 布林线
upperband_30, middleband_30, lowerband_30, jsonResult_b_30, result_bl_30,mairuresult_bl_30,maichuresult_bl_30 = BBANDS(codeItem, '30')
upperband_60, middleband_60, lowerband_60, jsonResult_b_60, result_bl_60,mairuresult_bl_60,maichuresult_bl_60 = BBANDS(codeItem, '60')
upperband_D, middleband_D, lowerband_D, jsonResult_b_D, result_bl_D,mairuresult_bl_D,maichuresult_bl_D = BBANDS(codeItem, 'D')
upperband_W, middleband_W, lowerband_W, jsonResult_b_W, result_bl_W,mairuresult_bl_W,maichuresult_bl_W = BBANDS(codeItem, 'W')
upperband_M, middleband_M, lowerband_M, jsonResult_b_M, result_bl_M, mairuresult_bl_M, maichuresult_bl_M = BBANDS(
codeItem, 'M')
jsonDic = {}
# jsonDic['90_Time'] = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time()))
jsonDic['aaaInfo_1股票编码'] = '_' + codeItem
jsonDic['aaaInfo_2股票名称'] = common.gupiaomingcheng(codeItem)
jsonDic['aaaInfo_股票涨跌幅'] = common.zhangdiefu(codeItem)
# MACD
jsonDic['basicInfo_30分钟MACD快线信息'] = '%.3f' % macd_30[-3] + '_' + '%.3f' % macd_30[-2] + '_' + '%.3f' % macd_30[-1]
jsonDic['basicInfo_30分钟MACD慢线信息'] = '%.3f' % macdsignal_30[-3] + '_' + '%.3f' % macdsignal_30[-2] + '_' + '%.3f' % macdsignal_30[-1]
jsonDic['basicInfo_30分钟MACD柱体信息'] = '%.3f' % macdhist_30[-3] + '_' + '%.3f' % macdhist_30[-2] + '_' + '%.3f' % macdhist_30[-1]
jsonDic['basicInfo_60分钟MACD快线信息'] = '%.3f' % macd_60[-3] + '_' + '%.3f' % macd_60[-2] + '_' + '%.3f' % macd_60[-1]
jsonDic['basicInfo_60分钟MACD慢线信息'] = '%.3f' % macdsignal_60[-3] + '_' + '%.3f' % macdsignal_60[-2] + '_' + '%.3f' % macdsignal_60[-1]
jsonDic['basicInfo_60分钟MACD柱体信息'] = '%.3f' % macdhist_60[-3] + '_' + '%.3f' % macdhist_60[-2] + '_' + '%.3f' % macdhist_60[-1]
jsonDic['basicInfo_日MACD快线信息'] = '%.3f' % macd_D[-3] + '_' + '%.3f' % macd_D[-2] + '_' + '%.3f' % macd_D[-1]
jsonDic['basicInfo_日MACD慢线信息'] = '%.3f' % macdsignal_D[-3] + '_' + '%.3f' % macdsignal_D[-2] + '_' + '%.3f' % macdsignal_D[-1]
jsonDic['basicInfo_日MACD柱体信息'] = '%.3f' % macdhist_D[-3] + '_' + '%.3f' % macdhist_D[-2] + '_' + '%.3f' % macdhist_D[-1]
jsonDic['basicInfo_周MACD快线信息'] = '%.3f' % macd_W[-6] + '_' + '%.3f' % macd_W[-5] + '_' + '%.3f' % macd_W[-4] + '_' + '%.3f' % macd_W[-3] + '_' + '%.3f' % macd_W[-2] + '_' + '%.3f' % macd_W[-1]
jsonDic['basicInfo_周MACD慢线信息'] = '%.3f' % macdsignal_W[-3] + '_' + '%.3f' % macdsignal_W[-2] + '_' + '%.3f' % macdsignal_W[-1]
jsonDic['basicInfo_周MACD柱体信息'] = '%.3f' % macdhist_W[-3] + '_' + '%.3f' % macdhist_W[-2] + '_' + '%.3f' % macdhist_W[-1]
jsonDic['basicInfo_月MACD快线信息'] = '%.3f' % macd_M[-3] + '_' + '%.3f' % macd_M[-2] + '_' + '%.3f' % macd_M[-1]
jsonDic['basicInfo_月MACD慢线信息'] = '%.3f' % macdsignal_M[-3] + '_' + '%.3f' % macdsignal_M[-2] + '_' + '%.3f' % macdsignal_M[-1]
jsonDic['basicInfo_月MACD柱体信息'] = '%.3f' % macdhist_M[-3] + '_' + '%.3f' % macdhist_M[-2] + '_' + '%.3f' % macdhist_M[-1]
# BULL
jsonDic['basicInfo_30分钟布林中线信息'] = '%.3f' % middleband_30[-3] + '_' + '%.3f' % middleband_30[-2] + '_' + '%.3f' % middleband_30[-1]
jsonDic['basicInfo_30分钟布林上线信息'] = '%.3f' % upperband_30[-3] + '_' + '%.3f' % upperband_30[-2] + '_' + '%.3f' % upperband_30[-1]
jsonDic['basicInfo_30分钟布林下线信息'] = '%.3f' % lowerband_30[-3] + '_' + '%.3f' % middleband_30[-2] + '_' + '%.3f' % middleband_30[-1]
jsonDic['basicInfo_60分钟布林中线信息'] = '%.3f' % middleband_60[-3] + '_' + '%.3f' % middleband_60[-2] + '_' + '%.3f' % middleband_60[-1]
jsonDic['basicInfo_60分钟布林上线信息'] = '%.3f' % upperband_60[-3] + '_' + '%.3f' % upperband_60[-2] + '_' + '%.3f' % upperband_60[-1]
jsonDic['basicInfo_60分钟布林下线信息'] = '%.3f' % lowerband_60[-3] + '_' + '%.3f' % lowerband_60[-2] + '_' + '%.3f' % lowerband_60[-1]
jsonDic['basicInfo_日布林中线信息'] = '%.3f' % middleband_D[-3] + '_' + '%.3f' % middleband_D[-2] + '_' + '%.3f' % middleband_D[-1]
jsonDic['basicInfo_日布林上线信息'] = '%.3f' % upperband_D[-3] + '_' + '%.3f' % upperband_D[ -2] + '_' + '%.3f' % upperband_D[-1]
jsonDic['basicInfo_日布林下线信息'] = '%.3f' % lowerband_D[-3] + '_' + '%.3f' % lowerband_D[-2] + '_' + '%.3f' % lowerband_D[-1]
jsonDic['basicInfo_周布林中线信息'] = '%.3f' % middleband_W[-3] + '_' + '%.3f' % middleband_W[-2] + '_' + '%.3f' % middleband_W[-1]
jsonDic['basicInfo_周布林上线信息'] = '%.3f' % upperband_W[-3] + '_' + '%.3f' % upperband_W[-2] + '_' + '%.3f' % upperband_W[-1]
jsonDic['basicInfo_周布林下线信息'] = '%.3f' % lowerband_W[-3] + '_' + '%.3f' % lowerband_W[2] + '_' + '%.3f' % lowerband_W[-1]
jsonDic['basicInfo_月布林中线信息'] = '%.3f' % middleband_M[-3] + '_' + '%.3f' % middleband_M[-2] + '_' + '%.3f' % middleband_M[-1]
jsonDic['basicInfo_月布林上线信息'] = '%.3f' % upperband_M[-3] + '_' + '%.3f' % upperband_M[-2] + '_' + '%.3f' % upperband_M[-1]
jsonDic['basicInfo_月布林下线信息'] = '%.3f' % lowerband_M[-3] + '_' + '%.3f' % lowerband_M[-2] + '_' + '%.3f' % lowerband_M[-1]
# 策略1
# MACD月线大于0，MACD月线处于上升阶段，布林周线下穿
stra001 = ''
if (macdsignal_M[-1] > 0):
stra001 = stra001 + '1'
if (macdhist_M[-1] > macdhist_M[-2]):
stra001 = stra001 + '2'
if ( (common.zuidijiage(codeItem, 'W') - lowerband_W[-1]) < 0):
stra001 = stra001 + '3'
jsonDic['aaaInfo_stra001_MACD月线大于0，MACD月线柱体处于上升阶段，布林周线下穿'] = stra001
# 策略2
# MACD月线大于0，MACD月线柱体转折，布林周线下穿
stra002 = ''
if (macdsignal_M[-1] > 0):
stra002 = stra002 + '1'
if (macdhist_M[-1] > macdhist_M[-2] and macdhist_M[-3] > macdhist_M[-2]):
stra002 = stra002 + '2'
if ((common.zuidijiage(codeItem, 'W') - lowerband_W[-1]) < 0):
stra002 = stra002 + '3'
jsonDic['aaaInfo_stra002_MACD月线大于0，MACD月线柱体转折，布林周线下穿'] = stra002
# 策略3
# MACD月线大于0，MACD月线柱体转折，布林周线下穿
stra003 = ''
if (macdsignal_M[-1] > 0):
stra003 = stra003 + '1'
if (macdhist_M[-1] > macdhist_M[-2]):
stra003 = stra003 + '2'
if (macdhist_W[-1] < macdhist_W[-4] or macdhist_W[-1] < macdhist_W[-5]):
stra003 = stra003 + '3'
jsonDic['aaaInfo_stra003_MACD月线大于0，MACD月线柱体处于上升阶段，MACD_周线_持续下跌，等待时机'] = stra003
# 策略4
if ( (common.zuidijiage(codeItem, 'W') - lowerband_W[-1]) < 0):
jsonDic['aaaInfo_stra004_布林_周线_收在下方'] = 1
# 策略5
if ((common.zuidijiage(codeItem, 'D') - lowerband_D[-1]) < 0):
jsonDic['aaaInfo_stra005_布林_日线_收在下方'] = 1
if ((middleband_D[-1]-lowerband_D[-1])/lowerband_D[-1] > 0.05):
jsonDic['aaaInfo_stra005_布林_日线_收在下方,上升空间大于5%'] = 1
if((common.zuidijiage(codeItem, 'D')-lowerband_W[-1])/common.zuidijiage(codeItem, 'D') < 0.1):
jsonDic['aaaInfo_stra005_布林_日线_收在下方,距离布林周线小于10%'] = 1
except (IOError, TypeError, NameError, IndexError, Exception) as e:
logging.error("error:" + codeItem)
print e
# 插入数据库
jsonParam = dict(jsonDic.items())
insertRecord_param(jsonParam, collectionName)
