Forum Discussion

Evan_Bolin's avatar
Evan_Bolin
Former Employee
Sep 02, 2020

New investment tracking template uses data types, STOCKHISTORY function

Hello Insiders,   Today we want to share a new investment tracking template with you. Sam Radakovitz, a Program Manager on the Excel team, shows you how to setup the template that uses the STOCKH...
Scott Moskowitz's avatar
Scott Moskowitz
Copper Contributor
Sep 15, 2020

Evan_Bolin  I have the Stocks Data type, but the STOCKHISTORY formula is not available.  It strange that I would get one without the other.  When will the formula be released to Office Insiders?  Please let me know. 

Thanks

Scott 

Evan_Bolin's avatar
Evan_Bolin
Former Employee
Sep 16, 2020

Hello Scott Moskowitz ,

 

The STOCKHISTORY function is currently only available to a portion of Office Insiders on the Beta Channel while it's being optimized over the next several months.  When it's ready, it will be released to all Office Insiders. Unfortunately at this time, we don't have a specific date for when that will be.

 

Cheers,

Evan

  • fdamaral's avatar
    fdamaral
    Copper Contributor
    Nov 12, 2022

    Hi Evan_Bolin !

     

    I have the same issue. It was working fine before but since a week or so ago it stopped working and I get #VALUE! instead 😟

  • john_thinggaard's avatar
    john_thinggaard
    Copper Contributor
    Sep 18, 2020

    Evan_Bolin 

    are there any release date on this for Excel office 365 subscribers?

    Thank you

     

    Kinds regards

    John

    • Evan_Bolin's avatar
      Evan_Bolin
      Former Employee
      Sep 18, 2020

      Hello john_thinggaard,

       

      Unfortunately nothing has been announced for when this feature will be available to the general public on Microsoft 365 subscriptions. You can keep an eye on the Excel blog section for any announcements.

       

      Cheers,

      Evan

Resources