Got a credit card? use our Credit Card & Finance Calculators
Thanks to Anonymous,bruncher,niord,gvonge,Shelford, for Donating to support the site
Updated Excel HYPTUSS available for test
-
- Lemon Quarter
- Posts: 4133
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3287 times
- Been thanked: 2869 times
Updated Excel HYPTUSS available for test
Yahoo recently disabled the API that we use to retrieve prices for HYPTUSS and other tools. I've developed an updated Excel HYPTUSS which gets prices from https://shareprices.com/indices/ftse-all-share/
One reason that the Yahoo API was used is that it was very fast, even for multiple shares. The new HYPTUSS is also reasonably fast, initially loading prices from the FTSE all-share index with a single web query, and then filling in any gaps on a share-by-share basis.
Itsallaguess and I have done some basic testing and it seems to be OK, so it's being made available to you for further testing while I work on a similar LibreOffice solution.
The test HYPTUSS can be downloaded here: https://lemonfoolfinancialsoftware.weeb ... _page.html
Please give it a good thrashing and let me know if you find any bugs. I tested it for shares quoted in pence, pounds and dollars, but I could not find any shares on the London Stock Exchange quoted in euros, groats or any other obscure currency, so if you know of any, please let me know.
--kiloran
One reason that the Yahoo API was used is that it was very fast, even for multiple shares. The new HYPTUSS is also reasonably fast, initially loading prices from the FTSE all-share index with a single web query, and then filling in any gaps on a share-by-share basis.
Itsallaguess and I have done some basic testing and it seems to be OK, so it's being made available to you for further testing while I work on a similar LibreOffice solution.
The test HYPTUSS can be downloaded here: https://lemonfoolfinancialsoftware.weeb ... _page.html
Please give it a good thrashing and let me know if you find any bugs. I tested it for shares quoted in pence, pounds and dollars, but I could not find any shares on the London Stock Exchange quoted in euros, groats or any other obscure currency, so if you know of any, please let me know.
--kiloran
-
- Lemon Quarter
- Posts: 1103
- Joined: November 4th, 2016, 1:12 pm
- Has thanked: 179 times
- Been thanked: 378 times
Re: Updated Excel HYPTUSS available for test
kiloran wrote:I could not find any shares on the London Stock Exchange quoted in euros, groats or any other obscure currency, so if you know of any, please let me know.
--kiloran
PEY is the Euro quote for Princess Private Equity. Quoted in GBX as PEYS.
-
- Lemon Quarter
- Posts: 4133
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3287 times
- Been thanked: 2869 times
Re: Updated Excel HYPTUSS available for test
genou wrote:kiloran wrote:I could not find any shares on the London Stock Exchange quoted in euros, groats or any other obscure currency, so if you know of any, please let me know.
--kiloran
PEY is the Euro quote for Princess Private Equity. Quoted in GBX as PEYS.
Brilliant! What a community this is!
--kiloran
-
- Posts: 38
- Joined: November 4th, 2016, 10:54 am
- Has thanked: 227 times
- Been thanked: 56 times
Re: Updated Excel HYPTUSS available for test
Just tried the new HYPTUS. Seems to work fine with one small issue. When updating the share price it does not update FTSE-HYP Tracking sheet. Interesting when you update the "Get Yields" that does update the tracking sheet.
Hope that helps
Lansdown
Hope that helps
Lansdown
-
- Lemon Half
- Posts: 8498
- Joined: January 7th, 2017, 9:56 am
- Has thanked: 1563 times
- Been thanked: 3460 times
Re: Updated Excel HYPTUSS available for test
Might need to add to the company data sheet
TFIF
SEQI
HDIV
APEO
BIPS
BGS
SDV
SREI
BHP forecast yield at 623% looks 'optimistic'..
TFIF
SEQI
HDIV
APEO
BIPS
BGS
SDV
SREI
BHP forecast yield at 623% looks 'optimistic'..
-
- Lemon Quarter
- Posts: 4133
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3287 times
- Been thanked: 2869 times
Re: Updated Excel HYPTUSS available for test
lansdown wrote:Just tried the new HYPTUS. Seems to work fine with one small issue. When updating the share price it does not update FTSE-HYP Tracking sheet. Interesting when you update the "Get Yields" that does update the tracking sheet.
Hope that helps
Lansdown
Correct. I left that bug in there to check if you were paying attention.
On the other hand, it might just be an example of my spectacular incompetence.
I'll fix it.
--kiloran
-
- Lemon Quarter
- Posts: 4133
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3287 times
- Been thanked: 2869 times
Re: Updated Excel HYPTUSS available for test
monabri wrote:Might need to add to the company data sheet
TFIF
SEQI
HDIV
APEO
BIPS
BGS
SDV
SREI
BHP forecast yield at 623% looks 'optimistic'..
I'll get those added in.
Sharecast have had problems with BHP forecast yield for many months. I seem to remember it broke HYPTUSS when it went over 1000%
--kiloran
-
- Lemon Half
- Posts: 8498
- Joined: January 7th, 2017, 9:56 am
- Has thanked: 1563 times
- Been thanked: 3460 times
Re: Updated Excel HYPTUSS available for test
lansdown wrote:Just tried the new HYPTUS. Seems to work fine with one small issue. When updating the share price it does not update FTSE-HYP Tracking sheet. Interesting when you update the "Get Yields" that does update the tracking sheet.
Hope that helps
Lansdown
Confirmed.
(It will update if you manually click on the "refresh data" button (grey box))
-
- Lemon Half
- Posts: 8498
- Joined: January 7th, 2017, 9:56 am
- Has thanked: 1563 times
- Been thanked: 3460 times
Re: Updated Excel HYPTUSS available for test
kiloran wrote:On the other hand, it might just be an example of my spectacular incompetence.
--kiloran
Never !!
-
- Lemon Half
- Posts: 8498
- Joined: January 7th, 2017, 9:56 am
- Has thanked: 1563 times
- Been thanked: 3460 times
Re: Updated Excel HYPTUSS available for test
Single Chart - throws up an issue (compile error in hidden module sheet 1):
Ditto "Sector Weighting"
Ditto "Sector Weighting"
-
- Lemon Half
- Posts: 8498
- Joined: January 7th, 2017, 9:56 am
- Has thanked: 1563 times
- Been thanked: 3460 times
-
- Lemon Quarter
- Posts: 4133
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3287 times
- Been thanked: 2869 times
Re: Updated Excel HYPTUSS available for test
Hmmm..... that's weird. I see the same error. I didn't touch that code. I need to do some head-scratching.
--kiloran
-
- Lemon Half
- Posts: 8498
- Joined: January 7th, 2017, 9:56 am
- Has thanked: 1563 times
- Been thanked: 3460 times
Re: Updated Excel HYPTUSS available for test
Dividends Page
I gave it a good thraping on ~100 shares. Seemed to work but reported "no div" on certain shares...the bond funds I mentioned earlier and Murray International (MYI). I seem to recall they had a 5:1 share split...maybe this is causing an issue as other income ITs (MRCH,EAT,HFEL.AEI,EDIN,DIG ++ ) seem to scrape the correct data.
MYI TFIF SEQI HDIV APEO BIPS BGS SDV BGCG BGEU BGUK AUSC MTE BOXE SREI
It then concluded the update with
picture sharing
I tried again, same error msg.
I gave it a good thraping on ~100 shares. Seemed to work but reported "no div" on certain shares...the bond funds I mentioned earlier and Murray International (MYI). I seem to recall they had a 5:1 share split...maybe this is causing an issue as other income ITs (MRCH,EAT,HFEL.AEI,EDIN,DIG ++ ) seem to scrape the correct data.
MYI TFIF SEQI HDIV APEO BIPS BGS SDV BGCG BGEU BGUK AUSC MTE BOXE SREI
It then concluded the update with
picture sharing
I tried again, same error msg.
Re: Updated Excel HYPTUSS available for test
First of all my I express my appreciation to Kiloran for creating HYPTUSS and for the continual support provided over the many years since. A tremendous commitment and much appreciated by me and many others on here.
I'm not a techy in this world so my problem may be due to something I've done (or not done) but the ZCASH ticker current price (Col E) is cleared when the get share prices button is pressed, and isn't reset to 100. Just goes blank.
Any thoughts anyone?
TIA.
I'm not a techy in this world so my problem may be due to something I've done (or not done) but the ZCASH ticker current price (Col E) is cleared when the get share prices button is pressed, and isn't reset to 100. Just goes blank.
Any thoughts anyone?
TIA.
-
- Lemon Quarter
- Posts: 4133
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3287 times
- Been thanked: 2869 times
Re: Updated Excel HYPTUSS available for test
Dinick wrote:First of all my I express my appreciation to Kiloran for creating HYPTUSS and for the continual support provided over the many years since. A tremendous commitment and much appreciated by me and many others on here.
I'm not a techy in this world so my problem may be due to something I've done (or not done) but the ZCASH ticker current price (Col E) is cleared when the get share prices button is pressed, and isn't reset to 100. Just goes blank.
Any thoughts anyone?
TIA.
First, and most importantly, HYPTUSS was the brainchild and creation of Itsallaguess. I'm the lesser mortal who helps with maintenance.
Secondly, it's not you, it's me, I forgot about ZCASH. That's the benefit of user testing and feedback. I'll fix it.
--kiloran
Re: Updated Excel HYPTUSS available for test
First, and most importantly, HYPTUSS was the brainchild and creation of Itsallaguess. I'm the lesser mortal who helps with maintenance.
Then my appreciation is also due to itsallaguess as well!
Thanks for taking a look.
Then my appreciation is also due to itsallaguess as well!
Thanks for taking a look.
-
- Lemon Slice
- Posts: 504
- Joined: November 6th, 2016, 11:25 am
- Has thanked: 135 times
- Been thanked: 140 times
Re: Updated Excel HYPTUSS available for test
kiloran wrote:Yahoo recently disabled the API that we use to retrieve prices for HYPTUSS and other tools. I've developed an updated Excel HYPTUSS which gets prices from https://shareprices.com/indices/ftse-all-share/
One reason that the Yahoo API was used is that it was very fast, even for multiple shares. The new HYPTUSS is also reasonably fast, initially loading prices from the FTSE all-share index with a single web query, and then filling in any gaps on a share-by-share basis.
Itsallaguess and I have done some basic testing and it seems to be OK, so it's being made available to you for further testing while I work on a similar LibreOffice solution.
The test HYPTUSS can be downloaded here: https://lemonfoolfinancialsoftware.weeb ... _page.html
Please give it a good thrashing and let me know if you find any bugs. I tested it for shares quoted in pence, pounds and dollars, but I could not find any shares on the London Stock Exchange quoted in euros, groats or any other obscure currency, so if you know of any, please let me know.
--kiloran
Thank you kiloran. Your hard work is very much appreciated.
However, I don't use HYPTUSS - having already had my own spreadsheet in use for many years I preferred to stick with that. But, I did incorporate your Yahoo-price-scraping code into my own VBA code, so now I'd like to use your shareprices.com code. However, I see that you have a password on the VBA code in HYPTUSS. May I have it please? Or otherwise, may I have a copy of just the price-scraping code?
-
- Lemon Quarter
- Posts: 4133
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3287 times
- Been thanked: 2869 times
Re: Updated Excel HYPTUSS available for test
Nocton wrote:However, I don't use HYPTUSS - having already had my own spreadsheet in use for many years I preferred to stick with that. But, I did incorporate your Yahoo-price-scraping code into my own VBA code, so now I'd like to use your shareprices.com code. However, I see that you have a password on the VBA code in HYPTUSS. May I have it please? Or otherwise, may I have a copy of just the price-scraping code?
Sure, the password is no secret, it's just there to stop someone inadvertently editing the code.
The password is: pleaseletmein
--kiloran
-
- Lemon Slice
- Posts: 504
- Joined: November 6th, 2016, 11:25 am
- Has thanked: 135 times
- Been thanked: 140 times
Re: Updated Excel HYPTUSS available for test
kiloran wrote:Nocton wrote:However, I don't use HYPTUSS - having already had my own spreadsheet in use for many years I preferred to stick with that. But, I did incorporate your Yahoo-price-scraping code into my own VBA code, so now I'd like to use your shareprices.com code. However, I see that you have a password on the VBA code in HYPTUSS. May I have it please? Or otherwise, may I have a copy of just the price-scraping code?
Sure, the password is no secret, it's just there to stop someone inadvertently editing the code.
The password is: pleaseletmein
--kiloran
Thank you.
-
- The full Lemon
- Posts: 10554
- Joined: November 4th, 2016, 9:33 am
- Has thanked: 3682 times
- Been thanked: 5339 times
Re: Updated Excel HYPTUSS available for test
I've run the test HYPTUSS on my 40-ish shares, and it went well, giving me the most reliable value for value and dividends I've had for a while.
No problems apart from the usual BHP, for which I stuck in 10.8%.
Thank you, Kiloran, for getting us going again!
Next test will be on my IT basket later today.
Arb.
No problems apart from the usual BHP, for which I stuck in 10.8%.
Thank you, Kiloran, for getting us going again!
Next test will be on my IT basket later today.
Arb.
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 7 guests