STOCKHISTORY FUNCTION STUCK ON BUSY

%3CLINGO-SUB%20id%3D%22lingo-sub-2667423%22%20slang%3D%22en-US%22%3ESTOCKHISTORY%20FUNCTION%20STUCK%20ON%20BUSY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2667423%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22zerksisiii_0-1629419705825.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F304569iC9EDA5031FEDCB53%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22zerksisiii_0-1629419705825.png%22%20alt%3D%22zerksisiii_0-1629419705825.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ESO%20IM%20USING%20THE%20FUNCTION%26nbsp%3B%3DIFERROR(STOCKHISTORY(%24A35%2CG%242%2C%2C0%2C0%2C1)%2C%22%22)%26nbsp%3B%20AND%20IT%20SEEMS%20TO%20BE%20STUCK%20IN%20This%20fashion%20so%20if%20i%20ask%20it%20to%20refresh%20or%20anything%20it%20does%20the%20same%20-%20d%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2667423%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2671818%22%20slang%3D%22en-US%22%3ERe%3A%20STOCKHISTORY%20FUNCTION%20STUCK%20ON%20BUSY%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2671818%22%20slang%3D%22en-US%22%3EWhat%20are%20the%20references%20in%20column%20A%20and%20row%202%3F%3CBR%20%2F%3E%3CBR%20%2F%3EHave%20you%20tried%20the%20STOCKHISTORY%20by%20itself%2C%20without%20the%20IFERROR%3F%20What%20happens%20then%3F%3C%2FLINGO-BODY%3E
New Contributor

zerksisiii_0-1629419705825.png

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

2 Replies
What are the references in column A and row 2?

Have you tried the STOCKHISTORY by itself, without the IFERROR? What happens then?

@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 .