Many years ago, Stepone created an Excel spreadsheet which appears to have been extremely popular. It showed historical and forecast dividends and EPS, Market Cap and various other bits of interesting data for FTSE350 companies. Stepone provided updated versions of the spreadsheet from time to time, but due to increasing pressures on his personal time, updates become less frequent, with the most recent being just over a year ago.With Stepone's approval, I have created a replacement spreadsheet. It was designed to be as identical as possible to Stepone's original, though there may be some differences in some columns. It uses Excel, though I plan to have a look at creating an equivalent using OpenOffice. The methodology will be similar to that of Stepone's.... I will publish updates (my plan is around the start of each calendar month), and the user can refresh latest price from Yahoo at any time. Since I am now retired, I should have rather more time available than Stepone, so updates should be reasonably assured for a few years, unless I get run over by a bus or father time taps me on the shoulder.The process uses Perl scripts to gather data before I load the data into Excel. If anyone is interested, I have also published the perl scripts.The intent of the spreadsheet is to provide a tool to allow filtering of data to identify candidates to add to an investment portfolio (especially a HYP). Having identified a potential investment, data should be checked from a reliable source such as the company's own web site. Having added a company to a portfolio, an excellent tool to monitor the portfolio is that created by Itsallaguess: http://boards.fool.co.uk/hyp-top-up-spreadsheet-version-9-12...The usual caveats apply:*...No guarantees of data accuracy*...No guarantees of data updates*...No guarantees of being able to fix any problems which are reported (though I'll do my best)*...Compatibility. I used Excel 2010, but save the document in Excel 97-2003 .xls format which should be OK for most peopleThe spreadsheet, a User Guide, and the perl scripts are available at:https://docs.google.com/leaf?id=0B6W23CpwsvtNMTJmZjNkOGItNWM...PLEASE.... read the User Guide before firing off any questions.Plaudits are due to Stepone for his vision in creating the original spreadsheet, and to Itsallaguess for giving my new spreadsheet the once over and creating the excel macro which can retrieve prices for 350 companies from Yahoo in the blink of an eye (well, about 5 seconds)--Kiloran
© Copyright 1998-2013, The Motley Fool Limited. All rights reserved. This material is for personal use only.The Motley Fool, Fool, and the "Fool" logo are registered trademarks of The Motley Fool, Inc.Place of Reg: England & Wales. Company Reg No: 3736872. VAT Reg No: 945 6990 68. Registered Office: 5th Floor, 60 Charlotte Street London W1T 2NU.
Page load time and server: