想研究一下股票，作為一個(gè)程序員，找到了一個(gè)很好的可以下載金融數(shù)據(jù)的網(wǎng)站，tushare.pro。由于tushare是一個(gè)python類庫(kù)，網(wǎng)上一大把怎么用python獲取股票信息的代碼
然而作為一個(gè)c#開發(fā)人員，想找一些用c#獲取tushare數(shù)據(jù)的代碼做參考，無果。只有自己動(dòng)手了，結(jié)果一番摸索，終于成功調(diào)用tushare的HTTP方法。給有類似需要的朋友做參考。
首先，vs2019新建一個(gè)window窗體項(xiàng)目，名稱隨便
image
在窗體上放一個(gè)button,改名為"下載日線數(shù)據(jù)"
image
引入Newtonsoft.Json和Microsoft.AspNet.WebApi.Client包
添加文件夾helpers和Models
image
新建一個(gè)類，APIHelper，用來發(fā)起請(qǐng)求
{
public static HttpClient ApiClient { get; set; }
public static void InitClient()
{
ApiClient = new HttpClient();
ApiClient.DefaultRequestHeaders.Accept.Clear();
ApiClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
}
}
在Models文件夾下新建類：StockType
/// <summary>
/// 股票類別，根據(jù)自己的需要擴(kuò)展
/// </summary>
public enum StockType
{
/// <summary>
/// 股票基本信息
/// </summary>
stock_basic,
/// <summary>
/// 交易日期
/// </summary>
trade_cal,
/// <summary>
/// 日線行情
/// </summary>
daily
}
StockPara 類：
` /// <summary>
/// 調(diào)用tushare http接口的參數(shù)類
/// </summary>
public class StockPara
{
public StockType stockType { get; set; }
public string api_name { get; set; }
public string token { get; set; }
public Dictionary<string,string> sparams{get;set;}
public string fields { get; set; }
}
StockData 類：
/// <summary>
/// 具體的股票數(shù)據(jù)，根據(jù)獲取的類型不同，fields，items的數(shù)據(jù)不一樣
/// </summary>
public class StockData
{
public string[] fields { get; set; }
public string[][] items { get; set; }
}
StockAllInfo 類：
/// <summary>
/// 所有http接口返回的信息
/// </summary>
public class StockAllInfo
{
public string request_id { get; set; }
public int code { get; set; }
public string msg { get; set; }
public StockData data { get; set; }
}
在helpers文件夾下新建 StockProcessor類：
public class StockProcessor
{
static string Url = "http://api.tushare.pro";
static string Token = "你注冊(cè)后的Token";
/// <summary>
/// 根據(jù)參數(shù)獲取股票信息，在根據(jù)業(yè)務(wù)邏輯進(jìn)行處理
/// </summary>
/// <param name="stockType"></param>
/// <param name="sparams"></param>
/// <param name="fields"></param>
/// <returns></returns>
public static async Task<StockData> GetStockInfo(StockType stockType, Dictionary<string, string> sparams, string fields = "")
{
StockPara para = new StockPara();
para.api_name = stockType.ToString();
para.token = Token;
para.sparams = sparams;
para.fields = fields;
var json = JsonConvert.SerializeObject(para);
var data = new StringContent(json, Encoding.UTF8, "application/json");
using (HttpResponseMessage response = await APIHelper.ApiClient.PostAsync(Url, data))
{
if (response.IsSuccessStatusCode)
{
var msg = await response.Content.ReadAsAsync<StockAllInfo>();
return msg.data;
}
else
{
throw new Exception(response.ReasonPhrase);
}
}
}
}
我用的是sql2008數(shù)據(jù)庫(kù)，新建一個(gè)數(shù)據(jù)庫(kù)，名為stock,執(zhí)行下面的sql語句：
USE [Stock]
GO
/****** Object: Table [dbo].[stock_dayly] Script Date: 2019/12/31 12:31:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[stock_dayly](
[ts_code] [varchar](50) NOT NULL,
[trade_date] [varchar](50) NOT NULL,
[open] [float] NULL,
[high] [float] NULL,
[low] [float] NULL,
[close] [float] NULL,
[pre_close] [float] NULL,
[change] [float] NULL,
[pct_chg] [float] NULL,
[vol] [float] NULL,
[amount] [float] NULL
) ON [PRIMARY]
GO
最后，更改Form1的代碼如下：
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
APIHelper.InitClient();
}
/// <summary>
/// 獲取日線行情
/// </summary>
/// <returns></returns>
private async Task GetStock_Daily()
{
Dictionary<string, string> paras = new Dictionary<string, string>();
paras.Add("start_date", "20191230");
paras.Add("end_date", "20191230");
var objs = await StockProcessor.GetStockInfo(StockType.daily, paras);
DataTable dt = new DataTable();
dt.Columns.Add("ts_code", typeof(string));
dt.Columns.Add("trade_date", typeof(string));
dt.Columns.Add("open", typeof(float));
dt.Columns.Add("high", typeof(float));
dt.Columns.Add("low", typeof(float));
dt.Columns.Add("close", typeof(float));
dt.Columns.Add("pre_close", typeof(float));
dt.Columns.Add("change", typeof(float));
dt.Columns.Add("pct_chg", typeof(float));
dt.Columns.Add("vol", typeof(float));
dt.Columns.Add("amount", typeof(float));
for (int i = 0; i < objs.items.Length; i++)
{
DataRow row = dt.NewRow();
for (int j = 0; j < objs.fields.Length; j++)
{
row[j] = objs.items[i][j];
}
dt.Rows.Add(row);
}
string connectionString = @" Server = localhost; Database = Stock; Trusted_Connection = True;";
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connectionString, SqlBulkCopyOptions.UseInternalTransaction))
{
try
{
bulkCopy.DestinationTableName = "stock_dayly";
bulkCopy.WriteToServer(dt);
}
catch (System.Exception ex)
{
throw ex;
}
}
}
}
private async void button1_Click(object sender, EventArgs e)
{
await GetStock_Daily();
MessageBox.Show("下載日線數(shù)據(jù)成功");
}
}
點(diǎn)擊按鈕
image.png
以上就是我簡(jiǎn)單的示例代碼，我的類都寫了注釋，不懂的可以看注釋。其中的亮點(diǎn)，插入代碼用了SqlBulkCopy類，示例中，4000行數(shù)據(jù)插入花了不到1秒時(shí)間。
