FREE Stock Portfolio Tracker now with SGX Google Finance automatic price updates | Investment Moats Skip to Content

FREE Stock Portfolio Tracker now with SGX Google Finance automatic price updates

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.

China Merchant Pacific: Dividend Analysis, AGM updates and Q1 report
← Previous
Overseas Property Leases and Rentals offers more predictable cash flow
Next →

This site uses Akismet to reduce spam. Learn how your comment data is processed.

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.