Outline ·
[ Standard ] ·
Linear+
Stock Spreadsheet
|
cucumber
|
 Oct 23 2021, 11:35 PM
|
|
QUOTE(calvinkcl @ Oct 23 2021, 11:37 AM) CODE =index(IMPORTXML("https://www.klsescreener.com/v2/stocks/view/5176", "//div[@class ='table-responsive']//table[1]/tbody/tr[7]/td[2]"),1) |
|
|
|
|
|
cucumber
|
Oct 23 2021, 11:50 PM
|
|
|
QUOTE(calvinkcl @ Oct 23 2021, 02:43 AM) May I know the code to pull out the 52w from klsescreener? Like this to keep it simple. CODE =index(IMPORTXML("https://www.klsescreener.com/v2/stocks/view/5176", "//tr[7]/td[2]"),1) |
|
|
|
|
|
cucumber
|
Apr 24 2022, 10:52 PM
|
|
|
If you're using Google Sheets Here's the new code : CODE =index(ImportXML("https://klse.i3investor.com/web/stock/overview/1155?randomstring", "//div[contains(@id, 'stock-price-info')]//p[2]"), 1, 1) |
|
|
|
|
|
cucumber
|
Feb 26 2024, 03:32 PM
|
|
|
QUOTE(126126 @ Feb 26 2024, 11:22 AM) Hello, have been using i3investor to pull bursa prices for sheets, but recently the prices are no longer updated. Anyone has the most recent code? Or any other ways to pull live prices on sheets? Could you share the code you were using? I had the same problem a few days ago, I just modified the url a bit and it worked. Yahoo however is not working, page is down. |
|
|
|
|
|
cucumber
|
Feb 12 2025, 09:36 AM
|
|
|
QUOTE(126126 @ Nov 14 2024, 10:28 AM) Hello, looks like the code has been down for the past few weeks. Anyone has the new code to pull recent prices from i3 website or any other sites? I cannot get it to work either with KLSE stocks. Tried various methods. It stopped working for me the past week. US stock still ok using Google Finance. If anyone found a way to extract KLSE stock price in Google Sheets kindly share here. |
|
|
|
|
|
cucumber
|
Mar 26 2025, 12:36 PM
|
|
|
QUOTE(jegan80 @ Mar 4 2025, 09:48 AM) Eg... for the green Telco provider.. CODE =importxml("https://www.klsescreener.com/v2/stocks/view/8672","//span[@id='price']") This works. Thank you ma man |
|
|
|
|
Quote
0.0231sec
0.50
7 queries
GZIP Disabled