6 Messages
Digest #3172
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
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/","
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?
>
>
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/","
>
> 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?
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","
The cell shows the following:
<span class='yfi-
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?
>
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","
>
> The cell shows the following:
>
> *<span class='yfi-
>
> 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
This appears broken:
=RCHGetTableCell("http://www.navellier.com/tools_research/view_stock_grade.aspx?Symbol="&$C2,2,
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
>
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,
>
> Where C2=IBM
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar