We don’t allow questions seeking recommendations for software libraries, tutorials, tools, books, or other off-site resources. You can edit the question so it can be answered with facts and citations.
Closed 6 years ago.
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
接受
或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
发布评论
评论(4)
我想您会通过查看这个问题找到您需要了解的所有信息:历史股票数据来源
除了 Yahoo! 之外,我不知道还有其他免费数据源,但它不提供逐笔数据,仅提供 1 分钟间隔和 15 分钟延迟。如果您想使用已有的工具来下载历史数据,那么我建议 EclipseTrader。它仅保存开盘价、收盘价、最高价、最低价和成交量。
(来源:divbyzero.com)
您可以轻松编写自己的数据抓取器。我写了一篇关于 下载 real- 的文章我的博客上有来自 yahoo 的时间数据,但它是用 C# 编写的。如果您熟悉 C#,那么您将能够很快地将操作翻译成 Java。如果您编写自己的数据抓取工具,那么您几乎可以获得 Yahoo! 的任何内容。在他们的网站上显示:买价、卖价、股息份额、收益份额、当日最高价、当日最低价等。
如果您不懂 C#,请不用担心,这非常简单:Yahoo 允许您下载只需修改 URL 即可添加带引号的 CSV 文件。您可以在此处找到有关 yahoo 上使用的 URL 和标签的所有信息: http: //www.gummy-stuff.org/Yahoo-data.htm
以下是您需要遵循的基本步骤:
URLConnection
您刚刚构建的 URL。您的 CSV 将具有以下格式:
I think you'll find all you need to know by looking at this question: source of historical stock data
I don't know of any free data feeds other than Yahoo!, but it doesn't offer tick-by-tick data, it only offers 1 minute intervals with a 15 minute delay. If you want to use an already existing tool to download the historical data, then I would recommend EclipseTrader. It only saves the Open, Close, High, Low, and Volume.
(source: divbyzero.com)
You can write your own data scraper with very little effort. I've written an article on downloading real-time data from yahoo on my blog, but it's in C#. If you're familiar with C# then you'll be able to translate the action in Java pretty quickly. If you write your own data scraper then you can get pretty much ANYTHING that Yahoo! shows on their web site: Bid, Ask, Dividend Share, Earnings Share, Day's High, Day's Low, etc, etc, etc.
If you don't know C# then don't worry, it's REALLY simple: Yahoo allows you to download CSV files with quotes just by modifying a URL. You can find out everything about the URL and the tags that are used on yahoo here: http://www.gummy-stuff.org/Yahoo-data.htm
Here are the basic steps you need to follow:
URLConnection
with the URL you just constructed.BufferedReader
to read the CSV file that is returned from the connection stream.Your CSV will have the following format:
开设 TDAmeritrade 账户,您将可以免费访问 ThinkOrSwim 实时交易和报价平台。实盘交易是实时的,纸面交易有15分钟延迟。我忘记了开设 TDAMeritrade 账户的最低要求是什么,但您可以前往 TDAMeritrade.com 或 thinkorswim.com 进行查看。
Open a TDAmeritrade account and you will have free access to ThinkOrSwim real time trading and quotes platform. Live trading is real time and paper trading is delayed 15 minutes. I forget what the minimum required is to open a TDAmeritrade account but you can go to TDAMeritrade.com or thinkorswim.com to check them out.
Intrinio 有很多免费和付费级别的提要。本质上,您只需为您需要的内容付费,而不是为更大的数据供应商付费。 Intrinio 专注于数据质量并迎合开发人员的需求,所以我认为这对您来说是一个不错的选择。
全面披露 - 我在 Intrinio 担任开发人员
Intrinio has a bunch of feeds with free and paid tiers. Essentially you only have to pay for what you need as opposed to the bigger data suppliers. Intrinio focuses on data quality and caters to developers as well, so I think it'd be a great option for you.
full disclosure - I work at Intrinio as a developer
Google Sheets(ImportHTML)中有一个方便的功能,我已经使用了一段时间,效果不错。
例如 -
=ImportHTML("http://www.bloomberg.com/markets/commodities /futures/metals/","table",1),5,3) 返回欧元黄金现货价格。
它也适用于雅虎,因此 =Index(ImportHTML("http://finance. yahoo.com/q?s=DX-Y.NYB","table",0),2,2) 返回 DXY。
数据更新有一些小的延迟,但它是可用的。
There's a handy function in Google Sheets (ImportHTML) which I've been using for a while to reasonable effect.
For example -
=ImportHTML("http://www.bloomberg.com/markets/commodities/futures/metals/","table",1),5,3) returns the EUR Gold spot price.
It works with Yahoo too, so =Index(ImportHTML("http://finance.yahoo.com/q?s=DX-Y.NYB","table",0),2,2) returns the DXY.
The data updates with some small delay but it's usable.