Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 Stock Spreadsheet

views
     
calvinkcl P
post Oct 23 2021, 02:43 AM

New Member
*
Probation
4 posts

Joined: Oct 2021
May I know the code to pull out the 52w from klsescreener?
calvinkcl P
post Oct 23 2021, 11:37 AM

New Member
*
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
ulala2021 P
post Oct 23 2021, 12:44 PM

New Member
*
Probation
3 posts

Joined: Oct 2021
what a good sharing on this.
cucumber
post Oct 23 2021, 11:35 PM

Enthusiast
*****
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)

cucumber
post Oct 23 2021, 11:50 PM

Enthusiast
*****
Junior Member
779 posts

Joined: Jun 2005


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)

calvinkcl P
post Nov 3 2021, 02:05 AM

New Member
*
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?

calvinkcl P
post Nov 3 2021, 10:34 AM

New Member
*
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!
cucubud
post Mar 1 2022, 10:59 AM

Super Moderator
*******
Senior Member
3,067 posts

Joined: Jan 2008


QUOTE(Yggdrasil @ Mar 4 2020, 03:04 PM)
bmwcaddy

Rough guide how to get the data. Clean up later if you want.

Excel
1. Copy URL.
user posted image

2. In Excel, go to Data.
user posted image

3. Paste link.

user posted image

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.

user posted image

5. It will appear like this.

user posted image

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.

user posted image

7. Click refresh all when you want to get latest data.

user posted image
*
This option was good to use for 2 years. Today i3 upgraded their site and can't pluck the latest price from there.
Thank you Yggdrasil for showing us this option.

kenalex555
post Mar 26 2022, 07:34 PM

New Member
*
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
cucubud
post Mar 28 2022, 10:17 AM

Super Moderator
*******
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.

Van Der Shah
post Apr 7 2022, 10:40 AM

New Member
*
Junior Member
35 posts

Joined: Dec 2012


QUOTE(cucubud @ Mar 28 2022, 10:17 AM)
You create a portfolio like Philips Farms in I3.
https://klse.i3investor.com/servlets/pfs/120720.jsp

Then you import the data from I3.
*
How do you go about doing this?
cucubud
post Apr 7 2022, 01:45 PM

Super Moderator
*******
Senior Member
3,067 posts

Joined: Jan 2008


QUOTE(Van Der Shah @ Apr 7 2022, 10:40 AM)
How do you go about doing this?
*
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.
cucumber
post Apr 24 2022, 10:52 PM

Enthusiast
*****
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)



Legarvin
post Sep 29 2022, 02:39 PM

New Member
*
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 ?
126126
post Feb 26 2024, 11:22 AM

Getting Started
**
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?
cucumber
post Feb 26 2024, 03:32 PM

Enthusiast
*****
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.

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.
126126
post Feb 26 2024, 09:48 PM

Getting Started
**
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 notworthy.gif

4 Pages « < 2 3 4Top
 

Change to:
| Lo-Fi Version
0.0168sec    0.29    6 queries    GZIP Disabled
Time is now: 29th March 2024 - 06:12 AM