1 New Message

Digest #2740

Re: RCHGetYahooQuotes returns 0 by "dennis071" dennis071

Message

1a

Re: RCHGetYahooQuotes returns 0

Tue Aug 20, 2013 3:12 am (PDT) . Posted by:

"dennis071" dennis071

Thank you very much Randy. I got it working following your advice.
I appreciate it.

Thanks,
Dennis.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You can try either of:
>
> =smfConvertData(smfGetTagContent("http://finance.yahoo.com/q?s=
> "&D2,"span",0,"yfs_l84_"))
> =smfConvertData(smfGetTagContent("http://finance.yahoo.com/q?s=
> "&D2,"span",4,"rt_quote_summary"))
>
> The problem is the coding of that section of the web page can change,
> depending on whether it is pre-market, post-market, or while the market is
> open. Plus, Yahoo seems to change it over time as well, so even when I have
> it working consistently for the three situations, it stops working without
> notice.
>
> However, if you examine the source code of the web page, you should be able
> to change your search strings in the above functions as needed.
>
> On Fri, Aug 16, 2013 at 12:05 AM, dennis071 <dennis071@...> wrote:
>
> >
> > I am having an issue obtaining the current price for India stocks using
> > RCHGetYahooQuotes. Following is the formula I am using.
> > =RCHGetYahooQuotes("TATASTEEL.NS", "l1")
> >
> > For US stocks it is working fine.
> > Apparently the csv file available for download at the Yahoo site is
> > showing 0 as well, so I suspect it is an issue with the Yahoo site.
> >
> > My question is whether is there another way to obtain the current price
> > from the yahoo site?
> >
>