3 Messages
Digest #4422
Messages
Wed Nov 14, 2018 6:18 am (PST) . Posted by:
"David K Smith" cancerfixer
This is a "problem" with the portfolio view and is yahoo's issue, not the smf.If you have an invalid ticker (say, "xyz") in your request, the function will return values all the way up to "xyz"Then EVERY stock ticker after "xyz" in the query will return dashes.I've noticed this happens after a merger. The old ticker stays active for a few weeks, then suddenly stops working. - and everything afterward returns "--" for price and name and so forth
It also happens if you query in the early hours of the day for certain issues, such as options quotes, I believe.You would think they would be able to just return the "--" for the invalid quotes, but no, not yahoo.It's just the way they wrote the API and that's the way it's probably going to stay.
In any event, the solution is to isolate the ticker in question and eliminate it from your query.If you are querying in early AM or odd hours, just wait and try later when the market is open. If all tickers are valid, the problem will disappear.You could put some traps in your code looking for "--" latest prices or names and then a msgbox to alert you to the problem ticker, but I haven't bothered to do that.
It also happens if you query in the early hours of the day for certain issues, such as options quotes, I believe.You would think they would be able to just return the "--" for the invalid quotes, but no, not yahoo.It'
In any event, the solution is to isolate the ticker in question and eliminate it from your query.If you are querying in early AM or odd hours, just wait and try later when the market is open. If all tickers are valid, the problem will disappear.You could put some traps in your code looking for "--" latest prices or names and then a msgbox to alert you to the problem ticker, but I haven't bothered to do that.
Wed Nov 14, 2018 6:44 am (PST) . Posted by:
"Steve Low" gordian
My experience has been quite different in two ways:
1. In the past, Yahoo sometimes had a problem returning a quout JUST for the General Motors warrants (B). I'd get the dashes, but all other tickers--above and below--populated correctly. It was weird, but cleared up within a few minutes after I detected it.
2. As for this bigger problem: Yahoo only delivered the first nine quotes last night. This morning (Tuesday), that continued until 9:38 AM, when all the quotes populated properly.
It seems that for some odd reason, Yahoo has decided to throttle its quote delivery until the market is open (quotes are delayed, and at 9:38, the quotes I received were today's--not yesterday's closing quotes.
Very strange, indeed.
On Wednesday, November 14, 2018, 9:25:59 AM EST, David K Smith cancerfixer@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
This is a "problem" with the portfolio view and is yahoo's issue, not the smf.If you have an invalid ticker (say, "xyz") in your request, the function will return values all the way up to "xyz"Then EVERY stock ticker after "xyz" in the query will return dashes.I've noticed this happens after a merger. The old ticker stays active for a few weeks, then suddenly stops working. - and everything afterward returns "--" for price and name and so forth
It also happens if you query in the early hours of the day for certain issues, such as options quotes, I believe.You would think they would be able to just return the "--" for the invalid quotes, but no, not yahoo.It's just the way they wrote the API and that's the way it's probably going to stay.
In any event, the solution is to isolate the ticker in question and eliminate it from your query.If you are querying in early AM or odd hours, just wait and try later when the market is open. If all tickers are valid, the problem will disappear.You could put some traps in your code looking for "--" latest prices or names and then a msgbox to alert you to the problem ticker, but I haven't bothered to do that.
| | Virus-free. www.avg.com |
1. In the past, Yahoo sometimes had a problem returning a quout JUST for the General Motors warrants (B). I'd get the dashes, but all other tickers--above and below--populated correctly. It was weird, but cleared up within a few minutes after I detected it.
2. As for this bigger problem: Yahoo only delivered the first nine quotes last night. This morning (Tuesday), that continued until 9:38 AM, when all the quotes populated properly.
It seems that for some odd reason, Yahoo has decided to throttle its quote delivery until the market is open (quotes are delayed, and at 9:38, the quotes I received were today's--not yesterday's closing quotes.
Very strange, indeed.
On Wednesday, November 14, 2018, 9:25:59 AM EST, David K Smith cancerfixer@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
This is a "problem" with the portfolio view and is yahoo's issue, not the smf.If you have an invalid ticker (say, "xyz"
It also happens if you query in the early hours of the day for certain issues, such as options quotes, I believe.You would think they would be able to just return the "--" for the invalid quotes, but no, not yahoo.It'
In any event, the solution is to isolate the ticker in question and eliminate it from your query.If you are querying in early AM or odd hours, just wait and try later when the market is open. If all tickers are valid, the problem will disappear.You could put some traps in your code looking for "--" latest prices or names and then a msgbox to alert you to the problem ticker, but I haven't bothered to do that.
| | Virus-free. www.avg.com |
Wed Nov 14, 2018 7:21 am (PST) . Posted by:
"Steve Low" gordian
Meant to say today (Wednesday)! sorry.
On Wednesday, November 14, 2018, 9:45:01 AM EST, Steve Low gordian@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
My experience has been quite different in two ways:
1. In the past, Yahoo sometimes had a problem returning a quout JUST for the General Motors warrants (B). I'd get the dashes, but all other tickers--above and below--populated correctly. It was weird, but cleared up within a few minutes after I detected it.
2. As for this bigger problem: Yahoo only delivered the first nine quotes last night. This morning (Tuesday), that continued until 9:38 AM, when all the quotes populated properly.
It seems that for some odd reason, Yahoo has decided to throttle its quote delivery until the market is open (quotes are delayed, and at 9:38, the quotes I received were today's--not yesterday's closing quotes.
Very strange, indeed.
On Wednesday, November 14, 2018, 9:25:59 AM EST, David K Smith cancerfixer@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
This is a "problem" with the portfolio view and is yahoo's issue, not the smf.If you have an invalid ticker (say, "xyz") in your request, the function will return values all the way up to "xyz"Then EVERY stock ticker after "xyz" in the query will return dashes.I've noticed this happens after a merger. The old ticker stays active for a few weeks, then suddenly stops working. - and everything afterward returns "--" for price and name and so forth
It also happens if you query in the early hours of the day for certain issues, such as options quotes, I believe.You would think they would be able to just return the "--" for the invalid quotes, but no, not yahoo.It's just the way they wrote the API and that's the way it's probably going to stay.
In any event, the solution is to isolate the ticker in question and eliminate it from your query.If you are querying in early AM or odd hours, just wait and try later when the market is open. If all tickers are valid, the problem will disappear.You could put some traps in your code looking for "--" latest prices or names and then a msgbox to alert you to the problem ticker, but I haven't bothered to do that.
| | Virus-free. www.avg.com |
On Wednesday, November 14, 2018, 9:45:01 AM EST, Steve Low gordian@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
My experience has been quite different in two ways:
1. In the past, Yahoo sometimes had a problem returning a quout JUST for the General Motors warrants (B). I'd get the dashes, but all other tickers--above and below--populated correctly. It was weird, but cleared up within a few minutes after I detected it.
2. As for this bigger problem: Yahoo only delivered the first nine quotes last night. This morning (Tuesday), that continued until 9:38 AM, when all the quotes populated properly.
It seems that for some odd reason, Yahoo has decided to throttle its quote delivery until the market is open (quotes are delayed, and at 9:38, the quotes I received were today's--not yesterday's closing quotes.
Very strange, indeed.
On Wednesday, November 14, 2018, 9:25:59 AM EST, David K Smith cancerfixer@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
This is a "problem" with the portfolio view and is yahoo's issue, not the smf.If you have an invalid ticker (say, "xyz"
It also happens if you query in the early hours of the day for certain issues, such as options quotes, I believe.You would think they would be able to just return the "--" for the invalid quotes, but no, not yahoo.It'
In any event, the solution is to isolate the ticker in question and eliminate it from your query.If you are querying in early AM or odd hours, just wait and try later when the market is open. If all tickers are valid, the problem will disappear.You could put some traps in your code looking for "--" latest prices or names and then a msgbox to alert you to the problem ticker, but I haven't bothered to do that.
| | Virus-free. www.avg.com |
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar