Where do you get your data feeds from?

Investing / Portfolios
53

The f£"($&^. They removed the feature in 2018 and deleted my portfolios and history. Now I see they re-introduced it in 2020:

On September 22, 2017, Google confirmed that the website was under renovation and that portfolio features would not be available after mid-November 2017.[4][5]

In early 2018, a notice on the website announced that the website had been renovated. The notice said that the portfolio feature was to be removed, and advised that stocks from the old portfolio feature would be migrated to the new website, and also giving the option for users to download the portfolio as a CSV file.[6]

A Google Finance mobile app was removed from the Google Play Store in 2015.[7]

Google Finance was relaunched in 2020[8] with tools to help users get started investing.[9]

It seems they haven’t implemented an import function so not keen to try them again.

If I figure a reliable way to pull data, then I will just use my own system and not be bothered by changes to the YF platform any more.

1 Like
54

Come on!

Zombies are people, too, and this one comes from a high profile graveyard: Google Graveyard - Killed by Google

55

Hello! I’m trying to import the current price of the SMMCHA.SW Swiss ETF, but without success. I tried with

=IMPORTHTML(“https://www.morningstar.ch/ch/etf/snapshot/snapshot.aspx?id=0P0000NR8O","table”,4)

What do you suggest?

56

=IMPORTHTML(“https://www.finanzen.ch/etf/ubs-etf-ch-smim-a-ch0111762537","table”,2)

Then use =SPLIT(xyz,“.”) etc. to get the format you need.

57

Thank you for the quick reply. However, I do not get the correct price. I would like to get 247.25, but I get 246.25 which is the one below. What is the meaning of 2 in the formula?

58

I rechecked. Try this:

=IMPORTHTML(“https://www.finanzen.ch/etf/ubs-etf-ch-smim-a-ch0111762537","table”,8)

The number 2, 8 etc. is just targeting the right table from the webpage.

59

Thank you very much !

60

You can use this formula for every webpage that you want to import something. Just try out different numbers in the last attribute till you get what you want. If it’s not in the right format, you can use SPLIT to get it right.

1 Like
61

you could also use
=GOOGLEFINANCE(“indexswx:smim”) x todays ETF closing price / today’s index value at closing
for example
=GOOGLEFINANCE(“indexswx:smim”) x 255 / 2509

I use this method for my SMICHA for years.