4 Messages
Digest #4430
Messages
Wed Nov 28, 2018 9:11 am (PST) . Posted by:
amt2100
Hi Randy,
Long time fan here. Everything has been going great for last couple years with the add-in, then computer crashed and loading on new drive.
I'm working with the RTD on Thinkorswim. Works fine on my other computer, but now I'm getting #N/A in all the cells. The add-in is working though, because I get
Stock Market Functions add-in, Version 2.1.2018.01.24 (C:\SMF Add-In; Windows (32-bit) NT :.00; 16.0; ; ; 1)
showing up just fine.
Excel 2016, Win 10, 64-bit. Is that a problem?
Any ideas?
Thanks!
Jim
Long time fan here. Everything has been going great for last couple years with the add-in, then computer crashed and loading on new drive.
I'm working with the RTD on Thinkorswim. Works fine on my other computer, but now I'm getting #N/A in all the cells. The add-in is working though, because I get
Stock Market Functions add-in, Version 2.1.2018.01.
showing up just fine.
Excel 2016, Win 10, 64-bit. Is that a problem?
Any ideas?
Thanks!
Jim
Wed Nov 28, 2018 11:26 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I know noting about RTD or Thinkorswim.
Since "Version" is working, it appears the add-in is installed properly.
What SMF add-in formula invocation is returning #N/A? That's not typically
something the add-in would return if an error occurs.
On Wed, Nov 28, 2018 at 10:42 AM amt2100@... wrote:
> Long time fan here. Everything has been going great for last couple years
> with the add-in, then computer crashed and loading on new drive.
>
> I'm working with the RTD on Thinkorswim. Works fine on my other computer,
> but now I'm getting #N/A in all the cells. The add-in is working though,
> because I get
> Stock Market Functions add-in, Version 2.1.2018.01.24 (C:\SMF Add-In;
> Windows (32-bit) NT :.00; 16.0; ; ; 1)
> showing up just fine.
> Excel 2016, Win 10, 64-bit. Is that a problem?
> Any ideas?
>
>
>
Since "Version" is working, it appears the add-in is installed properly.
What SMF add-in formula invocation is returning #N/A? That's not typically
something the add-in would return if an error occurs.
On Wed, Nov 28, 2018 at 10:42 AM amt2100@... wrote:
> Long time fan here. Everything has been going great for last couple years
> with the add-in, then computer crashed and loading on new drive.
>
> I'm working with the RTD on Thinkorswim. Works fine on my other computer,
> but now I'm getting #N/A in all the cells. The add-in is working though,
> because I get
> Stock Market Functions add-in, Version 2.1.2018.01.
> Windows (32-bit) NT :.00; 16.0; ; ; 1)
> showing up just fine.
> Excel 2016, Win 10, 64-bit. Is that a problem?
> Any ideas?
>
>
>
Thu Nov 29, 2018 5:39 am (PST) . Posted by:
"Steve Low" gordian
Two weeks have passed since my last report on this problem.
Is (almost) no one else experiencing this problem with Yahoo quotes prior to market open?
On Wednesday, November 14, 2018, 10:22:04 AM EST, Steve Low gordian@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
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 |
Is (almost) no one else experiencing this problem with Yahoo quotes prior to market open?
On Wednesday, November 14, 2018, 10:22:04 AM EST, Steve Low gordian@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
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"
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 |
Thu Nov 29, 2018 7:53 am (PST) . Posted by:
pietertvl
Good morning Steve
Unable to get updated quotes today using Yahoo Get Portfolio View.
All quotes still showing OHLCV for yesterday. (has worked fine all year)
Using the macro for Force Recalculation.
Is there a manual alternative with that (yes, but I forgot where in Excel 2007). Somewhere in Formulas? Also tried Ctrl Alt Shift F9 .to no avail.
Anyone else having issues with Yahoo Quotes today? Hopefully its just me.
TIA
Pieter
PS .. Hope you don't get two copies of this ... tried sending via Outlook, but it wasn't showing up. So sent second time via this Yahoo portal.
Unable to get updated quotes today using Yahoo Get Portfolio View.
All quotes still showing OHLCV for yesterday. (has worked fine all year)
Using the macro for Force Recalculation.
Is there a manual alternative with that (yes, but I forgot where in Excel 2007). Somewhere in Formulas? Also tried Ctrl Alt Shift F9 .to no avail.
Anyone else having issues with Yahoo Quotes today? Hopefully its just me.
TIA
Pieter
PS .. Hope you don't get two copies of this ... tried sending via Outlook, but it wasn't showing up. So sent second time via this Yahoo portal.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar