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.