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!


The current Dow divisor is in Historical Divisor Changes.

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


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