1

Where/How can I pull the following data on the DJIA stocks into Excel from the Web that updates every time I hit refresh in Excel?

The data: 1. Last 12 months of dividend payments 2. Prices 3. DJIA divisor

I'm creating a spreadsheet that will constantly calculate the dividend yield of the DJIA. I know where I can find this number (yahoo!finance), but I need to calculate it for myself.

Thank you!

2

The current Dow divisor is in Historical Divisor Changes.

The OpenOffice GetQuote function offers fields for current dividend either in dollars or yield.

| improve this answer | |

Not the answer you're looking for? Browse other questions tagged or ask your own question.