Forum Discussion
excel crashing with 10k stocks
it seems that excel is unstable using it as a database for studying stocks for a hedge fund was at 14,000 but errors pruned that down until I can insert more symbols which can be a challenge ...
Dell Precision 5540 with an i7-9850H CPU and 32GB of RAM
I am using the 64-bit version of Office 365 apps
Worksheet with NYSE, NASDAQ and other exchanges amount to over 10K rows
I am using the 64-bit version of Office 365 apps
Worksheet with NYSE, NASDAQ and other exchanges amount to over 10K rows
I repeat: Is there a question in there, in what you've written? I don't see one.
And there's certainly not a complete description of what you're doing when Excel crashes.
I have a worksheet with stocks and holdings etc and this is selected into a summary worksheet an a pro forma, the stock worksheet is a database
I also frequently see errors galore in the worksheet of stocks
So I take it, after repeatedly asking, that you have no question. You're just offering an observation.
Duly noted.
- Microsoft has updated excel to handle 13k+ stocks so I can use sum() etc to tabulate dividends etc
Still it is unstable at times