Messages In This Digest (1 Message)

1a.: Re: extract headlines from Yahoo no longer works for me From: bob_cutillo

View All Topics | Create New Topic

Message

1a.: Re: extract headlines from Yahoo no longer works for me

Posted by: "bob_cutillo" bob.cutillo@yahoo.com bob_cutillo

Sat Aug 20, 2011 4:27 am (PDT)

Thank you for getting back so fast.
I'll look at getting the code you provided.

You asked why I wanted the code to execute within vba. I want to use vba because I have other information in the cell and when I 'hover' the cursor over that cell, I see the top 4 headlines which were stored in a comment field. Or that's the way it used to work for me.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> To tell the truth, I'm confused about what you're actually asking.
>
> Your formula worked fine for me using ticker MMM.
>
> To get the headlines from the summary page:
>
> =smfGetTagContent("http://finance.yahoo.com/q?s="&$B$3,"a",...row...,"Filter
> Headlines")
>
> ...varying "...row..." from 1 to n. I found this easily in the message
> archives searching on "Headline":
>
> http://finance.groups.yahoo.com/group/smf_addin/message/15149
>
> Why would you use VBA to set a formula or do a copy?
>
> On Fri, Aug 19, 2011 at 4:22 AM, bob_cutillo <bob.cutillo@...> wrote:
>
> > I use the following formula which I borrowed from one of the other posts at
> > SMF. I'm not sure why it stopped extracting headlines.
> > I'm running Windows XP, Excel 2003, and Stock Market Functions add-in,
> > Version 2.1.2010.08.02.
> >
> > I have 2 questions.
> > 1. How to get it to work to extract the headlines from Yahoo Summary page.
> > 2. I haven't been able to figure out how to put the Formula into a VBA
> > statement directly. e.g. Range("A1").Formula = ....
> >
> > Here is the vba code that executes it:
> > Range("NewsFormula").Copy Destination:=Range(MyColumnLetter &
> > (StocksBeginRow) & ":" & MyColumnLetter & IRAEndRow)
> >
> > This is the formula contained in Range("NewsFormula") Cell.
> >
> > =RCHCreateComment("Dummy",0,500,80,,,,,Stocks!$A3&CHAR(10)&smfGetTagContent("
> > http://feeds.finance.yahoo.com/rss/2.0/headline?region=US&lang=en-US&s=
> > "&Stocks!$A3,"title",1,"<item")&CHAR(10)&smfGetTagContent("
> > http://feeds.finance.yahoo.com/rss/2.0/headline?region=US&lang=en-US&s=
> > "&Stocks!$A3,"title",2,"<item")&CHAR(10)&smfGetTagContent("
> > http://feeds.finance.yahoo.com/rss/2.0/headline?region=US&lang=en-US&s=
> > "&Stocks!$A3,"title",3,"<item")&CHAR(10)&smfGetTagContent("
> > http://feeds.finance.yahoo.com/rss/2.0/headline?region=US&lang=en-US&s=
> > "&Stocks!$A3,"title",4,"<item")&CHAR(10))
> >
> > Thanks in advance
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)