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.
Kyith is the Owner and Sole Writer behind Investment Moats. Readers tune in to Investment Moats to learn and build stronger, firmer wealth foundations, how to have a Passive investment strategy, know more about investing in REITs and the nuts and bolts of Active Investing.
Readers also follow Kyith to learn how to plan well for Financial Security and Financial Independence.
Kyith worked as an IT operations engineer from 2004 to 2019. Currently, he works as a Senior Solutions Specialist in Fee-only Wealth Advisory firm Providend. All opinions on Investment Moats are his own and does not represent the views of Providend.
You can view Kyith's current portfolio here, which uses his Free Google Stock Portfolio Tracker.
His investment broker of choice is Interactive Brokers, which allows him to invest in securities from different exchanges all over the world, at very low commission rates, without custodian fees, near spot currency rates.
You can read more about Kyith here.
- TD Ameritrade to Focus Only on Accredited Investors (AI) in Singapore. You May Need to Take Actions. - September 26, 2023
- The Dangers of Income Planning with a Fixed Inflation Rate (such as 3% p.a.) - September 25, 2023
- New 6-Month Singapore T-Bill Yield in Late-September 2023 Should Stick to 3.75% (for the Singaporean Savers) - September 21, 2023
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