Obtaining Hang Seng Index from the Stocks module
I am using Excel for Mac, version 16.30 (always updated to the latest version)
I can easily obtain stock quotes all index members of the Dow Jones, Hang Seng Index, Swiss Market Index. Also to retrieve the index quotes for DJIA, S&P500, DAX, etc. is not an issue at all.
Obtaining the quote for the Hang Seng Index itself I haven't figured out for a couple of months already.
“HSI” returns "H.I.S. Co Ltd (OTCM:HISJF)” “Hang Seng” returns “No results found for Hang Seng” “^HSI” returns results such as H-Source Holdings, etc.
I have reached out to Microsoft calling the hotline in Shanghai, approaching Microsoft through its Facebook page in Hong Kong, but all failed, as I believe the support team fails to grasp the question (what is a stock, what is an index, etc).
Also requests to speak to technical person with knowledge of the Stocks module remains unanswered.
How is best to approach Microsoft to have this resolved?