Got a credit card? use our Credit Card & Finance Calculators
Thanks to Rhyd6,eyeball08,Wondergirly,bofh,johnstevens77, for Donating to support the site
New HYPTUSS versions 11.52 and b-g
-
- Lemon Quarter
- Posts: 4112
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3249 times
- Been thanked: 2855 times
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 Quarter
- Posts: 4112
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3249 times
- Been thanked: 2855 times
Re: New HYPTUSS versions 11.52 and b-g
NeilW wrote:Just getting question marks on yield retrieval. No errors.
Excel or LibreOffice, Neil?
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: 8425
- Joined: January 7th, 2017, 9:56 am
- Has thanked: 1548 times
- Been thanked: 3443 times
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: 761
- Joined: November 4th, 2016, 4:27 pm
- Has thanked: 149 times
- Been thanked: 226 times
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
- Has thanked: 8 times
- Been thanked: 26 times
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: 9129
- Joined: November 4th, 2016, 1:16 pm
- Has thanked: 4140 times
- Been thanked: 10025 times
Re: New HYPTUSS versions 11.52 and b-g
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
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 -
https://vimeo.com/232215342
Cheers,
Itsallaguess
-
- Lemon Quarter
- Posts: 4112
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3249 times
- Been thanked: 2855 times
Re: New HYPTUSS versions 11.52 and b-g
NeilW wrote:Just getting question marks on yield retrieval. No errors.
Neil, I wonder if this is the SSL problem we saw a few months ago with Yahoo on your Mac/LibreOffice.
I've sent you a PM with a link to a test file to see if that fixes the problem.
--kiloran
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.
-
- The full Lemon
- Posts: 10439
- Joined: November 4th, 2016, 9:33 am
- Has thanked: 3644 times
- Been thanked: 5272 times
Re: New HYPTUSS versions 11.52 and b-g
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
Thanks for that. I've downloaded the new version but not used it yet apart from testing the initial BP share which works fine.
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: 4179
- Joined: November 4th, 2016, 9:42 pm
- Has thanked: 1001 times
- Been thanked: 1855 times
Re: New HYPTUSS versions 11.52 and b-g
kiloran wrote:Other than the change to use the replacement DigitalLook website, there are no other changes or bug fixes.
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 )
Done: all working normally.
-
- Lemon Slice
- Posts: 257
- Joined: November 5th, 2016, 12:02 am
- Has thanked: 275 times
- Been thanked: 72 times
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
Re: New HYPTUSS versions 11.52 and b-g
I noticed in my watchlist that Standard Life European Private Equity Trust (SEP), doesn't appear to be in my lookup data sheet
I think you will find that the ticker was changed to SLPE.
p
-
- Lemon Quarter
- Posts: 4112
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3249 times
- Been thanked: 2855 times
Re: New HYPTUSS versions 11.52 and b-g
Breelander wrote:kiloran wrote:Other than the change to use the replacement DigitalLook website, there are no other changes or bug fixes.
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 )
Done: all working normally.
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 continues
--kiloran
-
- Lemon Quarter
- Posts: 4112
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3249 times
- Been thanked: 2855 times
Re: New HYPTUSS versions 11.52 and b-g
peter666 wrote:I noticed in my watchlist that Standard Life European Private Equity Trust (SEP), doesn't appear to be in my lookup data sheet
I think you will find that the ticker was changed to SLPE.
p
Yes, SEP changed to SLPE a year ago. I've added SLPE to the Digital Look Data Sheet at http://lemonfoolfinancialsoftware.weebl ... op-up.html
--kiloran
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: 4112
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3249 times
- Been thanked: 2855 times
Re: New HYPTUSS versions 11.52 and b-g
Dochas 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
I've sent you a PM with details of a test for you to try
--kiloran
-
- 2 Lemon pips
- Posts: 119
- Joined: November 16th, 2016, 9:25 pm
- Has thanked: 103 times
- Been thanked: 39 times
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: 4112
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3249 times
- Been thanked: 2855 times
Re: New HYPTUSS versions 11.52 and b-g
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
That's normal, DigitalLook (uk.webfg.com) doesn't provide yield data for ETFs, sadly, in which case HYPTUSS reports '????'
https://uk.webfg.com/etf/IShares_UK_Dividend_Ucits_ETF
--kiloran
-
- Lemon Quarter
- Posts: 2574
- Joined: November 5th, 2016, 2:22 am
- Has thanked: 552 times
- Been thanked: 1212 times
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
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 13 guests