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?
Anonymous
shared this idea
1 comment
-
Anonymous
commented
Same problem, cant work out the Excel Stock connector code for indexes including, HSI, All Ordinaries, Shanghai. Thanks.