EXCEL STOCKHISTORY Function General Release

%3CLINGO-SUB%20id%3D%22lingo-sub-2262428%22%20slang%3D%22en-US%22%3EEXCEL%20STOCKHISTORY%20Function%20General%20Release%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2262428%22%20slang%3D%22en-US%22%3E%3CP%3EBy%20now%2C%20it's%20well-known%20that%20the%20STOCKHISTORY%20function%20has%20been%20released%20only%20for%20subscribers%20to%20MS%20Office%20365.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20if%20and%20when%20this%20function%20will%20be%20released%20for%20other%20versions%20of%20MS%20Excel%3F%26nbsp%3B%20It's%20a%20valuable%20function%2C%20but%20alone%20it's%20not%20worth%20a%20subscription%20license.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20appreciate%20any%20information%20that%20is%20available.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWil%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2262428%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

By now, it's well-known that the STOCKHISTORY function has been released only for subscribers to MS Office 365.

 

Does anyone know if and when this function will be released for other versions of MS Excel?  It's a valuable function, but alone it's not worth a subscription license.

 

I'd appreciate any information that is available.

 

Thanks,

 

Wil

3 Replies
There are lots of other functions available that are even more valuable for some users: UNIQUE, FILTER, SORT....LET Do you have those currently? I use STOCKHISTORY, but it is by no means the most valuable part of having the subscription. What are some of your applications of Excel?

 

@mathetes 

 

Hi,

 

I didn't know but am not surprised that there are other functions available in Office 365 that aren't in the permanent licensed versions.  I'm sure that they're useful, but so far I haven't had a need for them.  I spend the majority of my time working on spreadsheets for investors and for tax planning.  The former typically require pulling stock data from the web.  There are a number of workarounds that I've found, but it would be much simpler if MS would open the stockhistory function.  It's there, but blocked.  

 

Clearly, MS wants everyone on the 365 platform, but it's not practical for many folks.  At least, they have opened the stock data type for their online version of the software, but this doesn't pull historical data.

 

Thanks for you note.  Wishing you the best,

 

Wil

 

 

@WilRXR 

Wil, as a comment STOCKHISTORY() is avilablabe on Excel Online, nut sure if it is already deployed for all subscribers. But yes, that's 365, even if online.