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 - Ver 11.2 and a-z
A "Week Ahead" button has been added to the "High Yield Portfolio" sheet, linking to the Week Ahead web page in Investors Chronicle.
The button linking to the Software Repository has also been updated. - Ver 11.21 and a-z-1
Fixed a bug retrieving Week Ahead data - Ver 11.23 and b-a
Enhanced Week Ahead functionality to allow selection of week
Enhanced Forecast data (Yield. Cover and P/E) to report Latest data (in red) if Forecast data is not available - Ver 11.24 and b-b
Updated Watchlist to report Latest data (in red) if Forecast data is not available
Additional changes for b-b:
Fixed problem with Delete Shares dialogue caused by LibreOffice 5.2.3.3
Fixed 403:Forbidden problem with ADVFN dividends
Modified code to hopefully fix problems when used on a Mac - Ver 11.25 and b-c
Added Single Chart button to Watchlist
Modified the "View Dividends" buttons on the main sheet and Watchlist sheet to use the dividend source selected on the Parameters sheet (previously it was hard-coded to Dividend Data) - Ver b-c-1 08Apr17
Fixed a problem in BASIC fcst_yield and wl_fcst_yield with missing closing parenthesis, which caused problems using LibreOffice Portable 5.3.1.2 - Ver b-c-2 28Apr17
Modified the user agent due to problems with LibreOffice 5.5.0.3 - Ver b-c-2 01Jun17
Fixed problem with Yahoo price updates - Version 11.30 and b-d 20Jun17
Added Investorease as dividend source
Changed sector weighting chart to bar chart
Added cash capability
Added running yield, forecast dividends and portfolio list to tracking sheet
Replaced Yahoo charts with LiveCharts
Add User Guide - Version 11.31 and b-e 19Sep17
Fixed problem with Week-Ahead link
Added resizing capability to Sector Weighting chart
Added timestamp to Dividends sheet
LibreOffice version "Delete Share" function modified to delete the whole row instead of just the cells containing the portfolio. Now matches the Excel functionality - Version b-e-1 21Sep17
Fixed bug with "View Dividends" buttons on "High Yield Portfolio" and "Watchlist" sheets. - Version 11.4 and b-f 17Nov17
Fixed problem caused by change in Yahoo price download process
Added currency detection so prices for shares quoted in GBP (pounds) are now displayed in GBp (pence) - Version b-f-1 08Dec17
Modified the function of the Delete Share button on the High Yield Portfolio and Watchlist to match the functionality of the Excel version. Entire row is now deleted, previously it only deleted columns containing data - Version 11.52 and b-g 08Jan18
Digital Look changed their website to point to uk.webfg.com so HYPTUSS changed to handle this - Version 11.53 and b-h 13Feb18
Added MoneyAM charts as alternative to Livecharts, following change to Livecharts. - Version 11.54 and b-i 07May18
Added check that Yahoo has returned all prices - Version 11.65 and b-j 10Mar19
Added Overview and Snapshots sheets
Added Super-Sector functionality
Fixed bug when retrieving dividends from Dividend Data
Changed the Instructions button to User Guide
A number of macros in the LibreOffice version changed from Basic to Python - Version 11.68 08Apr19
Fixed problem with LiveCharts - Version 11.69 and b-k 25Jun19
Allowed renaming of "Equity Investment Instruments" as "IT xxxxx"
Added Parameter to allow user-selection of Latest or Forecast Yields - Version 11.70 and b-l 11Aug19
Replaced references to Digital Look by Sharecast
Improved control of Sector Weightings chart width
Fixed bug detecting Investment Trusts when using Super-sector
Renamed "Digital Look Data Sheet" to "Company Data Sheet"
Changed display of USD and EUR share prices to GBp - Version 11.71 16Aug19
Fixed problem with link to Corporate Investor Web Page - Version 11.72 and b-m 29Jan20
Removed Investorease dividend source
Added Sharecast and Stockopedia dividend sources
Added link to Investegate RNS
Added FT Funds sheet to get fund prices from Financial Times - Version 11.73 and b-n 04Oct20
Added ability to get Dividend Data via Google Cache
Converted all remaining Basic scripts to Python
Added user-defined benchmark capability to Tracking sheet
Fixed problems getting dividends from Stockopedia
Added currency to Column J of Dividends sheet
Removed currency formatting on Dividends sheet
Added Dividend Payment Amount and exchange rates to Dividends sheet - Version 11.75 and b-p 09Aug21
1...Yield data in Sharecast sometimes returns n/a. In this case, data is returned from the AIC website, such as https://tinyurl.com/2s9sw8ej
2...Some users have had problems importing an updated version of the Company Data Sheet. A macro now allows the import of the data
3...The functionality of the Company Data Sheet has been improved. If a user has customised values (perhaps a shorter name, or a different sector definition), these customised shares can be grouped at the top of the Company Data Sheet, with optional empty rows to separate them from the default data. The customised shares are not over-written when new data is imported. See pages 17/18 of the User Guide.
4... Charts from MoneyAM are no longer available and have been replaced by charts from Trustnet
5... Due to changes at LiveCharts, the LiveChart option no longer allows performance comparison with the FTSE-100 index. A pity, I liked this, but I cannot find a suitable alternative
6... The Snapshot and FTSE Tracking sheets can get quite long over time. Opening these sheets now automatically scrolls to the most recent data
7... The Week Ahead function no longer worked due to changes at Investors Chronicle. This has been fixed and simplified. - Version 11.77 and b-q 23Feb22
- Fixed problem with Overview "Generate Lemon Fool Table" on Excel. Problem caused by Windows bug
- Fixed dividend retrieval from Stockopedia following change to Stockopedia web page
- Added cell B11 to Parameters sheet to allow forcing of yields from AIC website for Investment Trusts
- Fixed problem with Sharecast sometimes having 3 dividend payments on a single payment date
- Version b-r 09Mar22
- Fixed problem with comma in forecast cover and P/E
- Version 11.78 16Mar22
- Fixed problem with error on some shares with no data in Sharecast
- Versions 11.79 and b-s
- Fixed problem with yields for some ITs caused by a change in the AIC website
- Versions 11.80 and b-t
- Fixed problem with dividends from Sharecast following change to Sharecast web page
- Changed "Get Sharecast Yields" button to "Get Yields"
- Fixed LibreOffice problem with "Get Dividends" from Stockopedia
- Versions 11.81 and b-u 15Nov22
- Removed ability to retrieve dividend data from Stockopedia following change to the Stockopedia website
- On the Excel version, fixed a minor autoscrolling bug when exiting the Tracking or Snapshot sheet
- Versions 11.85 and c-a 30Jul23
- Updated to get prices from SharePrices website and removed Yahoo option following termination of Yahoo Finance API
- Disabled LiveCharts option following change to website
- Versions 11.86 and c-b 10Sep23
- Implemented new functionality to get share prices from Yahoo
- Fixed bug with empty rows in Company Data Sheet
- Reinstated LiveCharts option