+ Reply to Thread
Results 1 to 4 of 4

Problems with Stocks Data Type

  1. #1
    Registered User
    Join Date
    05-10-2020
    Location
    Madrid, Spain
    MS-Off Ver
    2016
    Posts
    5

    Problems with Stocks Data Type

    Hello. I am using Excel 2016 in Spanish.

    I am trying to use the Stocks Data Type. When I put a name and select Data, Stock Quotes, it does convert the name I have in my cell into a long name with the Exchange reference. But I do not see the Little stock Exchange icon, and I cannot get the fields I need to add in the other columns.

    Any idea why ?

    Thanks

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,879

    Re: Problems with Stocks Data Type

    While this function shows on your ribbon, it is only functional in Office 365 (the Microsoft Subscription Version). I also have it on my 2019 version on the ribbon but it is not functional. I think it is a Microsoft tease to get you to buy into 365.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    05-10-2020
    Location
    Madrid, Spain
    MS-Off Ver
    2016
    Posts
    5

    Re: Problems with Stocks Data Type

    Thanks, so it shows on the ribbon, it converts the name into the long name and Exchange ticker, but not much more

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,879

    Re: Problems with Stocks Data Type

    That's it unless you have 365 and then it links to outside information re: Price, etc.

    Because I find it useless for me, I have removed it from the ribbon. File-->Options-->Customize Ribbon

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Want To Extract Data from a STOCKS website
    By kshiprajadav in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2020, 04:13 AM
  2. Price of Stocks data type
    By andy_2016 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-07-2019, 12:41 AM
  3. [SOLVED] Stocks data from IE via marco need help
    By ctguards1987 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2014, 01:29 PM
  4. Problems with DATE data type
    By dmplacebo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2005, 06:05 AM
  5. Problems with DATE data type
    By dmplacebo in forum Excel General
    Replies: 0
    Last Post: 07-12-2005, 04:07 AM
  6. Problems with DATE data type
    By dmplacebo in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 07-12-2005, 03:40 AM
  7. [SOLVED] how to get 52 week hi/lo data for UK stocks
    By Andy Jones in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-26-2005, 07:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1