Selasa, 09 September 2014

[smf_addin] Digest Number 3172

6 Messages

Digest #3172
1a
Re: Index Quotes by gshell422
1b
Re: Index Quotes by "Randy Harmelink" rharmelink
1c
Re: Index Quotes by gshell422
1d
Re: Index Quotes by "Randy Harmelink" rharmelink
2a
2b
Re: Navellier Stock Grade by "Randy Harmelink" rharmelink

Messages

Mon Sep 8, 2014 6:28 am (PDT) . Posted by:

gshell422

Randy,


It appears Yahoo has changed their site again and the last command line you provided to get the DJI quote has quit working.


=smfConvertData(smfGetTagContent("http://finance.yahoo.com/marketupdate/overview","span",-1,"_^dji"))


No longer works.


I can see that apparently Yahoo has renamed some of the web pages and I tried editing to the following, but it returns a "0.00"


=smfConvertData(smfGetTagContent("http://finance.yahoo.com/market-overview/","span",-1,"_^dji"))


Any suggestions?


Where can I find an explanation of the syntax for this command so that I can have better luck at fixing it myself as Yahoo changes things?


Thanks

Mon Sep 8, 2014 9:53 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The formula is working fine here...

You basically have to look at the source code of the web page. In this case:

<span class="Fz-xl"><span class="l84"
id="yfs_l84_^dji">17,123.94</span></span>

So, the function looks for the "_^dji" string above, then backs up to the
beginning of that span (i.e. "span" and -1), then extract the data from
that span tag and converts it to a number (if possible).

On Mon, Sep 8, 2014 at 6:28 AM, gshell422@... wrote:

>
> It appears Yahoo has changed their site again and the last command line
> you provided to get the DJI quote has quit working.
>
> =smfConvertData(smfGetTagContent("
> http://finance.yahoo.com/marketupdate/overview","span",-1,"_^dji"))
>
> No longer works.
>
> I can see that apparently Yahoo has renamed some of the web pages and I
> tried editing to the following, but it returns a "0.00"
>
> =smfConvertData(smfGetTagContent("
> http://finance.yahoo.com/market-overview/","span",-1,"_^dji"))
>
> Any suggestions?
>
> Where can I find an explanation of the syntax for this command so that I
> can have better luck at fixing it myself as Yahoo changes things?
>
>

Mon Sep 8, 2014 6:05 pm (PDT) . Posted by:

gshell422

Randy,


The source code presently reads:


<dd class="ticker-price Mt-4">
<span class="Fz-xl"><span class="l84" id="yfs_l84_^dji">17,111.42</span></span>
<span class="Fz-m yfi-price-change-red"><span class="c63" id="yfs_c63_^dji">-25.94</span></span>
<span class="Fz-m yfi-price-change-red"><span class="p43" id="yfs_p43_^dji">(0.15%)</span></span>
</dd>


For some reason, all of a sudden, when I use the following in my Excel program


=smfConvertData(smfGetTagContent("http://finance.yahoo.com/marketupdate/overview","span",-1,"_^dji"))


The cell shows the following:


<span class='yfi-price-change-red Fw-500'>-0.15%

Any suggestions?

Mon Sep 8, 2014 6:12 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The only thing I can think of is that Yahoo is serving you up different
source code for some reason. I don't understand why it would pick up the
"span" tag it apparently is.

You could try clarifying the search string further, with:

=smfConvertData(smfGetTagContent("
http://finance.yahoo.com/marketupdate/overview","span",-1,"_l84_^dji"))

On Mon, Sep 8, 2014 at 6:05 PM, gshell422@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> The source code presently reads:
>
> <dd class="ticker-price Mt-4">
>
> <span class="Fz-xl"><span class="l84" id="yfs_l84_^dji">17,111.42</
> span></span>
>
> <span class="Fz-m yfi-price-change-red"><span class="c63" id
> ="yfs_c63_^dji">-25.94</span></span>
>
> <span class="Fz-m yfi-price-change-red"><span class="p43" id
> ="yfs_p43_^dji">(0.15%)</span></span>
>
> </dd>
>
> For some reason, all of a sudden, when I use the following in my Excel
> program
>
> =smfConvertData(smfGetTagContent("
> http://finance.yahoo.com/marketupdate/overview","span",-1,"_^dji"))
>
> The cell shows the following:
>
> *<span class='yfi-price-change-red Fw-500'>-0.15%*
>
> Any suggestions?
>

Mon Sep 8, 2014 9:10 pm (PDT) . Posted by:

carmine288

Looks their data can no longer be captured.


This appears broken:


=RCHGetTableCell("http://www.navellier.com/tools_research/view_stock_grade.aspx?Symbol="&$C2,2,">"&$C2&";<",,,,,"</table",,"-")


Where C2=IBM

Tue Sep 9, 2014 1:06 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

They have changed the site. You now need to log in and create the IE
security cookie before you can access the data. This worked for me for the
total stock grade after I created the IE security cookie:

=RCHGetTableCell("
http://navelliergrader.com/view_stock_grade.aspx?Symbol=MMM",2,"
finance.yahoo.com/q")

On Mon, Sep 8, 2014 at 9:10 PM, carmine.nicoletta@...wrote:

> Looks their data can no longer be captured.
>
> This appears broken:
>
> =RCHGetTableCell("
> http://www.navellier.com/tools_research/view_stock_grade.aspx?Symbol=
> "&$C2,2,">"&$C2&";<",,,,,"</table",,"-")
>
> Where C2=IBM
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar