Forum Discussion

GW1980's avatar
GW1980
Copper Contributor
Apr 07, 2020

Get Stock Prices Function - Excel 365 on Mac

I am trying to use this function and while it recognises the ticker symbols I get no option to add column with the option of data sets i.e. price, close, 52 day average etc
excel
Formulas and Functions
office 365
Abiola1's avatar
Abiola1
MVP
Apr 07, 2020

GW1980 

 

Hello, can you upload a screenshot of the ticker you're trying to fetch the information

  • GW1980's avatar
    GW1980
    Copper Contributor
    Apr 07, 2020

    Abiola1 

     

    See attached - you can see it recognises tickers but does not give any option to add any data fields

    • Abiola1's avatar
      Abiola1
      MVP
      Apr 07, 2020

      GW1980 

       

      Yes, I can see that it recognized the tickers. 

      When I tried to do the same here, I am able to see the Add Column to fetch data

       

      I think the issue is probably associated with Mac. Not sure though

      • Simbolicious's avatar
        Simbolicious
        Copper Contributor
        Aug 11, 2020

        Abiola1I have exactly the same problem.  I have Microsoft 365 and on my laptop it works, however on my iMac it does not give the Stocks or Geography Data Type. 

Resources