What version of Excel do I need to be able to use the STOCKHISTORY() function?

[Mr. Snrub]

What version of Excel 365 do I need to be able to use the STOCKHISTORY() function? My software update attempt says Excel is up-to-date but I just wanted to verify.

 

[Fluff]

Are you on the Current channel (formerly Monthly channel)?

 

[kweaver]

A parallel question: while my version of 365 (16.0.13628.20128) has this function, any idea where (if there is a place) there is a complete list of current functions and their syntax for 365?

Even this one is incomplete. Excel functions (alphabetical)

 

[MARK858]

@kweaver, when you say it is incomplete can you let us know the ones that you are aware of being missing?

 

[kweaver]

@kweaver, when you say it is incomplete can you let us know the ones that you are aware of being missing?

Well, for one, STOCKHISTORY is not in the list.

 

[MARK858]

Thanks for that @kweaver, I only asked as I wanted to check that was missing wasn't something that was still on the Insider channel but STOCKHISTORY isn't one of those (having said that it was only fully released in January and so not surprised that MS haven't added to the list yet, they're not exactly the best at updating quickly).

 

[Fluff]

The daft thing is that list has ArraytoText & ValuetoText which are still on the Insider channel only.

 

[MARK858]

The daft thing is that list has ArraytoText & ValuetoText which are still on the Insider channel only.

Not surprised

 

[Mr. Snrub]

Are you on the Current channel (formerly Monthly channel)?

How can I tell?

 

[Fluff]

Click on File, Account & it will show you