5 Messages
Digest #3173
Messages
Tue Sep 9, 2014 9:26 am (PDT) . Posted by:
ronaldutrecht
Hello,
Does anyone know where to find the overview of they Yahoo stock tickers?
Thanks in advance,
Ronald
Does anyone know where to find the overview of they Yahoo stock tickers?
Thanks in advance,
Ronald
Tue Sep 9, 2014 9:30 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not sure what you're asking? If you mean a comprehensive list of all of the
ticker symbols, I'm not aware of one. And it would change almost daily
anyway.
On Tue, Sep 9, 2014 at 9:12 AM, r.kok@... wrote:
>
> Does anyone know where to find the overview of they Yahoo stock tickers?
>
> Thanks in advance,
>
ticker symbols, I'm not aware of one. And it would change almost daily
anyway.
On Tue, Sep 9, 2014 at 9:12 AM, r.kok@... wrote:
>
> Does anyone know where to find the overview of they Yahoo stock tickers?
>
> Thanks in advance,
>
Tue Sep 9, 2014 5:10 pm (PDT) . Posted by:
gshell422
Interesting. When I changed the smf command to the following:
=smfConvertData(smfGetTagContent("http://finance.yahoo.com/marketupdate/overview","span",-1,"_l84_^dji"
The cell displayed:
<span class='Fw-500 C-n'>17,013.87
Correct value, but a bunch of extra crap.
I extracted the value from the right side of the text string and then converted it to a number via the following:
=VALUE(RIGHT(smfConvertData(smfGetTagContent("http://finance.yahoo.com/marketupdate/overview","span",-1,"_l84_^dji")),9))
This should work as long as the DOW value is above 9,999.99 and below 99,999.99, or until Yahoo changes something else.
Thanks for your help.
=smfConvertData(smfGetTagContent("http://finance.yahoo.com/marketupdate/overview","span",-1,"_l84_^dji"
The cell displayed:
<span class='Fw-500 C-n'>17,013.87
Correct value, but a bunch of extra crap.
I extracted the value from the right side of the text string and then converted it to a number via the following:
=VALUE(RIGHT(smfConvertData(smfGetTagContent("http://finance.yahoo.com/marketupdate/overview","
This should work as long as the DOW value is above 9,999.99 and below 99,999.99, or until Yahoo changes something else.
Thanks for your help.
Tue Sep 9, 2014 10:33 pm (PDT) . Posted by:
zbgb952
Hello Randy,
It appears that RCHGetElementNumber(ticker,848) is just returning 'error' now. 848 is for the Zacks number. Pls advise. Thanks.
It appears that RCHGetElementNumber
Tue Sep 9, 2014 11:08 pm (PDT) . Posted by:
zbgb952
Just tried it again and it worked this time. Zacks must have been working on their website.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar