Got a credit card? use our Credit Card & Finance Calculators
Thanks to smokey01,bungeejumper,stockton,Anonymous,bruncher, for Donating to support the site
End of support for HYPTUSS
-
- Lemon Slice
- Posts: 452
- Joined: November 9th, 2016, 6:14 pm
- Has thanked: 429 times
- Been thanked: 149 times
Re: End of support for HYPTUSS
Thank you for all your hard work over the years, I came to rely upon it, perhaps too much!
I am no computer guru so will have to get help setting up something similar, maybe our son can help, he is a consultant softwear engineer but has nothing to do with finance.
Anyone else have any ideas apart from doing everything manually?
Good luck and continued good fortune to you both.
john
I am no computer guru so will have to get help setting up something similar, maybe our son can help, he is a consultant softwear engineer but has nothing to do with finance.
Anyone else have any ideas apart from doing everything manually?
Good luck and continued good fortune to you both.
john
-
- Lemon Half
- Posts: 8475
- Joined: November 4th, 2016, 11:20 am
- Has thanked: 941 times
- Been thanked: 4263 times
Re: End of support for HYPTUSS
johnstevens77 wrote:Thank you for all your hard work over the years, I came to rely upon it, perhaps too much!
I am no computer guru so will have to get help setting up something similar, maybe our son can help, he is a consultant softwear engineer but has nothing to do with finance.
Anyone else have any ideas apart from doing everything manually?
Good luck and continued good fortune to you both.
john
It's not too difficult doing it manually. Dividends are only announce 2 or 4 times per year. Prices can be found after the close fairly easily. If you have a portfolio on a website, it is fairly easy to copy it daily to Notepad and thence into a spreadsheet, or you can do it longhand and enter the prices yourself.
Now you need to rank them by yield from high to low, 1 is highest, and then inversely by holding value (1 is lowest), add those rankings and rank them. That gives you the order in which they should be topped up. It is not hard to put this in one or more spreadsheets.
TJH
-
- Lemon Half
- Posts: 8541
- Joined: January 7th, 2017, 9:56 am
- Has thanked: 1573 times
- Been thanked: 3474 times
Re: End of support for HYPTUSS
I use HYPTUSS purely to scrape shareprices to feed into another Excel sheet. I need a reliable method of scraping prices. Thus, I assembled a bunch of shares to look at the prices returned by HYPTUSS versus "Simple Price Scrape V2-1.xls" available via The Lemon Fool.
https://lemonfoolfinancialsoftware.weeb ... crape.html
It's 17:45 so we are past market close - that's when I ran both HYPTUSS and the Simple Price Scrape ("SPS") to compare the values by looking at the difference in the price that each return - see the last column. I used SPS to scrape a price from "SharePrices.com".
Results
Conclusion
The majority of values scraped by both HYPTUSS and SPS are in agreement but there are one or two things to note.
(1) The price for Lindsell Train Investments ; HYPTUS returns the figures in pence - whereas the figure returned by SPS appears to be returned in pound Sterling.
(2) Shares such as Woodside (WDS) - the simple price scrape returned a price - my version of HYPTUSS did not - I suspect this is because I'm using an older version of HYPTUSS so - My Fault!
(3) Shares listed in Euros (eg BOXE) returned a value of 0.56 Euros so we need to note this.
https://lemonfoolfinancialsoftware.weeb ... crape.html
It's 17:45 so we are past market close - that's when I ran both HYPTUSS and the Simple Price Scrape ("SPS") to compare the values by looking at the difference in the price that each return - see the last column. I used SPS to scrape a price from "SharePrices.com".
Results
Conclusion
The majority of values scraped by both HYPTUSS and SPS are in agreement but there are one or two things to note.
(1) The price for Lindsell Train Investments ; HYPTUS returns the figures in pence - whereas the figure returned by SPS appears to be returned in pound Sterling.
(2) Shares such as Woodside (WDS) - the simple price scrape returned a price - my version of HYPTUSS did not - I suspect this is because I'm using an older version of HYPTUSS so - My Fault!
(3) Shares listed in Euros (eg BOXE) returned a value of 0.56 Euros so we need to note this.
-
- Lemon Slice
- Posts: 452
- Joined: November 9th, 2016, 6:14 pm
- Has thanked: 429 times
- Been thanked: 149 times
Re: End of support for HYPTUSS
tjh290633 wrote:johnstevens77 wrote:Thank you for all your hard work over the years, I came to rely upon it, perhaps too much!
I am no computer guru so will have to get help setting up something similar, maybe our son can help, he is a consultant softwear engineer but has nothing to do with finance.
Anyone else have any ideas apart from doing everything manually?
Good luck and continued good fortune to you both.
john
It's not too difficult doing it manually. Dividends are only announce 2 or 4 times per year. Prices can be found after the close fairly easily. If you have a portfolio on a website, it is fairly easy to copy it daily to Notepad and thence into a spreadsheet, or you can do it longhand and enter the prices yourself.
Now you need to rank them by yield from high to low, 1 is highest, and then inversely by holding value (1 is lowest), add those rankings and rank them. That gives you the order in which they should be topped up. It is not hard to put this in one or more spreadsheets.
TJH
Thanks Terry, well explained as usual.
john
-
- Lemon Quarter
- Posts: 4149
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3310 times
- Been thanked: 2876 times
Re: End of support for HYPTUSS
monabri wrote:I use HYPTUSS purely to scrape shareprices to feed into another Excel sheet. I need a reliable method of scraping prices. Thus, I assembled a bunch of shares to look at the prices returned by HYPTUSS versus "Simple Price Scrape V2-1.xls" available via The Lemon Fool.
https://lemonfoolfinancialsoftware.weeb ... crape.html
snip
snip
snip
Conclusion
The majority of values scraped by both HYPTUSS and SPS are in agreement but there are one or two things to note.
(1) The price for Lindsell Train Investments ; HYPTUS returns the figures in pence - whereas the figure returned by SPS appears to be returned in pound Sterling.
(2) Shares such as Woodside (WDS) - the simple price scrape returned a price - my version of HYPTUSS did not - I suspect this is because I'm using an older version of HYPTUSS so - My Fault!
(3) Shares listed in Euros (eg BOXE) returned a value of 0.56 Euros so we need to note this.
HYPTUSS and Simple Price Scrape treat currencies differently very deliberately.
HYPTUSS converts everything to pence. The price for shares not natively in pence is displayed in red to indicate that it is a calculated price. Having everything in a common currency is necessary since HYPTUSS is used for a portfolio, so a consistent currency is required for totals, etc.
The Simple Price Scrape is designed to be as simple as possible, with no currency assumptions or calculations, and little need for ongoing maintenance if we suddenly get a share quoted in Sudanese pounds or whatever. So the SPS displays the share price as-is, but also shows the currency so the user can make their own decision on how to handle non-pence.
--kiloran
-
- Lemon Quarter
- Posts: 3631
- Joined: November 7th, 2016, 1:56 pm
- Has thanked: 1626 times
- Been thanked: 1452 times
Re: End of support for HYPTUSS
Are there any plans to "open source" all this work, eg. on GitHub ? Or it may be already ? Some brave soul may or may not pick it up in future.
-
- Lemon Quarter
- Posts: 4149
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3310 times
- Been thanked: 2876 times
Re: End of support for HYPTUSS
moorfield wrote:Are there any plans to "open source" all this work, eg. on GitHub ? Or it may be already ? Some brave soul may or may not pick it up in future.
I've never played around with GitHub and not sure I want to add a new string to my bow at this point. All macros are already freely accessible so anybody can change them, and even add to GitHub if they wish. If anyone wants to update HYPTUSS in the future, I'm more than willing to publish to our Weebly web site.
--kiloran
Re: End of support for HYPTUSS
Thank you both for the amazing work you have done over many years to maintain Hyptuss. It is and has been a valuable tool for lots of people and will be sorely missed by all. You both deserve a knighthood for the work and efforts you have given freely to supporting the board members. Best wishes to you both.
Regards
Jeff
Regards
Jeff
-
- Lemon Quarter
- Posts: 2137
- Joined: November 4th, 2016, 9:40 am
- Has thanked: 1066 times
- Been thanked: 866 times
Re: End of support for HYPTUSS
jeff50 wrote:Thank you both for the amazing work you have done over many years to maintain Hyptuss. It is and has been a valuable tool for lots of people and will be sorely missed by all. You both deserve a knighthood for the work and efforts you have given freely to supporting the board members. Best wishes to you both.
Regards
Jeff
Agreed.
Hat’s off to Sir kiloran & Sir IAAG.
-
- Lemon Quarter
- Posts: 1357
- Joined: November 4th, 2016, 12:11 pm
- Has thanked: 126 times
- Been thanked: 865 times
Re: End of support for HYPTUSS
Just seen this thread.
I would like to add my thanks to IAAG and kiloran for their sterling work on HYPTUSS.
I have used it many times over the years, but now I only really need the Simple Price Scrape now, which you have kindly said you will keep working.
Even I, with my rudimentary Excel skills can code up the tjh top-up ranking system if I need it, so the only thing I will lose is the forecast yield scrape which has always been of questionable use anyway.
I am largely just withdrawing income now, so not really in the top-up game any more anyway.
Thanks guys, you are stars.
FD
I would like to add my thanks to IAAG and kiloran for their sterling work on HYPTUSS.
I have used it many times over the years, but now I only really need the Simple Price Scrape now, which you have kindly said you will keep working.
Even I, with my rudimentary Excel skills can code up the tjh top-up ranking system if I need it, so the only thing I will lose is the forecast yield scrape which has always been of questionable use anyway.
I am largely just withdrawing income now, so not really in the top-up game any more anyway.
Thanks guys, you are stars.
FD
-
- Lemon Pip
- Posts: 51
- Joined: January 20th, 2022, 10:28 pm
- Has thanked: 10 times
- Been thanked: 30 times
Re: End of support for HYPTUSS
First off thanks for the awesome tool that is / was HYPTUSS. I’ve used it for a number of years and in general have found it very reliable and extremely useful. The fund price retrieval (FT scrape) has been exceptionally valuable from my perspective and despite my extreme lack of any programming / excel skills I’ve managed to incorporate that functionality into a spreadsheet tool of my own.
With HYPTUSS demise I’ve also managed to recreate the ranking tool within my own excel management tool and use the in built stock data function in office 365 excel to update relevant prices for shares and currencies. By maintaining my own dividend page for the holdings I have I can also calculate prospective yields (ttm) and use these in the ranking calculations and this all happens dynamically when I open the excel sheet.
The biggest problem I foresee is when the scrape inevitably breaks - should FT.com change their web pages, but I guess I will cross that bridge when it happens.
Thanks again for the awesome tool and to everyone for the inspiration and ideas that have enabled me to create a highly personalised management system with practically zero skill / knowledge of excel or any form of programming.
Femi
With HYPTUSS demise I’ve also managed to recreate the ranking tool within my own excel management tool and use the in built stock data function in office 365 excel to update relevant prices for shares and currencies. By maintaining my own dividend page for the holdings I have I can also calculate prospective yields (ttm) and use these in the ranking calculations and this all happens dynamically when I open the excel sheet.
The biggest problem I foresee is when the scrape inevitably breaks - should FT.com change their web pages, but I guess I will cross that bridge when it happens.
Thanks again for the awesome tool and to everyone for the inspiration and ideas that have enabled me to create a highly personalised management system with practically zero skill / knowledge of excel or any form of programming.
Femi
-
- Lemon Quarter
- Posts: 3731
- Joined: November 5th, 2016, 10:30 am
- Has thanked: 1 time
- Been thanked: 1254 times
Re: End of support for HYPTUSS
Don't forget there's still another tool with less bells - Simple Price Scrape. https://lemonfoolfinancialsoftware.weeb ... crape.html
It is my back up plan, have a sheet to call for prices and a function to feed that into HYPTUSS. So far I have not needed that. I even tried getting google to scrape numbers into a sheet. I got a few lines into it as a proof of concept but shelved the big job. No doubt I'll rue mentioning it but HYPTUSS has been good.
It is my back up plan, have a sheet to call for prices and a function to feed that into HYPTUSS. So far I have not needed that. I even tried getting google to scrape numbers into a sheet. I got a few lines into it as a proof of concept but shelved the big job. No doubt I'll rue mentioning it but HYPTUSS has been good.
-
- Lemon Pip
- Posts: 51
- Joined: January 20th, 2022, 10:28 pm
- Has thanked: 10 times
- Been thanked: 30 times
Re: End of support for HYPTUSS
kempiejon wrote:Don't forget there's still another tool with less bells - Simple Price Scrape. https://lemonfoolfinancialsoftware.weeb ... crape.html
It is my back up plan, have a sheet to call for prices and a function to feed that into HYPTUSS. So far I have not needed that. I even tried getting google to scrape numbers into a sheet. I got a few lines into it as a proof of concept but shelved the big job. No doubt I'll rue mentioning it but HYPTUSS has been good.
Thanks Kemplejohn, I'll have a look - the key for me would be whether it also covers funds ... if not then the stock data in Excel is good for me and the FT.Com price scrape works perfectly for my needs also - as I said the issue for me will be when that inevitably stops working
-
- Lemon Half
- Posts: 8541
- Joined: January 7th, 2017, 9:56 am
- Has thanked: 1573 times
- Been thanked: 3474 times
Re: End of support for HYPTUSS
Femi wrote:kempiejon wrote:Don't forget there's still another tool with less bells - Simple Price Scrape. https://lemonfoolfinancialsoftware.weeb ... crape.html
It is my back up plan, have a sheet to call for prices and a function to feed that into HYPTUSS. So far I have not needed that. I even tried getting google to scrape numbers into a sheet. I got a few lines into it as a proof of concept but shelved the big job. No doubt I'll rue mentioning it but HYPTUSS has been good.
Thanks Kemplejohn, I'll have a look - the key for me would be whether it also covers funds ... if not then the stock data in Excel is good for me and the FT.Com price scrape works perfectly for my needs also - as I said the issue for me will be when that inevitably stops working
See above
viewtopic.php?p=660173#p660173
-
- Lemon Pip
- Posts: 51
- Joined: January 20th, 2022, 10:28 pm
- Has thanked: 10 times
- Been thanked: 30 times
Re: End of support for HYPTUSS
Thanks. I downloaded it and it doesn’t cover funds that the FT Scrape handles so while it’s a great tool it’s not for me.
-
- Lemon Quarter
- Posts: 4149
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3310 times
- Been thanked: 2876 times
Re: End of support for HYPTUSS
Femi wrote:kempiejon wrote:Don't forget there's still another tool with less bells - Simple Price Scrape. https://lemonfoolfinancialsoftware.weeb ... crape.html
It is my back up plan, have a sheet to call for prices and a function to feed that into HYPTUSS. So far I have not needed that. I even tried getting google to scrape numbers into a sheet. I got a few lines into it as a proof of concept but shelved the big job. No doubt I'll rue mentioning it but HYPTUSS has been good.
Thanks Kemplejohn, I'll have a look - the key for me would be whether it also covers funds ... if not then the stock data in Excel is good for me and the FT.Com price scrape works perfectly for my needs also - as I said the issue for me will be when that inevitably stops working
Fund Prices have been added to the Simple Price Scrape. See viewtopic.php?f=27&t=43771
--kiloran
-
- Lemon Pip
- Posts: 51
- Joined: January 20th, 2022, 10:28 pm
- Has thanked: 10 times
- Been thanked: 30 times
Re: End of support for HYPTUSS
kiloran wrote:Fund Prices have been added to the Simple Price Scrape. See viewtopic.php?f=27&t=43771
--kiloran
Thanks Kiloran - I'll take a look, very grateful
-
- Lemon Quarter
- Posts: 2048
- Joined: November 5th, 2016, 7:41 am
- Has thanked: 766 times
- Been thanked: 1179 times
Re: End of support for HYPTUSS
Hi Kiloran
The High Yield tab in Hyptuss is now no longer downloading prices. Th FT Funds are still downloading.
Terry
The High Yield tab in Hyptuss is now no longer downloading prices. Th FT Funds are still downloading.
Terry
-
- Lemon Quarter
- Posts: 4149
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3310 times
- Been thanked: 2876 times
Re: End of support for HYPTUSS
TerryWood wrote:Hi Kiloran
The High Yield tab in Hyptuss is now no longer downloading prices. Th FT Funds are still downloading.
Terry
Terry, you need to provide more detailed info.
Excel/LibreOffice?
What is the High Yield tab?
What price source are you using?
I know we still have problems downloading prices from Yahoo using LibreOffice (HYPTUSS, Simple Price Scrape, StepOne, etc)
--kiloran
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 4 guests