2 Messages

Digest #3663

Retrieving Info from Reuters by lawleesh

Re: Retrieving Info from Reuters by "Randy Harmelink" rharmelink

Messages

1a

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

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: Retrieving Info from Reuters

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