Price data for pension ETFs

Investing / Others
1

I have a Google Sheet that “scrapes” public data via =IMPORTHTML to keep my net worth spreadsheet up to date, however the data sources recently are quite unreliable (cash.ch/finanzen.ch). Does anybody know a way to get reliable data for these that I could use in a Google Sheet online (Google sheet can not authenticate).

My list contains, among others

CH0042114261
CH0238494055
CH0275372958
CH0047710022
CH0273755501
CH0106027128
CH0252809709
CH0015036608

2

Yahoo Finance? Tried the first one, works:
https://finance.yahoo.com/quote/0P0000J335.SW/

Apple Numbers gets stocks data from there. Works for pension funds in my spreadsheets (not with the ISIN, but with the ticker, e.g. 0P0000J335.SW).

3

Thanks, didnt consider the ticker! Do you happen to have the scraping parser handy for Google Sheets?

4

Financial times. Do you need daily price?

5

You have to readjust the formula if they change the UI but you could use something similar to

=SUBSTITUTE(SUBSTITUTE(importxml(“https://markets.ft-.com/data/funds/tearsheet/summary?s=”&F89&“:”&R89;“//ul[contains(@class,‘mod-tearsheet-overview__quote__bar’)]/li[1]/span[contains(@class,‘mod-ui-data-list__value’)]”);“,”;“”);“.”;“,”)

If the formula is not working for your ticket you can explore the page in dev mode with F12 on Chrome.

NB: remove the - after FT otherwise the forum transform it

1 Like
6

Does not have everything I need. For example I am struggling with CH0015036608.

But thanks!

7

What do you mean? I only know how to do it with Apple Numbers, where it would be:

STOCK("0P0000J335.SW")
8

Sorry my point is that I have a data source problem, not only a parsing problem.