We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide

Good FTSE spreadsheet generator ? Dividend Yields ?

MoneyTown
MoneyTown Posts: 99 Forumite
in Savings & investments
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.

Comments

  • MoneyTown
    MoneyTown Posts: 99 Forumite
    anyone any ideas?
  • Mr_Mumble
    Mr_Mumble Posts: 1,758 Forumite
    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.
    "The state is the great fiction by which everybody seeks to live at the expense of everybody else." -- Frederic Bastiat, 1848.
  • EdInvestor
    EdInvestor Posts: 15,749 Forumite
    http://www.fundies.info/

    This one can be set to update itself.
    Trying to keep it simple...;)
This discussion has been closed.
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 353.5K Banking & Borrowing
  • 254.2K Reduce Debt & Boost Income
  • 455.1K Spending & Discounts
  • 246.6K Work, Benefits & Business
  • 603K Mortgages, Homes & Bills
  • 178.1K Life & Family
  • 260.6K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16K Discuss & Feedback
  • 37.7K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.
Update Your Picture