The Motley Fool Discussion Boards

Previous Page

Investing/Strategies / Mechanical Investing

URL:  https://boards.fool.com/slow-puzzled-i-have-a-workbook-with-3-sheets-32884479.aspx

Subject:  Re: Has Yahoo made a further improvement? Date:  11/3/2017  9:12 PM
Author:  rharmelink Number:  268309 of 278655

Slow? Puzzled... I have a workbook with 3 sheets of quotes filling up, 200 day historical prices, SMA functions, it takes... 10 seconds?

Like I said, I mostly used their importHTML() and importData() functions, because I was extracting things out of web pages.

But, yes, their API functions are pretty fast. I hadn't really tried them because of my experience with the import functions. If I remember correctly, there's also a limit on the number of import functions that can be used.

When I ran into the article today on publishing a CSV file, it was really the first time I did a large number of GoogleFinance() functions. I was pleasantly surprised.
Copyright 1996-2020 trademark and the "Fool" logo is a trademark of The Motley Fool, Inc. Contact Us