Get Stock Prices Function - Excel 365 on Mac

Copper Contributor

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

4 Replies

@GW1980 

 

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

@Abiola1 

 

See attached - you can see it recognises tickers but does not give any option to add any data fieldsScreenshot 2020-04-07 at 18.21.47.png

@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

Abiola1_0-1586293958928.png

 

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

@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.