HYP Top-up Version History
Note: To reduce confusion, the Excel version is numeric (eg: Ver 10.8) and the OpenOffice version is alphabetic (eg: Ver a-n)
- Initial Excel Release Sep 2010
See: http://boards.fool.co.uk/top-up-spreadsheet-auto-prices-and-yields-12035798.aspx
and http://boards.fool.co.uk/new-hyp-top-up-spreadsheet-12035791.aspx?sort=whole#12035791 - Ver 8.0 10Jan11
Added Watchlist and Notes facility
See: http://boards.fool.co.uk/hyp-top-up-spreadsheet-version-8-12136712.aspx - Ver 9.0 26Apr11
Allows downloads of Yields for Investment Trusts
See: http://boards.fool.co.uk/hyp-top-up-spreadsheet-version-9-12244367.aspx - Ver 10.0 28Jan12
Added FTSE All-share to tracking sheet
Enhanced dividend data
Added 1-month charrt
See: http://boards.fool.co.uk/hyp-top-up-spreadsheet-v10-12466404.aspx - Ver a-a 22Feb12
Initial release of OpenOffice version
See: http://boards.fool.co.uk/openoffice-version-of-hyp-top-up-spreadsheet-12488524.aspx - Ver a-c 04Mar12
Added Watchlist and Notes
See: http://boards.fool.co.uk/update-openoffice-hyp-top-up-ver-a-c-12498345.aspx - Ver a-f 17Mar12
Added charts and Sector Weighting
Functionality now the same as the Excel version
See: http://boards.fool.co.uk/openoffice-hyp-top-up-spreadsheet-ver-a-f-12509145.aspx - Ver a-g 31Jul12
Added delay when querying Dividend Investor
See: http://boards.fool.co.uk/openoffice-hyp-top-up-spreadsheet-version-a-g-12610430.aspx - Ver 10.3 23Jan13
Bug fix due to changes in Dividend Investor
See: http://boards.fool.co.uk/hyp-top-up-excel-version-update-12731482.aspx - Ver a-h 23Jan13
Update to match Ver 10.3
Added code to handle future unannounced dividends on Dividend Investor
See: http://boards.fool.co.uk/update-openoffice-hyp-top-up-12731433.aspx - Ver 10.4 28Jan13
Fixed issue with Investment Trust yields on Digital Look
See: http://boards.fool.co.uk/weve-implemented-a-fix-to-both-the-excel-and-12735289.aspx - Ver a-i 28Jan13
Update to match V10.4
See: http://boards.fool.co.uk/hopefully-kiloran-will-be-along-shortly-with-the-12735302.aspx - Ver 10.5 01Feb13
Bug fix to yields for Investment Trusts on Watchlist - ver 10.6 12Feb13
Fix for zero dividends in Dividend Investor
See: http://boards.fool.co.uk/hi-ive-updated-the-hyp-top-up-spreadsheet-to-12746623.aspx - Ver a-k 12Feb13
Fixed zero dividends issue.
See: http://boards.fool.co.uk/update-to-hyp-top-up-openoffice-12746714.aspx - Ver a-l 22Mar13
Fixed an issue with OpenOffice 3.4.1
See: http://boards.fool.co.uk/new-version-a-l-for-openoffice-hyp-top-up-12772646.aspx - Ver 10.7 23Jun13
Update to fix issue with future but unannounced dividends in Dividend Investor
Update to fix currency issue with dividends
See: http://boards.fool.co.uk/hyp-top-up-spreadsheet-v107-12835079.aspx - Ver a-m 23Jun13
Update to match Ver 10.7 - Ver 10.71 06Sep13
Minor update to fix issue with share price less than 1p
See: http://boards.fool.co.uk/minor-update-to-hyp-top-up-to-v1071-12878905.aspx - Ver a-n 07Sep13
Changed coding for all web scrapes from OpenOffice Basic to Python, resulting in a massive improvement in speed
See: http://boards.fool.co.uk/openoffice-hyp-top-up-new-version-a-n-12879233.aspx - Ver 10.8 19Sep13
Added facility to display web browser page showing Yahoo charts for all stocks - Ver a-o 19Sep13
Added Yahoo charts for all stocks, to match Ver 10.8 - Ver 10.81dev-a 15Apr14
This is a test version which has the same functionality as v10.8 but hopefully works with 64-bit versions of Excel (yet to be confirmed) - Ver a-o-1 01May14
Same functionality as Ver a-o but fixed a bug with message boxes caused by the release of LibreOffice 4.2.3.3 - Ver 10.9 14Jun14
Added Forecast Dividend Cover
Added Forecast Price-Earnings
Added Expected Dividends and Yield
Added code to allow operation with 64-bit Excel - Ver a-p 14Jun14
Added Forecast Dividend Cover
Added Forecast Price-Earnings
Added Expected Dividends and Yield - Ver 10.91 15Jun14
Fixed a problem with shares having no "Company Financials" section to provide Forecasts from Digital Look - Ver 10.92 and a-q 30Sep14
Fixed problems with dividends from Dividend Investor web page. The web page format had changed. - Ver a-r 08Nov14
Fixed problems retrieving Forecast Yields for LLPD - Ver 10.93 and a-s 08Dec14
Digital Look changed the format of the website so Forecast Yields could not be retrieved. Fixes put in place which include the replacement of the CSI code with the URL Suffix - Ver 10.94 and a-t 17Dec14
Modification of the URL Suffix to allow a greater range of shares and other securities. The URL Suffix now includes all of the URL after www.digitallook.com - Ver 10.942 13Feb15
Minor change. Some users have seen an "insufficient resources" message in Excel. This can be caused by different zoom levels on each of the sheets. Version 10.942 sets the zoom to 100% for all sheets - Ver a-t-1 19Mar15
Minor update to Digital Look Data Sheet - Ver 10.951 and a-u-1 15Aug15
Corrected problem due to ADVFN change of dollar currency symbol from USD to USX, which affected the data in the Dividends sheet - Ver a-v 22Aug15
Removed a link to Digital Look which caused problems for some users. The link was a remnant from the days when it used Basic, and is not required for the current Python-based versions. - Ver 11.00 and a-w 17Aug16
Added a button on the Dividends sheet to link to the Corporate Investors' Web Page to display dividend information.
LibreOffice/OpenOffice version also fixed the updating of the status bar as data is retrieved for each company - Ver 11.1 and a-x 07Oct16
Removed Dividend Investor as a source of dividends and replaced by Dividend Data (Upcoming Dividends) - Ver 11.11 08Oct16
Minor change to autofit row height when adding a new share to ensure that long sector names display correctly - Ver 11.12 16Oct16
"View Dividends" caused problems for some users due to mixed-case URL, so code has been modified to hopefully overcome this - Ver a-y 24Oct16
Resolved a problem retrieving dividends from Dividend Data website