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

4 Replies

  • 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

Resources