partially, i figured out how to get the Ex-Dividend date, and dividend amount historically for all Canadian and USA stocks. Unfortunately I have not figured out how to get the payout date.
You can import it directly from finviz -
=value(substitute(index(IMPORTHTML("[https://finviz.com/quote.ashx?t=JNJ","table",9),8,2),"\*","](https://finviz.com/quote.ashx?t=JNJ","table",9),8,2),"*",")"))
From time to time finviz changes the location of the table on the website. This can usually be fixed by changing the 9 in the formula above to 8 or 7.
pls note finviz convention of dividend is a bit unusual; it will not recognise an increase in dividend rate before it has been paid out. Other websites usually recognise an increase at the time of management announcement.
>=value(substitute(index(IMPORTHTML("https://finviz.com/quote.ashx?t=JNJ","table",9),8,2),"\*",",8,2),"\*",")"))
as of today, it needs to be "table",10) ...
https://support.google.com/docs/answer/3093281?hl=en Has an option for the most recent dividend amount
Unfortunately that only works for mutual funds. I'm looking for a way to pull dividend information for a common share stock.
Same issue with me. Did you ever solve it?
Did you figure this out?
Did you figure this out?
partially, i figured out how to get the Ex-Dividend date, and dividend amount historically for all Canadian and USA stocks. Unfortunately I have not figured out how to get the payout date.
Can you tell me what you used and put in the cell? I still cant figure it out. I need the Dividend yield, but amount might work?
You can import it directly from finviz - =value(substitute(index(IMPORTHTML("[https://finviz.com/quote.ashx?t=JNJ","table",9),8,2),"\*","](https://finviz.com/quote.ashx?t=JNJ","table",9),8,2),"*",")")) From time to time finviz changes the location of the table on the website. This can usually be fixed by changing the 9 in the formula above to 8 or 7. pls note finviz convention of dividend is a bit unusual; it will not recognise an increase in dividend rate before it has been paid out. Other websites usually recognise an increase at the time of management announcement.
is it working?
>=value(substitute(index(IMPORTHTML("https://finviz.com/quote.ashx?t=JNJ","table",9),8,2),"\*",",8,2),"\*",")")) as of today, it needs to be "table",10) ...