Forum Discussion

Hedge_Fund_Manager's avatar
Hedge_Fund_Manager
Brass Contributor
Mar 07, 2023

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

 

 

excel

6 Replies

  • mathetes's avatar
    mathetes
    Silver Contributor
    Mar 07, 2023

    Hedge_Fund_Manager 

     

    Is there a question in there?

     

    If so, you could make it more explicit. Also significant (or potentially so) would be information on what hardware and software you're running, OS and version of Excel.

    • Hedge_Fund_Manager's avatar
      Hedge_Fund_Manager
      Brass Contributor
      Mar 09, 2023
      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
      • mathetes's avatar
        mathetes
        Silver Contributor
        Mar 11, 2023

        Hedge_Fund_Manager 

         

        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.

Resources