google-sheetsweb-scrapinggoogle-sheets-formulayahoo-finance
IMPORTXML Yahoo Finance not working anymore
Until a few days ago this importxml was importing the current price from yahoo finance however it's now stopped working and I can't figure out why. Is anyone able to suggest a fix? Thanks a lot.
=INDEX(IMPORTXML("https://finance.yahoo.com/quote/SGLN.L","//*[@id='quote-header-info']/div[3]/div[1]/div/span[1]"),1)
Solution
It seems that Yahoo changed some things in their website and it resulted to the import formula not to work anymore for some of the webpage in Yahoo Finance as well as for some tickers. This is the result of the IMPORTXML command for the SGLN.L ticker and for the AAPL ticker which is still working.
For now, I suggest finding another website/data source that will give you the same information that you need for those unavailable/unscrapeable tickers. Another option would be to wait for yahoo to fix this issue.
- Function onEdit(e) works only for single cell edit
- Cancel Script is a cell is RED
- Can we hide column in sheet using google apps script?
- JavaScript function in Google spreadsheets to send QR codes to emails
- Google Sheet Concatenate + Filter
- Google Sheets QUERY is returning with a no column found errors
- Get eventID for Google Calendar Event
- How can I find the number of concordant/discordant pairs for a given cell in Google Sheets?
- COUNTIF Statements: Range Across All Sheets + Cell Reference as Criterion
- Writing a googlefinance wrapper
- Getting a macro to run using checkbox in google sheets
- Auto expanding formula in google sheets to the length of a dynamic range
- Issue in Auto close Modal Dialog - Google App-Script
- CSV extracted automatically into a sheet. Need help for filtering
- How can I sum top 5 values from column in Google Sheets
- Remove duplicates based on one column and keep latest entry in Google sheets (while ignoring blank entries in that column)
- Find the list of different values in 2 tables by id key
- VAT Checker Apps Script
- Script to lock a different tab sheet everyday
- Trigger python code from Google spreadsheets?
- Function to convert Google Sheet Table into one row
- Google Sheet Script 2 on edit function #NUM! error
- Google Sheet SUMIF returning an error! statement
- Same code behaving differently inside and outside function
- How to use VLOOKUP() + QUERY() + IMPORTRANGE() with multiple conditions?
- How to find value vertically and horizontally, using formula in Sheets?
- Return SUM of all cells that fit TWO CRITERIA related by POSITION
- Sum column until first empty cell
- Extract Data from Multiple Sheets with Similar Names
- How many time based trigger can your add-on run on a document / user?