5 New Messages
Digest #2650
Messages
Sat Jun 8, 2013 5:50 am (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
i found this code
=SUBSTITUTE(SUBSTITUTE(smfGetTagContent("http://www.reuters.com/finance/stocks/keyDevelopments?symbol= "&$A$1,"div",1,"LATEST KEY DEVELOPMENTS"),"<p>",""),"</p>",CHAR(13)&CHAR(13))
to be useful
what i did is i changed the number ''1'' to 2,3,4,5 to extract the different row of news
however, is there a way i can get rid of the junk hyperlink such as
<div class=''feature''> <h2>...
please refer to the url to see the pictures
http://imageshack.us/photo/my-images/594/68044949.jpg/
http://imageshack.us/photo/my-images/89/61176267z.jpg/
i just want to display the article
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Check out this template in the files area:
>
> RCHGetWebData-Template-Reuters-Key-Developments.xls
>
> I used a cascading extraction, with RCHGetWebData(). That template had
> stopped working some time back, so I had moved it to the "Works in Progress"
> folder until I could take a look at it. Turned out to be a relatively easy
> fix, so I just uploaded the changes.
>
> On Tue, Jan 4, 2011 at 9:21 AM, timdbui <timdbui@...> wrote:
>
> > Hi Randy,
> >
> > I am trying to get the text from "Latest Key Developments" page of Reuters
> > by using this code:
> >
> > =SUBSTITUTE(SUBSTITUTE(smfGetTagContent("
> > http://www.reuters.com/finance/stocks/keyDevelopments?symbol= "&$A$1,"div",1,"LATEST
> > KEY DEVELOPMENTS"),"<p>",""),"</p>",CHAR(13)&CHAR(13))
> >
> > ($A$1 is the cell for ticter)
> >
> > Source:
> > http://www.reuters.com/finance/stocks/keyDevelopments?symbol=VFC&pn=2
> >
> > However it only return 1 piece of news. Could you show me how to get the
> > whole page in to Excel? Thanks so much for your help!
> >
> > Tim
> >
>
i found this code
=SUBSTITUTE(
to be useful
what i did is i changed the number ''1&#
however, is there a way i can get rid of the junk hyperlink such as
<div class='&#
please refer to the url to see the pictures
http://imageshack.
http://imageshack.
i just want to display the article
--- In smf_addin@yahoogrou
>
> Check out this template in the files area:
>
> RCHGetWebData-
>
> I used a cascading extraction, with RCHGetWebData(
> stopped working some time back, so I had moved it to the "Works in Progress"
> folder until I could take a look at it. Turned out to be a relatively easy
> fix, so I just uploaded the changes.
>
> On Tue, Jan 4, 2011 at 9:21 AM, timdbui <timdbui@
>
> > Hi Randy,
> >
> > I am trying to get the text from "Latest Key Developments" page of Reuters
> > by using this code:
> >
> > =SUBSTITUTE(
> > http://www.reuters.
> > KEY DEVELOPMENTS"
> >
> > ($A$1 is the cell for ticter)
> >
> > Source:
> > http://www.reuters.
> >
> > However it only return 1 piece of news. Could you show me how to get the
> > whole page in to Excel? Thanks so much for your help!
> >
> > Tim
> >
>
Sat Jun 8, 2013 8:30 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but I don't have a function to strip out the HTML tags. I normally
use SUBSTITUTE(), but it looks like you have a number of them...
On Sat, Jun 8, 2013 at 5:50 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> i found this code
>
> =SUBSTITUTE(SUBSTITUTE(smfGetTagContent("
> http://www.reuters.com/finance/stocks/keyDevelopments?symbol= "&$A$1,"div",1,"LATEST
> KEY DEVELOPMENTS"),"<p>",""),"</p>",CHAR(13)&CHAR(13))
>
> to be useful
>
> what i did is i changed the number ''1'' to 2,3,4,5 to extract the
> different row of news
>
> however, is there a way i can get rid of the junk hyperlink such as
>
> <div class=''feature''> <h2>...
>
> please refer to the url to see the pictures
>
> http://imageshack.us/photo/my-images/594/68044949.jpg/
> http://imageshack.us/photo/my-images/89/61176267z.jpg/
>
> i just want to display the article
>
use SUBSTITUTE()
On Sat, Jun 8, 2013 at 5:50 AM, weekeewawa <weekeewawa@yahoo.
>
> i found this code
>
> =SUBSTITUTE(
> http://www.reuters.
> KEY DEVELOPMENTS"
>
> to be useful
>
> what i did is i changed the number ''1&#
> different row of news
>
> however, is there a way i can get rid of the junk hyperlink such as
>
> <div class='&#
>
> please refer to the url to see the pictures
>
> http://imageshack.
> http://imageshack.
>
> i just want to display the article
>
Sat Jun 8, 2013 11:53 am (PDT) . Posted by:
"oryxius" oryxius
Is anyone able to get the Fortune 500 list with ticker symbols? CNN has the list but without the tickers...
Sat Jun 8, 2013 11:42 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not all companies are publicly traded. I couldn't find a list, but I was
able to extract a list from the CNN website. See:
http://finance.groups.yahoo.com/group/smf_addin/files/Requested%20Samples/Fortune-500.html
On Sat, Jun 8, 2013 at 11:52 AM, oryxius <oryxius@yahoo.com > wrote:
> Is anyone able to get the Fortune 500 list with ticker symbols? CNN has
> the list but without the tickers...
>
able to extract a list from the CNN website. See:
http://finance.
On Sat, Jun 8, 2013 at 11:52 AM, oryxius <oryxius@yahoo.
> Is anyone able to get the Fortune 500 list with ticker symbols? CNN has
> the list but without the tickers...
>
Sun Jun 9, 2013 12:26 am (PDT) . Posted by:
"oryxius" oryxius
Thank you Randy! This is quite helpful.
MK
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Not all companies are publicly traded. I couldn't find a list, but I was
> able to extract a list from the CNN website. See:
>
> http://finance.groups.yahoo.com/group/smf_addin/files/Requested%20Samples/Fortune-500.html
>
> On Sat, Jun 8, 2013 at 11:52 AM, oryxius <oryxius@...> wrote:
>
> > Is anyone able to get the Fortune 500 list with ticker symbols? CNN has
> > the list but without the tickers...
> >
>
MK
--- In smf_addin@yahoogrou
>
> Not all companies are publicly traded. I couldn't find a list, but I was
> able to extract a list from the CNN website. See:
>
> http://finance.
>
> On Sat, Jun 8, 2013 at 11:52 AM, oryxius <oryxius@
>
> > Is anyone able to get the Fortune 500 list with ticker symbols? CNN has
> > the list but without the tickers...
> >
>
Tidak ada komentar:
Posting Komentar