Messages In This Digest (7 Messages)

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

2a.: Grab Tickers from Morningstar From: nate_lalala
2b.: Re: Grab Tickers from Morningstar From: Randy Harmelink

3a.: Re: 5y Tax Cost Ratio From: nate_lalala

4a.: Volume From: lexstar
4b.: Re: Volume From: Randy Harmelink

View All Topics | Create New Topic

Messages

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

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

Fri Aug 19, 2011 4:23 am (PDT)

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 (2)
1b.: Re: extract headlines from Yahoo no longer works for me

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

Fri Aug 19, 2011 8:55 am (PDT)

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@yahoo.com> 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 (2)

2a.: Grab Tickers from Morningstar

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

Fri Aug 19, 2011 2:41 pm (PDT)

Hello,

Thanks for this wonderful tool - it has been very helpful!

I would like to grab the top 10 or so tickers from this page: http://screen.morningstar.com/FundSearch/FundRank.html?fundCategory=all&screen=tr5yr

But I can't seem to find a way to do so...

Even doing something simple like: =RCHGetTableCell("http://screen.morningstar.com/FundSearch/FundRank.html?fundCategory=all&screen=tr5yr",1,"Tocqueville Gold")

returns an error.

Is it possible to grab the tickers from this url?

Thanks,
Nathan

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.: Re: Grab Tickers from Morningstar

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

Fri Aug 19, 2011 4:07 pm (PDT)

This works for me:

=RCHGetHTMLTable("
http://screen.morningstar.com/FundSearch/FundRank.html?fundCategory=all&screen=tr5yr
",
"Highest Returning",-1,"",1)

...or, to get the individual table cells:

=RCHGetTableCell("
http://screen.morningstar.com/FundSearch/FundRank.html?fundCategory=all&screen=tr5yr
",
column,">Ticker",,,,row)

...where "row" varies from 2 to n, and "column" is 1, 2, or 4.

However, since it is a subscription-level web page, you do need to create
your security cookie first, either by logging in with the EXCEL Web Query
dialog (preferred) or with IE. I suspect that was your problem. You may need
to run the smfForceRecalculation macro to purge the web page you retrieved
before logging in, if you haven't exited EXCEL since trying it before.

See the "Links" area of the group for info on the macro and security
cookies.

On Fri, Aug 19, 2011 at 2:41 PM, nate_lalala <nate_lalala@yahoo.com> wrote:

>
> I would like to grab the top 10 or so tickers from this page:
> http://screen.morningstar.com/FundSearch/FundRank.html?fundCategory=all&screen=tr5yr
>
> But I can't seem to find a way to do so...
>
> Even doing something simple like: =RCHGetTableCell("
> http://screen.morningstar.com/FundSearch/FundRank.html?fundCategory=all&screen=tr5yr",1,"Tocqueville
> Gold")
>
> returns an error.
>
> Is it possible to grab the tickers from this url?
>

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

3a.: Re: 5y Tax Cost Ratio

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

Fri Aug 19, 2011 2:46 pm (PDT)

Great thanks, that works fine.

-Nathan

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Sorry, but data cannot be extracted from that web page -- the data is
> displayed dynamically instead of being delivered within the source code of
> the web page.
>
> However, you can extract data from the "Print" versions of the web page, but
> they aren't as detailed. For example, it doesn't contain the 1-year value
> you want, but does have the 3-year average:
>
> =RCHGetTableCell("
> http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=PRWCX",1,">Tax
> Cost Ratio")
>
> On Thu, Aug 18, 2011 at 11:59 AM, nate_lalala <nate_lalala@...> wrote:
>
> > I am also interested in getting the tax cost ratio, but all I get is an
> > error
> >
> > =RCHGetTableCell("
> > http://quicktake.morningstar.com/FundNet/Tax.aspx?Symbol=PRWCX",5,"Tax
> > Cost Ratio","PRWCX")
> >
> > I want to return .68
> >
> > Tax Cost Ratio
> > PRWCX â€" â€" â€" â€" 0.68
> >
> > Any ideas?
> >
>

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

4a.: Volume

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

Fri Aug 19, 2011 6:37 pm (PDT)

Anyone know how to retrieve the monthly volume for a specific security?

For example, volume of DBC for the month of June 2006, or volume for IBM for month of January 2009.

Thanks.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4b.: Re: Volume

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

Fri Aug 19, 2011 7:14 pm (PDT)

Try the smfPricesBetween() function -- for example:

=smfPricesBetween("DBC",DATE(2006,6,1),DATE(2006,6,30),"09")

On Fri, Aug 19, 2011 at 6:37 PM, lexstar <lexstar@yahoo.com> wrote:

> Anyone know how to retrieve the monthly volume for a specific security?
>
> For example, volume of DBC for the month of June 2006, or volume for IBM
> for month of January 2009.
>

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

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

MARKETPLACE

A bad score is 598. A bad idea is not checking yours, at freecreditscore.com.

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

EXCEL FEED

Sabtu, 20 Agustus 2011

[smf_addin] Digest Number 1929

Messages In This Digest (7 Messages)

Messages

extract headlines from Yahoo no longer works for me

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

Fri Aug 19, 2011 4:23 am (PDT)

Re: extract headlines from Yahoo no longer works for me

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

Fri Aug 19, 2011 8:55 am (PDT)

Grab Tickers from Morningstar

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

Fri Aug 19, 2011 2:41 pm (PDT)

Re: Grab Tickers from Morningstar

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

Fri Aug 19, 2011 4:07 pm (PDT)

Re: 5y Tax Cost Ratio

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

Fri Aug 19, 2011 2:46 pm (PDT)

Volume

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

Fri Aug 19, 2011 6:37 pm (PDT)

Re: Volume

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

Fri Aug 19, 2011 7:14 pm (PDT)

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me