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 08-11-2017, 04:11 PM   #31
Senior Member
 
Join Date: Dec 2005
Posts: 1,558
I can't get it working for bonds.. Does WSJ provide bond prices?

I haven't tested it for bonds as I don't own any so I can't comment.

You can try to look it up using Bloomberg.
bobbytkc is offline   Reply With Quote
Old 08-11-2017, 05:49 PM   #32
Senior Member
 
Join Date: Jun 2006
Posts: 1,673
I haven't tested it for bonds as I don't own any so I can't comment.

You can try to look it up using Bloomberg.
can't seem to find it.. sigh.. anyone can help?

I dun need live data.. but i dun even know how to get like maybe end of day data..
mrwirus is offline   Reply With Quote
Old 08-11-2017, 07:36 PM   #33
Member
 
Join Date: Nov 2011
Posts: 212
Thanks for the workaround!
One thing to add. it seems that WSJ prices are rounded to nearest 2 decimal places. This will be a problem for some of the stocks below $2


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.
$warrior likes this.
__________________
I am not mad, just misunderstood....
Mad_Stranger is offline   Reply With Quote
Old 09-11-2017, 02:08 PM   #34
High Supremacy Member
 
Join Date: Apr 2003
Posts: 45,355
interday good enough for me as i dont scalp.
yahoo finance still working for users like me
chopra is offline   Reply With Quote
Old 09-11-2017, 06:18 PM   #35
Member
 
Join Date: Dec 2005
Posts: 466
can't seem to find it.. sigh.. anyone can help?

I dun need live data.. but i dun even know how to get like maybe end of day data..
Yes bonds and pref shares seem not available from those sources..

I am using Shareinvestors e.g for DBS pref shares..

https://www.shareinvestor.com/fundamental/factsheet.html?counter=MU7.SI
stjoe1 is offline   Reply With Quote
Old 09-11-2017, 11:53 PM   #36
Senior Member
 
Join Date: Jun 2006
Posts: 1,673
Yes bonds and pref shares seem not available from those sources..

I am using Shareinvestors e.g for DBS pref shares..

https://www.shareinvestor.com/fundam...counter=MU7.SI
you meant you just go into the website and take a look manually right?
mrwirus is offline   Reply With Quote
Old 10-11-2017, 08:56 AM   #37
Member
 
Join Date: Dec 2005
Posts: 466
you meant you just go into the website and take a look manually right?
No use web scraping formula.. Importxml to get the data directly to googlesheet..

You can use this formula to get the last done price for FCL bond with stock code AXXZ. For other bonds/pref shares, just change AXXZ with their stock codes.

=ImportXML("http://www.shareinvestor.com/fundamental/factsheet.html?counter=AXXZ", "//td[@class='sic_lastdone']/strong")
simplylyn likes this.

Last edited by stjoe1; 10-11-2017 at 09:35 AM..
stjoe1 is offline   Reply With Quote
Old 10-11-2017, 11:08 AM   #38
Supremacy Member
 
Join Date: Nov 2017
Posts: 6,552
Can try cnbc app
It has 3 digits
E.g. 0.535
1.38 but not 1.385

I also use SGX mobile app

Last edited by appl888; 10-11-2017 at 12:41 PM..
appl888 is online now   Reply With Quote
Old 10-11-2017, 01:22 PM   #39
Master Member
 
Join Date: Oct 2002
Posts: 3,172
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.
Thanks for the detailed writeup.

Any idea what stock code should I put for US or London stocks? Such as IWDA? I tried afew combinations but couldn't get it to work
Flex11 is online now   Reply With Quote
Old 10-11-2017, 01:53 PM   #40
Senior Member
 
Join Date: Dec 2005
Posts: 1,558
Thanks for the detailed writeup.

Any idea what stock code should I put for US or London stocks? Such as IWDA? I tried afew combinations but couldn't get it to work
For markets, you just look up the relevant stock and look for the corresponding code for international markets.

For instance, if you google AAPL bloomberg, it returns "https://www.bloomberg.com/quote/AAPL:US"

So you just replace ":SP" to ":US" for it to work for US equities.

For WSJ, you can so the same, and replace the SG with the corresponding one for international markets.
Flex11 likes this.
bobbytkc is offline   Reply With Quote
Old 10-11-2017, 02:24 PM   #41
Supremacy Member
 
Rainbow1112's Avatar
 
Join Date: May 2008
Posts: 5,347
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.
cant seem to get this to work..

formula entered in cell G2

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

Cell F2 i enter Bloomberg code for M1 - M1:SP

i'm getting Error Imported content is empty.
Rainbow1112 is offline   Reply With Quote
Old 10-11-2017, 02:56 PM   #42
Master Member
 
Join Date: Oct 2002
Posts: 3,172
For markets, you just look up the relevant stock and look for the corresponding code for international markets.

For instance, if you google AAPL bloomberg, it returns "https://www.bloomberg.com/quote/AAPL:US"

So you just replace ":SP" to ":US" for it to work for US equities.

For WSJ, you can so the same, and replace the SG with the corresponding one for international markets.
Thanks alot ! Works like a charm !
Flex11 is online now   Reply With Quote
Old 10-11-2017, 03:05 PM   #43
Senior Member
 
Join Date: Dec 2005
Posts: 1,558
cant seem to get this to work..

formula entered in cell G2

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

Cell F2 i enter Bloomberg code for M1 - M1:SP

i'm getting Error Imported content is empty.

Just key in M1, not M1:SP
bobbytkc is offline   Reply With Quote
Old 12-11-2017, 01:01 AM   #44
Supremacy Member
 
apriliasiao's Avatar
 
Join Date: Dec 2001
Posts: 6,454
Just key in M1, not M1:SP
can you give an example of the working strings? i tried many combo but didnt work like that 1 below since :SP is not needed.

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

i have also tried putting M1 in F3 cell and your code =IMPORTXML("http://www.bloomberg.com/quote/"&F3&":SP","//div[@class='price']") in another cell.
Dint work too.

I notice that Bloomberg is using https instead of http which is in your code.

Last edited by apriliasiao; 12-11-2017 at 01:56 AM..
apriliasiao is offline   Reply With Quote
Old 12-11-2017, 01:02 AM   #45
Supremacy Member
 
apriliasiao's Avatar
 
Join Date: Dec 2001
Posts: 6,454
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.
thanks but i have error using your Singtel example.
apriliasiao 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