'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Missing Roche Stock Ticker XSWX:ROG in Excel
Question details
The user is attempting to track the Roche Holding AG Participation Certificate (XSWX:ROG) in Excel, but only the bearer share (XSWX:RO) is available.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Using Excel's built-in Stocks data type to track specific Swiss market financial instruments.
- Observed behavior
- Excel successfully identifies XSWX:RO (bearer share) but fails to recognize or retrieve data for XSWX:ROG (participation certificate).
Verify your internet connection and ensure your Microsoft 365 subscription is active, as the Stocks data type requires a premium subscription and online access to query external financial servers.
Submit a Request for the Missing Ticker to Microsoft
Excel's stock data is provided by Refinitiv. If a specific instrument like XSWX:ROG is missing, the primary method to resolve this is by submitting feedback to request its addition.
Microsoft relies on third-party providers (like Refinitiv) for its stock market data. Coverage can vary by exchange and instrument type. Because XSWX:ROG represents the participation certificate and XSWX:RO represents the bearer share, you should not substitute them as they track different prices.
Open your Microsoft Excel application. Click on the 'Help' tab in the top ribbon and select 'Feedback'.
Click on 'I have a suggestion' or 'Report a problem'.
Write a brief description stating that the Refinitiv stock data is missing the Roche Holding AG Participation Certificate. Specifically mention the ticker 'XSWX:ROG' and click Submit.
Import the Stock Data Manually via Web Query
If you cannot wait for the Stocks data type to update, you can use Power Query to pull the live price of XSWX:ROG from a financial website.
Try WPS Office for Your Financial Spreadsheets
If you are experiencing feature limitations or simply looking for a lightweight, free alternative to Microsoft Office, WPS Spreadsheet offers excellent performance for managing financial data, creating models, and tracking portfolios.
Frequently Asked Questions
What is the difference between XSWX:RO and XSWX:ROG?
XSWX:RO represents Roche Holding Ltd's bearer shares, while XSWX:ROG represents their participation certificates. They are fundamentally different financial instruments with distinct trading prices.
Can I manually force Excel's Stock feature to recognize XSWX:ROG?
No. The built-in Stocks data type strictly relies on the database provided by Refinitiv. If the provider has not mapped or included XSWX:ROG, Excel cannot automatically generate a rich data card for it.
How often does Microsoft update its supported stock tickers?
Microsoft and its data partners continually update their databases to reflect market changes, additions, and user feedback. However, there is no public schedule indicating exactly when specific requested tickers will be added.
