I have a Web application that needs to display up to date information on REITs and tickers like AX.UN, BEI.UN, CAR.UN etc..
我有一个Web应用程序,需要显示有关REIT和代码的最新信息,如AX.UN,BEI.UN,CAR.UN等。
For example, I need to automate consumption of information on pages such as http://ca.finance.yahoo.com/q?s=AX-UN.TO
例如,我需要在http://ca.finance.yahoo.com/q?s=AX-UN.TO等页面上自动消费信息。
Are there rss feeds or apis I can use to import this kind of data? I don't want to copy and paste this information into my website on a daily basis.
是否有rss feed或apis我可以用来导入这种数据?我不想每天将这些信息复制并粘贴到我的网站上。
2 个解决方案
#1
On the very site you link to, there's a small link that says "download data". If you have a database with the symbols you want to track, it would be pretty easy to construct that download URL on the fly, query it, parse the CSV, and load that data into your database for display on your website.
在您链接的网站上,有一个小链接显示“下载数据”。如果您有一个包含要跟踪的符号的数据库,则可以非常轻松地动态构建下载URL,查询它,解析CSV,并将该数据加载到您的数据库中以便在您的网站上显示。
ETA: Here's the link:
ETA:这是链接:
http://ca.finance.yahoo.com/d/quotes.csv?s=AX-UN.TO&f=sl1d1t1c1ohgv&e=.csv
Just have your program replace the "AX-UN.TO" with whatever symbol you want, and it should grab the data for that symbol.
只需让你的程序用你想要的任何符号替换“AX-UN.TO”,它应该获取该符号的数据。
#2
Take a look at http://www.mergent.com/servius - particularly the Historical Securities Data API. Not sure if it has REIT data - if it doesn't, it may be available by special arrangement from them.
请查看http://www.mergent.com/servius - 尤其是Historical Securities Data API。不确定它是否有REIT数据 - 如果没有,可以通过他们的特殊安排获得。
#1
On the very site you link to, there's a small link that says "download data". If you have a database with the symbols you want to track, it would be pretty easy to construct that download URL on the fly, query it, parse the CSV, and load that data into your database for display on your website.
在您链接的网站上,有一个小链接显示“下载数据”。如果您有一个包含要跟踪的符号的数据库,则可以非常轻松地动态构建下载URL,查询它,解析CSV,并将该数据加载到您的数据库中以便在您的网站上显示。
ETA: Here's the link:
ETA:这是链接:
http://ca.finance.yahoo.com/d/quotes.csv?s=AX-UN.TO&f=sl1d1t1c1ohgv&e=.csv
Just have your program replace the "AX-UN.TO" with whatever symbol you want, and it should grab the data for that symbol.
只需让你的程序用你想要的任何符号替换“AX-UN.TO”,它应该获取该符号的数据。
#2
Take a look at http://www.mergent.com/servius - particularly the Historical Securities Data API. Not sure if it has REIT data - if it doesn't, it may be available by special arrangement from them.
请查看http://www.mergent.com/servius - 尤其是Historical Securities Data API。不确定它是否有REIT数据 - 如果没有,可以通过他们的特殊安排获得。