Google sheets live tracker link for iShares Physical Silver (SSLN)?

maxsteam

Type_45 said:

maxsteam said:

Yup. Some people will hold it. The summary prospectus states

"The Issuer has an authorised share capital of €100,000. The Issuer has issued 40,000 ordinary shares, all of 

which are fully paid. All such issued ordinary shares are held by Wilmington Trust SP Services (Dublin) Limited 

on trust for charitable purposes."

If you have looked and not found, it would appear that this is not a "retail product".

I have no idea what you're trying to say.  Are you saying that SSLN is not a very good thing to have?  Why not?

It's probably just as good as any other silver fund. The words that I quoted from the prospectus suggest to me that the fund was created for a specific customer and it's not aimed at retail investors like you and me. You should read the prospectus (it's a long and dull read) and form your own opinion on this.

Just a word of warning about the gold/silver ratio. It's just another statistic. When it reaches the limits of previous trading ranges, it can either break out of those trading ranges or it can head back into those trading ranges. When I look at the chart, the ratio looks well within its recent trading range but, if you expect the ratio to fall, it could be due to the price of silver rising or it could be due to the price of gold falling. It concerns me that there's a lot of hype around at the moment suggesting that buying silver is a surefire way to make money. There's never a surefire way to make money. Following hype without understanding it is, in the long term, a surefire way to lose money. It's possible that silver will go up but then it's also possible that you will lose the profit on the next bit of hype that you follow.

wiseonesomeofthetime

Type_45 said:

Just wondering please if anyone has this.  I've searched high and low.

I was using this, but it doesn't update anymore:
=index(split(index(importhtml("https://www.morningstar.co.uk/uk/etf/snapshot/snapshot.aspx?id=0P0000SV4L","table",4), 2, 3), " "), 1, 2)

This works in my Google Sheets

=value(SUBSTITUTE(query(IMPORTXML("https://www.hl.co.uk/shares/shares-search-results/i/ishares-physical-metals-physical-silver-etc","//span[@class='bid price-divide']"),"select* limit 1",0),"p","",1))/100

Currently returning £15.73 - the Sell Price

As a footnote, by my calculation, had I put £20,000 ISA money in that on 06/04/2021, it would currently be worth £1,767 less. Ouch. Though investment is for long term, I know.

Type_45

wiseonesomeofthetime said:

Type_45 said:

Just wondering please if anyone has this.  I've searched high and low.

I was using this, but it doesn't update anymore:
=index(split(index(importhtml("https://www.morningstar.co.uk/uk/etf/snapshot/snapshot.aspx?id=0P0000SV4L","table",4), 2, 3), " "), 1, 2)

This works in my Google Sheets

=value(SUBSTITUTE(query(IMPORTXML("https://www.hl.co.uk/shares/shares-search-results/i/ishares-physical-metals-physical-silver-etc","//span[@class='bid price-divide']"),"select* limit 1",0),"p","",1))/100

Currently returning £15.73 - the Sell Price

As a footnote, by my calculation, had I put £20,000 ISA money in that on 06/04/2021, it would currently be worth £1,767 less. Ouch. Though investment is for long term, I know.

This link works!  Amazing - thank you

wiseonesomeofthetime

Glad to be of service