Got a credit card? use our Credit Card & Finance Calculators
Thanks to Anonymous,bruncher,niord,gvonge,Shelford, for Donating to support the site
HYP Top UP Sheet Price Update.
HYP Top UP Sheet Price Update.
I have just tried to update my spreadsheet (which is fantastic BTW) and it failed this morning. When I did a check one URL
https://query1.finance.yahoo.com/v7/fin ... bols=MKS.l
It returned this:
"HTTP Status 500 - Request failed.
type Status report
message Request failed.
description Server Error"
Is anyone else have issues this morning?
ExFM
https://query1.finance.yahoo.com/v7/fin ... bols=MKS.l
It returned this:
"HTTP Status 500 - Request failed.
type Status report
message Request failed.
description Server Error"
Is anyone else have issues this morning?
ExFM
-
- Lemon Quarter
- Posts: 4131
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3284 times
- Been thanked: 2868 times
Re: HYP Top UP Sheet Price Update.
ExFM wrote:I have just tried to update my spreadsheet (which is fantastic BTW) and it failed this morning. When I did a check one URL
https://query1.finance.yahoo.com/v7/fin ... bols=MKS.l
It returned this:
"HTTP Status 500 - Request failed.
type Status report
message Request failed.
description Server Error"
Is anyone else have issues this morning?
ExFM
I just tried v11.74 (excel) on Windows 10 with Excel 2016 for MKS and it worked fine. Sounds like you had a transient error due to a Yahoo problem or maybe a network/wifi problem.
It's always helpful when you report a problem to include:
1...HYPTUSS version
2...Excel or Libreoffice version
3...Operating system
--kiloran
-
- Lemon Slice
- Posts: 496
- Joined: August 19th, 2017, 8:37 am
- Has thanked: 155 times
- Been thanked: 241 times
Re: HYP Top UP Sheet Price Update.
When you say "update", what were you actually doing? Updating the spreadsheet with a new "version" or using one of the "update buttons", if so which one? I was using my latest verision spreadsheet this morning with no problems and I have MKS? However, if you look at Yahoo finance MKS page seems to be "missing" some data...
edit. Just re-run "Get Yahoo prices" and HYPTUSS returned that the scrape failed from Yahoo, re-run and it was ok. so maybe Yahoo is having some problems this morning.
edit. Just re-run "Get Yahoo prices" and HYPTUSS returned that the scrape failed from Yahoo, re-run and it was ok. so maybe Yahoo is having some problems this morning.
-
- Lemon Slice
- Posts: 547
- Joined: November 4th, 2016, 9:12 am
- Has thanked: 157 times
- Been thanked: 184 times
Re: HYP Top UP Sheet Price Update.
kiloran wrote:I just tried v11.74 (excel) on Windows 10 with Excel 2016 for MKS and it worked fine. Sounds like you had a transient error due to a Yahoo problem or maybe a network/wifi problem.
--kiloran
I'm seeing similar problems this morning on both HYPTUSS (latest version) on LibreOffice and on my own spreadsheet which uses the Eventide add-on.
HYPTUSS reports "Yahoo returned no data"
while Excel reports ::tick_Err:: on each entry and tells me theres a run-time error.
I had tried Excel first and initially suspected a connection with a Windows 10 update that occurred last night, but when HYTUSS failed as well I presumed a Yahoo problem.
cheers
Spiderbill
Re: HYP Top UP Sheet Price Update.
So I closed Excel and re ran the price update and it "just worked". So it may be just an intermittent issue. Thank you for looking in any event.
I use the excel version, but I have changed the name of the spreadsheet and can't see a reference as to which was the original version of the HYPTSS (Sorry) I am using. The operating system I use is Windows 10.
I use the excel version, but I have changed the name of the spreadsheet and can't see a reference as to which was the original version of the HYPTSS (Sorry) I am using. The operating system I use is Windows 10.
-
- Lemon Quarter
- Posts: 4131
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3284 times
- Been thanked: 2868 times
Re: HYP Top UP Sheet Price Update.
ExFM wrote:I use the excel version, but I have changed the name of the spreadsheet and can't see a reference as to which was the original version of the HYPTSS
The last sheet "Version History" shows which version you have
--kiloran
Re: HYP Top UP Sheet Price Update.
kiloran wrote:ExFM wrote:I use the excel version, but I have changed the name of the spreadsheet and can't see a reference as to which was the original version of the HYPTSS
The last sheet "Version History" shows which version you have
--kiloran
I think it is
11.12 13-Oct-16
But I have hacked it around a bit, so I may have added in later changes without taking the new sheet. Sorry, not much help.
It does seem to be intermittent, I have had the issue 5 or 6 times this morning, and then it will work. The most like scenario is that Yahoo are having issues and hopefully that will be fixed in due course.
-
- Lemon Quarter
- Posts: 4131
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3284 times
- Been thanked: 2868 times
Re: HYP Top UP Sheet Price Update.
ExFM wrote:kiloran wrote:ExFM wrote:I use the excel version, but I have changed the name of the spreadsheet and can't see a reference as to which was the original version of the HYPTSS
The last sheet "Version History" shows which version you have
--kiloran
I think it is
11.12 13-Oct-16
But I have hacked it around a bit, so I may have added in later changes without taking the new sheet. Sorry, not much help.
It does seem to be intermittent, I have had the issue 5 or 6 times this morning, and then it will work. The most like scenario is that Yahoo are having issues and hopefully that will be fixed in due course.
No, it's definitely not 11.12. Yahoo subsequently made some big changes, and 11.12 just collapses in an ungainly heap and never retrieves prices.
I've tried 11.74 a few times this morning and there's definitely an intermittent Yahoo problem. Works most of the time, but sometimes fails. Sadly, not a lot we can do about that
--kiloran
Re: HYP Top UP Sheet Price Update.
also getting the same issue - had it fail 3 times, then it worked
-
- Lemon Quarter
- Posts: 4131
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3284 times
- Been thanked: 2868 times
Re: HYP Top UP Sheet Price Update.
I've also seen problems with the Yahoo Finance website today https://finance.yahoo.com/quote/Bp.l
Works most of the time, but sometimes no price or an "HTTP Status 500 - Request failed" problem
--kiloran
Works most of the time, but sometimes no price or an "HTTP Status 500 - Request failed" problem
--kiloran
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 7 guests