Performance

Discussion in 'Troubleshooting' started by ed b, Nov 2, 2017.

Performance

  1. ed b

    ed b New Member

    Joined:
    Nov 2, 2017
    Messages:
    13
    Likes Received:
    0
    i have 800 rows in my spreadsheet with 3 functions. a refresh is taking over 15 minutes.
     
  2. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,157
    Likes Received:
    11
    Hi,

    Please can you try out the latest version, it has some better caching. May I ask which functions do you have in the sheet?

    Many thanks
    Ankur
     
  3. ed b

    ed b New Member

    Joined:
    Nov 2, 2017
    Messages:
    13
    Likes Received:
    0
    i load the new version, performance is still bad, i am using last, open and prior close.
     
  4. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,157
    Likes Received:
    11
    ok, may I ask how many symbols roughly?

    Thanks
    Ankur
     
  5. ed b

    ed b New Member

    Joined:
    Nov 2, 2017
    Messages:
    13
    Likes Received:
    0
  6. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,157
    Likes Received:
    11
    We are putting this on a bigger box. You will see improvements soon.

    Kind regards
    Ankur
     
  7. ed b

    ed b New Member

    Joined:
    Nov 2, 2017
    Messages:
    13
    Likes Received:
    0
    in the meantime, what is the vba code to execute your ribbon command to refresh selected. Open and previous close are only needed once a day. i have coded a select 100 cells loop to select and refresh only last trade.
     

Share This Page