hi can someone help me out here. been trying and trying but with no success. can someone point out where i am wrong?

=importxml("https://www.klsescreener.com/v2/stocks/view/5238","//*(@id=price_header)")

thanks in advance

This post has been edited by gegambo: Jun 2 2020, 06:12 PM

Found this today. Excellent way to get stock data via your Excel!

https://www.youtube.com/embed/xzOvM164H6M?rel=0

But need paid Excel 365 for the latest functions, I think.

Sadly bursa not supported https://support.microsoft.com/en-us/office/...ea-c5a6c8e787e6

Hi, anyone with success using =GOOGLEFINANCE() in Google Spreadsheet to pull KLSE stock prices?

Not sure why but the Bloomberg formula that works well for the past few months is now showing error

Because bloomberg, along with many other sites with stock prices are one-by-one blocking us from fetching data. You've to find other new websites to fetch prices from.

I think Google doesn't have permission to pull from Malaysia exchange.
It can't pull from Japan exchange too. You need to pull from other websites.

Yeah not sure why but I managed to pull from investing.com

Your code is wrong. Here's the correct one.


It's not that hard to learn.

BTW TO OTHERS... STOP ASKING ANYMORE..
If error means your code wrong or website cannot pull.

For those interested, can also use my spreadsheet. I published it for free initially for fundsupermart users but over time I've moved on to other vehicles (incl. Malaysia / Foreign stocks)

The spreadsheet might be quite heavy though.

Links in my signature or read more here: https://forum.lowyat.net/index.php?showtopi...&#entry98487565

You have a great thing going there, though I'm wondering why don't you move to Google Sheets, since Google Sheets is superior in so many ways.

For instance, my portfolio file on google sheets is able to save my end-of-day portfolio value, without having to open the file at all. Google scripts can be automated to be triggered on a time basis, without requiring one to open the file on a daily basis and pressing macro buttons. So I get a summary of how my portfolio of stocks on Bursa, SGX and HKEX have evolved over the last 3+ years as per the chart below. All without pressing buttons and running macros. I only have to key into my sheet my trades and dividends received, with google sheets taking care of everything else.





This post has been edited by Havoc Knightmare: Oct 19 2020, 08:12 PM

Dang, that's actually pretty neat! Personally I thought about it a few times but was too lazy to re-do everything again on Google Sheets and that kinda held me back

Maybe I should really spend some time and look into it My snapshot is only as good as the times I remember to refresh it There's some obvious "holes" on certain month when I forgot to even open the sheet

Yeah, with google sheets you will never have to open the sheet just to run macros. You just need to check in every now and then to correct any errors since google sheets doesn't fetch data correctly occasionally and you end up with #error cell outputs.

My current sheet is derived from this Singaporean blogger's work since I have little knowledge in programming languages - https://investmentmoats.com/StockPortfolioT...menttracker.php

Perhaps you can use his sheet as a blueprint to work with.

Wow that dedication!

I manage to use klse.i3investor.com to pull the prices but as some has mentioned the formula keeps on changing sometimes it’s up,sometimes it’s down

Solution already mentioned here:
https://forum.lowyat.net/index.php?showtopi...post&p=95692476

Use IFERROR( ...link with up... , ...link with down...)
This means if Google fetch the link with up and it's an error, it will revert to link with down.
Disadvantage is it's a long formula.

Hi there, i wondering is there any method or insert any code to make it auto refresh within few second/minute instead of manual refresh it?

You can easily Google this..

I am still having trouble doing this. Could you be so kind to help me out? It keeps showing N/A. And it says content imported is empty.

https://pictr.com/images/2020/10/30/7MOy35.png
https://pictr.com/images/2020/10/30/7MOXjV.png
https://pictr.com/images/2020/10/30/7MOKpv.md.png

N/A because Bloomberg website doesn't allow "scrapping" figures or Google's website having problem retrieving.
Extract from klsescreener instead.

hihi, i had created a webpage mainly to cater this google sheet problem. Feel free to test it out and let me know any feedbacks =)

www.mybuku555.com