Problem with Morningstar scraper & Google sheets
348 views
Skip to first unread message
Mike S
Feb 16, 2023, 5:42:42 AM2/16/23
to Google Finance
I have been using a scraper to import Morningstar fund prices into Google sheets for a couple of years
e.g. =IMPORTXML(“http://www.morningstar.co.uk/uk/funds/snapshot/snapshot.aspx?id=F00000MC3M”, A2)
However, I have started getting #N/A results with the error messag such as: Error Could not fetch url: http://www.morningstar.c...shot.aspx?id=F00000MC3M
However, I have found that if I change ‘A2’ to ‘A3’ then back to ‘A2’ that the scraper starts working properly again. Could anyone please tell me if there is there is anything that I can do to permanently rectify this problem?
e.g. =IMPORTXML(“http://www.morningstar.co.uk/uk/funds/snapshot/snapshot.aspx?id=F00000MC3M”, A2)
However, I have started getting #N/A results with the error messag such as: Error Could not fetch url: http://www.morningstar.c...shot.aspx?id=F00000MC3M
However, I have found that if I change ‘A2’ to ‘A3’ then back to ‘A2’ that the scraper starts working properly again. Could anyone please tell me if there is there is anything that I can do to permanently rectify this problem?
Reply all
Reply to author
Forward
0 new messages