Messages In This Digest (10 Messages)
- 1a.
- Element numbers From: Gordon
- 1b.
- Re: Element numbers From: Randy Harmelink
- 2a.
- trouble referencing a cell in RCHGetTableCell From: oryxius
- 2b.
- Re: trouble referencing a cell in RCHGetTableCell From: Randy Harmelink
- 3a.
- All Equity Summary Score From: smithjhhic
- 3b.
- Re: All Equity Summary Score From: Randy Harmelink
- 3c.
- Re: All Equity Summary Score From: smithjhhic
- 3d.
- Re: All Equity Summary Score From: Randy Harmelink
- 4a.
- element numbers From: Gordon
- 4b.
- Re: element numbers From: Randy Harmelink
Messages
- 1a.
-
Element numbers
Posted by: "Gordon" gordonj5@aol.com gordonjones123
Mon May 28, 2012 8:22 am (PDT)
With formula =RCHGetElementNumber($E$6,1, "Error") I used to get Company Description.
I also can't get last price using the formula above using 25 as the element #
I also can't get 3 month Relative Strength using formula above using element #30
I also can't get 6 month Relative Strength using formula above using element # 31
I am looking for another element # through the element list and I'm unable to find a replacement number to get me the information. I'm especially interested in last price.
Thank for any information you can give me. Gordon Jones
- 1b.
-
Re: Element numbers
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon May 28, 2012 9:16 am (PDT)
I suspect you need the updated MSN element definitions -- see:
http://finance.groups.yahoo. com/group/ smf_addin/ message/18529
For current quotes, you should use the RCHGetYahooQuotes() function.
Besides, MSN is currently posting the previous day's closing price as the
"Last Price".
On Mon, May 28, 2012 at 8:11 AM, Gordon <gordonj5@aol.com > wrote:
> With formula =RCHGetElementNumber($E$6,1, "Error") I used to get Company
> Description.
> I also can't get last price using the formula above using 25 as the
> element #
> I also can't get 3 month Relative Strength using formula above using
> element #30
> I also can't get 6 month Relative Strength using formula above using
> element # 31
>
> I am looking for another element # through the element list and I'm unable
> to find a replacement number to get me the information. I'm especially
> interested in last price.
>
- 2a.
-
trouble referencing a cell in RCHGetTableCell
Posted by: "oryxius" oryxius@yahoo.com oryxius
Mon May 28, 2012 10:35 am (PDT)
Hello everyone,
I am new here and I am still finding my way around, but I am quite impressed at the great work you guys have done, especially Randy.
I am trying to get the signal opinions from the bigchart.com bottom signals page, and I am able to do it using the ticker symbol, e.g.:
=RCHGetTableCell("http://www.barchart .com/stocks/ ",5,"Today's Opinion","DELL"signals/bottom10 0 )
But when I replace the ticker with a cell referencing it, it gives me an error message:
=RCHGetTableCell("http://www.barchart .com/stocks/ ",5,"Today's Opinion","&S18&signals/bottom10 0 ")
Any suggestions?
Moe
- 2b.
-
Re: trouble referencing a cell in RCHGetTableCell
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon May 28, 2012 10:37 am (PDT)
A cell reference would be just:
S18
...not:
"&S18&"
That last item is a 5-character string literal, not a cell reference.
On Mon, May 28, 2012 at 9:53 AM, oryxius <oryxius@yahoo.com > wrote:
>
> I am new here and I am still finding my way around, but I am quite
> impressed at the great work you guys have done, especially Randy.
>
> I am trying to get the signal opinions from the bigchart.com bottom
> signals page, and I am able to do it using the ticker symbol, e.g.:
>
> =RCHGetTableCell("http://www.barchart .com/stocks/ ",5,"Today'ssignals/bottom10 0
> Opinion","DELL")
>
> But when I replace the ticker with a cell referencing it, it gives me an
> error message:
>
> =RCHGetTableCell("http://www.barchart .com/stocks/ ",5,"Today'ssignals/bottom10 0
> Opinion","&S18&")
>
> Any suggestions?
>
- 3a.
-
All Equity Summary Score
Posted by: "smithjhhic" smithjhhic@yahoo.com smithjhhic
Mon May 28, 2012 11:17 am (PDT)
I am attempting to retrieve the "All Equity Summary Score:" from Fidelity, but have an error in my formula. I'd like to return "Bullish (8.2)" from the pages code below. However, my formula returns "ALL Equity Summary Score Firms", which is at the bottom of the cut/pasted code. I'd appreciate any help getting me on the right track.
=RCHGetTableCell("http://eresearch. fidelity. ",1,"ALL Equity Summary Score:")com/eresearch/ goto/evaluate/ analystsOpinions .jhtml?symbols= ALL
<h3>ALL Equity Summary Score:
</h3>
<span class="stock-sentiment" ><span class='tableCallout '>Bullish< /span> (8.2)</span>
<span class="pro-txt">
Provided by
<a href="http://research2.fidelity. ">com/fidelity/ research/ reports/release2 /ResearchFirmDet ails.asp? page=StarMine. asp
StarMine
</a>
<a target="_blank" href="http://personal.fidelity. ">com/help/ research/ learn_er_ glossary_ 1.shtml#equitysu mmaryscore
<img alt="" title="" src="http://personal.fidelity. " />com/common/ always-cached/ eresearch/ 11.05/images/ 11_11_question1. gif
</a>
</span>
<span class="date-time">AS OF 05/27/2012</ span>
</div>
<p>
<span class="bold">The Equity Summary Score</span> is an accuracy-weighted sentiment derived from the ratings of independent research providers on Fidelity.com. It uses the past relative accuracy of the providers in determining the emphasis placed on any individual opinion.
<a class="bold" target="_blank" href="http://personal.fidelity. /research/equity/com
 popups/stock- research- starmine- learn-more. shtml
 ">
Learn More....
</a>
</p>
</div>
<div class="sentiment-summary-section" >
<table id="sentSummaryFirmsTable" cellpadding= "0" cellspacing= "0" xmlns:ms="urn: schemas-microsof t-com:xslt" xmlns:wsod="http://wallst. com/wsod ">
<tr>
<td>
<div class="sentiment-summary-data- table">
<div class="header">
<h3>ALL Equity Summary Score Firms
- 3b.
-
Re: All Equity Summary Score
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon May 28, 2012 12:08 pm (PDT)
The RCHGetTableCell() function will not work, because the data is not
within a table. You'll need to use the smfGetTagContent() function.
Try something like this (untested, of course):
=smfGetTagContent("
http://eresearch.fidelity. ","span",1,"com/eresearch/ goto/evaluate/ analystsOpinions .jhtml?symbols= ALL ALL
Equity Summary Score:")
...although that will give you something you'll need to extract the
necessary data from. The smfStrExtr() functionj would probably be best for
that.
On Mon, May 28, 2012 at 11:15 AM, smithjhhic <smithjhhic@yahoo.com > wrote:
> I am attempting to retrieve the "All Equity Summary Score:" from Fidelity,
> but have an error in my formula. I'd like to return "Bullish (8.2)" from
> the pages code below. However, my formula returns "ALL Equity Summary
> Score Firms", which is at the bottom of the cut/pasted code. I'd
> appreciate any help getting me on the right track.
>
> =RCHGetTableCell("
> http://eresearch.fidelity. ",1,"ALLcom/eresearch/ goto/evaluate/ analystsOpinions .jhtml?symbols= ALL
> Equity Summary Score:")
>
>
> <h3>ALL Equity Summary Score:
> </h3>
> <span class="stock-sentiment" ><span class='tableCallout '>Bullish< /span>
> (8.2)</span>
>
- 3c.
-
Re: All Equity Summary Score
Posted by: "smithjhhic" smithjhhic@yahoo.com smithjhhic
Mon May 28, 2012 1:07 pm (PDT)
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
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The RCHGetTableCell() function will not work, because the data is not
> within a table. You'll need to use the smfGetTagContent() function.
>
> Try something like this (untested, of course):
>
> =smfGetTagContent("
> http://eresearch.fidelity. ","span",1,"com/eresearch/ goto/evaluate/ analystsOpinions .jhtml?symbols= ALL ALL
> Equity Summary Score:")
>
> ...although that will give you something you'll need to extract the
> necessary data from. The smfStrExtr() functionj would probably be best for
> that.
>
> On Mon, May 28, 2012 at 11:15 AM, smithjhhic <smithjhhic@...> wrote:
>
> > I am attempting to retrieve the "All Equity Summary Score:" from Fidelity,
> > but have an error in my formula. I'd like to return "Bullish (8.2)" from
> > the pages code below. However, my formula returns "ALL Equity Summary
> > Score Firms", which is at the bottom of the cut/pasted code. I'd
> > appreciate any help getting me on the right track.
> >
> > =RCHGetTableCell("
> > http://eresearch.fidelity. ",1,"ALLcom/eresearch/ goto/evaluate/ analystsOpinions .jhtml?symbols= ALL
> > Equity Summary Score:")
> >
> >
> > <h3>ALL Equity Summary Score:
> > </h3>
> > <span class="stock-sentiment" ><span class='tableCallout '>Bullish< /span>
> > (8.2)</span>
> >
>
- 3d.
-
Re: All Equity Summary Score
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon May 28, 2012 5:03 pm (PDT)
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@yahoo.com > 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
>
- 4a.
-
element numbers
Posted by: "Gordon" gordonj5@aol.com gordonjones123
Mon May 28, 2012 11:50 am (PDT)
I looked at the elements definitions and I seen no change from previous.
I'm looking for the last price of a stock.
The element # should be 25 to bring this information in.
It doesn't.
Am I misinterpreting the information in element definitions or am I using the wrong formula.
Sorry that I can't seem to understand your answer about element definitions.
What replaces 25?
What replaces 30?
What replaces 31?
Thank you, Gordon Jones
- 4b.
-
Re: element numbers
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon May 28, 2012 12:11 pm (PDT)
The smf-elements-1.txt file in the add-in's folder contains the element
definitions for MSN. Those all had to be changed at the end of April
because MSN changed their website structure and content. There is a new
smf-elements-1.txt file in the "Works in Progress" folder of the FILES area
of the group, that contains those new definitions.
You should exit EXCEL, replace that file in the add-in folder with the file
that you can download, and then restart EXCEL. That will update your
element definitions.
On Mon, May 28, 2012 at 11:48 AM, Gordon <gordonj5@aol.com > wrote:
> I looked at the elements definitions and I seen no change from previous.
> I'm looking for the last price of a stock.
> The element # should be 25 to bring this information in.
> It doesn't.
> Am I misinterpreting the information in element definitions or am I using
> the wrong formula.
>
> Sorry that I can't seem to understand your answer about element
> definitions.
>
> What replaces 25?
> What replaces 30?
> What replaces 31?
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
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
Tidak ada komentar:
Posting Komentar