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

Type_45

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)

maxsteam

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".

Type_45

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?

[Deleted User]

I used the Excel stock function and it returned data for the ticker
I tried the googlefinance function (basically the same thing) but couldn't get it work for the ticker

Both aren't really live but have a 15 minute delay

EDIT - I just tried your function and it works fine for me in googlesheets (returns 1638, which is not 15 mins old - that's the start of day price), note Excel returned the same price

Type_45

Deleted_User said:

I used the Excel stock function and it returned data for the ticker
I tried the googlefinance function (basically the same thing) but couldn't get it work for the ticker

Both aren't really live but have a 15 minute delay

EDIT - I just tried your function and it works fine for me in googlesheets (returns 1638, which is not 15 mins old - that's the start of day price)

Yep, it's been saying 1638 for a long time.  The price is currently 1578.  It's stuck...

[Deleted User]

Type_45 said:

Deleted_User said:

I used the Excel stock function and it returned data for the ticker
I tried the googlefinance function (basically the same thing) but couldn't get it work for the ticker

Both aren't really live but have a 15 minute delay

EDIT - I just tried your function and it works fine for me in googlesheets (returns 1638, which is not 15 mins old - that's the start of day price)

Yep, it's been saying 1638 for a long time.  The price is currently 1578.  It's stuck...

I tried a different Excel function (I was using the history one) and it did return 1578

Type_45

Deleted_User said:

Type_45 said:

Deleted_User said:

I used the Excel stock function and it returned data for the ticker
I tried the googlefinance function (basically the same thing) but couldn't get it work for the ticker

Both aren't really live but have a 15 minute delay

EDIT - I just tried your function and it works fine for me in googlesheets (returns 1638, which is not 15 mins old - that's the start of day price)

Yep, it's been saying 1638 for a long time.  The price is currently 1578.  It's stuck...

I tried a different Excel function (I was using the history one) and it did return 1578

But it won't work with Google Sheets?

[Deleted User]

Type_45 said:

Deleted_User said:

Type_45 said:

Deleted_User said:

I used the Excel stock function and it returned data for the ticker
I tried the googlefinance function (basically the same thing) but couldn't get it work for the ticker

Both aren't really live but have a 15 minute delay

EDIT - I just tried your function and it works fine for me in googlesheets (returns 1638, which is not 15 mins old - that's the start of day price)

Yep, it's been saying 1638 for a long time.  The price is currently 1578.  It's stuck...

I tried a different Excel function (I was using the history one) and it did return 1578

But it won't work with Google Sheets?

Your function is picking up the closing price, from what I can see there is no live price to bring on that page you are importing only the closing price (assuming that is what the table is pointing at)
There is a googlefinance function which works well for US and some UK stocks etc, I would play around with that one

[Deleted User]

Try importing this page instead

https://www.morningstar.com/etfs/xlon/ssln/quote

Type_45

Deleted_User said:

Type_45 said:

Deleted_User said:

Type_45 said:

Deleted_User said:

I used the Excel stock function and it returned data for the ticker
I tried the googlefinance function (basically the same thing) but couldn't get it work for the ticker

Both aren't really live but have a 15 minute delay

EDIT - I just tried your function and it works fine for me in googlesheets (returns 1638, which is not 15 mins old - that's the start of day price)

Yep, it's been saying 1638 for a long time.  The price is currently 1578.  It's stuck...

I tried a different Excel function (I was using the history one) and it did return 1578

But it won't work with Google Sheets?

Your function is picking up the closing price, from what I can see their is no live price to bring in only the closing price (assuming that is what the table is pointing at)
Their is a googlefinance function which works well for US and some UK stocks etc, I would play around with that one

Yes, I think you've got it there - the page says:

This fund is not currently covered by a Morningstar analyst.

So I guess they don't have live prices.  Maybe only opening/closing prices.


So I think I need a brand new site/link in order to lightly track this ETC.

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. If this particular statistic heads back into its previous trading ranges, 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.