Hi ! I am currently designing my own stock excel/google sheets but I can't seem to find a way to pull KLSE data into it. Is there any way for me to proceed?

Thanks

I think it's not possible to obtain data on Google Sheets using Google Finance formula because it is not supported.
You might be able to if you have a paid database and use an add-on.

On Excel, it is possible to pull data from websites.
Example here.
So you may be able to pull from websites that has Malaysian closing price.

Example of pulling from klse.i3investor.com




Do note that most websites do not give live rates and are often delayed.
Therefore, it's not useful for daily trading.

I just tried using =importxml in google sheet, it works!

But I choose to scrape the price from Bloomberg instead, just a personal preference. Google limit the formula auto update in sheet at once per hour interval if use too many of the formula in one sheet, so not suitable for day trading too. Though it’s great to have the sheet as a tracker to check at night after work

Thanks for sharing. But how do you get the Xpath?
I tried but I got an error.



Took the Xpath from here. There's Xpath and full Xpath

I did this



D7 = the cell that I put the Bloomberg url

Then I get a column of the url I want to track, and copy paste the =importxml formula

This post has been edited by Intimidated: Mar 3 2020, 10:17 PM

Nice! But do you know how to get the code? So can use for other websites too
Edit: Wait. I think the picture I posted has the answer lol.
Edit 2: Oops doesn't work. Ah well.

This post has been edited by Yggdrasil: Mar 3 2020, 10:28 PM

Ya ya i think the formula only works with things like

I also trial and error lol

This post has been edited by Intimidated: Mar 3 2020, 10:26 PM

I think I found it. For example, klse.i3investor.com



1. Input the formula like usual: =importxml("https://klse.i3investor.com/servlets/stk/annrep/6084.jsp",
2. Use inspect element to highlight the data.

As you can see, the code starts with "td". So,

3. 0.38 which is the data we need is next to "class", so

4. Fill in with the remaining code. So,

5. Final code:



6. Results

Oh I just tried on a stock that gained instead of loss

The class will be ‘up big16’ instead

So maybe can do like

IFERROR(importxml_with_up big16, importxml_with_down big16)

Wow learnt something new today. Thanks for sharing!

Mine still have error of #NAME?

Any idea how to solve it ?

Which website and which stock?
Post your formula here

SUNREIT, from KLSE i3investor

=importxml("https://klse.i3investor.com/servlets/stk/5176.jsp","//tdclass='up big16'")

Hmm. klse.i3investor.com code is unstable as it changes everytime.

Use Bloomberg instead. E.g. for Sunreit:

Why need to use excel? Plenty of established free or by subscription tool available. You want to be successful or just having fancy excel sheet is the goal?

Still the same problem wor. Am i missing out anything? need to enable any developer tools etc. ? I just copied your code into my excel formula then #NAME?

The code is for Sheets. For Excel, you need to import the data from the link.

Ah my bad for not reading it. Got it (on sheets).

Thanks!

bmwcaddy

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.

Thanks for the detailed steps. But my problem seems to be stuck at step 2: My excel 2016 cant run the script (error running) of the website, causing it to crash whenever i past any web link