10 New Messages
Digest #2558
4c
Re: How can I have a Yahoo chart open in my browser using the plugin by "Randy Harmelink" rharmelink
Messages
Sat Mar 23, 2013 4:42 am (PDT) . Posted by:
"draz2121" draz2121
Hi Randy,
I can't see an issue flagged with =RCHGetYahooHistory but it seems to have stopped updating as of the 19th March.
Any ideas?
Thanks.
Shaun
I can't see an issue flagged with =RCHGetYahooHistory but it seems to have stopped updating as of the 19th March.
Any ideas?
Thanks.
Shaun
Sat Mar 23, 2013 4:45 am (PDT) . Posted by:
"draz2121" draz2121
Ahhh, actually, looking at:
http://uk.finance.yahoo.com/q/hp?s=RRL.L
(FOR EXAMPLE)
It seems as though it's Yahoo that stopped updating on the 19th.
Damn, I hope they resume and it is a temp glitch.
Shaun
--- In smf_addin@yahoogroups.com , "draz2121"; <bolony21@...> wrote:
>
> Hi Randy,
>
> I can't see an issue flagged with =RCHGetYahooHistory but it seems to have stopped updating as of the 19th March.
>
> Any ideas?
>
> Thanks.
>
> Shaun
>
http://uk.finance.
(FOR EXAMPLE)
It seems as though it's Yahoo that stopped updating on the 19th.
Damn, I hope they resume and it is a temp glitch.
Shaun
--- In smf_addin@yahoogrou
>
> Hi Randy,
>
> I can't see an issue flagged with =RCHGetYahooHistory but it seems to have stopped updating as of the 19th March.
>
> Any ideas?
>
> Thanks.
>
> Shaun
>
Sat Mar 23, 2013 5:52 am (PDT) . Posted by:
"lexstar" lexstar
The error occurs as soon as you start Excel 2013.
I have tried exit, shutdown/restart, restart Excel... and in every case, the same error msg pops up.
I cannot create a new worksheet and use the add-in functions. Recalling the functions only gives the value "#NAME?".
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> When does the error message come up?
>
> If you exit and restart EXCEL, can you create a new workbook and use the
> add-in functions?
>
> On Fri, Mar 22, 2013 at 7:55 PM, lexstar <lexstar@...> wrote:
>
> > Help. I just started having this error msg come up in Excel and I can't
> > seem to find an answer to solve the problem.
> >
> > ERROR MSG:
> >
> > "This workbook has lost its VBA project, ActiveX controls and any other
> > programmability-related features."
> >
> > This causes the VB Editor and Macros in Excel to be grayed out. Can't run
> > any macros. I hate to be screwed.
> >
> > Any help is very much appreciated.
> >
>
I have tried exit, shutdown/restart, restart Excel... and in every case, the same error msg pops up.
I cannot create a new worksheet and use the add-in functions. Recalling the functions only gives the value "#NAME?
--- In smf_addin@yahoogrou
>
> When does the error message come up?
>
> If you exit and restart EXCEL, can you create a new workbook and use the
> add-in functions?
>
> On Fri, Mar 22, 2013 at 7:55 PM, lexstar <lexstar@
>
> > Help. I just started having this error msg come up in Excel and I can't
> > seem to find an answer to solve the problem.
> >
> > ERROR MSG:
> >
> > "This workbook has lost its VBA project, ActiveX controls and any other
> > programmability-
> >
> > This causes the VB Editor and Macros in Excel to be grayed out. Can't run
> > any macros. I hate to be screwed.
> >
> > Any help is very much appreciated.
> >
>
Sat Mar 23, 2013 7:45 am (PDT) . Posted by:
"lexstar" lexstar
Re-installing Office 2013 seemed to get rid of the error msg for now. Hoping it'll solve the problem.
--- In smf_addin@yahoogroups.com , "lexstar" <lexstar@...> wrote:
>
> The error occurs as soon as you start Excel 2013.
>
> I have tried exit, shutdown/restart, restart Excel... and in every case, the same error msg pops up.
>
> I cannot create a new worksheet and use the add-in functions. Recalling the functions only gives the value "#NAME?".
>
>
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > When does the error message come up?
> >
> > If you exit and restart EXCEL, can you create a new workbook and use the
> > add-in functions?
> >
> > On Fri, Mar 22, 2013 at 7:55 PM, lexstar <lexstar@> wrote:
> >
> > > Help. I just started having this error msg come up in Excel and I can't
> > > seem to find an answer to solve the problem.
> > >
> > > ERROR MSG:
> > >
> > > "This workbook has lost its VBA project, ActiveX controls and any other
> > > programmability-related features."
> > >
> > > This causes the VB Editor and Macros in Excel to be grayed out. Can't run
> > > any macros. I hate to be screwed.
> > >
> > > Any help is very much appreciated.
> > >
> >
>
--- In smf_addin@yahoogrou
>
> The error occurs as soon as you start Excel 2013.
>
> I have tried exit, shutdown/restart, restart Excel... and in every case, the same error msg pops up.
>
> I cannot create a new worksheet and use the add-in functions. Recalling the functions only gives the value "#NAME?
>
>
>
> --- In smf_addin@yahoogrou
> >
> > When does the error message come up?
> >
> > If you exit and restart EXCEL, can you create a new workbook and use the
> > add-in functions?
> >
> > On Fri, Mar 22, 2013 at 7:55 PM, lexstar <lexstar@
> >
> > > Help. I just started having this error msg come up in Excel and I can't
> > > seem to find an answer to solve the problem.
> > >
> > > ERROR MSG:
> > >
> > > "This workbook has lost its VBA project, ActiveX controls and any other
> > > programmability-
> > >
> > > This causes the VB Editor and Macros in Excel to be grayed out. Can't run
> > > any macros. I hate to be screwed.
> > >
> > > Any help is very much appreciated.
> > >
> >
>
Sat Mar 23, 2013 11:55 am (PDT) . Posted by:
"hjreed@swbell.net" hjreed@swbell.net
I'm late to this topic but wanted to give some info I've found working with IBD. I believe you must be a member to access and the pdf's are password protected so they can NOT be converted to .xlsx or .docx using Adobe ExportPDF.
Here is where you can directly see many IBD files. Most are pdf's but the IBD 50 can be opened as.xlsx or .txt:
http://news.
Here is the direct link to the IBD 50 as .xlsx:
http://news.
Here is the link to the printed book ($40) of all the 197 sectors and the stocks that make them up. I found this a valued resource but is only updated every 6 months:
http://www.investor
Also there are several files in the local "meetup" sites (Google "ibd meetup sites" and you will find several cities that have chapters that have sessions you can attend) that can be easily worked with this great tool Randy has created.
I am just a member of IBD but found these sites and will shared them here.
Thanks again Randy for all the help you give us.
I know I for one really appreciate it.
Sat Mar 23, 2013 12:31 pm (PDT) . Posted by:
"andyha8" andyha8
Hey Randy:
This has been working great but since yesterday this:
=HYPERLINK("http://finance.yahoo.com/echarts?s= "&$C2&"+Interactive#symbol=coo;range=6m;compare=;indicator=ema(20,100)+macd+rsi+volume;charttype=candlestick;crosshair=on;ohlcvalues=0;logscale=off;source=undefined",$C2&"")
is taking me here:
http://finance.yahoo.com/echarts?s=OCN#symbol=ocn;range=1y;compare=;indicator=volume;charttype=area;crosshair=on;ohlcvalues=0;logscale=off;source=undefined;
It's the right chart, but none of the indicators.
Any ideas?
--- In smf_addin@yahoogroups.com , "andyha8" <andyha8@...> wrote:
>
> It's working!!! Been messing around with this and I'm not sure what I did but it is now working beautifully. Many thanks again.
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > 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@> 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")
> > >
> >
>
This has been working great but since yesterday this:
=HYPERLINK("http://finance.
is taking me here:
http://finance.
It's the right chart, but none of the indicators.
Any ideas?
--- In smf_addin@yahoogrou
>
> It's working!!! Been messing around with this and I'm not sure what I did but it is now working beautifully. Many thanks again.
>
> --- In smf_addin@yahoogrou
> >
> > 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.
> > ;
> >
> > On Sun, Mar 10, 2013 at 1:44 AM, andyha8 <andyha8@
> >
> > > 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")
> > >
> >
>
Sat Mar 23, 2013 12:59 pm (PDT) . Posted by:
"andyha8" andyha8
Randy, forget about it. I messed around with some firefox settings and now it's working again. Not sure what I did, but it works so it's all good. Have a great day.
--- In smf_addin@yahoogroups.com , "andyha8" <andyha8@...> wrote:
>
> Hey Randy:
>
> This has been working great but since yesterday this:
>
> =HYPERLINK("http://finance.yahoo.com/echarts?s= "&$C2&"+Interactive#symbol=coo;range=6m;compare=;indicator=ema(20,100)+macd+rsi+volume;charttype=candlestick;crosshair=on;ohlcvalues=0;logscale=off;source=undefined",$C2&"")
>
> is taking me here:
>
> http://finance.yahoo.com/echarts?s=OCN#symbol=ocn;range=1y;compare=;indicator=volume;charttype=area;crosshair=on;ohlcvalues=0;logscale=off;source=undefined;
>
> It's the right chart, but none of the indicators.
>
> Any ideas?
>
>
> --- In smf_addin@yahoogroups.com , "andyha8" <andyha8@> wrote:
> >
> > It's working!!! Been messing around with this and I'm not sure what I did but it is now working beautifully. Many thanks again.
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > 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@> 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")
> > > >
> > >
> >
>
--- In smf_addin@yahoogrou
>
> Hey Randy:
>
> This has been working great but since yesterday this:
>
> =HYPERLINK("http://finance.
>
> is taking me here:
>
> http://finance.
>
> It's the right chart, but none of the indicators.
>
> Any ideas?
>
>
> --- In smf_addin@yahoogrou
> >
> > It's working!!! Been messing around with this and I'm not sure what I did but it is now working beautifully. Many thanks again.
> >
> > --- In smf_addin@yahoogrou
> > >
> > > 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.
> > > ;
> > >
> > > On Sun, Mar 10, 2013 at 1:44 AM, andyha8 <andyha8@
> > >
> > > > 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")
> > > >
> > >
> >
>
Sat Mar 23, 2013 2:05 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Worked fine here...
Maybe a temporary glitch on Yahoo's part? I was actually surprised it
worked when you asked about it -- in the past, you could never get back to
the indicators with the URLs.
On Sat, Mar 23, 2013 at 12:31 PM, andyha8 <andyha8@gmail.com > wrote:
> Hey Randy:
>
> This has been working great but since yesterday this:
>
> =HYPERLINK("http://finance.yahoo.com/echarts?s=
> "&$C2&"+Interactive#symbol=coo;range=6m;compare=;indicator=ema(20,100)+macd+rsi+volume;charttype=candlestick;crosshair=on;ohlcvalues=0;logscale=off;source=undefined",$C2&"")
>
> is taking me here:
>
>
> http://finance.yahoo.com/echarts?s=OCN#symbol=ocn;range=1y;compare=;indicator=volume;charttype=area;crosshair=on;ohlcvalues=0;logscale=off;source=undefined
> ;
>
> It's the right chart, but none of the indicators.
>
> Any ideas?
>
Maybe a temporary glitch on Yahoo's part? I was actually surprised it
worked when you asked about it -- in the past, you could never get back to
the indicators with the URLs.
On Sat, Mar 23, 2013 at 12:31 PM, andyha8 <andyha8@gmail.
> Hey Randy:
>
> This has been working great but since yesterday this:
>
> =HYPERLINK("http://finance.
> "&$
>
> is taking me here:
>
>
> http://finance.
> ;
>
> It's the right chart, but none of the indicators.
>
> Any ideas?
>
Sat Mar 23, 2013 12:49 pm (PDT) . Posted by:
"ufdn16" ufdn16
What is the most reliable element number to get the current P/E?
I've used #54 but I get an error for BP. Please lead me to a good number. Thanks, David
I've used #54 but I get an error for BP. Please lead me to a good number. Thanks, David
Sat Mar 23, 2013 2:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It works fine here:
=RCHGetElementNumber("BP",54)
...returns 11.6.
As for reliability, I have no comment. I've not done any kind of comparison.
On Sat, Mar 23, 2013 at 12:49 PM, ufdn16 <ufdn16@yahoo.com > wrote:
> What is the most reliable element number to get the current P/E?
> I've used #54 but I get an error for BP. Please lead me to a good number.
> Thanks, David
>
=RCHGetElementNumbe
...returns 11.6.
As for reliability, I have no comment. I've not done any kind of comparison.
On Sat, Mar 23, 2013 at 12:49 PM, ufdn16 <ufdn16@yahoo.
> What is the most reliable element number to get the current P/E?
> I've used #54 but I get an error for BP. Please lead me to a good number.
> Thanks, David
>
Tidak ada komentar:
Posting Komentar