15 Messages
Digest #3481
Messages
Mon Aug 10, 2015 7:26 am (PDT) . Posted by:
rr76012
Mon 8/10/2015
Hello Randy,
My version:
Stock Market Functions add-in, Version 2.1.2014.01.
My smfgetyahoouotes is not working? =RCHGetYahooQuotes(
I was wondering if it is the yahoo servers or my current smfaddin version or something else?
Smfgetyahooquotes has always been working so I am un-sure what to do?
Randy, Pls advise, is it just the yahoo servers today or is it my version or something else.
Thank You.
rr76012
Mon Aug 10, 2015 7:50 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just tried the SMF-Template-RCHGetYahooQuotes.xls template from the web
site and it's working fine for me.
Make sure your Internet Options are set up to always get a fresh copy of
the web page, and then run the smfForceRecalculation macro. Hopefully, it
was just a temporary glitch from Yahoo....
On Mon, Aug 10, 2015 at 7:26 AM, rr76012@... wrote:
> Mon 8/10/2015
>
> Hello Randy,
>
> My version:
>
> Stock Market Functions add-in, Version 2.1.2014.01.30 (C:\Program
> Files\SMF Add-In; ; 1)
>
> My smfgetyahoouotes is not working?
> =RCHGetYahooQuotes(B4:B203,C2:V2,,NOW())
>
> I was wondering if it is the yahoo servers or my current smfaddin version
> or something else?
>
> Smfgetyahooquotes has always been working so I am un-sure what to do?
>
> Randy, Pls advise, is it just the yahoo servers today or is it my version
> or something else.
>
>
site and it's working fine for me.
Make sure your Internet Options are set up to always get a fresh copy of
the web page, and then run the smfForceRecalculati
was just a temporary glitch from Yahoo....
On Mon, Aug 10, 2015 at 7:26 AM, rr76012@... wrote:
> Mon 8/10/2015
>
> Hello Randy,
>
> My version:
>
> Stock Market Functions add-in, Version 2.1.2014.01.
> Files\SMF Add-In; ; 1)
>
> My smfgetyahoouotes is not working?
> =RCHGetYahooQuotes(
>
> I was wondering if it is the yahoo servers or my current smfaddin version
> or something else?
>
> Smfgetyahooquotes has always been working so I am un-sure what to do?
>
> Randy, Pls advise, is it just the yahoo servers today or is it my version
> or something else.
>
>
Mon Aug 10, 2015 8:28 am (PDT) . Posted by:
rr76012
Hi Randy,
This rchgetyahooquotes has always worked for me without any glitches, so, like you I hope this is temporary? I will keep my fingers crossed.
1. do you mean hit F9 or something else, for the smfForceRecalculation macro?
2. Internet Options are set up to always get a fresh copy of the web page.
I am using Windows 8.1, and Internet Explorer 11.
I looked under I.E. Tools -> Internet Options -> Advanced - > Browsing -> there is no check box for fresh copy of web page. But I have never had a problem until this morning and I have used your smf-template-rchgetyahooquotes.xls about every 2 days without any problems or glitches.
Randy, pls tell me how to do the smfForceRecalculation - I will then do it.
Thank You.
rr76012
This rchgetyahooquotes has always worked for me without any glitches, so, like you I hope this is temporary? I will keep my fingers crossed.
1. do you mean hit F9 or something else, for the smfForceRecalculati
2. Internet Options are set up to always get a fresh copy of the web page.
I am using Windows 8.1, and Internet Explorer 11.
I looked under I.E. Tools -> Internet Options -> Advanced - > Browsing -> there is no check box for fresh copy of web page. But I have never had a problem until this morning and I have used your smf-template-
Randy, pls tell me how to do the smfForceRecalculati
Thank You.
rr76012
Mon Aug 10, 2015 8:30 am (PDT) . Posted by:
"Lyndal Homewood" lyndal.homewood
I have switched from smfgetYAHOOquotes to smfgetGOOGLEquotes
1) closer to real time
2) response seems faster
3) provides PUT options for the current month
As of today, 8/10/15, the AUGUST ones work, the OCT & JAN puts are
returning "Error")
1) closer to real time
2) response seems faster
3) provides PUT options for the current month
As of today, 8/10/15, the AUGUST ones work, the OCT & JAN puts are
returning "Error"
Mon Aug 10, 2015 8:30 am (PDT) . Posted by:
sharn.spartner
Same here. It has been working fine but not until this morning. Tried smfFixLinks yet it won't work. Is anyone else experiencing the same problem?
My version is:
Stock Market Functions add-in, Version 2.1.2015.03.05 (C:\SMF; ; Local; 60)
Randy,
How do I "Make sure your Internet Options are set up to always get a fresh copy of the web page"?
Thanks in advance.
My version is:
Stock Market Functions add-in, Version 2.1.2015.03.
Randy,
How do I "Make sure your Internet Options are set up to always get a fresh copy of the web page"?
Thanks in advance.
Mon Aug 10, 2015 8:32 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/13523
On Mon, Aug 10, 2015 at 8:14 AM, sharn.spartner@... wrote:
>
> Same here. It has been working fine but not until this morning. Tried
> smfFixLinks yet it won't work. Is anyone else experiencing the same problem?
>
> My version is:
> Stock Market Functions add-in, Version 2.1.2015.03.05 (C:\SMF; ; Local; 60)
>
> Randy,
>
> How do I "Make sure your Internet Options are set up to always get a
> fresh copy of the web page"?
>
> Thanks in advance.
>
>
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/13523
On Mon, Aug 10, 2015 at 8:14 AM, sharn.spartner@
>
> Same here. It has been working fine but not until this morning. Tried
> smfFixLinks yet it won't work. Is anyone else experiencing the same problem?
>
> My version is:
> Stock Market Functions add-in, Version 2.1.2015.03.
>
> Randy,
>
> How do I "Make sure your Internet Options are set up to always get a
> fresh copy of the web page"?
>
> Thanks in advance.
>
>
>
Mon Aug 10, 2015 8:37 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
smfGetGoogleQuotes()??
On Mon, Aug 10, 2015 at 8:00 AM, Lyndal Homewood lyndal.homewood1@... wrote:
>
> I have switched from smfgetYAHOOquotes to smfgetGOOGLEquotes
> 1) closer to real time
> 2) response seems faster
> 3) provides PUT options for the current month
> As of today, 8/10/15, the AUGUST ones work, the OCT & JAN puts are
> returning "Error")
>
>
On Mon, Aug 10, 2015 at 8:00 AM, Lyndal Homewood lyndal.homewood1@
>
> I have switched from smfgetYAHOOquotes to smfgetGOOGLEquotes
> 1) closer to real time
> 2) response seems faster
> 3) provides PUT options for the current month
> As of today, 8/10/15, the AUGUST ones work, the OCT & JAN puts are
> returning "Error"
>
>
Mon Aug 10, 2015 8:40 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
For smfForceRecalculation, see the "Tips and FAQs" web page. There's a link
there to a write-up on the macro.
F9 doesn 't update all functions, so I never use it with SMF workbooks.
On Mon, Aug 10, 2015 at 8:28 AM, rr76012@.... wrote:
> This rchgetyahooquotes has always worked for me without any glitches, so,
> like you I hope this is temporary? I will keep my fingers crossed.
>
> 1. do you mean hit F9 or something else, for the smfForceRecalculation
> macro?
>
> 2. Internet Options are set up to always get a fresh copy of the web page.
>
> I am using Windows 8.1, and Internet Explorer 11.
>
> I looked under I.E. Tools -> Internet Options -> Advanced - > Browsing ->
> there is no check box for fresh copy of web page. But I have never had a
> problem until this morning and I have used your
> smf-template-rchgetyahooquotes.xls about every 2 days without any problems
> or glitches.
>
> Randy, pls tell me how to do the smfForceRecalculation - I will then do it.
>
>
there to a write-up on the macro.
F9 doesn 't update all functions, so I never use it with SMF workbooks.
On Mon, Aug 10, 2015 at 8:28 AM, rr76012@.... wrote:
> This rchgetyahooquotes has always worked for me without any glitches, so,
> like you I hope this is temporary? I will keep my fingers crossed.
>
> 1. do you mean hit F9 or something else, for the smfForceRecalculati
> macro?
>
> 2. Internet Options are set up to always get a fresh copy of the web page.
>
> I am using Windows 8.1, and Internet Explorer 11.
>
> I looked under I.E. Tools -> Internet Options -> Advanced - > Browsing ->
> there is no check box for fresh copy of web page. But I have never had a
> problem until this morning and I have used your
> smf-template-
> or glitches.
>
> Randy, pls tell me how to do the smfForceRecalculati
>
>
Mon Aug 10, 2015 8:40 am (PDT) . Posted by:
richqw
I'm getting this same problem, after years of no problems. I think something in Yahoo has changed.
I'm using the formula =rchgetyahooquotes("RSP","d1")
Going into the VBA code, this is looking for the url:
http://download.finance.yahoo.com/d/quotes.csv?s=rsp&f=d1&e=.ignore http://download.finance.yahoo.com/d/quotes.csv?s=rsp&f=d1&e=.ignore
As of right now, this url does not work.
I'm using the formula =rchgetyahooquotes("RSP","d1")
Going into the VBA code, this is looking for the url:
http://download.finance.yahoo.com/d/quotes.csv?s=rsp&f=d1&e=.ignore http://download.finance.yahoo.com/d/quotes.csv?s=rsp&f=d1&e=.ignore
As of right now, this url does not work.
Mon Aug 10, 2015 8:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
What is the formula returning?
On Mon, Aug 10, 2015 at 8:40 AM, richqw@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I'm getting this same problem, after years of no problems. I think
> something in Yahoo has changed.
>
> I'm using the formula =rchgetyahooquotes("RSP","d1")
>
On Mon, Aug 10, 2015 at 8:40 AM, richqw@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I'm getting this same problem, after years of no problems. I think
> something in Yahoo has changed.
>
> I'm using the formula =rchgetyahooquotes(
>
Mon Aug 10, 2015 9:01 am (PDT) . Posted by:
richqw
The url is returning code 400 and the code is going to the errorexit. The function returns the variable verror, which is set to "N/A"
Mon Aug 10, 2015 9:02 am (PDT) . Posted by:
jimexstock
Also having issues. Tried =rchgetyahooquotes("SPY") & it returns ERROR
Mon Aug 10, 2015 9:06 am (PDT) . Posted by:
rr76012
Hi Randy,
Now, like Jimexstock, using your template for smfgetyahooquotes, I too get an "ERROR" message instead of just blank?
rr76012
Now, like Jimexstock, using your template for smfgetyahooquotes, I too get an "ERROR" message instead of just blank?
rr76012
Mon Aug 10, 2015 8:36 am (PDT) . Posted by:
richqw
I'm getting this same problem, after years of no problems. I think something in Yahoo has changed.
I'm using the formula =rchgetyahooquotes("RSP","d1")
Going into the VBA code, this is looking for the url:
http://download.finance.yahoo.com/d/quotes.csv?s=rsp&f=d1&e=.ignore http://download.finance.yahoo.com/d/quotes.csv?s=rsp&f=d1&e=.ignore
As of right now, this url does not work.
I'm using the formula =rchgetyahooquotes("RSP","d1")
Going into the VBA code, this is looking for the url:
http://download.finance.yahoo.com/d/quotes.csv?s=rsp&f=d1&e=.ignore http://download.finance.yahoo.com/d/quotes.csv?s=rsp&f=d1&e=.ignore
As of right now, this url does not work.
Mon Aug 10, 2015 8:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just clicked on the URL you cited below, and it worked fine for me.
If you go to the summary page for RSP:
http://finance.yahoo.com/q?s=RSP
...what URL do you see for the "Download Data (delayed)" link toward the
right bottom of the web page? Does that link open up as a CSV file in EXCEL
for you? I see:
http://download.finance.yahoo.com/d/quotes.csv?s=RSP&f=sl1d1t1c1ohgv&e=.csv
...which more or less matches the link you have below. And, like I've said
on other messages, everything is working fine for me here.
On Mon, Aug 10, 2015 at 8:36 AM, richqw@... wrote:
>
> I'm getting this same problem, after years of no problems. I think
> something in Yahoo has changed.
>
> I'm using the formula =rchgetyahooquotes("RSP","d1")
>
> Going into the VBA code, this is looking for the url:
> http://download.finance.yahoo.com/d/quotes.csv?s=rsp&f=d1&e=.ignore
>
> As of right now, this url does not work.
>
>
If you go to the summary page for RSP:
http://finance.yahoo.com/q?s=RSP
...what URL do you see for the "Download Data (delayed)" link toward the
right bottom of the web page? Does that link open up as a CSV file in EXCEL
for you? I see:
http://download.finance.yahoo.com/d/quotes.csv?s=RSP&f=sl1d1t1c1ohgv&e=.csv
...which more or less matches the link you have below. And, like I've said
on other messages, everything is working fine for me here.
On Mon, Aug 10, 2015 at 8:36 AM, richqw@... wrote:
>
> I'm getting this same problem, after years of no problems. I think
> something in Yahoo has changed.
>
> I'm using the formula =rchgetyahooquotes("RSP","d1")
>
> Going into the VBA code, this is looking for the url:
> http://download.finance.yahoo.com/d/quotes.csv?s=rsp&f=d1&e=.ignore
>
> As of right now, this url does not work.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar