[smf_addin] Digest Number 3104

EXCEL Stock Market Functions Add-in Group

6 Messages

Digest #3104

1a

Extracting news headlines from Reuters by lawleesh

1b

Re: Extracting news headlines from Reuters by "Randy Harmelink" rharmelink

1c

Re: Extracting news headlines from Reuters by lawleesh

1d

Re: Extracting news headlines from Reuters by "Randy Harmelink" rharmelink

1e

Re: Extracting news headlines from Reuters by lawleesh

2a

Re: I think Google changed to https by "Randy Harmelink" rharmelink

Messages

1a

Extracting news headlines from Reuters

Thu Jun 26, 2014 2:57 am (PDT) . Posted by:

lawleesh

Hi Randy


Is there a way to extract news headlines from reuters page such as this one?


http://www.reuters.com/finance/stocks/companyNews?symbol=IJML.KL http://www.reuters.com/finance/stocks/companyNews?symbol=IJML.KL



thanks


LL

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

1b

Re: Extracting news headlines from Reuters

Thu Jun 26, 2014 8:20 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Quick and Dirty, you can try:

=smfGetTagContent(...url...,"a",..counter...,"id=""companyNews""")

...using your URL for "...url..." and varying "...counter..." from 1 to n.
This will get what you need, plus some extras. It would take a lot of work
to figure out all the possible patterns and extract the data more neatly.

On Thu, Jun 26, 2014 at 2:57 AM, lawrence.leesh@... wrote:

> Is there a way to extract news headlines from reuters page such as this
> one?
>
> http://www.reuters.com/finance/stocks/companyNews?symbol=IJML.KL
>
>

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

1c

Re: Extracting news headlines from Reuters

Thu Jun 26, 2014 6:40 pm (PDT) . Posted by:

lawleesh

Hi Randy

I got an error with this entry
=smfGetTagContent("http://www.reuters.com/finance/stocks/companyNews?symbol=IJM.KL","a",1,"id=""companyNews";"")



Did you manage to get something on your end?


regards


LL

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

1d

Re: Extracting news headlines from Reuters

Thu Jun 26, 2014 7:19 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Your formula gives me an error as well, because your ticker symbol isn't a
valid one. However, this:

=smfGetTagContent("
http://www.reuters.com/finance/stocks/companyNews?symbol=IJML.KL
","a",1,"id=""companyNews""")

...give me this:

Malaysia's IJM Corp to privatize IJM Land for $619 mln

On Thu, Jun 26, 2014 at 6:40 PM, lawrence.leesh@... wrote:

>
> I got an error with this entry
> =smfGetTagContent("
> http://www.reuters.com/finance/stocks/companyNews?symbol=IJM.KL
> ","a",1,"id=""companyNews";"")
>
> Did you manage to get something on your end?
>
>

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

1e

Re: Extracting news headlines from Reuters

Thu Jun 26, 2014 7:43 pm (PDT) . Posted by:

lawleesh

Thanks Randy.

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

2a

Re: I think Google changed to https

Thu Jun 26, 2014 8:11 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Working fine for me here, although it does appear to do the redirection.

See this thread and its resolution:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/25976

On Wed, Jun 25, 2014 at 11:46 PM, dolce7ss@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> getelement only works if I manually edit to https from http for google
> finance elements
>
> Might need to update SMF file
> Please confirm?
>

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

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 60

• Privacy • Unsubscribe • Terms of Use