buffer wrote:I'm using HYPTUSS update v11.72 with excel. I have opted to 'enable macros'.
I also tried the vanilla (BP only) option. It won't run on this either.
buffer
Sorry to hear that. I just tried and it's working fine for me.
What operating system and which version of Excel?
Let's concentrate on the freshly-downloaded BP-only version of 11.72.
When you click the "Get Yahoo Prices" button, what do you get for the price for BP in cell E6?
What do you get in cells A2 and B2 in the "FTSE-HYP Tracking" sheet?
The values for FY, Cover and PE should be unchanged at 6.6%, 1,3 and 11.8. These are only updated if you click on the "Get Sharecast Forecast Yields" button, and are independent of the price update
As a work-around, if we fill the price & FY fields by hand (eg from the stepone data) will the topup scoring/fields rearrange themselves appropriately?
I think they should do
My final potential 'work around' (which I am reluctant to do as I may not have the required life expectancy!) is to bring an old computer in from the garage which I put Ubuntu on and try to run the Unix version ('b-m')…
No need for that. You can run LibreOffice on your Windows PC, no need for Ubuntu. I suggest the Portable version from https://portableapps.com/apps/office/li ... e_portable which will run HYPTUSS version b-m quite happily.
Let me know how you get on
--kiloran