Rabu, 10 September 2014

[smf_addin] Digest Number 3173

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

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,
>

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.

Tue Sep 9, 2014 10:33 pm (PDT) . Posted by:

zbgb952

Hello Randy,

It appears that RCHGetElementNumber(ticker,848) is just returning 'error&#39; now. 848 is for the Zacks number. Pls advise. Thanks.




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