How do I get the Stocks data type?

[Mr. Snrub]

I don't see "Stocks" on the Data menu. I understand that the Stocks data type is only available to Office 365. I'm not 100% sure if
I'm running Office 365 or not. I go to File --> Account --> About Excel, and it says "Microsoft Excel for Office 365 MSO (16.0.10730.20264) 32-bit". Is this not Office 365?

 

[sandy666]

I don't think you'll find name "Stock" in Excel or even in PowerBi
You need to choose appropriate kind of service for that

 

[AhoyNC]

You should find it under the DATA Menu. It does say STOCKS. You may need to check that you have the latest ver. See below link to Office Support. They say this came out in the March 2019 update.

https://support.office.com/en-us/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54

 

[sandy666]

You may need to check that you have the latest ver. See below link to Office Support. They say this came out in the March 2019 update.

Thanks AhoyNC, update is required

 

[Mr. Snrub]

So, is "Microsoft Excel for Office 365 MSO (16.0.10730.20264) 32-bit" the right version or not? There does not appear to be a date associated with it.

ETA: I am using Office for PC.

 

[sandy666]

maybe this is available for ProPlus
https://support.office.com/en-us/ar...f-office-8e83dd74-3b83-4528-bda6-6ff6118f8293

 

[Mr. Snrub]

UPDATE! My IT administrator just updated all of our versions of Excel, and now I've got "Microsoft Excel for Office 365 MSO (16.0.11328.20362) 32-bit", and now I have Stocks in the Data tab!!!!! Woo hoo!!!!!!!