Kamis, 13 Juni 2013

[smf_addin] Digest Number 2654

4 New Messages

Digest #2654
2a
Debug by "Jason" g3m1n1980
2b
Re: Debug by "Randy Harmelink" rharmelink

Messages

Wed Jun 12, 2013 7:47 am (PDT) . Posted by:

"Kermit W. Prather" kermitpra

I need assistance with the IFERROR formula. In the table below I have hidden
columns not needed for this formula.
I look at the Excel help but still can't figure out the correct formula.

What I want to do is have a zero value in place of the Error value that is
the result of the IF statement shown in Column A Row 5

I hope I have provide enough information to allow you to understand what I
am trying to do.



Column

A
B
F
O

1
11
Element#
19

1
per
per
Error

IFERROR(IF($B4=$F4,(smfGetTagContent("http://dividata.com/stock/"&$F4&"/divi
dend","p",O$3,">Ex-Dividend Date"))," "),"0")




Wed Jun 12, 2013 1:52 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

In such situations, I usually divide an expected value by 1. If it's
numeric, the value stays the same. If not, it triggers an error.

For example, for the date and amount, I would do something like:

=IFERROR(DATEVALUE(smfGetTagContent("http://dividata.com/stock/"&$F4&"/dividend","p",500,">Ex-Dividend
Date"))/1,"--")
=IFERROR(smfGetTagContent("http://dividata.com/stock/"&$F4&"/dividend","p",501,">Ex-Dividend
Date")/1,0)

On Wed, Jun 12, 2013 at 7:47 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
> I need assistance with the IFERROR formula. In the table below I have
> hidden columns not needed for this formula. ****
>
> I look at the Excel help but still can't figure out the correct formula. *
> ***
>
> ** **
>
> What I want to do is have a zero value in place of the Error value that is
> the result of the IF statement shown in Column A Row 5 ****
>
> ** **
>
> I hope I have provide enough information to allow you to understand what I
> am trying to do. ****
>
> ** **
>
> ** **
>
> *Column*
>
> *A*
>
> *B*
>
> *F*
>
> *O*
>
> *1*
>
> *11*
>
> Element#****
>
> *19*
>
> 1****
>
> *per*
>
> per****
>
> Error****
>
> IFERROR(IF($B4=$F4,(smfGetTagContent("http://dividata.com/stock/"&$F4&"/dividend","p",O$3,">Ex-Dividend
> Date"))," "),"0")****
>
> ****
>
> ****
>
> ****
>
> ****
>
> ****
>
> ****
>
> ****
>
> ** **
>
>

Wed Jun 12, 2013 7:18 pm (PDT) . Posted by:

"Jason" g3m1n1980

http://www.nasdaq.com/symbol/nus/guru-analysis/lynch

=RCHGetTableCell("http://www.nasdaq.com/symbol/"&C1&"/guru-analysis/lynch",4,">Source",,,,1,"</table",,"--")

Im having issues with the gurus on the nasdaq site. It was working recently and i dont see anything has changed with the URL.

Please advise

Wed Jun 12, 2013 7:57 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

What are you trying to extract? With:

=RCHGetTableCell("http://www.nasdaq.com/symbol/nus/guru-analysis/lynch
",4,">Source",,,,1,"</table",,"--")

...I am getting back the 93% from Peter Lynch...

If that Guru Score is all you want, I would just pick it up further down,
with:

=smfConvertData(smfStrExtr(RCHGetTableCell("
http://www.nasdaq.com/symbol/nus/guru-analysis/lynch",
0,"Guru Score:"),":","~"))

On Wed, Jun 12, 2013 at 7:18 PM, Jason <xxjaysonxx@aol.com> wrote:

> http://www.nasdaq.com/symbol/nus/guru-analysis/lynch
>
> =RCHGetTableCell("http://www.nasdaq.com/symbol/
> "&C1&"/guru-analysis/lynch",4,">Source",,,,1,"</table",,"--")
>
> Im having issues with the gurus on the nasdaq site. It was working
> recently and i dont see anything has changed with the URL.
>
> Please advise
>

Tidak ada komentar:

Posting Komentar