如何从谷歌财经API后2017年9月6日获取数据的多支股票

Question

帖子9月6日

我工作的一个项目，我想从谷歌财经API显示实时价格多股票有类似的信息changechange in %volumeTimestamp of data

和

像ROI/E，ROA，Net-profit-margin几比率 - 这是完全可选的。 （如果可用，那么如果不是那么惊人，那么问题依然不大。）

当谈到效率时，发送每个股票的请求是荒谬的。

我试过许多东西一样

https://finance.google.com/finance?q=NSE:ABAN,NSE:ABB&output=json 

这给我的股票的基本信息，但不是实时价格。

https://finance.google.com/finance?q=NSE:ABAN,ABB&output=json 

此查询只是承认存在名称为ABAN的股票存在。

我对NSE（国家证券交易所 - 印度）的数据感兴趣。 我已经通过2-3线程为这件事情，但无法获得太多的信息， 也雅虎停止支持印度市场，所以这个选项也被列入名单。

该项目是学术性的，所以我想要一个免费的数据源，如果可能的话。

任何有关这方面的帮助将非常感激。

Answer 1

你可以做以下伎俩：

1. 查询标识您需要的股票（你可以做到这一次，标识似乎是永久的）：

https://finance.google.com/finance?output=json&q= ,, .. 。（最多14个股票每个查询）

输出将有'id'字段，你应该收集。 实施例：

{... 
"searchresults" : [ 
{ 
"title" : "Aban Offshore Ltd", 
"id" : "3302534", 
"ticker" : "ABAN", 
"exchange" : "NSE", 
... 
} , { 
"title" : "ABB India Ltd", 
"id" : "5296497", 
"ticker" : "ABB", 
"exchange" : "NSE", 
... 
}] 
... 

使用的ID
1. 查询信息：

https://finance.google.com/finance/data?dp=mra&output=json&catid=all&cid=3302534,5296497，...（不知道的限制，但它的方式超过14的ID）

输出将有大约每ID信息

{...,company:{related:{cols:[...], 
rows:[ 
{id:"3302534", 
values:["3302534","ABAN","Aban Offshore Ltd","ABAN","NSE","INR","178.35","+0.40","chg","0.22","","-184.19","","0.39","0.59","10.41B","","0.00","","0.63","63.15","74.78","448.77","531.41","-5.34","-32.89","-6.46","1.40","-59.21","93.14","52.77","12.88","1,275","17,579.20","-10,408.33","9,275.71"]}, 
{id:"5296497", 
values:["5296497","ABB","ABB India Ltd","ABB","NSE","INR","1,365.20","+24.00","chg","1.79","","17.88","76.36","8.66","3.09","289.56B","","4.00","0.30","1.56","7.76","7.76","18.28","18.28","4.95","11.90","9.86","1.43","4.08","32.94","7.56","5.92","5,603","91,840.50","3,744.70","6,945.30"]}], 
visible_cols:[...]}}} 

的列有：ID，北京时间，姓名，股票代码，交易所，货币， Price，Change，Unknown，Change％，Unknown，EPS，PE，PB，PS，Cap，EntValue，Div，DivYield，CurrRatio，LtDebtToAssets，TotalDebtToAssets，LtDebtToEquity，TotalDebtToEquity，ReturnOnAvgAssets，ReturnOnAvgEquity，ReturnOnAvgInvestment，Beta，NetProfitMargin，GrossMargin，EBITDMargin ，OperatingMargin，员工，收入，净收入，EBITDA

不幸的是，没有延长会议价格e或任何最后的交易时间。 如果你知道如何获得股票的最后交易时间，请让我知道。

开始=>