使用python获取股票行情

从163网站获取股票行情，网址：http://quotes.money.163.com/service/chddata.html

1、获取股票行情源码，getStock.py

#导入需要使用到的模块
import urllib
import re
import pandas as pd
import pymysql
import os
import datetime
from openpyxl import Workbook
from openpyxl import load_workbook
from openpyxl.writer.excel import ExcelWriter
import csv

 

#抓取特定股票, 保存到csv文本文件
def getStockByCode2EndDate(stockCode,endDate):
    if stockCode[0] == '0': #深圳市场
        if stockCode == '000001': #上证指数
            url = 'http://quotes.money.163.com/service/chddata.html?code=0'+stockCode+\
            '&end='+endDate+'&fields=TCLOSE;HIGH;LOW;TOPEN;LCLOSE;CHG;PCHG;TURNOVER;VOTURNOVER;VATURNOVER;TCAP;MCAP'
        else:
            url = 'http://quotes.money.163.com/service/chddata.html?code=1'+stockCode+\
            '&end='+endDate+'&fields=TCLOSE;HIGH;LOW;TOPEN;LCLOSE;CHG;PCHG;TURNOVER;VOTURNOVER;VATURNOVER;TCAP;MCAP'
    else: #上海市场
        url = 'http://quotes.money.163.com/service/chddata.html?code=0'+stockCode+\
        '&end='+endDate+'&fields=TCLOSE;HIGH;LOW;TOPEN;LCLOSE;CHG;PCHG;TURNOVER;VOTURNOVER;VATURNOVER;TCAP;MCAP'
    print(url)
    urllib.request.urlretrieve(url, '../data/'+stockCode+'.csv')

#抓取特定股票， 保存到csv文本文件
def getStockByCode(stockCode,startDate):
    if stockCode[0] == '0': #深圳市场
        if stockCode == '000001': #上证指数
                url = 'http://quotes.money.163.com/service/chddata.html?code=0'+stockCode+\
                '&start='+startDate+'&fields=TCLOSE;HIGH;LOW;TOPEN;LCLOSE;CHG;PCHG;TURNOVER;VOTURNOVER;VATURNOVER;TCAP;MCAP'
        else :
                url = 'http://quotes.money.163.com/service/chddata.html?code=1'+stockCode+\
                '&start='+startDate+'&fields=TCLOSE;HIGH;LOW;TOPEN;LCLOSE;CHG;PCHG;TURNOVER;VOTURNOVER;VATURNOVER;TCAP;MCAP'
    else: #上海市场
        url = 'http://quotes.money.163.com/service/chddata.html?code=0'+stockCode+\
        '&start='+startDate+'&fields=TCLOSE;HIGH;LOW;TOPEN;LCLOSE;CHG;PCHG;TURNOVER;VOTURNOVER;VATURNOVER;TCAP;MCAP'

    print(url)
    urllib.request.urlretrieve(url, '../data/'+stockCode+'.csv')

#连接数据库
def connect(host,port,user,passwd,db):
    conn = pymysql.Connect(host=host,port=port,u