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!

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.

2

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.