Share via

How to find the ticker number for Hong Kong stocks or China A-shares stock?

Anonymous
2025-02-20T09:32:42+00:00

I want to use the STOCKHISTORY function to retrieve stock price for Hong Kong and China A-share stocks, but I don't know the ticker symbol format... for e.g. SEHK: 0005, what is the correct format for this?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

  1. Anonymous
    2025-02-20T10:18:02+00:00

    Hi David,

    Welcome to Microsoft Community.

    The basic format for Hong Kong stock ticker symbols is XHKG:****. For Shenzhen Stock Exchange in China is XSHE:****.

    Taking Tencent Holdings Limited as an example, its ticker symbol is XHKG:700.

    You can look up the ticker symbols for stock exchanges around the world here: About the Stocks financial data sources - Microsoft Support

    If you have any other questions or want to share more context, please let me know in your reply!

    Best Regards,

    Thomas C - MSFT | Microsoft Community Support Specialist

    2 people found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful