Example #1
0
__author__ = 'Rocky'
'''
http://30daydo.com
Contact: [email protected]
'''
import datetime
import os
import xlrd
import time
from xlutils.copy import copy
import tushare as ts
from setting import get_mysql_conn
import codecs
from setting import LLogger

logger = LLogger('recordMyChoice.log')


class Prediction_rate():
    def __init__(self):
        self.today_stock = ts.get_today_all()
        now = datetime.datetime.now()
        self.today = now.strftime("%Y-%m-%d")
        # weekday=now+datetime.timedelta(days=-2)
        # weekday=weekday.strftime("%Y-%m-%d")
        # print weekday
        # today=now.strftime('%Y-%m-%d')
        self.path = os.path.join(os.getcwd(), 'data')
        self.filename = os.path.join(self.path, 'recordMyChoice.xls')

    def stock_pool(self, stock_list):
Example #2
0
__author__ = 'Rocky'
'''
http://30daydo.com
Contact: [email protected]
'''
# 每天的涨跌停
import urllib2, re, time, xlrd, xlwt, sys, os
import setting
import pandas as pd
import tushare as ts
from setting import LLogger
reload(sys)
sys.setdefaultencoding('gbk')

logger = LLogger('zdt.log')


class GetZDT:
    def __init__(self, current):
        self.user_agent = "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/64.0.3282.167 Chrome/64.0.3282.167 Safari/537.36"
        # self.today = time.strftime("%Y%m%d")
        self.today = current
        self.path = os.path.join(os.path.dirname(__file__), 'data')
        self.zdt_url = 'http://home.flashdata2.jrj.com.cn/limitStatistic/ztForce/' + self.today + ".js"
        self.zrzt_url = 'http://hqdata.jrj.com.cn/zrztjrbx/limitup.js'

        self.host = "home.flashdata2.jrj.com.cn"
        self.reference = "http://stock.jrj.com.cn/tzzs/zdtwdj/zdforce.shtml"

        self.header_zdt = {
Example #3
0
Contact: [email protected]
'''
# working v1.0
from bs4 import BeautifulSoup
import urllib2
import datetime
import time
import codecs
import random
import os, sys
# import itchat
# import MySQLdb
# import setting
from setting import sendmail,LLogger
from setting import get_mysql_conn
logger = LLogger('news.log')

def create_tb(conn):
    cur=conn.cursor()
    cmd = '''CREATE TABLE IF NOT EXISTS tb_cnstock(Date DATETIME ,Title VARCHAR (80),URL VARCHAR (80),PRIMARY KEY (URL)) charset=utf8;'''
    try:
        cur.execute(cmd)
        conn.commit()
        # conn.close()
        return True
    except Exception as e:
        logger.log(e)
        conn.rollback()
        return False

def getinfo(max_index_user=3, days=-2):
Example #4
0
# -*-coding=utf-8-*-
# 估价达到自己的设定值,发邮件通知, 每天2.45发邮件
import tushare as ts
from setting import sendmail, get_engine, trading_time, LLogger
import datetime
import time
import pandas as pd
import tushare as ts
logger = LLogger('alert.log')

# 5秒循环检测一次
LOOP__TIME = 60
EXECEPTION_TIME = 2* LOOP__TIME

class ReachTarget():
    def __init__(self):
        self.cb_code, self.name, self.yjl= self.bond()
        self.stocks = dict(zip(self.cb_code,self.name))
        self.stocks_yjl = dict(zip(self.cb_code,self.yjl))
        self.api = ts.get_apis()
        self.code_list = self.stocks.keys()

    def bond(self):
        engine = get_engine('db_bond')
        bond_table = 'tb_bond_jisilu'
        try:
            jsl_df = pd.read_sql(bond_table, engine, index_col='index')
            return list(jsl_df[u'正股代码'].values),list(jsl_df[u'正股名称'].values),list(jsl_df[u'溢价率'].values)
        except Exception,e:
            logger.log(e)
            return None
Example #5
0
# -*-coding=utf-8-*-
# 估价达到自己的设定值,发邮件通知, 每天2.45发邮件
import tushare as ts
from setting import sendmail, get_engine, trading_time, LLogger
import datetime
import time
import pandas as pd
import tushare as ts
import config

logger = LLogger('alert.log')

# 5秒循环检测一次
LOOP__TIME = 60
EXECEPTION_TIME = 2 * LOOP__TIME


class ReachTarget():
    def __init__(self):
        self.cb_code, self.name, self.yjl = self.bond()
        self.stocks = dict(zip(self.cb_code, self.name))
        self.stocks_yjl = dict(zip(self.cb_code, self.yjl))
        self.api = ts.get_apis()
        self.code_list = self.stocks.keys()

    def bond(self):
        engine = get_engine('db_bond')
        bond_table = 'tb_bond_jisilu'

        try:
            jsl_df = pd.read_sql(bond_table, engine, index_col='index')
Example #6
0
#-*-coding=utf-8-*-
# 每天收盘收运行
import datetime

__author__ = 'Rocky'
import tushare as ts
import os
from setting import get_engine,LLogger
import pandas as pd
logger=LLogger('collect_data.log')

class SaveData():
    today = datetime.datetime.now().strftime("%Y-%m-%d")
    daily_engine = get_engine('daily')

    def __init__(self):
        current=os.getcwd()
        work_space=os.path.join(current,'data')
        if os.path.exists(work_space) ==False:
            os.mkdir(work_space)
        os.chdir(work_space)


    @staticmethod
    def daily_market():
        df = ts.get_today_all()
        try:
            df.to_sql(SaveData.today,SaveData.daily_engine,if_exists='replace')
        except Exception,e:
            print e
        print "Save {} data to MySQL".format(SaveData.today)
Example #7
0
Contact: [email protected]
'''
# working v1.0
from bs4 import BeautifulSoup
import urllib2
import datetime
import time
import codecs
import random
import os, sys
# import itchat
# import MySQLdb
# import setting
from setting import sendmail, LLogger
from setting import get_mysql_conn
logger = LLogger('news.log')


def create_tb(conn):
    cur = conn.cursor()
    cmd = '''CREATE TABLE IF NOT EXISTS tb_cnstock(Date DATETIME ,Title VARCHAR (80),URL VARCHAR (80),PRIMARY KEY (URL)) charset=utf8;'''
    try:
        cur.execute(cmd)
        conn.commit()
        # conn.close()
        return True
    except Exception, e:
        logger.log(e)
        conn.rollback()
        return False