Wednesday, August 29, 2012

Get Singapore Stock Market Quotes in Google Docs

*20 August 2018 update: Due to data unavailability for both Google Finance and Yahoo finance, i had created a new Google Apps Script to download and import SGX daily price list data to Google sheets. Please refer to this link for details.

* 24 Feb 2014 update: Recently, i have had some problem with getting the result from Yahoo finance and the cell always show #VALUE! with error - "The data could not be retrieved. Please check the URL". I tried to use GoogleFinance again and it seems like they finally start to support SGX stocks. So to get the price of stock like Keppel Land, just type the following in the cell

=GoogleFinance("SGX:K17")

So the syntax is quite easy, just type in the stock quote name with SGX: precede in front. The only problem is the limitation of 2 decimal points...

For more information on what data can be retrieved, please refer to this link.

=====================================================================

If you are using Google Docs to keep track of your stocks statistics, this will be something very useful to you. By having the ability to import stock market quotes directly, you can manipulate this data further, example - to calculate paper gain/loss quickly.

Google actually provide a useful tool which is GoogleFinance* for this purpose but unfortunately, Singapore stock is not supported. Luckily, there is still this tool call ImportData which we can use to import structured data from other website like Yahoo Finance.

To do this, first,  you need to know your stock symbol. You can get this easily by typing the stock name in the get quotes field. Screenshot shows the list of possible stocks after i type in Keppel Land.


After you know your stock symbol, you just need to type the following in the cell of your spreadsheet document and replace the italic word with your own options. You can go to the following link for all the special tag options.

=ImportData("http://finance.yahoo.com/d/quotes.csv?s=stock symbol&f=special tag")

For example, if you want to get last trade price for Keppel Land, i just type the following:

=ImportData("http://finance.yahoo.com/d/quotes.csv?s=k17.si&f=l1")

and that's it, you can see that Google Docs will load the last trade price in the cell as shown below:




2 comments:

Unknown said...


stock market quote is the basic collection of numbers an investor must understand to achieve success in the stock market.quotes are popular with stock market investors because they are folksy but insightful.

Unknown said...

visit for live updates.

sgx nifty