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

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

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

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)

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