I have a gsheet, where in the column A there are plenty of listed companies' (from different stock exchanges) tickers. In column B and C I need to have a data regarding Market Capitalization and Revenue for each company respectively. For Market Cap I've just used Googlefinance formula, but unfortunately due to its limitation I am unable to import the financial data.
I've tried "=IMPORTXML("https://www.google.com/finance/quote/TICKER","//table//tr[contains(@class,'roXhBd')]")" but unfortunately it returns only quaterly data, and I have no idea how to convert it to display annual values.
