Tracking investments with Google Spreadsheet

[klarklar]

Bookmark this good page.

 

[Roland216]

anyone knew how to use google finance for Bursa Malaysia?

Was it .my, my., klse, KLSE: or any? I can get the data

 

[sandwicher]

Well, Google Spreadsheet is really good. I wrote my own codes to track my portfolio vs STI. The finance information is scheduled to be placed into the cells daily after 6pm.

You all should really try it. That is how you can improve your returns. Here is my results so far this year.

Dividends not included.

Hey Hey!! What are the codes for this chart? I tried writing the codes to reproduce for myself but failed!

 

[dkhchan]

anyone knew how to use google finance for Bursa Malaysia?

Was it .my, my., klse, KLSE: or any? I can get the data

is .kl .......................

 

[makav31i]

Bookmark first...

 

[fbb005]

Is it possible to get fundamental analysis data from any financial website like yahoo or msn so that when I type the ticker, all the fundamental ratio automatic calculate

 

[limster]

I was trying to find out how to import Gold Spot into Google spreadsheet and found this link to the SGD spot price. Because the source webpage has been reformatted, you need to make a slight change:

=Index(ImportHtml("http://www.goldrate24.com/gold-prices/asia/singapore/", "table",2),2,2)

 

[peterchan75]

eh, nope, im wrote a module to import streaming feed from google into microsoft excel (not google spreadsheet), but when i try to pull in t39, it shows the other px, but for rest of the sgx prices, its normal, just that sph got problem.
strange

You can try this URL and see if it works.

http://www.google.com/finance/getprices?q=T39&x=SGX&i=86400&p=1d&f=d,o,h,l,c,v

 

[klarklar]

You can try this URL and see if it works.

http://www.google.com/finance/getprices?q=T39&x=SGX&i=86400&p=1d&f=d,o,h,l,c,v

Impressive. Are you a software programmer?

 

[peterchan75]

Impressive. Are you a software programmer?

No expert but just a cobbler. Be careful, not to hit Google Finance with too many http request. It will turn on their counter measure. Yahoo Finance is more generous in this aspect.

 

[klarklar]

No expert but just a cobbler. Be careful, not to hit Google Finance with too many http request. It will turn on their counter measure. Yahoo Finance is more generous in this aspect.

Will Google deny certain IP addr when traffic is too high?

 

[peterchan75]

Will Google deny certain IP addr when traffic is too high?

You try.

 

[kangkang86]

Anyone facing problems getting google finance data on google sheets? The sg mkt data having problems..

 

[af7680]

Anyone facing problems getting google finance data on google sheets? The sg mkt data having problems..

Same here..

 

[Some-one]

Anyone facing problems getting google finance data on google sheets? The sg mkt data having problems..

Same problem. I think the data has been banned by sgx to be shown on google.

 

[rerear]

Is the investment moats one also not working? Recall that is also on Google spreadsheet.

 

[peterchan75]

Google Finance and Yahoo Finance are both having this problem sometimes. For SGX counters, SGX is the most reliable source. EOD data is available at 6pm. Excel user can do http request and update daily open, high, low, close and volume.

 

[MrSinkie95]

any nice sharing?

 

[WindBoi]

My Stock Portfolio Tracker uses both Google and Yahoo Finance data. Somehow Google Finance stopped working but the price on my Stock Portfolio Tracker Still updates.

Current Portfolio Case Study

To learn how to use, you can go to this Guide to the Free Google Stock Portfolio Tracker

 

[Zapper1819]

sad, the google finance data is not working on their spreadsheet.