Forum Discussion

Blake T Walsh's avatar
Blake T Walsh
Former Employee
Jul 24, 2018

Community Question - How have you been using the new Stocks and Geography Data Types?

How have you been using the new http://aka.ms/stockgeoXL in Excel? Since the new Stocks and Geography data types in Excel have been available to Insiders for a little while now, we want to hear from ...
excel
Formulas and Functions
office 365
Sanjay Patel's avatar
Sanjay Patel
Copper Contributor
Aug 22, 2018

I love it - set it up for keeping on top of my Stock Portfolio ( the timing was perfect, as previously was getting data from Yahoo via WebService function but they turned off access).

 

however, just installed my Office 365 Home on new Surface and the DATA TYPES are not there... not sure when they will appear or how I can force it... I clicked on File - > Account - > Update Options - > Update Now and it says I am up to date but NO DATA TYPES :-(  (Also Stock/Geo) is not there if I try going into Customise Ribbon.

 

how can I get them back?

  • James Spotanski's avatar
    James Spotanski
    Former Employee
    Aug 23, 2018
    Hi Sanjay,
    The feature is still only available to Office Insiders at this time. 100% of Insiders Fast should see the feature, while we are still only enabled for 50% of Insiders Slow (aka Monthly Channel - Targeted) right now. More information on the Insiders program can be found at http://aka.ms/officeinsider.

    If you have previously used the feature as an Insider and are unable to see it on your new computer, I recommend verifying that you have signed in with the same account that you registered for Office Insiders. If you want to guarantee the feature appears, you will need to join Insiders Fast due to the 100% availability there that I mentioned above.

    Thanks!
    James
    • Sanjay Patel's avatar
      Sanjay Patel
      Copper Contributor
      Aug 24, 2018

      Thanks. I understand now why it was not showing unless I am on the Insiders channel. 

       

      It has been 2 months since the post here - > which is why I thought it was ready now.

       

      https://support.office.com/en-us/article/Stock-quotes-and-geographic-data-61a33056-9935-484f-8ac8-f1a89e210877

       

      this says...

       

      "Note: June 12, 2018: This feature is being made available to customers on a gradual basis over several days or weeks. It will first be available to https://products.office.com/office-insider participants, and later to https://products.office.com/buy/compare-microsoft-office-products subscribers. If you are an Office 365 subscriber, https://support.office.com/en-us/article/how-do-i-upgrade-to-office-2016-ee68f6cf-422f-464a-82ec-385f65391350."

Resources