如何从2017年9月6日以后的中获取多只股票的数据

Question

邮报9月6日

我正在做一个项目，我想用change change in % volume Timestamp of data之类的信息显示Google上的多只股票的实时价格。

和

很少有像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. 查询所需股票的ID(您可以这样做一次，ID似乎是永久的)：

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",
...
}]
...

1. 使用ID查询信息：

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、Ticker、Name、Ticker、Exchange、Currency、Price、Change、Exchange%、EBITDA、EPS、PE、PB、PS、Cap、EntValue、Div、DivYield、CurrRatio、LtDebtToAssets、TotalDebtToAssets、LtDebtToEquity、TotalDebtToEquity、ReturnOnAvgAssets、ReturnOnAvgEquity、ReturnOnAvgInvestment、Beta、NetProfitMargin、GrossMargin、EBITDMargin、OperatingMargin、Employees、ID、NetIncome、EBITDA。

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