Example #1
0
def update(end_date):
    indexes = bd.getStocks(True)
    for each in indexes:
        stock_code = each[0]
        stock_code_163 = each[3]
        start_date = each[5]

        if start_date is None:
            start_date = du.convertStringToDate("1990-01-01", "%Y-%m-%d")
        elif start_date == end_date:
            continue
        else:
            start_date = start_date + timedelta(1)

        data = bd.getStockData(stock_code_163, start_date, end_date)
        last_updated_date = data[0].split(",")[0]

        bd.insertBasicData(stock_code, data)
        bd.insertTechData(stock_code, data)
        bd.insertAnalysisData(stock_code, data)
        bd.updateMasterDate("LAST_UPDATED_DATE", last_updated_date, stock_code_163)

    stocks = bd.getStocks(False)
    for each in stocks:
        stock_code = each[0]
        stock_code_163 = each[3]
        stock_code_sina = each[4]
        start_date = each[5]

        if start_date is None:
            start_date = du.convertStringToDate("1990-01-01", "%Y-%m-%d")
        elif start_date == end_date:
            continue
        else:
            start_date = start_date + timedelta(1)

        data = bd.getStockData(stock_code_163, start_date, end_date)
        last_updated_date = data[0].split(",")[0]

        bd.insertBasicData(stock_code, data)
        bd.insertTechData(stock_code, data)
        bd.insertAnalysisData(stock_code, data)
        bd.updateMasterDate("LAST_UPDATED_DATE", last_updated_date, stock_code_163)

        rf = bd.getRecoveryFactor(stock_code_163, stock_code_sina, start_date)
        bd.insertRecoveryFactor(stock_code, rf)