Welcome Guest ( Log In | Register )

Bump Topic Add Reply RSS Feed

Outline · [ Standard ] · Linear+

 Stock Spreadsheet

views
     
jegan80
post Mar 4 2025, 09:48 AM

New Member
*
Newbie
7 posts

Joined: Feb 2010
Eg... for the green Telco provider..

CODE
=importxml("https://www.klsescreener.com/v2/stocks/view/8672","//span[@id='price']")


This post has been edited by jegan80: Mar 4 2025, 09:50 AM
LakeEdger
post Mar 9 2025, 04:09 PM

New Member
*
Junior Member
43 posts

Joined: Sep 2010
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']")

*
Thanks man. This works for my klse stocks. Cheers!
b787
post Mar 13 2025, 10:37 AM

Getting Started
**
Junior Member
192 posts

Joined: Jul 2008
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)

*
Anybody got the latest code ?
nauticat99
post Mar 15 2025, 03:16 PM

On my way
****
Junior Member
587 posts

Joined: May 2016
Recently I wanted to create a simple spreadsheets for certain HKEx stocks- daily opening, closing, high, low and volume. Ask deepseek and am astounded it solved my problem in less than 10 minutes. Link google sheet with google finance and from there expanded the spreadsheet to include 52w h&l, price difference and % difference.
nauticat99
post Mar 15 2025, 03:17 PM

On my way
****
Junior Member
587 posts

Joined: May 2016
QUOTE(b787 @ Mar 13 2025, 10:37 AM)
Anybody got the latest code ?
*
Try using deepseek, I find it easier and faster to get answers rather than chatgpt.
cucumber
post Mar 26 2025, 12:36 PM

Enthusiast
*****
Junior Member
821 posts

Joined: Jun 2005
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
« Next Oldest · Stock Exchange · Next Newest »
 

5 Pages « < 3 4 5Top
Add ReplyOptions
 

Change to:
| Lo-Fi Version
 0.0151sec    0.55    6 queries    GZIP Disabled
Time is now: 20th December 2025 - 08:26 PM
All Rights Reserved © 2002- 2025 Vijandren Ramadass (~unite against racism~)
Removal Request
Powered by Invision Power Board © 2025  IPS, Inc.