STOCKHISTORY Function Failing

%3CLINGO-SUB%20id%3D%22lingo-sub-2099734%22%20slang%3D%22en-US%22%3ESTOCKHISTORY%20Function%20Failing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2099734%22%20slang%3D%22en-US%22%3E%3CP%3EI%20can't%20seem%20to%20get%20my%20STOCKHISTORY%20function%20to%20work.%20The%20function%20I'm%20using%20is%26nbsp%3B%3DSTOCKHISTORY(%22CL%22%2C%222020-01-1%22%2CTODAY()).%20I%20have%20an%20o365%20for%20Enterprise%20version%20of%20Excel.%20I%20am%20running%20with%20version%202012%20on%20the%20Current%20Channel.%20When%20I%20work%20on%20Excel%20Online%2C%20I%20can%20get%20the%20function%20to%20work%20properly.%20However%2C%20when%20I%20try%20to%20run%20it%20on%20the%20desktop%20app%2C%20the%20formula%20returns%20an%20error%20telling%20me%20I%20need%20to%20sign%20in.%20I%20believe%20that%20I'm%20already%20signed%20in%20but%20can't%20seem%20to%20get%20to%20the%20bottom%20of%20the%20issue.%20I've%20attached%20screenshots%20of%20my%20Account%20page%20and%20my%20workbook.%20Any%20assistance%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22LukeBeenken_0-1611702600189.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F249655iBF2FCB76FB47D65B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22LukeBeenken_0-1611702600189.png%22%20alt%3D%22LukeBeenken_0-1611702600189.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22LukeBeenken_1-1611702679184.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F249656i552960EDDBC61448%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22LukeBeenken_1-1611702679184.png%22%20alt%3D%22LukeBeenken_1-1611702679184.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2099734%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2107404%22%20slang%3D%22en-US%22%3ERe%3A%20STOCKHISTORY%20Function%20Failing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2107404%22%20slang%3D%22en-US%22%3EIf%20it's%20in%20the%20version%202012%20that%20it's%20not%20working--which%20is%20what%20it%20appears%20to%20be--that's%20because%20it%20only%20works%20in%20the%20more%20recent%20versions%3C%2FLINGO-BODY%3E
New Contributor

I can't seem to get my STOCKHISTORY function to work. The function I'm using is =STOCKHISTORY("CL","2020-01-1",TODAY()). I have an o365 for Enterprise version of Excel. I am running with version 2012 on the Current Channel. When I work on Excel Online, I can get the function to work properly. However, when I try to run it on the desktop app, the formula returns an error telling me I need to sign in. I believe that I'm already signed in but can't seem to get to the bottom of the issue. I've attached screenshots of my Account page and my workbook. Any assistance would be greatly appreciated.

 

LukeBeenken_0-1611702600189.pngLukeBeenken_1-1611702679184.png

 

1 Reply
If it's in the version 2012 that it's not working--which is what it appears to be--that's because it only works in the more recent versions