Currently, I am using xPath to grab Ex-Div date, Dividends, etc but I cannot seem to be able to grab the Fair Value "Undervalue" rating from Yahoo Finance.
I want the "Undervalue" to be specific but the CELL simply keeps "Loading..."
I have a Chrome extension for xPath which retrieves me this
"//*[@id="quote-summary"]/div[3]/div[1]/div[2]/div[2]"
but nothing seems to work.
Please check this spreadsheet, I have recreated the way my sheet functions normally.
https://docs.google.com/spreadsheets/d/1Ji5swdt_NxXEp1jYYJtF6uQ7nMW7M0mmW9XeNumiCZM/edit?usp=sharing