Get Stock Prices Function - Excel 365 on Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-1289098%22%20slang%3D%22en-US%22%3EGet%20Stock%20Prices%20Function%20-%20Excel%20365%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1289098%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20use%20this%20function%20and%20while%20it%20recognises%20the%20ticker%20symbols%20I%20get%20no%20option%20to%20add%20column%20with%20the%20option%20of%20data%20sets%20i.e.%20price%2C%20close%2C%2052%20day%20average%20etc%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1289098%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1289197%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20Stock%20Prices%20Function%20-%20Excel%20365%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1289197%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20attached%20-%20you%20can%20see%20it%20recognises%20tickers%20but%20does%20not%20give%20any%20option%20to%20add%20any%20data%20fields%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-04-07%20at%2018.21.47.png%22%20style%3D%22width%3A%20760px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F182850i55EDB4F7B4D65958%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screenshot%202020-04-07%20at%2018.21.47.png%22%20alt%3D%22Screenshot%202020-04-07%20at%2018.21.47.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1289871%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20Stock%20Prices%20Function%20-%20Excel%20365%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1289871%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F612965%22%20target%3D%22_blank%22%3E%40GW1980%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes%2C%20I%20can%20see%20that%20it%20recognized%20the%20tickers.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhen%20I%20tried%20to%20do%20the%20same%20here%2C%20I%20am%20able%20to%20see%20the%20Add%20Column%20to%20fetch%20data%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Abiola1_0-1586293958928.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F182920i8A397E20C9EC24B3%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Abiola1_0-1586293958928.png%22%20alt%3D%22Abiola1_0-1586293958928.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20think%20the%20issue%20is%20probably%20associated%20with%20Mac.%20Not%20sure%20though%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1289160%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20Stock%20Prices%20Function%20-%20Excel%20365%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1289160%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F612965%22%20target%3D%22_blank%22%3E%40GW1980%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello%2C%20can%20you%20upload%20a%20screenshot%20of%20the%20ticker%20you're%20trying%20to%20fetch%20the%20information%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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.