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!

closed as off-topic by Ganesh Sittampalam Dec 27 '18 at 11:52

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions seeking product or service recommendations are off-topic because they tend to become obsolete quickly. Instead, describe your situation and the specific problem you're trying to solve." – Ganesh Sittampalam
If this question can be reworded to fit the rules in the help center, please edit the question.


The current Dow divisor is in Historical Divisor Changes.

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

  • Excellent. Do you have the link to the cme page that goes to that pdf? I want it to make sure it's the most recent version. Thank you in advance! – FinanceMajor Jun 22 '13 at 1:24
  • wsj.com/mdc/public/page/2_3022-djiahourly.html real time divisor – JoeTaxpayer Jun 22 '13 at 2:46
  • Sweet, that last link you gave me was what I found too. It's much easier than the cme site or the djia site. – FinanceMajor Jun 24 '13 at 17:07

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