Minggu, 27 Maret 2016

[smf_addin] Digest Number 3663

2 Messages

Digest #3663
1b
Re: Retrieving Info from Reuters by "Randy Harmelink" rharmelink

Messages

Sat Mar 26, 2016 5:20 pm (PDT) . Posted by:

lawleesh

Hi Randy


Could you pls help me with the formula to retrieve from http://www.reuters.com/finance/stocks/overview?symbol=SIAL.SI


1. Price - 11.47
2. Date of last close - 24 Mar 2016
3. Avg. Vol - 1,461,237
4. 52-wk High - $12.24
5. 52-wk Low - $9.57
6. Market Cap(Mil.): $13,762.29



thanks so much


Sat Mar 26, 2016 7:12 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfGetTagContent("
http://www.reuters.com/finance/stocks/overview?symbol=SIAL.SI
","span",-3,"nasdaqChangeTime",,,,1)

=smfGetTagContent("
http://www.reuters.com/finance/stocks/overview?symbol=SIAL.SI
","span",-1,"nasdaqChangeTime")

=smfGetTagContent("
http://www.reuters.com/finance/stocks/overview?symbol=SIAL.SI","span",1,">Avg.
Vol",,,,1)

=smfGetTagContent("
http://www.reuters.com/finance/stocks/overview?symbol=SIAL.SI","span",1,">52-wk
High",,,,1)

=smfGetTagContent("
http://www.reuters.com/finance/stocks/overview?symbol=SIAL.SI","span",1,">52-wk
Low",,,,1)

=smfGetTagContent("
http://www.reuters.com/finance/stocks/overview?symbol=SIAL.SI","td",1,">Market
Cap",,,,1)

On Sat, Mar 26, 2016 at 5:20 PM, lawrence.leesh@... wrote:

> Could you pls help me with the formula to retrieve from
> http://www.reuters.com/finance/stocks/overview?symbol=SIAL.SI
>
> 1. Price - 11.47
>
> 2. Date of last close - 24 Mar 2016
>
> 3. Avg. Vol - 1,461,237
>
> 4. 52-wk High - $12.24
>
> 5. 52-wk Low - $9.57
>
> 6. Market Cap(Mil.): $13,762.29
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar