Importing Fund Price into Google Sheets

rothers

Hi,

I have a spreadsheet on google sheets which imports different fund prices in, it has worked fine until recently. Unfortunately I now get a #REF error which tells me to use the desktop version of the ft site where I am pulling the prices from. I am on an Acer Chromebook and seem unable to rectify it.

Has anyone else had this issue and been able to resolve it?

Many Thanks

NoMore

I use mufunds, µFunds: Google Sheets add-on for mutual funds and stocks (mufunds.com) you could try that ?

sausage_time

rothers said:

Hi,

I have a spreadsheet on google sheets which imports different fund prices in, it has worked fine until recently. Unfortunately I now get a #REF error which tells me to use the desktop version of the ft site where I am pulling the prices from. I am on an Acer Chromebook and seem unable to rectify it.

Has anyone else had this issue and been able to resolve it?

Many Thanks

Can you post an example of the equation you used previously?

cloud_dog

rothers said:

Hi,

I have a spreadsheet on google sheets which imports different fund prices in, it has worked fine until recently. Unfortunately I now get a #REF error which tells me to use the desktop version of the ft site where I am pulling the prices from. I am on an Acer Chromebook and seem unable to rectify it.

Has anyone else had this issue and been able to resolve it?

Many Thanks

I use MorningStar, but I only tend to use it for the current price:

=(index(split(index(importhtml("https://www.morningstar.co.uk/uk/etf/snapshot/snapshot.aspx?id="&O11,"table",4), 2, 3), " "), 1, 2))/100

With O11 being the fund identifier.

rothers

sausage_time said:

rothers said:

Hi,

I have a spreadsheet on google sheets which imports different fund prices in, it has worked fine until recently. Unfortunately I now get a #REF error which tells me to use the desktop version of the ft site where I am pulling the prices from. I am on an Acer Chromebook and seem unable to rectify it.

Has anyone else had this issue and been able to resolve it?

Many Thanks

Can you post an example of the equation you used previously?

I used this previously

=importxml("https://markets.ft.com/data/funds/tearsheet/summary?s=GB00B4PQW151:GBP","/html/body/div[3]/div[2]/section[1]/div/div/div[1]/div[2]/ul/li[1]/span[2]") 

Thanks for the other replies too, I'll try them.

rothers

cloud_dog said:

rothers said:

Hi,

I have a spreadsheet on google sheets which imports different fund prices in, it has worked fine until recently. Unfortunately I now get a #REF error which tells me to use the desktop version of the ft site where I am pulling the prices from. I am on an Acer Chromebook and seem unable to rectify it.

Has anyone else had this issue and been able to resolve it?

Many Thanks

I use MorningStar, but I only tend to use it for the current price:

=(index(split(index(importhtml("https://www.morningstar.co.uk/uk/etf/snapshot/snapshot.aspx?id="&O11,"table",4), 2, 3), " "), 1, 2))/100

With O11 being the fund identifier.

That comes up with the same error unfortunately

sausage_time

Ah - some progress here.   The "Desktop version" referred to is the desktop version of Google Sheets.  If you open the Sheet there (in a browser) it asks for permission to access external data.  One granted, it works on the mobile app (which is I assume what you are using on the Chromebook).  Let us know!

rothers

sausage_time said:

Ah - some progress here.   The "Desktop version" referred to is the desktop version of Google Sheets.  If you open the Sheet there (in a browser) it asks for permission to access external data.  One granted, it works on the mobile app (which is I assume what you are using on the Chromebook).  Let us know!

OMG!! You are an absolute legend!!  This has done my head in for a couple of days, I was trying to get the desktop version of the web page (it already was the desktop version!).

Thank you!!

sausage_time

I have been called many things, but that's new.  

Glad you are sorted.

cloud_dog

rothers said:

cloud_dog said:

rothers said:

Hi,

I have a spreadsheet on google sheets which imports different fund prices in, it has worked fine until recently. Unfortunately I now get a #REF error which tells me to use the desktop version of the ft site where I am pulling the prices from. I am on an Acer Chromebook and seem unable to rectify it.

Has anyone else had this issue and been able to resolve it?

Many Thanks

I use MorningStar, but I only tend to use it for the current price:

=(index(split(index(importhtml("https://www.morningstar.co.uk/uk/etf/snapshot/snapshot.aspx?id="&O11,"table",4), 2, 3), " "), 1, 2))/100

With O11 being the fund identifier.

That comes up with the same error unfortunately

It is currently showing prices for me.

shortseller09

NoMore said:

I use mufunds, µFunds: Google Sheets add-on for mutual funds and stocks (mufunds.com) you could try that ?

Very unreliable, often returns 'error', I have to change the country code from uk to gb every couple of days, and then back again when the error pops up again.