Forum Discussion

zerksisiii's avatar
zerksisiii
Copper Contributor
Aug 20, 2021

STOCKHISTORY FUNCTION STUCK ON BUSY

SO IM USING THE FUNCTION =IFERROR(STOCKHISTORY($A35,G$2,,0,0,1),"")  AND IT SEEMS TO BE STUCK IN This fashion so if i ask it to refresh or anything it does the same - d

excel
Formulas and Functions

2 Replies

  • mathetes's avatar
    mathetes
    Silver Contributor
    Aug 21, 2021
    What are the references in column A and row 2?

    Have you tried the STOCKHISTORY by itself, without the IFERROR? What happens then?
    • zerksisiii's avatar
      zerksisiii
      Copper Contributor
      Sep 14, 2021

      mathetes 

      Hello thanks for response 

      yes it works for example even if ill do the function of the last close it gives it immediately BUT when you try doing other dates it because a big deal and gets stuck sometimes it does respond after hours . 

Resources