最近一两年内,股票量化分析逐渐成为热门话题。而从事这一领域工作的第一步,就是获取全面且准确的股票数据。因为无论是实时交易数据、历史交易记录、财务数据还是基本面信息,这些数据都是我们进行量化分析时不可或缺的宝贵资源。我们的主要任务是从这些数据中提炼出有价值的信息,为我们的投资策略提供有力的指导。
在数据探索的旅途中,我尝试了多种方法,包括自编网易股票页面爬虫、申万行业数据爬虫,以及同花顺问财的爬虫,甚至还使用了聚宽的免费数据API。然而,爬虫作为数据源常常显得不够稳定,给我们的量化分析带来不小的困扰。
在量化分析领域,实时且准确的数据接口是成功的基石。经过多次实际测试,我将已确认可用的数据接口分享给正在从事量化分析的朋友们,希望能够对你们的研究和工作有所帮助,接下来我会用Python、JavaScript(Node.js)、Java、C#和Ruby五种主流语言的实例代码给大家逐一演示一下如何获取各类股票数据:
1、python
import requests
url = "http://api.mairui.club/hscp/cwzb/000001/b997d4403688d5e66a"
response = requests.get(url)
data = response.json()
print(data)
2、JavaScript (Node.js)
const axios = require('axios');
const url = "http://api.mairui.club/hscp/cwzb/000001/b997d4403688d5e66a";
axios.get(url)
.then(response => {
console.log(response.data);
})
.catch(error => {
console.log(error);
});
3、Java
import java.net.URI;
import java.net.http.HttpClient;
import java.net.http.HttpRequest;
import java.net.http.HttpResponse;
import java.io.IOException;
public class Main {
public static void main(String[] args) {
HttpClient client = HttpClient.newHttpClient();
HttpRequest request = HttpRequest.newBuilder()
.uri(URI.create("http://api.mairui.club/hscp/cwzb/000001/b997d4403688d5e66a"))
.build();
try {
HttpResponse<String> response = client.send(request, HttpResponse.BodyHandlers.ofString());
System.out.println(response.body());
} catch (IOException | InterruptedException e) {
e.printStackTrace();
}
}
}
4、C#
using System;
using System.Net.Http;
using System.Threading.Tasks;
class Program
{
static async Task Main()
{
using (HttpClient client = new HttpClient())
{
string url = "http://api.mairui.club/hscp/cwzb/000001/b997d4403688d5e66a";
HttpResponseMessage response = await client.GetAsync(url);
string responseBody = await response.Content.ReadAsStringAsync();
Console.WriteLine(responseBody);
}
}
}
5、Ruby
require 'net/http'
require 'json'
url = URI("http://api.mairui.club/hscp/cwzb/000001/b997d4403688d5e66a")
http = Net::HTTP.new(url.host, url.port)
request = Net::HTTP::Get.new(url)
response = http.request(request)
data = JSON.parse(response.read_body)
puts data
返回的数据:
[{"date":"2024-06-30","tbmg":"1.3336","jqmg":"1.23","mgsy":"1.23","kfmg":"1.23","mgjz":"24.831","mgjzad":"21.23","mgjy":"5.8602","mggjj":"4.1617","mgwly":"11.9029","zclr":"0.4498","zylr":"--","zzlr":"0.4564","cblr":"146.0671","yylr":"--","zycb":"--","xsjl":"--","gbbc":"193.106","jzbc":"7.7768","zcbc":"0.6513","xsml":"--","xxbz":"--","fzy":"37.9304","zybz":"-2.4486","gxff":"--","tzsy":"--","zyyw":"-783000000","jzsy":"5.37","jqjz":"5.79","kflr":"25880000000","zysr":"--","jlzz":"1.938","jzzz":"6.591","zzzz":"4.6088","yszz":"--","yszzt":"--","chzz":"--","chzzl":"--","gzzz":"--","zzzzl":"--","zzzzt":"--","ldzz":"--","ldzzt":"--","gdzz":"--","ldbl":"--","sdbl":"--","xjbl":"--","lxzf":"--","zjbl":"--","gdqy":"8.3745","cqfz":"--","gdgd":"5248.5459","fzqy":"1094.1073","zczjbl":"--","zblv":"--","gdzcjz":"44.1904","zbgdh":"1194.1073","cqbl":"0","qxjzb":"--","gdzcbz":"0.1596","zcfzl":"91.6255","zzc":"5754033000000","jyxj":"--","zcjyxj":"0.0198","jylrb":"4.3944","jyfzl":"0.0216","xjlbl":"--","dqgptz":null,"dqzctz":"--","dqjytz":"--","qcgptz":null,"cqzqtz":"779113000000","cqjyxtz":"--","yszk1":"--","yszk12":"--","yszk23":"--","yszk3":"--","yfhk1":"--","yfhk12":"94000000","yfhk23":"98000000","yfhk3":"--","ysk1":"--","ysk12":"--","ysk23":"--","ysk3":"--"},{"date":"2024-03-31","tbmg":"0.7695","jqmg":"0.66","mgsy":"0.66","kfmg":"0.66","mgjz":"25.0221","mgjzad":"21.42","mgjy":"-1.1018","mggjj":"4.1617","mgwly":"12.0596","zclr":"0.2606","zylr":"--","zzlr":"0.2639","cblr":"171.2107","yylr":"--","zycb":"--","xsjl":"--","gbbc":"76.9456","jzbc":"3.0751","zcbc":"0.2606","xsml":"--","xxbz":"--","fzy":"25.2254","zybz":"-2.1053","gxff":"--","tzsy":"--","zyyw":"-390000000","jzsy":"3.08","jqjz":"3.15","kflr":"14906000000","zysr":"--","jlzz":"2.26","jzzz":"8.692","zzzz":"5.0129","yszz":"--","yszzt":"--","chzz":"--","chzzl":"--","gzzz":"--","zzzzl":"--","zzzzt":"--","ldzz":"--","ldzzt":"--","gdzz":"--","ldbl":"--","sdbl":"--","xjbl":"--","lxzf":"--","zjbl":"--","gdqy":"8.4752","cqfz":"--","gdgd":"--","fzqy":"1079.9179","zczjbl":"--","zblv":"--","gdzcjz":"--","zbgdh":"1179.9179","cqbl":"0","qxjzb":"--","gdzcbz":"--","zcfzl":"91.5248","zzc":"5729398000000","jyxj":"--","zcjyxj":"-0.0037","jylrb":"-1.432","jyfzl":"-0.0041","xjlbl":"--","dqgptz":null,"dqzctz":"--","dqjytz":"--","qcgptz":null,"cqzqtz":"792167000000","cqjyxtz":"--","yszk1":"--","yszk12":"--","yszk23":"--","yszk3":"--","yfhk1":"--","yfhk12":"--","yfhk23":"--","yfhk3":"--","ysk1":"--","ysk12":"--","ysk23":"--","ysk3":"--"},{"date":"2023-12-31","tbmg":"2.3939","jqmg":"2.25","mgsy":"2.25","kfmg":"2.25","mgjz":"24.3394","mgjzad":"20.74","mgjy":"4.7646","mggjj":"4.1617","mgwly":"11.4014","zclr":"0.8315","zylr":"--","zzlr":"0.8517","cblr":"121.0605","yylr":"--","zycb":"--","xsjl":"--","gbbc":"296.0334","jzbc":"12.1627","zcbc":"1.0282","xsml":"--","xxbz":"--","fzy":"27.4507","zybz":"-2.9765","gxff":"--","tzsy":"--","zyyw":"-1718000000","jzsy":"9.84","jqjz":"11.38","kflr":"46431000000","zysr":"--","jlzz":"2.063","jzzz":"8.6611","zzzz":"4.9911","yszz":"--","yszzt":"--","chzz":"--","chzzl":"--","gzzz":"--","zzzzl":"--","zzzzt":"--","ldzz":"--","ldzzt":"--","gdzz":"--","ldbl":"--","sdbl":"--","xjbl":"--","lxzf":"--","zjbl":"--","gdqy":"8.4539","cqfz":"--","gdgd":"4812.3077","fzqy":"1082.889","zczjbl":"--","zblv":"--","gdzcjz":"47.1694","zbgdh":"1182.889","cqbl":"0","qxjzb":"--","gdzcbz":"0.1757","zcfzl":"91.5461","zzc":"5587116000000","jyxj":"--","zcjyxj":"0.0165","jylrb":"1.9903","jyfzl":"0.0181","xjlbl":"--","dqgptz":null,"dqzctz":"--","dqjytz":"--","qcgptz":null,"cqzqtz":"772467000000","cqjyxtz":"--","yszk1":"--","yszk12":"--","yszk23":"--","yszk3":"--","yfhk1":"--","yfhk12":"--","yfhk23":"--","yfhk3":"--","ysk1":"--","ysk12":"--","ysk23":"--","ysk3":"--"},{"date":"2023-09-30","tbmg":"2.0424","jqmg":"1.94","mgsy":"1.94","kfmg":"1.93","mgjz":"24.0061","mgjzad":"20.4","mgjy":"5.974","mggjj":"4.1616","mgwly":"11.2464","zclr":"0.7185","zylr":"--","zzlr":"0.7314","cblr":"139.2915","yylr":"--","zycb":"--","xsjl":"--","gbbc":"204.2418","jzbc":"8.5079","zcbc":"0.7185","xsml":"--","xxbz":"--","fzy":"22.8849","zybz":"-2.6228","gxff":"--","tzsy":"--","zyyw":"-1285000000","jzsy":"8.51","jqjz":"9.88","kflr":"39568000000","zysr":"--","jlzz":"8.1181","jzzz":"9.5152","zzzz":"6.1838","yszz":"--","yszzt":"--","chzz":"--","chzzl":"--","gzzz":"--","zzzzl":"--","zzzzt":"--","ldzz":"--","ldzzt":"--","gdzz":"--","ldbl":"--","sdbl":"--","xjbl":"--","lxzf":"--","zjbl":"--","gdqy":"8.445","cqfz":"--","gdgd":"--","fzqy":"1084.13","zczjbl":"--","zblv":"--","gdzcjz":"--","zbgdh":"1184.13","cqbl":"0","qxjzb":"--","gdzcbz":"--","zcfzl":"91.555","zzc":"5516388000000","jyxj":"--","zcjyxj":"0.021","jylrb":"2.9249","jyfzl":"0.023","xjlbl":"--","dqgptz":null,"dqzctz":"--","dqjytz":"--","qcgptz":null,"cqzqtz":"745661000000","cqjyxtz":"--","yszk1":"--","yszk12":"--","yszk23":"--","yszk3":"--","yfhk1":"--","yfhk12":"--","yfhk23":"--","yfhk3":"--","ysk1":"--","ysk12":"--","ysk23":"--","ysk3":"--"}]
财务指标
API接口:http://api.mairui.club/hscp/cwzb/股票代码(如000001)/b997d4403688d5e66a
接口说明:根据《股票列表》得到的股票代码获取上市公司近四个季度的主要财务指标。按报告日期倒序。
字段名称 | 数据类型 | 字段说明 |
---|---|---|
date | string | 报告日期yyyy-MM-dd |
tbmg | string | 摊薄每股收益(元)d |
jqmg | string | 加权每股收益(元)型 |
mgsy | string | 每股收益_调整后(元) |
kfmg | string | 扣除非经常性损益后的每股收益(元) |
mgjz | string | 每股净资产_调整前(元) |
mgjzad | string | 每股净资产_调整后(元) |
mgjy | string | 每股经营性现金流(元) |
mggjj | string | 每股资本公积金(元) |
mgwly | string | 每股未分配利润(元) |
zclr | string | 总资产利润率(%) |
zylr | string | 主营业务利润率(%) |
zzlr | string | 总资产净利润率(%) |
cblr | string | 成本费用利润率(%) |
yylr | string | 营业利润率(%) |
zycb | string | 主营业务成本率(%) |
xsjl | string | 销售净利率(%) |
gbbc | string | 股本报酬率(%) |
jzbc | string | 净资产报酬率(%) |
zcbc | string | 资产报酬率(%) |
xsml | string | 销售毛利率(%) |
xxbz | string | 三项费用比重 |
fzy | string | 非主营比重 |
zybz | string | 主营利润比重 |
gxff | string | 股息发放率(%) |
tzsy | string | 投资收益率(%) |
zyyw | string | 主营业务利润(元) |
jzsy | string | 净资产收益率(%) |
jqjz | string | 加权净资产收益率(%) |
kflr | string | 扣除非经常性损益后的净利润(元) |
zysr | string | 主营业务收入增长率(%) |
jlzz | string | 净利润增长率(%) |
jzzz | string | 净资产增长率(%) |
zzzz | string | 总资产增长率(%) |
yszz | string | 应收账款周转率(次) |
yszzt | string | 应收账款周转天数(天) |
chzz | string | 存货周转天数(天) |
chzzl | string | 存货周转率(次) |
gzzz | string | 固定资产周转率(次) |
zzzzl | string | 总资产周转率(次) |
zzzzt | string | 总资产周转天数(天) |
ldzz | string | 流动资产周转率(次) |
ldzzt | string | 流动资产周转天数(天) |
gdzz | string | 股东权益周转率(次) |
ldbl | string | 流动比率 |
sdbl | string | 速动比率 |
xjbl | string | 现金比率(%) |
lxzf | string | 利息支付倍数 |
zjbl | string | 长期债务与营运资金比率(%) |
gdqy | string | 股东权益比率(%) |
cqfz | string | 长期负债比率(%) |
gdgd | string | 股东权益与固定资产比率(%) |
fzqy | string | 负债与所有者权益比率(%) |
zczjbl | string | 长期资产与长期资金比率(%) |
zblv | string | 资本化比率(%) |
gdzcjz | string | 固定资产净值率(%) |
zbgdh | string | 资本固定化比率(%) |
cqbl | string | 产权比率(%) |
qxjzb | string | 清算价值比率(%) |
gdzcbz | string | 固定资产比重(%) |
zcfzl | string | 资产负债率(%) |
zzc | string | 总资产(元) |
jyxj | string | 经营现金净流量对销售收入比率(%) |
zcjyxj | string | 资产的经营现金流量回报率(%) |
jylrb | string | 经营现金净流量与净利润的比率(%) |
jyfzl | string | 经营现金净流量对负债比率(%) |
xjlbl | string | 现金流量比率(%) |
dqgptz | string | 短期股票投资(元) |
dqzctz | string | 短期债券投资(元) |
dqjytz | string | 短期其它经营性投资(元) |
qcgptz | string | 长期股票投资(元) |
cqzqtz | string | 长期债券投资(元) |
cqjyxtz | string | 长期其它经营性投资(元) |
yszk1 | string | 1年以内应收帐款(元) |
yszk12 | string | 1-2年以内应收帐款(元) |
yszk23 | string | 2-3年以内应收帐款(元) |
yszk3 | string | 3年以内应收帐款(元) |
yfhk1 | string | 1年以内预付货款(元) |
yfhk12 | string | 1-2年以内预付货款(元) |
yfhk23 | string | 2-3年以内预付货款(元) |
yfhk3 | string | 3年以内预付货款(元) |
ysk1 | string | 1年以内其它应收款(元) |
ysk12 | string | 1-2年以内其它应收款(元) |
ysk23 | string | 2-3年以内其它应收款(元) |
ysk3 | string | 3年以内其它应收款(元) |
【重要提示】
上方所有演示中的API接口Url链接结尾的b997d4403688d5e66a,均为数据请求licence证书,因为这个证书是官方测试证书,仅可用于验证各个接口的有效性,所以这个证书限制了只可请求股票代码为000001的数据,正式环境中是不能使用的,证书可以自己去申请一个替换掉就好了,证书是免费申请的:https://www.mairui.club/getlicence.html,替换成自己申请的证书就可以请求任何股票数据了。