Selasa, 05 Maret 2013

[smf_addin] Digest Number 2532

8 New Messages

Digest #2532

Messages

Mon Mar 4, 2013 5:19 am (PST) . Posted by:

"Pete" petekoch

Randy, you exposed a mistake I was making using AdvFN -- I was pulling down Operating Revenue, not Total Revenue (wrong element). You are correct: Total Revenue is the same on AdvFN and M*.

But, if you plug in PFE on AdvFN (either directly on the website or with an SMF element), the FY 2012 income statement is just fine, but the balance sheet items and the cash flow statement items are completely missing. This happens often and usually to companies within the same sector at the same time. E.g., MRK's balance sheet items are also missing for FY 2012. It seems that all companies within the sector will get updated together. This lack of timeliness (the data appears to be available from most other data suppliers) is my main gripe with AdvFN. The 10-year view is a BIG positive.

Mon Mar 4, 2013 12:38 pm (PST) . Posted by:

"sean" seanlink7

For the function =smfGetTagContent("http://finance.yahoo.com/q?s="&$B$3,"a",...row...,"Filter
> Headlines")and again you can use MMM as symbol...is it possible to have the content pull the name of the article and have the hyperlink to directly to it?

--- In smf_addin@yahoogroups.com, Randy Harmelink 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 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,"
> http://feeds.finance.yahoo.com/rss/2.0/headline?region=US&lang=en-US&s=
> > "&Stocks!$A3,"title",2,"
> http://feeds.finance.yahoo.com/rss/2.0/headline?region=US&lang=en-US&s=
> > "&Stocks!$A3,"title",3,"
> http://feeds.finance.yahoo.com/rss/2.0/headline?region=US&lang=en-US&s=
> > "&Stocks!$A3,"title",4,"
>
> > Thanks in advance
> >
>

Mon Mar 4, 2013 1:27 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I think this would get the links:

=smfStrExtr(smfGetTagContent("http://finance.yahoo.com/q?s="&$B$3,"li",...row...,"Filter
Headlines"),"""","""")

If you want to make a clickable link out of it, just use EXCEL's
HYPERLINK() function.

On Mon, Mar 4, 2013 at 1:37 PM, sean seanlink7@gmail.com> wrote:

> For the function =smfGetTagContent("http://finance.yahoo.com/q?s=
> "&$B$3,"a",...row...,"Filter
> > Headlines")and again you can use MMM as symbol...is it possible to have
> the content pull the name of the article and have the hyperlink to directly
> to it?
>

Mon Mar 4, 2013 3:16 pm (PST) . Posted by:

"sean" seanlink7

Thanks!! Any way I can use my own personal Filters for the headlines. IE Have my filter for my yahoo account set to not pick up any Mootley fool articles...Any way that can translate into this add in?

--- In smf_addin@yahoogroups.com, Randy Harmelink wrote:
>
> I think this would get the links:
>
> =smfStrExtr(smfGetTagContent("http://finance.yahoo.com/q?s="&$B$3,"li",...row...,"Filter
> Headlines"),"""","""")
>
> If you want to make a clickable link out of it, just use EXCEL's
> HYPERLINK() function.
>
> On Mon, Mar 4, 2013 at 1:37 PM, sean wrote:
>
> > For the function =smfGetTagContent("http://finance.yahoo.com/q?s=
> > "&$B$3,"a",...row...,"Filter
> > > Headlines")and again you can use MMM as symbol...is it possible to have
> > the content pull the name of the article and have the hyperlink to directly
> > to it?
> >
>

Mon Mar 4, 2013 3:41 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Only by blanking out those items if you retrieve them...

But nothing proactive that I'm aware of.

On Mon, Mar 4, 2013 at 4:16 PM, sean seanlink7@gmail.com> wrote:

> Thanks!! Any way I can use my own personal Filters for the headlines. IE
> Have my filter for my yahoo account set to not pick up any Mootley fool
> articles...Any way that can translate into this add in?
>

Mon Mar 4, 2013 1:14 pm (PST) . Posted by:

"scaee" scaee

I tried this also and have been successful for the most part but I found that there were some symbols that gave me an Error. An example of this is where cell A4 = AAPL for Apple. On the yahoo page, there is clearly a next earnings date but I can't seem to pull it. Is there something I'm overlooking?

Thanks

--- In smf_addin@yahoogroups.com, "andyha8" wrote:
>
> Works like a charm! Thankyou!
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink wrote:
> >
> > This is just a normal EXCEL operation of concatenation:
> >
> > =RCHGetTableCell("http://finance.yahoo.com/q?s="&A4,1,"Next Earnings
> > Date:",,,,0)
> >
> > On Wed, Feb 27, 2013 at 11:13 AM, andyha8 wrote:
> >
> > >
> > > I want to get the next earnings date for a list of stocks.
> > >
> > > In excel, I have a list of tickers in cells A1-A12
> > >
> > > Is there a way to use this formula:
> > >
> > > =RCHGetTableCell("http://finance.yahoo.com/q?s=BAC&ql=1",1,"Next Earnings
> > > Date:",,,,0)
> > >
> > > to get the ticker from the cells instead of having to write the ticker
> > > into the formula every time?
> > >
> >
>

Mon Mar 4, 2013 1:20 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

This works fine for me with AAPL in cell A4:

=RCHGetTableCell("http://finance.yahoo.com/q?s="&A4,1,"Next Earnings Date:")

On Mon, Mar 4, 2013 at 1:46 PM, scaee thevino@gmail.com> wrote:

> I tried this also and have been successful for the most part but I found
> that there were some symbols that gave me an Error. An example of this is
> where cell A4 = AAPL for Apple. On the yahoo page, there is clearly a next
> earnings date but I can't seem to pull it. Is there something I'm
> overlooking?
>

Tidak ada komentar:

Posting Komentar