Alpha Vantage API Excel [英] Alpha Vantage API Excel

问题描述

我有一个Alpha Vantage API密钥，并且在解析数据时遇到问题.由于存在JSON和CSV选项，因此我不确定如何解析数据. CSV似乎是一个下载文件，我并不是想每次想更新股价时都手动下载一个新文件.

I’ve got an Alpha Vantage API key and am having issues with parsing the data. I’m unsure how to approach parsing the data as there are JSON and CSV options. The CSV seems to be a download, I’m not trying to manually download a new file every time I want to update the stock price.

这是我过去在Excel中获取股票价格的方式:

This is how I used to get the prices of stocks in Excel:

我将始终使用CTRL-ALT-F9刷新所有内容.

I would always use CTRL-ALT-F9 to refresh everything.

很遗憾，雅虎已停止了此服务，因此我必须对其进行修复.

Unfortunately, Yahoo has stopped this service so I have to fix it.

推荐答案

您可以以相同的方式使用Alpha Vantage.但是它为您提供了每次调用的更多信息，因此您需要对其进行解析. 例如，要获取最新的股票价格，此方法有效:

You can use Alpha Vantage the same way. But it gives you more information for each call so you need to parse it. To get the latest stock price for example, this works:

=NUMBERVALUE(MID(WEBSERVICE("https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&apikey=<key>&datatype=csv&symbol=MSFT&outputsize=compact"),49,6))

这篇关于Alpha Vantage API Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！