Messages In This Digest (2 Messages)

1a.: Retrieving current news From: peteblack43
1b.: Re: Retrieving current news From: Randy Harmelink

View All Topics | Create New Topic

Messages

1a.: Retrieving current news

Posted by: "peteblack43" peteblack43@yahoo.com peteblack43

Sun May 22, 2011 7:45 am (PDT)

Hi Randy,

I have been looking for information on retrieving current news on
different tickers and found this in a really old message . Is this
possible using the RCHCreateComment() function? If not, any
suggestions?

Part of message - Message #485 - Sep 19, 2006

"Although I think the new RCHGetTableCell() and RCHGetWebData()
functions will do it fairly easily. Actually, I am using Yahoo's
company news RSS feeds to get the information for the companies I own.
When I created the RCHCreateComment() function, one item I considered
was to throw the Yahoo news into a comment that could be popped up when
the cell is hovered over."

Thank you for all your hard work.

PeteB

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
1b.: Re: Retrieving current news

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Mon May 23, 2011 12:43 am (PDT)

It would just be a matter of doing something like:

=RCHCreateComment("Dummy",0,,,,,,,"Line 1"&CHAR(10)&"Line 2"&CHAR(10)&"Line
3"&CHAR(10)&"Line 4")

The content of "Line1" thru "Line 4" could be what you need it to be. For
example:

=RCHCreateComment("Dummy",0,400,,,,,,
smfGetTagContent("
http://feeds.finance.yahoo.com/rss/2.0/headline?s=MMM&region=US&lang=en-US
","title",1,"<item")&CHAR(10)
&smfGetTagContent("
http://feeds.finance.yahoo.com/rss/2.0/headline?s=MMM&region=US&lang=en-US
","title",2,"<item")&CHAR(10)
&smfGetTagContent("
http://feeds.finance.yahoo.com/rss/2.0/headline?s=MMM&region=US&lang=en-US
","title",3,"<item")&CHAR(10)
&smfGetTagContent("
http://feeds.finance.yahoo.com/rss/2.0/headline?s=MMM&region=US&lang=en-US
","title",4,"<item"))

Or you could load up the comment with something like the "Business Summary"
from Yahoo:

=RCHCreateComment("Dummy",0,500,400,,,,,
smfGetTagContent("http://finance.yahoo.com/q/pr?s=MMM","p",1,">Business
Summary"))

On Sun, May 22, 2011 at 7:44 AM, peteblack43 <peteblack43@yahoo.com> wrote:

>
> I have been looking for information on retrieving current news on different
> tickers and found this in a really old message . Is this possible using the
> RCHCreateComment() function? If not, any suggestions?
>
> Part of message - Message #485 - Sep 19, 2006
>
> "Although I think the new RCHGetTableCell() and RCHGetWebData() functions
> will do it fairly easily. Actually, I am using Yahoo's company news RSS
> feeds to get the information for the companies I own. When I created the
> RCHCreateComment() function, one item I considered was to throw the Yahoo
> news into a comment that could be popped up when the cell is hovered over."
>
> Thank you for all your hard work.
>

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