打开APP
userphoto
未登录

开通VIP,畅享免费电子书等14项超值服

开通VIP
Use Yahoo Finance as a data source – Klipfolio Help Center

Resources

Data Source Type:REST/URL
Sample Query

This example query uses Yahoo Finance quote properties for NASDAQ:

http://download.finance.yahoo.com/d/quotes.csv?s=^IXIC&f=nsl1opc1p2&e=.csv

API Documentation

Getting Started with the Yahoo Finance API

Get Real Time Stock Quotes with the Yahoo Finance API

Important!

Yahoo Finance API does not support all the stock symbols.

Klip GallerySave time and add pre-built Klips with the Klip Gallery!
See Klip Gallery: Yahoo Finance.

Step-by-Step

Step 1: Start the data source creation process

To create a data source using Yahoo Finance, go to the Connector Gallery page in Klipfolio and select Yahoo Finance.

Step 2: Write a Yahoo Finance Query

To build a Yahoo Finance query, you will need to include quote properties in your query. If you are interested in historical data, you will also need to enter correct date formatting as instructed by Yahoo Finance. Use the following Yahoo Finance API links for reference:

Refer to the links above to learn more about writing a query. Here are a few example queries to help you get started:

Example 1: for Yahoo Finance - NASDAQ

This example query uses Yahoo Finance quote properties:

http://download.finance.yahoo.com/d/quotes.csv?s=^IXIC&f=nsl1opc1p2&e=.csv

Example 2: for Yahoo Finance - Yahoo, Google and Apple

This example query uses multiple stock symbols

http://download.finance.yahoo.com/d/quotes.csv?s=YHOO,GOOG,AAPL&f=sl1d1t1c1ohgv&e=.csv&columns='symbol,price,date,time,change,col1,high,low,col2

Remember! Yahoo Finance API does not support all the stock symbols.

Example 3: for Yahoo Finance - 30 Day Stock History

This example query uses Yahoo Finance date formatting:

http://ichart.yahoo.com/table.csv?s=GE&a={date.addMonths(-2).format('MM')}&b={date.today.format('dd')}&c={date.today.format('yyyy')}&d={date.addMonths(-1).format('MM')}&e={date.today.format('dd')}&f={date.today.format('yyyy')}&g=d&ignore=.csv

  • After entering your query, click Get Resource.
  • If you are happy with the data provided, click Continue.
  • Save and name your data source.

Useful articles

Related links

本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请点击举报
打开APP,阅读全文并永久保存 查看更多类似文章
猜你喜欢
类似文章
【热】打开小程序,算一算2024你的财运
Finance APIs
如何设置excel工作簿内数据不能重复导入?
Download Query Express
操盘必读
逆透视简单好用
PQ-综合实战:数据都堆在一列里,怎么办?
更多类似文章 >>
生活服务
热点新闻
分享 收藏 导长图 关注 下载文章
绑定账号成功
后续可登录账号畅享VIP特权!
如果VIP功能使用有故障,
可点击这里联系客服!

联系客服