Senin, 25 Juni 2012

[smf_addin] Digest Number 2257

Messages In This Digest (8 Messages)

Messages

1a.

Re: All Equity Summary Score

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

Sun Jun 24, 2012 4:10 am (PDT)



Randy,
I've been trying to extract the data using RCHGetWebData() as you describe, but after looking at other examples and document files do not have the understanding to do so. Part of my difficulty is the text I search for changes based on the symbol (ie. "DG Equity Summary Score:", AAPL Equity Summary Score:", etc). Understand you do not have access to the web page. I could send the the text file of it if that helps. An example would be very helpful.
v/r,
Jeff

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Yup. It's a span within a span, but the smfGetTagContent() is a very simple
> extractor and just looks for the next end of span tag.
>
> You'll need to use the RCHGetWebData() function and extract the data
> manually.
>
> On Mon, May 28, 2012 at 1:07 PM, smithjhhic <smithjhhic@...> wrote:
>
> > Randy,
> > Thank you. It returned "<span class='tableCallout'>Bullish". It did not
> > pickup the "(8.2)". Did I do something wrong? Understand difficult to
> > advise since you can't test.
> > v/r,
> > Jeff
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
1b.

Re: All Equity Summary Score

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

Sun Jun 24, 2012 8:50 am (PDT)



I would do something like (untested, of course):

=smfStrExtr(RCHGetWebData("
http://eresearch.fidelity.com/eresearch/goto/evaluate/analystsOpinions.jhtml?symbols=ALL","Equity
Summary Score:",200),"='tableCallout'>","<")

=smfConvertData(smfStrExtr(RCHGetWebData("
http://eresearch.fidelity.com/eresearch/goto/evaluate/analystsOpinions.jhtml?symbols=ALL","Equity
Summary Score:",200),"(",")"))

On Sun, Jun 24, 2012 at 4:06 AM, smithjhhic <smithjhhic@yahoo.com> wrote:

> Randy,
> I've been trying to extract the data using RCHGetWebData() as you
> describe, but after looking at other examples and document files do not
> have the understanding to do so. Part of my difficulty is the text I
> search for changes based on the symbol (ie. "DG Equity Summary Score:",
> AAPL Equity Summary Score:", etc). Understand you do not have access to
> the web page. I could send the the text file of it if that helps. An
> example would be very helpful.
> v/r,
> Jeff
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
1c.

Re: All Equity Summary Score

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

Sun Jun 24, 2012 10:05 am (PDT)



Randy,
That worked great. Thank you!
v/r,
Jeff

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I would do something like (untested, of course):
>
> =smfStrExtr(RCHGetWebData("
> http://eresearch.fidelity.com/eresearch/goto/evaluate/analystsOpinions.jhtml?symbols=ALL","Equity
> Summary Score:",200),"='tableCallout'>","<")
>
> =smfConvertData(smfStrExtr(RCHGetWebData("
> http://eresearch.fidelity.com/eresearch/goto/evaluate/analystsOpinions.jhtml?symbols=ALL","Equity
> Summary Score:",200),"(",")"))
>
> On Sun, Jun 24, 2012 at 4:06 AM, smithjhhic <smithjhhic@...> wrote:
>
> > Randy,
> > I've been trying to extract the data using RCHGetWebData() as you
> > describe, but after looking at other examples and document files do not
> > have the understanding to do so. Part of my difficulty is the text I
> > search for changes based on the symbol (ie. "DG Equity Summary Score:",
> > AAPL Equity Summary Score:", etc). Understand you do not have access to
> > the web page. I could send the the text file of it if that helps. An
> > example would be very helpful.
> > v/r,
> > Jeff
> >
>

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

RCHGetYahooHistory and monthly adjusted prices

Posted by: "chaim422" chaim422@gmail.com   chaim422

Sun Jun 24, 2012 6:25 pm (PDT)



Randy, RCHGetYahooHistory doesn't adjust the price correctly in a month that a stock split occurs when asking for monthly adjusted prices. See for example RCHGetYahooHistory("LVLT",2011,10,11,2012,10,11,"m","DOHLA",1,1,1). Is there a workaround?

Thank you!

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

Re: RCHGetYahooHistory and monthly adjusted prices

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

Sun Jun 24, 2012 7:01 pm (PDT)



The function is just showing what Yahoo is sending -- here's what they have:

http://finance.yahoo.com/q/hp?s=LVLT&a=03&b=1&c=1998&d=05&e=25&f=2012&g=m

No easy workaround I know of. Your best bet would be to complain to Yahoo
and get the problem fixed at the source.

On Sun, Jun 24, 2012 at 5:57 PM, chaim422 <chaim422@gmail.com> wrote:

> Randy, RCHGetYahooHistory doesn't adjust the price correctly in a month
> that a stock split occurs when asking for monthly adjusted prices. See for
> example RCHGetYahooHistory("LVLT",2011,10,11,2012,10,11,"m","DOHLA",1,1,1).
> Is there a workaround?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2c.

Re: RCHGetYahooHistory and monthly adjusted prices

Posted by: "chaim422" chaim422@gmail.com   chaim422

Sun Jun 24, 2012 7:15 pm (PDT)



Randy, I looked over what Yahoo is sending but I didn't find an error.
Is Yahoo sending adjusted Open High Low prices?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...>
wrote:
>
> The function is just showing what Yahoo is sending -- here's what they
have:
>
>
http://finance.yahoo.com/q/hp?s=LVLT&a=03&b=1&c=1998&d=05&e=25&f=2012&g=\
m
>
> No easy workaround I know of. Your best bet would be to complain to
Yahoo
> and get the problem fixed at the source.
>
> On Sun, Jun 24, 2012 at 5:57 PM, chaim422 chaim422@... wrote:
>
> > Randy, RCHGetYahooHistory doesn't adjust the price correctly in a
month
> > that a stock split occurs when asking for monthly adjusted prices.
See for
> > example
RCHGetYahooHistory("LVLT",2011,10,11,2012,10,11,"m","DOHLA",1,1,1).
> > Is there a workaround?
> >
>

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

Re: RCHGetYahooHistory and monthly adjusted prices

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

Sun Jun 24, 2012 7:40 pm (PDT)



From the web page I cited:

DateOpenHighLowCloseAvg VolAdj Close* Nov 1, 201125.8525.8918.0520.61
2,302,80020.61Oct 20, 20111: 15 Stock SplitOct 3, 20111.4927.961.3126.69
2,943,90026.69
Since the close and adjusted close are the same, the open, high, and low
prices would be left unchanged. The open and low prices are from data
previous to the split, obviously. There is no way to adjust the open and
low prices for the split based on that data.

I would think this would be an issue with ALL of their weekly and monthly
data, any time a split or dividend adjustment occurred during the period.

On a normal split, it would be the open and high prices that are not
adjustable. For example:

http://finance.yahoo.com/q/hp?s=MMM&a=08&b=1&c=2003&d=09&e=31&f=2003&g=m

Note that there, it is adjustable for later period dividends and splits,
but not for the given period.

On Sun, Jun 24, 2012 at 7:14 PM, chaim422 <chaim422@gmail.com> wrote:

>
> Randy, I looked over what Yahoo is sending but I didn't find an error. Is
> Yahoo sending *adjusted* Open High Low prices?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2e.

Re: RCHGetYahooHistory and monthly adjusted prices

Posted by: "chaim422" chaim422@gmail.com   chaim422

Sun Jun 24, 2012 8:20 pm (PDT)



Randy, I've been reading your code for RCHGetYahooHistory. I see how it
adjusts the prices and why there is no easy workaround. Thanks for
explaining it so well.

P.S. I dabble in VB and there is lots that I learned from your code in
the 15 minutes that I studied it now! I'm sure that as I study it better
I can learn a lot more. Good job, thank you!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...>
wrote:
>
> From the web page I cited:
>
> DateOpenHighLowCloseAvg VolAdj Close* Nov 1, 201125.8525.8918.0520.61
> 2,302,80020.61Oct 20, 20111: 15 Stock SplitOct 3,
20111.4927.961.3126.69
> 2,943,90026.69
> Since the close and adjusted close are the same, the open, high, and
low
> prices would be left unchanged. The open and low prices are from data
> previous to the split, obviously. There is no way to adjust the open
and
> low prices for the split based on that data.
>
> I would think this would be an issue with ALL of their weekly and
monthly
> data, any time a split or dividend adjustment occurred during the
period.
>
> On a normal split, it would be the open and high prices that are not
> adjustable. For example:
>
>
http://finance.yahoo.com/q/hp?s=MMM&a=08&b=1&c=2003&d=09&e=31&f=2003&g=m
>
> Note that there, it is adjustable for later period dividends and
splits,
> but not for the given period.
>
> On Sun, Jun 24, 2012 at 7:14 PM, chaim422 chaim422@... wrote:
>
> >
> > Randy, I looked over what Yahoo is sending but I didn't find an
error. Is
> > Yahoo sending *adjusted* Open High Low prices?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
Recent Activity
Visit Your Group
Yahoo! News

Odd News

You won't believe

it, but it's true

New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 01.35

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)