The Excel Stock tool doesn't return the proper data

The Data Selector panel says, 'No results found for "BRK.B" ' and returns #FIELD! for all attributes.

If I manually edit the cell and change its value to " XNYS: BRK.B" the attributes for LEGATO MERGER UNT (XNYS) are returned.

Hi Mark Weisman

Thank you for testing that and sharing the exact results.

As one final check, could you try BRK.B in a new blank workbook using Excel for the web? If the Data Selector also shows No results found, or maps XNYS: BRK.B to LEGATO MERGER UNT, that would indicate the issue is not limited to your desktop installation or current workbook.

In that case, there would be no further local troubleshooting I could recommend. Please report the incorrect or missing mapping through Give feedback in the Data Selector, or through Help > Feedback in Excel. Include these exact results:

• BRK.B returns No results found and #FIELD!
• XNYS: BRK.B incorrectly resolves to LEGATO MERGER UNT (XNYS)
• The intended security is Berkshire Hathaway Inc. Class B

This information should help the responsible team identify the incorrect Stocks data mapping.

Same results with a new workbook. BRK.B used to work for me, but no longer does. This leads me to believe that Microsoft's 3rd party provider for the Stock datatype has a corrupt dataset. You can lookup the BRK.B stock symbol on the CNBC stock app without any problems.

Hi Mark Weisman

Since BRK.B previously worked, now returns No results found, and XNYS: BRK.B resolves to an unrelated security, this appears to be an issue with the online Stocks data source or its instrument mapping rather than your workbook or Excel installation.

Although the Stocks data type obtains financial information from an external data provider. However, we cannot verify from the community forum whether the provider’s dataset is corrupted or directly correct the stock mapping.

At this stage, further local troubleshooting is unlikely to resolve it. Please report the issue through Help > Feedback in Excel and include these exact results:

• BRK.B returns No results found and #FIELD!
• XNYS: BRK.B incorrectly resolves to LEGATO MERGER UNT (XNYS)
• The intended security is Berkshire Hathaway Inc. Class B
• The symbol previously worked in Excel
• The behavior also occurs in a new workbook

This will give the Excel product team the information needed to investigate the provider-side mapping. As a temporary workaround, you would need to obtain the data from another reliable financial source until the Excel Stocks record is corrected.

You can also contact Microsoft Support, in case you need further insight and assistance:

Please note that this is a user-to-user support forum. Moderators and contributors, including external Microsoft employees, are not allowed to directly interfere with Microsoft product features or access back-end systems. Our role is limited solely to providing technical guidance on reported incidents, requests, or ideas.  

1. Open a website link - Contact - Microsoft Support 
2. In the box below "We're here to help", type Microsoft 365, click "Get Help", and then click "Contact Support" below. 
3. In this section, you will need to sign in to your Microsoft account. 
4. Select "Microsoft 365 and Office" under Products & Services, select "Technical Support" as the category, and click to confirm 
5. You can select " Chat with a support agent in your web browser " to access the chat window.