4 ms·
gotcha, thanks for answering!
by temp_praneshp 4y ago
gotcha, thanks for answering!
- maire 4y agoIf you are using google sheets you can use ycharts to pull in the dividend data. Here is my calculation to get 1 year of dividends. =query(importhtml(concatenate("https://ycharts.com/companies/",$A4,"/dividend"),"table",0),$J$2 https://ycharts.com/companies/",$A4,"/dividend"),"table",0),...) where $J$2 is ="select Col6 where Col1 > date '"&TEXT(I2,"yyyy-mm-dd")&"' LIMIT 12"