New HYPTUSS versions 11.52 and b-g
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
New HYPTUSS versions 11.52 and b-g
Following the changes to the DigitalLook website, Itsallaguess and I have updated the HYP Top-Up SpreadSheet. http://lemonfoolfinancialsoftware.weebl ... op-up.html
Many companies have seen a change to the URL suffix in Column A of the Digital Look Data Sheet, but things now seem to be relatively stable.
Other than the change to use the replacement DigitalLook website, there are no other changes or bug fixes.
--kiloran
Many companies have seen a change to the URL suffix in Column A of the Digital Look Data Sheet, but things now seem to be relatively stable.
Other than the change to use the replacement DigitalLook website, there are no other changes or bug fixes.
--kiloran
-
- Lemon Slice
- Posts: 755
- Joined: November 4th, 2016, 4:27 pm
Re: New HYPTUSS versions 11.52 and b-g
Just getting question marks on yield retrieval. No errors.
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: New HYPTUSS versions 11.52 and b-g
Excel or LibreOffice, Neil?NeilW wrote:Just getting question marks on yield retrieval. No errors.
What happens if you download the new version and just update yield for the existing BP? Does that work?
If that does work, which shares are you having problems with?
--kiloran
-
- Lemon Half
- Posts: 7482
- Joined: January 7th, 2017, 9:56 am
Re: New HYPTUSS versions 11.52 and b-g
Many Thanks, All working fine in "Home & Student Edition 2010 " Excel [32-Bit] under Windows 10.
-
- Lemon Slice
- Posts: 755
- Joined: November 4th, 2016, 4:27 pm
Re: New HYPTUSS versions 11.52 and b-g
Usual - LibreOffice on a Mac. 5.3.7.2
All the shares have the problem - including the BP share from a clean download.
I've checked with curl and the download of the root URL I'd expect to be the correct one (https://uk.webfg.com/equity/BP) works fine from a terminal window.
All the shares have the problem - including the BP share from a clean download.
I've checked with curl and the download of the root URL I'd expect to be the correct one (https://uk.webfg.com/equity/BP) works fine from a terminal window.
-
- 2 Lemon pips
- Posts: 128
- Joined: November 18th, 2016, 8:07 am
Re: New HYPTUSS versions 11.52 and b-g
Many thanks.
Everything working splendidly here and the spreadsheet seems to open and close (after saving) a lot quicker than the previous version.
Everything working splendidly here and the spreadsheet seems to open and close (after saving) a lot quicker than the previous version.
-
- Lemon Half
- Posts: 8675
- Joined: November 4th, 2016, 1:16 pm
Re: New HYPTUSS versions 11.52 and b-g
I'm sure everyone's got this great 'HYPTUSS Portfolio Transfer' video bookmarked by now, but just in case anyone has lost their link, here's a video showing you how simple it is to migrate your portfolio from an earlier version of the tool into the latest whizz-bang release -kiloran wrote:
Following the changes to the DigitalLook website, Itsallaguess and I have updated the HYP Top-Up SpreadSheet.
http://lemonfoolfinancialsoftware.weebl ... op-up.html
https://vimeo.com/232215342
Cheers,
Itsallaguess
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: New HYPTUSS versions 11.52 and b-g
Neil, I wonder if this is the SSL problem we saw a few months ago with Yahoo on your Mac/LibreOffice.NeilW wrote:Just getting question marks on yield retrieval. No errors.
I've sent you a PM with a link to a test file to see if that fixes the problem.
--kiloran
-
- 2 Lemon pips
- Posts: 111
- Joined: December 8th, 2016, 10:30 am
Re: New HYPTUSS versions 11.52 and b-g
Tomorrow I think I'm going to just write a macro to do this. Could it be incorporated into the next sheet? It'll be fairly simple and obviously won't cover custom sheets that people add.
-
- Lemon Half
- Posts: 9905
- Joined: November 4th, 2016, 9:33 am
Re: New HYPTUSS versions 11.52 and b-g
Thanks for that. I've downloaded the new version but not used it yet apart from testing the initial BP share which works fine.kiloran wrote:Following the changes to the DigitalLook website, Itsallaguess and I have updated the HYP Top-Up SpreadSheet. http://lemonfoolfinancialsoftware.weebl ... op-up.html
Many companies have seen a change to the URL suffix in Column A of the Digital Look Data Sheet, but things now seem to be relatively stable.
Other than the change to use the replacement DigitalLook website, there are no other changes or bug fixes.
--kiloran
Fingers crossed they don't change something else in a day or two. I think I might wait before populating the spreadsheet....
-
- Lemon Quarter
- Posts: 4108
- Joined: November 4th, 2016, 9:42 pm
Re: New HYPTUSS versions 11.52 and b-g
Thanks - I'll just import the updated datasheet then (as I'm already on b-f it's quicker/easier than migrating my portfolio and customisations )kiloran wrote:Other than the change to use the replacement DigitalLook website, there are no other changes or bug fixes.
Done: all working normally.
-
- 2 Lemon pips
- Posts: 219
- Joined: November 5th, 2016, 12:02 am
Re: New HYPTUSS versions 11.52 and b-g
Downloaded the excel version and working with windows 10.
Made my conversions and customisations quite quickly and the core of the portfolio seems ok so far.
I have to say the gathering of dividend data went faster than before and I didn't notice any delays due to (site not responding) issues as was 100% certain in the past.
I noticed in my watchlist that Standard Life European Private Equity Trust (SEP), doesn't appear to be in my lookup data sheet.
SEP is listed in the previous version 11.4_beta so I copied and pasted this into new version 11.52 however the yield info returns question marks.
I was playing around adding a new IT, Aberdeen Standard European Logistics Income (ASLI) although I don't have a CSI code for that yet; therefore also returns question marks.
Overall very happy again
midgesgalore
Made my conversions and customisations quite quickly and the core of the portfolio seems ok so far.
I have to say the gathering of dividend data went faster than before and I didn't notice any delays due to (site not responding) issues as was 100% certain in the past.
I noticed in my watchlist that Standard Life European Private Equity Trust (SEP), doesn't appear to be in my lookup data sheet.
SEP is listed in the previous version 11.4_beta so I copied and pasted this into new version 11.52 however the yield info returns question marks.
I was playing around adding a new IT, Aberdeen Standard European Logistics Income (ASLI) although I don't have a CSI code for that yet; therefore also returns question marks.
Overall very happy again
midgesgalore
-
- Posts: 22
- Joined: November 4th, 2016, 9:52 am
Re: New HYPTUSS versions 11.52 and b-g
I think you will find that the ticker was changed to SLPE.I noticed in my watchlist that Standard Life European Private Equity Trust (SEP), doesn't appear to be in my lookup data sheet
p
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: New HYPTUSS versions 11.52 and b-g
I guess that's a reasonable approach, Bree, as long as the website's current redirection from http://www.digitallook.com to uk.webfg.com continuesBreelander wrote:Thanks - I'll just import the updated datasheet then (as I'm already on b-f it's quicker/easier than migrating my portfolio and customisations )kiloran wrote:Other than the change to use the replacement DigitalLook website, there are no other changes or bug fixes.
Done: all working normally.
--kiloran
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: New HYPTUSS versions 11.52 and b-g
Yes, SEP changed to SLPE a year ago. I've added SLPE to the Digital Look Data Sheet at http://lemonfoolfinancialsoftware.weebl ... op-up.htmlpeter666 wrote:I think you will find that the ticker was changed to SLPE.I noticed in my watchlist that Standard Life European Private Equity Trust (SEP), doesn't appear to be in my lookup data sheet
p
--kiloran
-
- Posts: 23
- Joined: November 7th, 2016, 12:57 pm
Re: New HYPTUSS versions 11.52 and b-g
Like NeilW, I am getting only question marks when updating the yield using office libre v5.4.2.2 on mac OS 10.13.2
Dochas
Dochas
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: New HYPTUSS versions 11.52 and b-g
I've sent you a PM with details of a test for you to tryDochas wrote:Like NeilW, I am getting only question marks when updating the yield using office libre v5.4.2.2 on mac OS 10.13.2
Dochas
--kiloran
-
- 2 Lemon pips
- Posts: 104
- Joined: November 16th, 2016, 9:25 pm
Re: New HYPTUSS versions 11.52 and b-g
Thanks for the new version which works fine on Excel I've just noticed that IUKD has been added but when using it the yield is filled by question marks.
Puffster
Puffster
-
- Lemon Quarter
- Posts: 3865
- Joined: November 4th, 2016, 9:24 am
Re: New HYPTUSS versions 11.52 and b-g
That's normal, DigitalLook (uk.webfg.com) doesn't provide yield data for ETFs, sadly, in which case HYPTUSS reports '????'puffster wrote:Thanks for the new version which works fine on Excel I've just noticed that IUKD has been added but when using it the yield is filled by question marks.
Puffster
https://uk.webfg.com/etf/IShares_UK_Dividend_Ucits_ETF
--kiloran
-
- Lemon Quarter
- Posts: 2943
- Joined: November 5th, 2016, 2:22 am
Re: New HYPTUSS versions 11.52 and b-g
Downloaded HYPTUS 11.52 (Windows 10 64 bit, Excel MS Office 2010) and migrated data with no problems (actually - super easy - thank you for keeping it that way!)
Updated data and all looks good.
As discussed previously, there is a quirk for Co-op 11% pref shares (Epic=42TE), reporting the price in GBp but stating it's in GBP.
To fix this I've used a fairly blunt approach: open the VB Object in Sheet1 (High Yield Portfolio) and look for:
' Go down the portfolio and fill in price information where the tickers are matched in the dictionary
and change to:
' Go down the portfolio and fill in price information where the tickers are matched in the dictionary
Crude, but it works. Just remember to keep an eye on 42TE in case it increases in value 100-fold some day
Updated data and all looks good.
As discussed previously, there is a quirk for Co-op 11% pref shares (Epic=42TE), reporting the price in GBp but stating it's in GBP.
To fix this I've used a fairly blunt approach: open the VB Object in Sheet1 (High Yield Portfolio) and look for:
' Go down the portfolio and fill in price information where the tickers are matched in the dictionary
For rowsdown = 6 To lastrow ticker = Cells(rowsdown, 3) If dict.Exists(ticker) Then share_price = Left(dict(ticker), InStr(1, dict(ticker), "|") - 1) share_currency = Right(dict(ticker), Len(dict(ticker)) - InStr(1, dict(ticker), "|")) If share_currency = "GBP" Then Cells(rowsdown, 5) = share_price * 100 Else Cells(rowsdown, 5) = share_price End If End If Next rowsdown
and change to:
' Go down the portfolio and fill in price information where the tickers are matched in the dictionary
For rowsdown = 6 To lastrow
ticker = Cells(rowsdown, 3)
If dict.Exists(ticker) Then
share_price = Left(dict(ticker), InStr(1, dict(ticker), "|") - 1)
share_currency = Right(dict(ticker), Len(dict(ticker)) - InStr(1, dict(ticker), "|"))
If share_currency = "GBP" Then
Cells(rowsdown, 5) = share_price * 100
Else
Cells(rowsdown, 5) = share_price
End If
End If
'Added by VRDiver to correct 42TE GBPence error in source data
If ticker = "42TE" Then
share_price = Left(dict(ticker), InStr(1, dict(ticker), "|") - 1)
share_currency = Right(dict(ticker), Len(dict(ticker)) - InStr(1, dict(ticker), "|"))
Cells(rowsdown, 5) = share_price
End If
Next rowsdown
Crude, but it works. Just remember to keep an eye on 42TE in case it increases in value 100-fold some day