4 New Messages
Digest #2539
1b
Re: How can I have a Yahoo chart open in my browser using the plugin by "Randy Harmelink" rharmelink
1d
Re: How can I have a Yahoo chart open in my browser using the plugin by "Randy Harmelink" rharmelink
Messages
Sat Mar 9, 2013 11:43 pm (PST) . Posted by:
"andyha8" andyha8
Yeah, but I just don't know how to get that link to read a ticker from an excel cell. Like you know how you can put "&A5,1, so that you get what's in that cell, ie
=RCHGetTableCell("http://www.earningswhispers.com/stocks.asp?symbol= "&$A5,1,"Release Date:"),"")
is there a way to do that with the yahoo link?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Do you just want EXCEL's HYPERLINK() function? For example:
>
> =HYPERLINK("
> http://finance.yahoo.com/echarts?s=COO+Interactive#symbol=coo;range=6m;compare=;indicator=ema%2820,50%29+macd+stochasticslow+rsi;charttype=area;crosshair=on;ohlcvalues=0;logscale=off;source=undefined
> ","Test")
>
> On Sat, Mar 9, 2013 at 9:30 PM, andyha8 <andyha8@...> wrote:
>
> >
> > Hey Randy, Thanks for the help again. Actually, I don't really want to
> > bring anything into excel, I just want the browser to open to the yahoo
> > chart but from the ticker in one of my excel cells.
> >
> > Actually I am building a frankenspreadsheet, mostly from your stuff! It's
> > a hybrid of RCHGetTableCell-Template-Options-CC-List-Returns.xls, and
> > RCHGetTableCell-Template-IBD-Stock-Checkup.xls with a bunch of my own and
> > others stuff in there too.
> >
> > So if I have a row that has all the stock and option ratings, technical
> > and fundamental metrics, I thought it would be cool if I had a cell at the
> > end that when I clicked on would open up Yahoo charts, with those
> > parameters from my original post, but get the tickers from my spreadsheet.
> >
> > Have a great night
> >
>
=RCHGetTableCell(
is there a way to do that with the yahoo link?
--- In smf_addin@yahoogrou
>
> Do you just want EXCEL's HYPERLINK() function? For example:
>
> =HYPERLINK("
> http://finance.
> ","
>
> On Sat, Mar 9, 2013 at 9:30 PM, andyha8 <andyha8@
>
> >
> > Hey Randy, Thanks for the help again. Actually, I don't really want to
> > bring anything into excel, I just want the browser to open to the yahoo
> > chart but from the ticker in one of my excel cells.
> >
> > Actually I am building a frankenspreadsheet, mostly from your stuff! It's
> > a hybrid of RCHGetTableCell-
> > RCHGetTableCell-
> > others stuff in there too.
> >
> > So if I have a row that has all the stock and option ratings, technical
> > and fundamental metrics, I thought it would be cool if I had a cell at the
> > end that when I clicked on would open up Yahoo charts, with those
> > parameters from my original post, but get the tickers from my spreadsheet.
> >
> > Have a great night
> >
>
Sun Mar 10, 2013 12:25 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Try:
=HYPERLINK("http://finance.yahoo.com/echarts?s= "&A5&"+Interactive#symbol=coo;range=6m;compare=;indicator=ema%2820,50%29+macd+stochasticslow+rsi;charttype=area;crosshair=on;ohlcvalues=0;logscale=off;source=undefined",A5&"
Chart")
On Sun, Mar 10, 2013 at 12:43 AM, andyha8 <andyha8@gmail.com > wrote:
> Yeah, but I just don't know how to get that link to read a ticker from an
> excel cell. Like you know how you can put "&A5,1, so that you get what's in
> that cell, ie
>
> =RCHGetTableCell("http://www.earningswhispers.com/stocks.asp?symbol= "&$A5,1,"Release
> Date:"),"")
>
> is there a way to do that with the yahoo link?
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > Do you just want EXCEL's HYPERLINK() function? For example:
> >
> > =HYPERLINK("
> >
> http://finance.yahoo.com/echarts?s=COO+Interactive#symbol=coo;range=6m;compare=;indicator=ema%2820,50%29+macd+stochasticslow+rsi;charttype=area;crosshair=on;ohlcvalues=0;logscale=off;source=undefined
> > ","Test")
>
=HYPERLINK("http://finance.
Chart")
On Sun, Mar 10, 2013 at 12:43 AM, andyha8 <andyha8@gmail.
> Yeah, but I just don't know how to get that link to read a ticker from an
> excel cell. Like you know how you can put "&A5,
> that cell, ie
>
> =RCHGetTableCell(
> Date:")
>
> is there a way to do that with the yahoo link?
>
> --- In smf_addin@yahoogrou
> >
> > Do you just want EXCEL's HYPERLINK() function? For example:
> >
> > =HYPERLINK("
> >
> http://finance.
> > ","
>
Sun Mar 10, 2013 12:45 am (PST) . Posted by:
"andyha8" andyha8
Well that just gets me to here:
http://finance.yahoo.com/echarts?s=
mmmm, I still see coo in that link...
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Try:
>
> =HYPERLINK("http://finance.yahoo.com/echarts?s= "&A5&"+Interactive#symbol=coo;range=6m;compare=;indicator=ema%2820,50%29+macd+stochasticslow+rsi;charttype=area;crosshair=on;ohlcvalues=0;logscale=off;source=undefined",A5&"
> Chart")
>
> On Sun, Mar 10, 2013 at 12:43 AM, andyha8 <andyha8@...> wrote:
>
> > Yeah, but I just don't know how to get that link to read a ticker from an
> > excel cell. Like you know how you can put "&A5,1, so that you get what's in
> > that cell, ie
> >
> > =RCHGetTableCell("http://www.earningswhispers.com/stocks.asp?symbol= "&$A5,1,"Release
> > Date:"),"")
> >
> > is there a way to do that with the yahoo link?
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > Do you just want EXCEL's HYPERLINK() function? For example:
> > >
> > > =HYPERLINK("
> > >
> > http://finance.yahoo.com/echarts?s=COO+Interactive#symbol=coo;range=6m;compare=;indicator=ema%2820,50%29+macd+stochasticslow+rsi;charttype=area;crosshair=on;ohlcvalues=0;logscale=off;source=undefined
> > > ","Test")
> >
>
http://finance.
mmmm, I still see coo in that link...
--- In smf_addin@yahoogrou
>
> Try:
>
> =HYPERLINK("http://finance.
> Chart")
>
> On Sun, Mar 10, 2013 at 12:43 AM, andyha8 <andyha8@
>
> > Yeah, but I just don't know how to get that link to read a ticker from an
> > excel cell. Like you know how you can put "&A5,
> > that cell, ie
> >
> > =RCHGetTableCell(
> > Date:")
> >
> > is there a way to do that with the yahoo link?
> >
> > --- In smf_addin@yahoogrou
> > >
> > > Do you just want EXCEL's HYPERLINK() function? For example:
> > >
> > > =HYPERLINK("
> > >
> > http://finance.
> > > ","
> >
>
Sun Mar 10, 2013 1:03 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. Works for me. It changes that other COO to MMM when it renders the
page for me. This is where I end up when it follows the link:
http://finance.yahoo.com/echarts?s=MMM+Interactive#symbol=mmm;range=6m;compare=;indicator=ema%2820,50%29+macd+stochasticslow+rsi;charttype=area;crosshair=on;ohlcvalues=0;logscale=off;source=undefined
;
On Sun, Mar 10, 2013 at 1:44 AM, andyha8 <andyha8@gmail.com > wrote:
> Well that just gets me to here:
> http://finance.yahoo.com/echarts?s=
> mmmm, I still see coo in that link...
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > Try:
> >
> > =HYPERLINK("http://finance.yahoo.com/echarts?s=
> "&A5&"+Interactive#symbol=coo;range=6m;compare=;indicator=ema%2820,50%29+macd+stochasticslow+rsi;charttype=area;crosshair=on;ohlcvalues=0;logscale=off;source=undefined",A5&"
> > Chart")
>
page for me. This is where I end up when it follows the link:
http://finance.
;
On Sun, Mar 10, 2013 at 1:44 AM, andyha8 <andyha8@gmail.
> Well that just gets me to here:
> http://finance.
> mmmm, I still see coo in that link...
>
> --- In smf_addin@yahoogrou
> >
> > Try:
> >
> > =HYPERLINK("http://finance.
> "&A5&
> > Chart")
>
Tidak ada komentar:
Posting Komentar