Tested, and all working fine.
Thank you Kiloran
tuk020
New HYPTUSS versions 11.77 and b-q
-
- Lemon Quarter
- Posts: 1915
- Joined: November 5th, 2016, 7:41 am
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: New HYPTUSS versions 11.77 and b-q
Apologies for the late response, I've had a few distractions lately.daveh wrote:Thanks for the help. Changed the first column in the Company data sheet for EMDV as suggested and the yield scrape no longer stops there and I get a blue box with ???? as with the other ETFs. I added AV.B to the company data sheets as AV-B and that works for the prices, but now the yield scrape fails there with a Runtime error '424' Object required error message. I'll have a play with what I put in the first column for AV.B as I think that is probably where the problem is. But as AV.B is now last and it collects all the prices and all the yields (or ??? for ETFs) for everything else I can just add in the AV.B yield by hand as its easy to calculate being a pref. with a known coupon.
Thanks
I've put in a trap for the error and HYPTUSS now continues if it finds an error. HYPTUSS version 11.78 is available at http://lemonfoolfinancialsoftware.weebl ... op-up.html
For other HYPTUSS users.... if you don't suffer from this problem (it's only on a few extreme, non-HYP shares), there's no need to upgrade to 11.78
--kiloran
-
- Lemon Quarter
- Posts: 1753
- Joined: November 4th, 2016, 11:06 am
Re: New HYPTUSS versions 11.77 and b-q
That's great thanks.kiloran wrote:Apologies for the late response, I've had a few distractions lately.daveh wrote:Thanks for the help. Changed the first column in the Company data sheet for EMDV as suggested and the yield scrape no longer stops there and I get a blue box with ???? as with the other ETFs. I added AV.B to the company data sheets as AV-B and that works for the prices, but now the yield scrape fails there with a Runtime error '424' Object required error message. I'll have a play with what I put in the first column for AV.B as I think that is probably where the problem is. But as AV.B is now last and it collects all the prices and all the yields (or ??? for ETFs) for everything else I can just add in the AV.B yield by hand as its easy to calculate being a pref. with a known coupon.
Thanks
I've put in a trap for the error and HYPTUSS now continues if it finds an error. HYPTUSS version 11.78 is available at http://lemonfoolfinancialsoftware.weebl ... op-up.html
For other HYPTUSS users.... if you don't suffer from this problem (it's only on a few extreme, non-HYP shares), there's no need to upgrade to 11.78
--kiloran