Updated LibreOffice HYPTUSS version b-x

[kiloran]

A couple of bugs have been identified and fixed with this new version:

1. Retrieving prices for a share in EUR currency failed
2. Retrieving IT dividend yields from the AIC website failed

Hopefully that's the last of the bugs.

The new version is available at https://lemonfoolfinancialsoftware.weeb ... op-up.html

Excel version 11.83 is unaffected

--kiloran

[gigha]

Hi Kiloran,

Thanks for all the work you do on this spreadsheet. It is very much appreciated.
I've just run the new HYPTUSS spreadsheet for LibreOffice and ive got a couple of issues which are throwing everything out:
* Sainsburys (SBRY) is showing n/a for yield, cover and p/e
* BHP Group ( BHP) Is returning a weird yield value. It says 1053.1%
Is there a fix?

[Itsallaguess]

I've just run the new HYPTUSS spreadsheet for LibreOffice and ive got a couple of issues which are throwing everything out:

* Sainsburys (SBRY) is showing n/a for yield, cover and p/e

* BHP Group ( BHP) Is returning a weird yield value. It says 1053.1%

Is there a fix?

The first port of call for any issue like this related to individual yields, cover, or P/E should be the relevant Sharecast page for the investment to check on underlying data...

BHP Group (BHP) - https://www.sharecast.com/equity/BHP_Group_Limited_NPV_DI

Sainsbury - (SBRY) - https://www.sharecast.com/equity/Sainsbury_J

Checking the above pages, you'll see that the underlying data is the issue in these two cases, and whilst those issues are ongoing, an alternative data-source should be used if you're looking to maintain valid entries for the missing or erroneous fields.

Do note that the tool makes it easy to carry out these manual checks, and by selecting any related EPIC field in your income-portfolio and then clicking the 'Open Sharecast Web Page' button, the related Sharecast page for that selected EPIC should then open in your default browser...

For yields, I find that the relevant Yahoo Finance page for most UK shares gives an accurate current-yield figure that can be manually entered into the tool when these types of issues are being experienced with a particular holding -

BHP Group (BHP) - https://finance.yahoo.com/quote/BHP/



Sainsbury - (SBRY) - https://uk.finance.yahoo.com/quote/SBRY.L/



Note that the Yahoo yields are the figures in brackets above, so currently 9.40% for BHP and 4.70% for Sainsbury.

Please also note that the above checks and workarounds for these types of data-related issues are suitable for both the LibreOffice version and the Excel version.

Cheers,

Itsallaguess

[gigha]

Thank you so much for your patient and detailed reply. As you will no doubt have guessed, I don't know my way around spreadsheets, apart from pressing buttons to update them, so I really appreciate your guidance. I can see what I need to do now.