Excel hanging

[garyfritz]

I'm doing some research on stock prices. I'm using the AlphaVantage add-in (Excel Add-on | Alpha Vantage) to source the price history. Currently I have 13 sheets of stock data with about 5000 lines -- large, but nothing extraordinary. Most of that space is populated by an AlphaVantage call in a single cell, spilling over to provide 4975 days of Date/Open/High/Low/Close/AdjClose/Volume/Split history. Then I have another sheet that does a bunch of calculations on that history.

The AV plugin is a bit flaky. Sometimes it works, sometimes not. Sometimes a sheet that was full of data suddenly shows an #ERROR in the AV cell and the spillover data vanishes. Usually I can fix it by copying the cell and pasting it back in again. (!?) Annoying, and I'd love to hear if anyone has a solution. But that's not my major problem.

The big problem is, Excel keeps hanging. Sometimes I can work on it for hours and it's fine. Sometimes I can freshly start Excel and open the spreadsheet, and it hangs within a minute or three. I have to kill Excel and restart, which is mighty annoying and sometimes loses data.

Surely this can't be caused by 14 sheets x 5000 lines? I suspect the AV plugin, and/or maybe the spillover logic is less than bombproof?

I would use the STOCKHISTORY function, but as far as I can tell it doesn't handle splits and dividends.

 

[Marc L]

​

As hanging may mean working so the more webpages to query the longer to execute …​

​

As you are using a specific add-on so the better is to report your issue to its author like preconised in your link.​

 

[garyfritz]

No, it's not just a "working, I'll get to you in a minute" situation. It's GONE and never comes back. I've let it sit for an hour and it was still hung.

And unfortunately the AlphaVantage vendor doesn't support their freebie offering very well. Like, at all.