I've seen a lot of posts explaining ways to alter the standard ImportData() function in Google Sheets to retrieve stock info from YahooFinance or Vangaurd's API, but every now and again the formulas stop working and I was wondering what people think is the best method to get stock info into a Google Sheets portfolio. The standard GoogleFinance() functions work great for the basics, but I currently I'm having trouble getting historical data like a company's earnings in previous quarters, or even simple stuff like the dividend yield or rate. Any advice would be greatly appreciated, its probably a bit obvious in the post that I'm a bit new to using functions beyond GoogleFinance().
Submitted July 12, 2018 at 09:46PM by djrasras https://ift.tt/2L39mKW
