Good FTSE spreadsheet generator ? Dividend Yields ?

MoneyTown

I'm after a way of creating spreadsheets for equity markets - specifically for the FTSE100, FTSE250 and FTSE all share.

The moneyextra site http://www.moneyextra.com/stocks/ftse100/ creates a spreadsheet in CSV format that works well, though it doesn't appear to include all data.

Specifically I would like to list Dividend Yield for all companies.

Anyone know how to do it?

thanks.

MoneyTown

anyone any ideas?

Mr_Mumble

The Fool is the place for you, I'm not sure which board you'd currently ask this query on, it used to be "mechanical trading - tools" but it has been archived now and doesn't seem to get any traffic. Take a look at this particular post:
http://boards.fool.co.uk/Message.asp?mid=7602132

Unfortunately the dividend yield is usually not shown in yahoo's data and some of those that do show up are wrong! You could set up a spreadsheet yourself to divide the share price by the dividend per share to get a reasonable current yield estimate using the yahoo data though.

EdInvestor

http://www.fundies.info/

This one can be set to update itself.