Google Apps脚本未返回数据 [英] Google apps script not returning data
问题描述
我有一个Google Apps脚本,它从Google表格中提取数据,该数据是通过GoogleFinance获取数据的(附有图片),价格差"= GOOGLEFINANCE(A2," change)"可以正常工作,但是收盘价称为通过"= INDEX(GOOGLEFINANCE((A3)," close,F2),2,2)"仅返回#REF!
I have a Google Apps Script pulling data from a Google Sheet, which gets data via GoogleFinance, (image attached) the price difference "=GOOGLEFINANCE(A2, "change")" works fine, but the close price which is called via "=INDEX(GOOGLEFINANCE((A3), "close", F2),2,2)" just returns #REF!
我已经尝试过getValue和getDisplayValue,但这没什么作用
I have tried the getValue and getDisplayValue, but this makes no difference
for(var i = 2; i < 72; i++) {
var thePrice = sheet.getRange('B' + i).getValue();
var sharename = sheet.getRange('D'+ i).getValue();
var theDifference = sheet.getRange('C'+ i).getValue();
}
推荐答案
历史记录 GOOGLEFINANCE数据无法在Google外部访问 床单.如果您有一个包含GOOGLEFINANCE函数生成的历史数据的电子表格,并尝试下载或通过Apps脚本或API访问它,则相应的单元格将显示#N/A.
Historical GOOGLEFINANCE data no longer accessible outside of Google Sheet. If you have a spreadsheet with historical data generated from the GOOGLEFINANCE function and you try to download it or access it via Apps Script or an API, the corresponding cells will show #N/A.
有关更多信息: G Suite更新博客
此外,它已经在应用程序脚本问题跟踪器中提出,并且得到了Google的回复是"无法解决(预期行为)"
Also, it has been raised in the App Script issue tracker and the response from Google is "Won't Fix (Intended behavior)"
这篇关于Google Apps脚本未返回数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!