3 New Messages
Digest #2318
| |
Messages
Sat Aug 18, 2012 6:21 am (PDT) . Posted by:
"rr76012" rr76012
Hi Randy,
Here is a link, http://finance.yahoo.com/q/ao?s=EXC+Analyst+Opinion
It is located Yahoo left side , Analyst Coverage, then under Analyst Opinions.
Randy, just as a suggestion. in your updates, could you possibly build this into rchgetelementnumber( , )?
I bet this would be very helpful to everyone?
Thanks for all that you do.
rr76012
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> That table and those items are probably new since I did the element
> numbers. Actually, it looks like there are no elements from that page. I
> wonder if the entire page is new.
>
> In any case, you can just use the RCHGetTableCell() function for the data.
> For example:
>
> =RCHGetTableCell("http://finance.yahoo.com/q/ao?s=MMM ",1,">Price Target
> Summary","Mean Target")
>
> On Fri, Aug 17, 2012 at 11:07 AM, rr76012 <rr76012@...> wrote:
>
> > re: Yahoo Analyst Opinion
> >
> > Hello Randy,
> >
> > I have looked, but I may have overlooked rchgetelementnumber numbers for
> > the Yahoo Analyst Opinions on Price Target Summary, are there
> > rchgetelementnumbers for these fields? (target stock prices fields the
> > mean, median, high, low prices?
> >
> > If not can you make a recommendation to download this info?
> >
> > I copied and pasted and example from yahoo Analyst Opinion web page.
> >
> > from Yahoo,
> >
> > Price Target Summary:
> > Mean Target: 39.06
> > Median Target: 39.50
> > High Target: 43.00
> > Low Target: 35.00
> > No. of Brokers: 16
> >
>
Here is a link, http://finance.
It is located Yahoo left side , Analyst Coverage, then under Analyst Opinions.
Randy, just as a suggestion. in your updates, could you possibly build this into rchgetelementnumber
I bet this would be very helpful to everyone?
Thanks for all that you do.
rr76012
--- In smf_addin@yahoogrou
>
> That table and those items are probably new since I did the element
> numbers. Actually, it looks like there are no elements from that page. I
> wonder if the entire page is new.
>
> In any case, you can just use the RCHGetTableCell(
> For example:
>
> =RCHGetTableCell(
> Summary","Mean Target")
>
> On Fri, Aug 17, 2012 at 11:07 AM, rr76012 <rr76012@...
>
> > re: Yahoo Analyst Opinion
> >
> > Hello Randy,
> >
> > I have looked, but I may have overlooked rchgetelementnumber numbers for
> > the Yahoo Analyst Opinions on Price Target Summary, are there
> > rchgetelementnumber
> > mean, median, high, low prices?
> >
> > If not can you make a recommendation to download this info?
> >
> > I copied and pasted and example from yahoo Analyst Opinion web page.
> >
> > from Yahoo,
> >
> > Price Target Summary:
> > Mean Target: 39.06
> > Median Target: 39.50
> > High Target: 43.00
> > Low Target: 35.00
> > No. of Brokers: 16
> >
>
Sun Aug 19, 2012 2:56 am (PDT) . Posted by:
"jr105_" jr105_
I am getting an error when trying to get % change for option prices. The only service to provide such is MSN, but in all instances the parameter "%" causes an error.
Sun Aug 19, 2012 3:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just tried these and they worked fine for me:
=smfGetOptionQuotes("SPY 8/24 2012 $143 Call","%",,"MSN")
=smfGetOptionQuotes("MMM Sep 2012 $95 Call","%",,"MSN")
Without a specific example to look at, I have no idea what you're looking
at.
On Sun, Aug 19, 2012 at 2:56 AM, jr105_ <john.richards21@comcast.net > wrote:
> I am getting an error when trying to get % change for option prices. The
> only service to provide such is MSN, but in all instances the parameter "%"
> causes an error.
>
=smfGetOptionQuotes
=smfGetOptionQuotes
Without a specific example to look at, I have no idea what you're looking
at.
On Sun, Aug 19, 2012 at 2:56 AM, jr105_ <john.richards21@
> I am getting an error when trying to get % change for option prices. The
> only service to provide such is MSN, but in all instances the parameter "%"
> causes an error.
>
Tidak ada komentar:
Posting Komentar