3 New Messages
Digest #2353
| |
Messages
Sun Sep 23, 2012 9:57 am (PDT) . Posted by:
"nhatnam4" nhatnam4
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)
="Market Edge Recommendation: "&MID(RCHGetWebData
Sun Sep 23, 2012 11:14 am (PDT) . Posted by:
"Ron Spruell" hashky
Have you logged on to ameritrade using IE or Excel first?
Ron Spruell
>________________________________
> From: nhatnam4 <nhatnam4@yahoo.com >
>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)
>
>
>
>
>
Ron Spruell
>___________
> From: nhatnam4 <nhatnam4@yahoo.
>To: smf_addin@yahoogrou
>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
>
>
>
>
>
Sun Sep 23, 2012 6:07 pm (PDT) . Posted by:
"nhatnam4" nhatnam4
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)
> >
> >
> >
> >
> >
>
Here's the formula I'm using:
="Market Edge Recommendation: "&MID(RCHGetWebData
--- In smf_addin@yahoogrou
>
> Have you logged on to ameritrade using IE or Excel first?
>
> Ron Spruell
>
>
>
>
> >___________
> > From: nhatnam4 <nhatnam4@..
> >To: smf_addin@yahoogrou
> >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
> >
> >
> >
> >
> >
>
Tidak ada komentar:
Posting Komentar