3 New Messages

Digest #2354

Re: Market Edge Second Opinion Weekly Recommendation by "Ron Spruell" hashky

RCHGetElementNumber(ticker, 46) - Return "NA" by "bobc94595" bobc94595

HEY by "Harry Kerry" shadowemailclone

Messages

1a

Re: Market Edge Second Opinion Weekly Recommendation

Mon Sep 24, 2012 5:01 am (PDT) . Posted by:

"Ron Spruell" hashky

I don't have an account at ameritrade so I can't see the page. Sorry. Maybe someone else can help.

>________________________________
> From: nhatnam4 <nhatnam4@yahoo.com>
>To: smf_addin@yahoogroups.com
>Sent: Sunday, September 23, 2012 8:07 PM
>Subject: [smf_addin] Re: Market Edge Second Opinion Weekly Recommendation
>
>
>
>I logged onto excel first. I get #VALUE! response in the cell, which I believe there's something wrong with the formula.
>
>Here's the formula I'm using:
>
>="Market Edge Recommendation: "&MID(RCHGetWebData("https://ameritradew.marketedge.com/Weekly/Stock/S/"&Ticker&".asp?from=1&sym="&Ticker&"&r=0","Stock is"),1,(SEARCH("</td>",RCHGetWebData("https://ameritradew.marketedge.com/Weekly/Stock/S/"&Ticker&".asp?from=1&sym="&Ticker&"&r=0","Stock is")))-2)
>
>--- In smf_addin@yahoogroups.com, Ron Spruell <hashky@...> wrote:
>>
>> Have you logged on to ameritrade using IE or Excel first?
>>
>> Ron Spruell
>>
>>
>>
>>
>> >________________________________
>> > From: nhatnam4 <nhatnam4@...>
>> >To: smf_addin@yahoogroups.com
>> >Sent: Sunday, September 23, 2012 11:57 AM
>> >Subject: [smf_addin] Market Edge Second Opinion Weekly Recommendation
>> >
>> >
>> >Â
>> >I'm trying to get this formula to work with a "Ticker" name input, but can't seem to make it work. I tried replacing "IBM" with "&Ticker&". But no luck. Please help.
>> >
>> >="Market Edge Recommendation: "&MID(RCHGetWebData("https://ameritradew.marketedge.com/Weekly/Stock/S/IBM.asp?from=1&sym=IBM&r=0","Stock is"),1,(SEARCH("</td>",RCHGetWebData("https://ameritradew.marketedge.com/Weekly/Stock/S/IBM.asp?from=1&sym=IBM&r=0","Stock is")))-2)
>> >
>> >
>> >
>> >
>> >
>>
>
>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2 RCHGetElementNumber(ticker, 46) - Return "NA"

Mon Sep 24, 2012 12:36 pm (PDT) . Posted by:

"bobc94595" bobc94595

I have a spreadsheet with one column which uses RCHGetElementNumber(ticker, 46), to get Dividend Rates for about 25 stocks. Those stocks that do not pay dividends return "NA", without the quotes. I am using that Dividend Rate column information to calculate another column of Dividend Income, but I get a #VALUE! in the Dividend Income column for any stock with an NA in the Dividend Rate column.
Do you have a formula to convert NA to zero in the Dividend Rate column?