HWZ Forums

Login Register FAQ Mark Forums Read

What alternatives after Yahoo Finance stops intra-day stock quotes?

Like Tree10Likes
Reply
 
LinkBack Thread Tools
Old 06-11-2017, 12:40 PM   #16
Member
 
Join Date: Dec 2005
Posts: 466
Able to retrieve current realtime price from this?

Edit: found the way thanks!
Why the retrieval from http is working but using formula googlesheet not working for SGX stocks?
stjoe1 is offline   Reply With Quote
Old 06-11-2017, 01:21 PM   #17
Supremacy Member
 
Jumpman23's Avatar
 
Join Date: Jan 2000
Posts: 5,470
Why the retrieval from http is working but using formula googlesheet not working for SGX stocks?
Seems like direct query is blocked by SGX...

Jumpman23 is online now   Reply With Quote
Old 06-11-2017, 01:38 PM   #18
Member
 
Join Date: Dec 2005
Posts: 466
Seems like direct query is blocked by SGX...

Lousy SGX..

How to be world-class exchange? Other stock market has no issue, even the closest competitor HKG can have direct access.
stjoe1 is offline   Reply With Quote
Old 08-11-2017, 01:17 AM   #19
Supremacy Member
 
apriliasiao's Avatar
 
Join Date: Dec 2001
Posts: 6,454
Able to retrieve current realtime price from this?

Edit: found the way thanks!
did u manage to find a way to feed in SGX stock into google sheet? can share?
apriliasiao is online now   Reply With Quote
Old 08-11-2017, 08:40 AM   #20
Supremacy Member
 
starfish.starfish's Avatar
 
Join Date: Sep 2007
Posts: 5,170
Not sure if it's related. I hv been using the stock master app for a while now. Since the past week, I couldn't get any sgx price updates when I use 4G. But I can still get it on wifi. No problems with the US stocks though.
starfish.starfish is offline   Reply With Quote
Old 08-11-2017, 08:46 AM   #21
Master Member
 
Join Date: Apr 2003
Posts: 4,516
Can do this. But not live update.
=ImportXML(ʺhttp://www.google.com/finance?q=SGX:Z74, ʺ//span[@class='pr']ʺ)
peterchan75 is offline   Reply With Quote
Old 08-11-2017, 09:43 AM   #22
Supremacy Member
 
Jumpman23's Avatar
 
Join Date: Jan 2000
Posts: 5,470
did u manage to find a way to feed in SGX stock into google sheet? can share?
I used:

=arrayformula(ImportData("http://finance.google.com/finance/getprices?x=SGX&q=Z74&i=60&p=1d"))

to get minute update of intraday prices for 1 day at every manual refresh (i think creating a auto refresh script in Sheets might work as well)

In another cell I simply lookup the last entry of the above to get the current price:

=INDEX(FILTER(N:N,NOT(ISBLANK(N:N))),ROWS(FILTER(N:N,NOT(ISBLANK(N:N)))))

where N is the column for the close price

Hope this helps.
Jumpman23 is online now   Reply With Quote
Old 08-11-2017, 09:54 AM   #23
Arch-Supremacy Member
 
Layers's Avatar
 
Join Date: Aug 2004
Posts: 16,751
I used:

=arrayformula(ImportData("http://finance.google.com/finance/getprices?x=SGX&q=Z74&i=60&p=1d"))

to get minute update of intraday prices for 1 day at every manual refresh (i think creating a auto refresh script in Sheets might work as well)

In another cell I simply lookup the last entry of the above to get the current price:

=INDEX(FILTER(N:N,NOT(ISBLANK(N:N))),ROWS(FILTER(N:N,NOT(ISBLANK(N:N)))))

where N is the column for the close price

Hope this helps.
How about excel?

Layers is offline   Reply With Quote
Old 08-11-2017, 10:29 AM   #24
Supremacy Member
 
Jumpman23's Avatar
 
Join Date: Jan 2000
Posts: 5,470
How about excel?
Might be able to create a web query in Excel using the same link above, have not tried that though..

https://support.office.com/en-us/art...4-7ee5f1b1cfba
Jumpman23 is online now   Reply With Quote
Old 08-11-2017, 12:17 PM   #25
Senior Member
 
Join Date: Jun 2006
Posts: 1,673
last time i used this to get the price from yahoo finance.. anyone knows how to just get the same quote using google?

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

I only need that one value..
mrwirus is offline   Reply With Quote
Old 08-11-2017, 12:37 PM   #26
Senior Member
 
Join Date: Dec 2005
Posts: 1,558
Hi all,

I have 2 alternatives if you are using Investment Moat's google spreadsheet.

Simply copy and paste the following into the respective cells:

For Bloomberg Prices:

=IMPORTXML("http://www.bloomberg.com/quote/"&F3&":SP","//div[@class='price']")

Replace the cell F3 with Bloombergs code for the SGX listed company. For instance, if you look up Keppel Corp, Bloomberg's code for keppel is KEP, so key in KEP in the cell F3.

For wall street journal prices:

=IMPORTXML("http://quotes.wsj.com/SG/"&F3&"","//span[@class='cr_num cr_curr_price']/span[@id='quote_val']")

WSJ is easier, because you just need to put in the SGX ticker in F3. For instance, the ticker for Kep Corp is BN4, so key in BN4 in the cell F3.

For some reason, quotes for the ETF G3B is not available on WSJ, so I had to use Bloomberg's prices for that. I only tested the above on google spreadsheets, not excel. I have no idea how to do it for excel.
limster, Flex11, simplylyn and 3 others like this.

Last edited by bobbytkc; 08-11-2017 at 12:41 PM..
bobbytkc is offline   Reply With Quote
Old 08-11-2017, 02:51 PM   #27
Senior Member
 
Join Date: Jun 2006
Posts: 1,673
Hi all,

I have 2 alternatives if you are using Investment Moat's google spreadsheet.

Simply copy and paste the following into the respective cells:

For Bloomberg Prices:

=IMPORTXML("http://www.bloomberg.com/quote/"&F3&":SP","//div[@class='price']")

Replace the cell F3 with Bloombergs code for the SGX listed company. For instance, if you look up Keppel Corp, Bloomberg's code for keppel is KEP, so key in KEP in the cell F3.

For wall street journal prices:

=IMPORTXML("http://quotes.wsj.com/SG/"&F3&"","//span[@class='cr_num cr_curr_price']/span[@id='quote_val']")

WSJ is easier, because you just need to put in the SGX ticker in F3. For instance, the ticker for Kep Corp is BN4, so key in BN4 in the cell F3.

For some reason, quotes for the ETF G3B is not available on WSJ, so I had to use Bloomberg's prices for that. I only tested the above on google spreadsheets, not excel. I have no idea how to do it for excel.
I'm trying to use your method but it kept giving me an error called "unknown range name".. or "Imported content is empty." Did I do something wrong?
mrwirus is offline   Reply With Quote
Old 08-11-2017, 02:56 PM   #28
Senior Member
 
Join Date: Dec 2005
Posts: 1,558
I'm trying to use your method but it kept giving me an error called "unknown range name".. or "Imported content is empty." Did I do something wrong?
Maybe You can post a screenshot of your spreadsheet and error? It is working on my spreadsheet.

In the code, you need to key in the ticker into a cell, and then replace the F3 with the coordinate of the cell where you keyed in the ticker.
bobbytkc is offline   Reply With Quote
Old 08-11-2017, 03:26 PM   #29
Senior Member
 
Join Date: Jun 2006
Posts: 1,673
Maybe You can post a screenshot of your spreadsheet and error? It is working on my spreadsheet.

In the code, you need to key in the ticker into a cell, and then replace the F3 with the coordinate of the cell where you keyed in the ticker.
ohhh.. I got it working.. Maybe I very manual.. haha.. every cell I will key in the ticker manually..

=IMPORTXML("http://quotes.wsj.com/SG/AJBU","//span[@class='cr_num cr_curr_price']/span[@id='quote_val']")

This will get Keppel DC Reit pricing.. Now I know..

Thanks alot for all your help!
mrwirus is offline   Reply With Quote
Old 08-11-2017, 03:52 PM   #30
Senior Member
 
Join Date: Jun 2006
Posts: 1,673
Maybe You can post a screenshot of your spreadsheet and error? It is working on my spreadsheet.

In the code, you need to key in the ticker into a cell, and then replace the F3 with the coordinate of the cell where you keyed in the ticker.
I can't get it working for bonds.. Does WSJ provide bond prices?
mrwirus is offline   Reply With Quote
Reply
Important Forum Advisory Note
This forum is moderated by volunteer moderators who will react only to members' feedback on posts. Moderators are not employees or representatives of HWZ. Forum members and moderators are responsible for their own posts.

Please refer to our Terms of Service for more information.


Thread Tools

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are On