google-sheets - 是否有可能在特定时间范围内获得一天中股票价格的高点和低点？

Question

就像标题所说的那样，有没有办法在特定时间后获得一天中股价的高点和低点？有一种方法可以让日子在一段时间内达到高潮和低谷：

=GOOGLEFINANCE("AMZN","high","05/01/2020","05/10/2020","DAILY")

=GOOGLEFINANCE("AMZN","low","05/01/2020","05/10/2020","DAILY")

但是在特定时间段的白天呢？例如从太平洋标准时间上午 9:12 到太平洋标准时间上午 11:23？

标签： google-sheetsgoogle-sheets-formula

Answer 1

解决方案#3：您可以通过 2 种方式使用 Alpha Vantage，附加 GSheets 或自定义函数，即：

// mike steelson
var apikey = 'xxxxxxxxxxxxxx'
function getAllDataJSONv2(code) {
  var url = 'https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol='+code+'&interval=5min&apikey='+apikey
  var data = JSON.parse(UrlFetchApp.fetch(url).getContentText())['Time Series (5min)']
  var resultat = []
  for (var elem in eval(data)){
    resultat.push([elem,eval(data[elem]['1. open']),eval(data[elem]['2. high']),eval(data[elem]['3. low']),eval(data[elem]['4. close']),eval(data[elem]['5. volume'])])
  }
  return resultat
}

apikey 每天最多可免费处理 500 个请求。https://rapidapi.com/alphavantage/api/alpha-vantage