Research for other sites turned up the aforementioned, abandoned Google Finance API. In the last few months, the most recent website I used for multiple quotes made some change that rendered my spreadsheet and its web queries non-operational. As time went on, however, more and more websites made it more and more difficult to use Web Queries, at least for the sort of data I wanted for multiple stocks: Open Price, High Price, Low Price, Current/Closing Price, Volume, Time of last Trade.įor a while, Google's finance API was a favored alternative, however Google recently shut that down in favor of using built-in Google Docs functionality. It was subject to occasional hiccups when page design/layout changed, but was often easy enough to repair. Where before if you wanted live data, like stock quotes, you had to write your own "screen-scraper", now you could let Office do the heavy lifting.
Backgroundīack when Office 97 was launched, Microsoft added a cool new feature: Web Queries. Provides a set of VBA macros and functions to download and parse live stock quotes from Yahoo Finance via the Yahoo Query Language.
0 kommentar(er)
