Google Sheets (and I suppose Microsoft Excel) is the gift that keeps on giving.

I learned that you can webscrape in Sheets! Seriously, what can't Google Sheets do at this point.

I follow Bob from Tawcan.com for insight on dividend investments and came across his post about using google spreadsheets to track data from Google Finance or Yahoo Finance. I already know that you can use the built in `GOOGLEFINANCE` formula to do currency conversion or get stock info but I couldn't find a way to get dividend or yield data.

Bob uses `IMPORTXML` and `IMPORTHTML` to scrape data. I ended up going on a rabbit hole and tried using these formulas myself and as a result learned about XPath and XQuery.

References:
https://support.google.com/docs/answer/3093342?hl=en
https://www.tawcan.com/using-google-spreadsheet-dividend-investment/#Even_Newer_Formula1