First, I failed to properly express my gratitude to you, Randy, in my prior post. The add-in that you created is tremendously useful. Thank you.

After a bit of trial and error, I found that =RCHGETYAHOOQUOTES(M25,"l1",,NOW(),) , where M25 is CAD=X, causes Excel to freeze intermittently while it attempts to pull data from q1.finance.vip.ac4.yahoo.com.

It's possible that some of the other SMF Add-in functions were also reaching out to that address and this is just the first one I've found.

Thanks again,
Heath

--- In smf_addin@yahoogroups.com, "Heath" <heath.winter@...> wrote:
>
> Hi,
>
> I looked for information on this error in previous posts, but didn't see anything. An excel spreadsheet is freezing intermittently. Windows Resource Monitor shows that Excel is waiting for a thread to finish network I/O. The thread is a connection to q1.finance.vip.ac4.yahoo.com.
>
> I disabled the RCHGETYAHOOQUOTES function from the spreadsheet, as a test, but the error persists. Is there another function that could be trying to send or receive data from q1.finance.vip.ac4.yahoo.com?
>
> Thanks!
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (13) . Top ^

1b

Re: Slow data feed from yahoo?

Thu Aug 16, 2012 8:17 am (PDT) . Posted by:

"friedman_steve" friedman_steve

Late on Tuesday, I actually heard that Verizon Fios was having problems (in NJ) connecting to certain sites. I'm aware of others using Fios having random problems with certain sites. Anyhow. all started working fine for me again the next day (after Verizon figured out there issues).

--- In smf_addin@yahoogroups.com, "friedman_steve" <friedman_steve@...> wrote:
>
> for what it's worth...my spreadsheets that I've used daily for a longtime (thanks Randy), aren't working as of this morning either [it has many formulas and just gets stuck calculating. if I set excel calculation on manual, and update just one cell, it sometimes work, and sometimes get frozen.
>
> Happening on 2 different computers at different locations (one Vista, one Windows 7... both have Verizon Fios. Looked to me like a Yahoo site issue. I've also noticed going directly to finance.yahoo.com site with my browser is getting stuck a lot too.
>
>
>
>
>
> --- In smf_addin@yahoogroups.com, "Bob" <rkd@> wrote:
> >
> > Having the same problem since this morning European time. Looks like maybe a slow feed from Yahoo using RCHGET as the same isn't evident on another application that I use which has a Yahoo API feed. Am just going to wait and see if it gets cured from the yahoo end.
> >
> > But any other input appreciated if someone has found a workround/fix.
> >
> > Thanks,
> >
> > Bob
> >
> > --- In smf_addin@yahoogroups.com, "Heath" <heath.winter@> wrote:
> > >
> > > Hi,
> > >
> > > I looked for information on this error in previous posts, but didn't see anything. An excel spreadsheet is freezing intermittently. Windows Resource Monitor shows that Excel is waiting for a thread to finish network I/O. The thread is a connection to q1.finance.vip.ac4.yahoo.com.
> > >
> > > I disabled the RCHGETYAHOOQUOTES function from the spreadsheet, as a test, but the error persists. Is there another function that could be trying to send or receive data from q1.finance.vip.ac4.yahoo.com?
> > >
> > > Thanks!
> > >
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (13) . Top ^

1c

Re: Slow data feed from yahoo?

Thu Aug 16, 2012 12:21 pm (PDT) . Posted by:

"nuno.nogueira" nuno.nogueira

Hi,

Thanks all for this information.

I guess it's a Yahoo Finance problem, since as of 2 days ago, my spreadsheet takes an eternity to update quotes.

--- In smf_addin@yahoogroups.com, "Heath" <heath.winter@...> wrote:
>
> First, I failed to properly express my gratitude to you, Randy, in my prior post. The add-in that you created is tremendously useful. Thank you.
>
> After a bit of trial and error, I found that =RCHGETYAHOOQUOTES(M25,"l1",,NOW(),) , where M25 is CAD=X, causes Excel to freeze intermittently while it attempts to pull data from q1.finance.vip.ac4.yahoo.com.
>
> It's possible that some of the other SMF Add-in functions were also reaching out to that address and this is just the first one I've found.
>
> Thanks again,
> Heath
>
> --- In smf_addin@yahoogroups.com, "Heath" <heath.winter@> wrote:
> >
> > Hi,
> >
> > I looked for information on this error in previous posts, but didn't see anything. An excel spreadsheet is freezing intermittently. Windows Resource Monitor shows that Excel is waiting for a thread to finish network I/O. The thread is a connection to q1.finance.vip.ac4.yahoo.com.
> >
> > I disabled the RCHGETYAHOOQUOTES function from the spreadsheet, as a test, but the error persists. Is there another function that could be trying to send or receive data from q1.finance.vip.ac4.yahoo.com?
> >
> > Thanks!
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (13) . Top ^

1d

Re: Slow data feed from yahoo?

Thu Aug 16, 2012 12:33 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I just tried the template from the files area and it's almost
instantaneous. I refreshed quotes several times with the same quick
response.

For those of you that have delays -- what kinds of quotes are you getting:
US stocks, foreign stocks, futures, currencies, delayed quotes, real-time
quotes, etc.?

On Thu, Aug 16, 2012 at 12:21 PM, nuno.nogueira
<nuno.nogueira35@gmail.com>wrote:

>
> Thanks all for this information.
>
> I guess it's a Yahoo Finance problem, since as of 2 days ago, my
> spreadsheet takes an eternity to update quotes.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (13) . Top ^

1e

Re: Slow data feed from yahoo?

Thu Aug 16, 2012 1:53 pm (PDT) . Posted by:

"nautilustech" nautilustech

> For those of you that have delays -- what kinds of quotes are you
> getting: US stocks, foreign stocks, futures, currencies, delayed
> quotes, real-time quotes, etc.?

U.S. stocks - current prices, ITM1, ITM2, ITM3, OTM1, option last price, ask and bid. About 6 stock symbols. It's taking about 10-15 minutes, sometimes a little faster.

Reply to sender . Reply to group . Reply via Web Post . All Messages (13) . Top ^

1f

Re: Slow data feed from yahoo?

Thu Aug 16, 2012 2:18 pm (PDT) . Posted by:

"kjtemplin" kjtemplin

I am having similar problems with Yahoo (this is not the first time they have done something to slow down the process and otherwise cause Excel to run erratically). I retrieve mostly delayed US stocks, ETF's and option quotes. This is very frustrating.

Ken

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I just tried the template from the files area and it's almost
> instantaneous. I refreshed quotes several times with the same quick
> response.
>
> For those of you that have delays -- what kinds of quotes are you getting:
> US stocks, foreign stocks, futures, currencies, delayed quotes, real-time
> quotes, etc.?
>
> On Thu, Aug 16, 2012 at 12:21 PM, nuno.nogueira
> <nuno.nogueira35@...>wrote:
>
> >
> > Thanks all for this information.
> >
> > I guess it's a Yahoo Finance problem, since as of 2 days ago, my
> > spreadsheet takes an eternity to update quotes.
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (13) . Top ^

1g

Re: Slow data feed from yahoo?

Thu Aug 16, 2012 2:26 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Well, the original message was on the RCHGetYahooQuotes() function, which
has nothing to do with options. RCHGetYahooQuotes() gets a CSV file, with
as much data as was requested in a single Internet access.

Options are retrieved on a web page by web page basis, which will be
slower. Even more so if there are more delays than normal in Yahoo
response time. For each stock and each time period, you need to get another
web page.

On Thu, Aug 16, 2012 at 1:53 PM, nautilustech <fwkirk@gmail.com> wrote:

> > For those of you that have delays -- what kinds of quotes are you
> > getting: US stocks, foreign stocks, futures, currencies, delayed
> > quotes, real-time quotes, etc.?
>
> U.S. stocks - current prices, ITM1, ITM2, ITM3, OTM1, option last price,
> ask and bid. About 6 stock symbols. It's taking about 10-15 minutes,
> sometimes a little faster.
>

On Thu, Aug 16, 2012 at 2:06 PM, kjtemplin <templin@mchsi.com> wrote:

> I am having similar problems with Yahoo (this is not the first time they
> have done something to slow down the process and otherwise cause Excel to
> run erratically). I retrieve mostly delayed US stocks, ETF's and option
> quotes. This is very frustrating.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (13) . Top ^

2a

Re: Getting Started with Stockcharts

Thu Aug 16, 2012 6:31 pm (PDT) . Posted by:

"blc6@ymail.com" blc6@ymail.com

Stockcharts agreement with their data provider is that they can not distribute the raw data. They do display a small portion of the data via the past data link but, it is only for debugging.

I got this from Chip Anderson while taking a class from them this summer.

--- In smf_addin@yahoogroups.com, "dice962" <derekbarrett@...> wrote:
>
> Hi all,
>
> I've been using the addon for a couple of years now and recommend it to everybody I know that trades their own stocks. Great job Randy for empowering so many people.
>
> I was strictly fundamental before, but now am starting to look at technicals, and looks like Stockcharts.com has every indicator I want right now.
>
> Is there a getting started or primer doc somewhere for pulling data from Stockcharts? I've searched through posts and looks like many in the group utilize the site alot, but am just looking for the 101 stuff.
>
> If this question has already answered a million times already, apologies in advance, and I will keep digging.
>
> Thanks !!!!
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . Top ^

3a

Re: StockScouter Rating

Fri Aug 17, 2012 12:04 am (PDT) . Posted by:

"clemer2001" clemer2001

MSN' StockScouter seems to change from time to time. At least I'm not able to retrieve the StockScouter Rating any more.

Any assistance appreciated! Also, the built-in function RCHGetElementNumber("MSFT",543} no longer appears to work. THANKS!

Note: Up until recently, I was using:
=RIGHT('smfGetTagContent("http://investing.money.msn.com/investments/stock-price?symbol="&A6&"&ocid=qbeb","span",-1,"How StockScouter Works"),15)

--- In smf_addin@yahoogroups.com, "Brendyn" <bsarnacki2000@...> wrote:
>
> If this will help anyone. I found this to work for getting the stockscouter rating number:
> =1*MID(smfGetTagContent("http://investing.money.msn.com/investments/stock-ratings?symbol="&A3,"p",0,"Stock Rating Summary"),100,2)
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

3b

Re: StockScouter Rating

Fri Aug 17, 2012 12:10 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I just tried element #543 with MSFT and it worked fine for me -- do you
have the updated element definitions from the "Works in Progress" folder?
MSN changed their website structure at the end of April.

On Fri, Aug 17, 2012 at 12:04 AM, clemer2001 <clemer2001@yahoo.com> wrote:

> MSN' StockScouter seems to change from time to time. At least I'm not
> able to retrieve the StockScouter Rating any more.
>
> Any assistance appreciated! Also, the built-in function
> RCHGetElementNumber("MSFT",543} no longer appears to work. THANKS!
>
> Note: Up until recently, I was using:
> =RIGHT('smfGetTagContent("
> http://investing.money.msn.com/investments/stock-price?symbol="&A6&"&ocid=qbeb","span",-1,"How
> StockScouter Works"),15)
>
> --- In smf_addin@yahoogroups.com, "Brendyn" <bsarnacki2000@...> wrote:
> >
> > If this will help anyone. I found this to work for getting the
> stockscouter rating number:
> > =1*MID(smfGetTagContent("
> http://investing.money.msn.com/investments/stock-ratings?symbol="&A3,"p",0,"Stock
> Rating Summary"),100,2)
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

3c

Re: StockScouter Rating

Fri Aug 17, 2012 12:37 am (PDT) . Posted by:

"nuno.nogueira" nuno.nogueira

I'm using SMF lite for US and European stocks and they all take a lot of time (10-15 seconds) to refresh.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I just tried element #543 with MSFT and it worked fine for me -- do you
> have the updated element definitions from the "Works in Progress" folder?
> MSN changed their website structure at the end of April.
>
> On Fri, Aug 17, 2012 at 12:04 AM, clemer2001 <clemer2001@...> wrote:
>
> > MSN' StockScouter seems to change from time to time. At least I'm not
> > able to retrieve the StockScouter Rating any more.
> >
> > Any assistance appreciated! Also, the built-in function
> > RCHGetElementNumber("MSFT",543} no longer appears to work. THANKS!
> >
> > Note: Up until recently, I was using:
> > =RIGHT('smfGetTagContent("
> > http://investing.money.msn.com/investments/stock-price?symbol="&A6&"&ocid=qbeb","span",-1,"How
> > StockScouter Works"),15)
> >
> > --- In smf_addin@yahoogroups.com, "Brendyn" <bsarnacki2000@> wrote:
> > >
> > > If this will help anyone. I found this to work for getting the
> > stockscouter rating number:
> > > =1*MID(smfGetTagContent("
> > http://investing.money.msn.com/investments/stock-ratings?symbol="&A3,"p",0,"Stock
> > Rating Summary"),100,2)
> >
>