The Lemon Fool

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

kiloran wrote:

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

Apologies for the late response, I've had a few distractions lately.

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