6 New Messages
Digest #2321
| 3b Re: Yahoo, Price Target Summary, of the Mean, Median, High, Low stoc by "Randy Harmelink" rharmelink |
Messages
Tue Aug 21, 2012 4:17 am (PDT) . Posted by:
"vibhordawar@yahoo.com" vibhordawar
Tue Aug 21, 2012 6:27 am (PDT) . Posted by:
"vibhor dawar" vibhordawar
etvbgknelvgoliremntbgivone4nvg
Tue Aug 21, 2012 2:15 pm (PDT) . Posted by:
"spudtatro" spudtatro
Hi Randy,
Within your formula how do you get the stock symbol (in this case MMM) to change? I tried changing MMM to be "ticker" but it gives an error.
Thanks
--- 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
> >
>
Within your formula how do you get the stock symbol (in this case MMM) to change? I tried changing MMM to be "ticker" but it gives an error.
Thanks
--- 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
> >
>
Tue Aug 21, 2012 2:16 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Just do normal EXCEL string concatenation, using normal cell references:
="string1"&A1
=A1&"string1
="string1"&A1&"string2"&B2
On Tue, Aug 21, 2012 at 2:00 PM, spudtatro <labsrcool@hotmail.com > wrote:
>
> Within your formula how do you get the stock symbol (in this case MMM) to
> change? I tried changing MMM to be "ticker" but it gives an error.
>
="string1"&A1
=A1&"string1
="string1"&A1&
On Tue, Aug 21, 2012 at 2:00 PM, spudtatro <labsrcool@hotmail.
>
> Within your formula how do you get the stock symbol (in this case MMM) to
> change? I tried changing MMM to be "ticker" but it gives an error.
>
Tue Aug 21, 2012 10:37 pm (PDT) . Posted by:
"notkoushik" notkoushik
Hi Randy,
I think I found a small bug in the smfGetADVFNElement routine. I am trying to retrieve EBIT using
=smfGetADVFNElement("GOOG","A",1,">EBIT")
but it returns the value corresponding to EBITDA
After looking within the routine, it points to this line in the code within RCHExtractData -
iPos1 = InStr(iPos1 + 1, sData(3), UCase(pFind1))
since InStr returns the first match, it ignores the real 'EBIT'.
I am not sure the data format within sData, and so I don't know how string search can be modified to avoid multiple pattern matches. Can InStrRev return value be compared against InStr return value and be used to find the other pattern?
Perhaps, there is an already existing solution/workaround, please let me know.
Many thanks!
Koushik
I think I found a small bug in the smfGetADVFNElement routine. I am trying to retrieve EBIT using
=smfGetADVFNElement
but it returns the value corresponding to EBITDA
After looking within the routine, it points to this line in the code within RCHExtractData -
iPos1 = InStr(iPos1 + 1, sData(3), UCase(pFind1)
since InStr returns the first match, it ignores the real 'EBIT'.
I am not sure the data format within sData, and so I don't know how string search can be modified to avoid multiple pattern matches. Can InStrRev return value be compared against InStr return value and be used to find the other pattern?
Perhaps, there is an already existing solution/workaround
Many thanks!
Koushik
Tue Aug 21, 2012 11:04 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's just doing what you told it -- getting the most recent year of data
following search string ">EBIT". It's just not a unique enough string for
what you want. That's why the function allows multiple search terms, so you
can get to the one you want. Try:
=smfGetADVFNElement("GOOG","A",1,">EBIT",">EBIT")
Another option would be:
=smfGetADVFNElement("GOOG","A",1,">EBIT<")
On Tue, Aug 21, 2012 at 10:37 PM, notkoushik <notkoushik@yahoo.com > wrote:
> Hi Randy,
> I think I found a small bug in the smfGetADVFNElement routine. I am trying
> to retrieve EBIT using
> =smfGetADVFNElement("GOOG","A",1,">EBIT")
> but it returns the value corresponding to EBITDA
> After looking within the routine, it points to this line in the code
> within RCHExtractData -
> iPos1 = InStr(iPos1 + 1, sData(3), UCase(pFind1))
>
> since InStr returns the first match, it ignores the real 'EBIT'.
> I am not sure the data format within sData, and so I don't know how string
> search can be modified to avoid multiple pattern matches. Can InStrRev
> return value be compared against InStr return value and be used to find the
> other pattern?
>
> Perhaps, there is an already existing solution/workaround, please let me
> know.
>
following search string ">EBIT". It's just not a unique enough string for
what you want. That's why the function allows multiple search terms, so you
can get to the one you want. Try:
=smfGetADVFNElement
Another option would be:
=smfGetADVFNElement
On Tue, Aug 21, 2012 at 10:37 PM, notkoushik <notkoushik@yahoo.
> Hi Randy,
> I think I found a small bug in the smfGetADVFNElement routine. I am trying
> to retrieve EBIT using
> =smfGetADVFNElement
> but it returns the value corresponding to EBITDA
> After looking within the routine, it points to this line in the code
> within RCHExtractData -
> iPos1 = InStr(iPos1 + 1, sData(3), UCase(pFind1)
>
> since InStr returns the first match, it ignores the real 'EBIT'.
> I am not sure the data format within sData, and so I don't know how string
> search can be modified to avoid multiple pattern matches. Can InStrRev
> return value be compared against InStr return value and be used to find the
> other pattern?
>
> Perhaps, there is an already existing solution/workaround
> know.
>
Tidak ada komentar:
Posting Komentar