Tracy Chan
Original Poster
Apr 2, 2019

How to Track HK Stocks With GOOGLE FINANCE Function?

I tried https://business.tutsplus.com/tutorials/how-to-track-stock-data-in-google-sheets-with-googlefinance-function--cms-28182  However, may I know how to put Div Yield "yieldcpt"and income dividend date "incomedividenddata"? https://support.google.com/docs/answer/3093281?hl=en for HK Stock? Thanks a lot.
Details
Sheets,Chrome OS,Personal use
Locked
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Last edited Apr 2, 2019
All Replies
Arindam Das
Oct 25, 2019
USE googlefinance("HKG:xxxx","price") where xxxx is the code for the stock on the HK exchange.

For example, for TENCENT (code "0700.HK") the function syntax will be =googlefinance("HKG:0700","price")
false
9878499613731126901
true
Search Help Center
true
true
true
true
true
35
Search
Clear search
Close search
Main menu
false
false