News for hackers. Stuff that matters.

A comment on When buying the dip doesn’t work: An analysis of the dot-com crash. Parent comment

Re:When buying the dip doesn’t work: An analysis of the dot-... by temp_praneshp on Sunday May 08, 2022 @12:31PM (#31305541)
gotcha, thanks for answering!
[ Parent | on HN ]
Re:When buying the dip doesn’t work: An analysis of the dot-... by maire on Sunday May 08, 2022 @12:56PM (#31305769)
If 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),...)

where $J$2 is ="select Col6 where Col1 > date '"&TEXT(I2,"yyyy-mm-dd")&"' LIMIT 12"

[ Parent | on HN ]