Some people just prefer a simple spreadsheet tracker that doesn’t require additional login/software like me

I like to have one column for the actual amount paid (including fees) for the shares, one for how many shares I have, and one for the latest price (which I have now automated with the importxml formula!). Then some other fancy formatting like scale weightage conditional color formatting, blabla.

So it gives me a quick glance how much the real gain/loss is without me logging into another website or software. I already use Google Drive extensively for work

EDITED: just realised I can scrape fund prices from Bloomberg for my FSM/other unit trust portfolios as well now I can have a one-sheet tracker to tell me how are the investments doing, don’t have to login here there anymore

This post has been edited by Intimidated: Mar 4 2020, 04:55 PM

Hi ! I actually am more comfy using Google Sheets/ Excel tbh. What other free or subscription tool do you know? I quite cheap skate cause I am still a student not willing to pay subscription

Can you explain the IFERROR part?

Thanks!

Thank you very much for the tutorial.
It works!!!

The formula will be long and complicated. Just use Bloomberg for Sheets. Solve the problem.

it's just a normal Excel formula. you can understand from this link https://www.excel-easy.com/examples/iferror.html
once understand then you can apply in google sheets as well

What tool would you suggest?

This is quite useful. And I realize the naming convention of KLSE URL is the stock code, so can use the concatenate(or &) formula and only need to amend the stock code.
i.e. ="https://klse.i3investor.com/servlets/stk/"&"Stock Code&".jsp"

Hi,
how to get the price for day high only?

Thanks

Try this

I tried this
But it will fetch 52 weeks price also. The code is identical. But i dont know how to limit to day range high price only.

It fetched the day high for me. Not sure why it doesn't work for you.

52 weeks 1.98 will come up at bottom....


Attached thumbnail(s)

Just hide the cell. Can't help it I think because both share the same code.

Noted. Thanks alot

The stock price from xml will not update automatically?

Should auto update but you may need to refresh the page.

Hey bro, I trying to follow what you guys done here with KLSE Screener. I use IMPORTHTML to get the table I want but again, it is abit tricky to import the price

This is the code : =IMPORTXML("https://www.klsescreener.com/v2/stocks/view/"A2,"//spanid='price'")

A2 is the cell/stock code, and the remaining is modified according to what you guys done, it is originally from KLSE Screener element for price display.
But at the end it does not show anything, just blanked. Could you please lookup for me, please I feeling like just one small step away from success

A2 cell:

CODE:

P.S.: To others, stop asking me anymore Tired of this. Just trial and error please.

This post has been edited by Yggdrasil: Apr 30 2020, 09:19 AM

Excellent! I have the same desire to have all my data on a page and with my own analysis calculations.

Currently, I am importing historical data from different web sites, cut and paste the data into a spreadsheet for my calculations and graphing. Find that tedious. So an auto data gathering spreadsheet will be my dream.

I hope that you can help when I go back to work on this spreadsheet.

Thanks.

P/S Get the latest data or also historical data from your method?