Our Free Stock Portfolio Tracker that helps investors track their stock portfolio by transactions supports automatic REAL TIME Google price updates
We got to know a few months ago Google Finance supports Singapore SGX Exchange. This means that you can look up say Mencast at Google Finance and you will get a stock price.
But it is only recently that the GoogleFinance() Function in the Google API supports SGX as an exchange.
As such, I decide to incorporate it into myAwesome Free Stock Portfolio Tracker.
For those interested in Getting Started with this free tracker, view this post here.
Changes you need to make to your Stock Portfolio Tracker
All you need to do is to put in the right symbol format.
Say you want to update UMS. Just look up the right symbol in Google Finance.
At “Google Quote” column, insert the symbol as “SGX:{your stock symbol}”
The upside of Google is really their prices look to be REAL TIME. The downside is that they show last trade price. If your stock is like Pertama, which have not been trading for some time, it will show a zero.
Google smallest decimal place is also 2 decimal place, which doesn’t work that well with penny stocks.
To get started with dividend investing, start by bookmarking my Dividend Stock Tracker which shows the prevailing yields of blue chip dividend stocks, utilities, REITs updated nightly.
Make use of the free Stock Portfolio Tracker to track your dividend stock by transactions to show your total returns.
For my best articles on investing, growing money check out the resources section.
- Do You Have a Strong Insurance Protection Foundation? A FREE Havend E-book to Help Singaporeans(Plus Webinar Tonight) - March 28, 2024
- When Does High Quality and Low Quality Companies Perform Well? - March 27, 2024
- A Potential Rule of Thumb to Estimate CPF LIFE Standard Income with Our 65-Year-Old CPF RA Capital. - March 24, 2024
PengSP
Tuesday 16th of February 2016
Passing by & saw comment, these might fix Googlefinance not working:
=ImportXML("https://www.google.com/finance?q=SGX:BS6", "//span[@class='pr']")
=ImportXML(concatenate("https://www.google.com/finance?q=", "SGX:BS6"), "//span[@class='pr']") or this one to replace "SGX:BS6" with cell number
=ImportXML(concatenate("https://www.google.com/finance?q=", C2), "//span[@class='pr']")
Kyith
Thursday 18th of February 2016
hi PengSP, thanks for the heads up! great share!
singaporecoins
Saturday 9th of January 2016
Google finance function not working any more.
Kyith
Saturday 9th of January 2016
hi Singaporecoins, yes that is right, but the Yahoo finance prices should still be functioning
Gonzalo Redondo
Sunday 19th of May 2013
Great tool. Can you help me on how to use Spanish stock quotes. Really appreciate it
Anshul SGX
Monday 29th of April 2013
does it helpful for trading work also