May I know the code to pull out the 52w from klsescreener?
Stock Spreadsheet
Stock Spreadsheet
|
Oct 23 2021, 02:43 AM
|
Probation
4 posts Joined: Oct 2021 |
May I know the code to pull out the 52w from klsescreener?
|
|
|
|
Oct 23 2021, 11:37 AM
|
Probation
4 posts Joined: Oct 2021 |
Below code is to import the price.
If I want to import the 52w info, why to do it? Thank you in advance. https://pictr.com/images/2021/10/23/BL49Z6.md.jpg |
|
Oct 23 2021, 12:44 PM
|
Probation
3 posts Joined: Oct 2021 |
what a good sharing on this.
|
|
Oct 23 2021, 11:35 PM
Show posts by this member only | IPv6 | Post
#64
|
Junior Member
779 posts Joined: Jun 2005 |
QUOTE(calvinkcl @ Oct 23 2021, 11:37 AM) Below code is to import the price. If I want to import the 52w info, why to do it? Thank you in advance. <a href='https://pictr.com/images/2021/10/23/BL49Z6.md.jpg' target='_blank'>https://pictr.com/images/2021/10/23/BL49Z6.md.jpg </a> CODE =index(IMPORTXML("https://www.klsescreener.com/v2/stocks/view/5176", "//div[@class ='table-responsive']//table[1]/tbody/tr[7]/td[2]"),1) calvinkcl liked this post
|
|
Oct 23 2021, 11:50 PM
|
Junior Member
779 posts Joined: Jun 2005 |
QUOTE(calvinkcl @ Oct 23 2021, 02:43 AM) Like this to keep it simple.CODE =index(IMPORTXML("https://www.klsescreener.com/v2/stocks/view/5176", "//tr[7]/td[2]"),1) calvinkcl liked this post
|
|
Nov 3 2021, 02:05 AM
|
Probation
4 posts Joined: Oct 2021 |
Hi Bro & Sis, I wish to get the price different with the (xxx%) beside it, what is the code?
|
|
Nov 3 2021, 10:34 AM
|
Probation
4 posts Joined: Oct 2021 |
Hi buddies, I am import the data from klsescreener.
When i import that price different everyday, it comes with % up or down. How to remove it. How to amend to to remove the % up or down that beside the price different. Thanks in advance! |
|
Mar 1 2022, 10:59 AM
|
Senior Member
3,067 posts Joined: Jan 2008 |
QUOTE(Yggdrasil @ Mar 4 2020, 03:04 PM) bmwcaddy This option was good to use for 2 years. Today i3 upgraded their site and can't pluck the latest price from there.Rough guide how to get the data. Clean up later if you want. Excel 1. Copy URL. 2. In Excel, go to Data. 3. Paste link. 4. Navigate to the info you want. Easy way is to just import the whole table and hide the sheet we don't want. Click load. 5. It will appear like this. 6. Clean up if you want. My putting a master sheet with what you want to see and the other data in another sheet like this. 7. Click refresh all when you want to get latest data. Thank you Yggdrasil for showing us this option. |
|
|
|
Mar 26 2022, 07:34 PM
Show posts by this member only | IPv6 | Post
#69
|
Junior Member
22 posts Joined: Sep 2010 |
Does anyone have an updated method to pull price data for KLSE stocks? The old method suggested in this thread no longer works after i3investor updated their website
|
|
Mar 28 2022, 10:17 AM
|
Senior Member
3,067 posts Joined: Jan 2008 |
QUOTE(kenalex555 @ Mar 26 2022, 07:34 PM) Does anyone have an updated method to pull price data for KLSE stocks? The old method suggested in this thread no longer works after i3investor updated their website You create a portfolio like Philips Farms in I3.https://klse.i3investor.com/servlets/pfs/120720.jsp Then you import the data from I3. |
|
Apr 7 2022, 10:40 AM
Show posts by this member only | IPv6 | Post
#71
|
Junior Member
35 posts Joined: Dec 2012 |
QUOTE(cucubud @ Mar 28 2022, 10:17 AM) You create a portfolio like Philips Farms in I3. How do you go about doing this?https://klse.i3investor.com/servlets/pfs/120720.jsp Then you import the data from I3. |
|
Apr 7 2022, 01:45 PM
|
Senior Member
3,067 posts Joined: Jan 2008 |
QUOTE(Van Der Shah @ Apr 7 2022, 10:40 AM) 1. Register a user id in i3.2. Sign in and create a portfolio with the stocks you want to get the price. 3. Make that portfolio a Transaction Type and a Shared Access Type. 4. You import the link of that portfolio to your Excel spreadsheet where you can pluck the price of the stock you created. |
|
Apr 24 2022, 10:52 PM
Show posts by this member only | IPv6 | Post
#73
|
Junior Member
779 posts Joined: Jun 2005 |
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) 126126 liked this post
|
|
Sep 29 2022, 02:39 PM
Show posts by this member only | IPv6 | Post
#74
|
Newbie
1 posts Joined: Feb 2015 |
Hi,
I want to extract Debt to Cash ratio from klsescreener into my Google sheet, tried many methods but still unsuccessful, anyone can help ? |
|
|
|
Feb 26 2024, 11:22 AM
Show posts by this member only | IPv6 | Post
#75
|
Junior Member
56 posts Joined: Jan 2011 |
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? |
|
Feb 26 2024, 03:32 PM
Show posts by this member only | IPv6 | Post
#76
|
Junior Member
779 posts Joined: Jun 2005 |
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. 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.Anyone has the most recent code? Or any other ways to pull live prices on sheets? |
|
Feb 26 2024, 09:48 PM
Show posts by this member only | IPv6 | Post
#77
|
Junior Member
56 posts Joined: Jan 2011 |
QUOTE(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) QUOTE(cucumber @ Feb 26 2024, 03:32 PM) 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. Hey I was using the code you shared in 2022. But i just checked back sheets just now and it was working again. Was down for the past few days thought need a new code. Thanks again |
Change to: | 0.0168sec
0.29
6 queries
GZIP Disabled
Time is now: 29th March 2024 - 06:12 AM |