Share via

Accurate Singapore Stock prices - Mac + Office 365.

Arun Vasudevan 40 Reputation points
2026-05-01T06:02:30.2366667+00:00

I am unable to get Singapore stock prices accurately (while it is okay for US, UK, and HK stocks) using the stock function on Office 265 for Mac. Did you have similar issues? How did you fix them?

Microsoft 365 and Office | Excel | For home | MacOS
0 comments

Answer accepted by question author

Kai-H 17,760 Reputation points Microsoft External Staff Moderator
2026-05-01T10:43:22.81+00:00

Hi, Arun Vasudevan

This looks less like a Mac setting issue and more like Excel matching the Singapore ticker to the wrong instrument, exchange, or delayed data source. I would not rely only on the displayed “Price” field until you confirm the exact exchange and last trade time.

Besides the solutions provided by the Q&A Assist, here are some suggestions you can try:

Right-select the stock cell, choose Data Type > Change, then search by the full company name instead of only the ticker. Pick the result that clearly matches the Singapore listing/SGX, if it appears. A wrong exchange match can easily give a wrong price.

Add the Exchange, Currency, and Last Trade Time fields next to Price. This helps confirm whether Excel is pulling the correct listing or an old/delayed quote.

If Excel still cannot match SGX correctly, it is recommended that you use a separate source for Singapore stocks, such as SGX/EOD data, Apple Numbers, or a Google Sheets import workaround, then paste or link the values back into Excel. Excel for Mac seems less reliable for some non-US market data.

Note: This information is provided as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above sites. 

Thank you for your patience in reading, I hope this information has been helpful to you. 

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment."    

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

Was this answer helpful?

1 person found this answer helpful.
0 comments

Answer accepted by question author

AI answer

2026-05-01T06:02:42.5166667+00:00

Singapore stock data in Excel on Mac comes from the Stocks linked data type, which relies on an external provider (LSEG Data & Analytics) and Microsoft’s online matching service. The context only confirms how to use Stocks and where the data comes from; it does not provide any product-side fix or known issue specific to Singapore listings.

What can be done within the documented capabilities:

  1. Ensure the Stocks data type is being used correctly
    • Enter the Singapore ticker or company name in a cell.
    • Select the cell(s), go to Data > Stocks to convert to the Stocks data type.
    • After conversion (stock icon appears), use the Add Column button to pull fields such as Price, Change, Last Trade Time, Exchange, etc., as described in the Stocks workflow.
  2. Confirm account and language prerequisites
    • Stocks data type is only available to Microsoft 365 accounts or those with a free Microsoft Account.
    • One of these editing languages must be added in Office Language Preferences: English, French, German, Italian, Spanish, or Portuguese.
  3. Understand data source limitations
    • All stock prices and related company information (including for Singapore) are provided by LSEG Data & Analytics under the Microsoft Service Agreement.
    • If certain markets or instruments are delayed, incomplete, or mapped differently, that behavior is controlled by the provider and the online service, not by a local Excel/Mac setting.

If US, UK, and HK prices are accurate but Singapore prices are not, and the above conditions are met, the behavior is governed by the external data source and there is no additional documented client-side fix in Excel for Mac beyond using the Stocks data type as designed.

References:

AI-generated content may be incorrect. Read our transparency notes for more information.

Was this answer helpful?

1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.