Thoughts, tips and rants from a professional programmer
Thanks for posting this! I’ve tried out the URL but I only get 52 of the FTSE 100 constituents – do you think this is a Yahoo limitation, and if so do you know of a workaround?
Paul, Did you manage to resolve this issue?
No joy with Yahoo for constituents I’m afraid. My new approach is to screen scrape http://www.lse.co.uk – a site called ‘London South East’ – check out the URL http://www.lse.co.uk/index-constituents.asp?index=idx:ukx&indexname=ftse_100
I then use a combination of html2text, grep and sed to get a list of symbols. I suspect that excessive screen scraping will result in them blocking us so go easy!
I’ve found again that single sources of free data are prone to errors and incomplete fields so my approach is to build a system which scrapes as many feeds as possible then stitches them together to make a master record – if (when) a single feed breaks it hopefully means I won’t lose too much data.
Hope that helps, let me know how you get on.
A few late, but I found an excel spreadsheet on this site with the constituents of the FTSE 100, together with live financial data: http://investexcel.net/ftse-100-companies-live-data-in-a-spreadsheet/
Fill in your details below or click an icon to log in:
You are commenting using your WordPress.com account. ( Log Out / Change )
You are commenting using your Twitter account. ( Log Out / Change )
You are commenting using your Facebook account. ( Log Out / Change )
You are commenting using your Google+ account. ( Log Out / Change )
Connecting to %s
Notify me of new comments via email.