9 New Messages
Digest #2418
Messages
Fri Nov 30, 2012 4:59 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
Why in the world does anyone need 1000 stocks in a worksheet? Please help me
understand why?
Where is this spreadsheet? I'd like to see what it is all about? I'm curious
now.
There are numerous stock screeners, many FREE, to help narrow your list to a
manageable list.
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Andy
Sent: Thursday, November 29, 2012 5:30 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] 1000 Input Tickers Worksheet
This is an awesome template. I have a few questions.
1. The buttons (Link, Remove Link, Force) do not work for me. I get an
error message. Anyone know what is causing this or what the purpose of the
buttons is?
2. I am able to change/replace a ticker but I am not able to add a new row
altogether. Does anyone know how to add a new row?
3. What is the meaning of the color codes?
Thanks,
Andy
------------------------------------
Yahoo! Groups Links
understand why?
Where is this spreadsheet? I'd like to see what it is all about? I'm curious
now.
There are numerous stock screeners, many FREE, to help narrow your list to a
manageable list.
-----Original Message-----
From: smf_addin@yahoogrou
Of Andy
Sent: Thursday, November 29, 2012 5:30 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] 1000 Input Tickers Worksheet
This is an awesome template. I have a few questions.
1. The buttons (Link, Remove Link, Force) do not work for me. I get an
error message. Anyone know what is causing this or what the purpose of the
buttons is?
2. I am able to change/replace a ticker but I am not able to add a new row
altogether. Does anyone know how to add a new row?
3. What is the meaning of the color codes?
Thanks,
Andy
------------
Yahoo! Groups Links
Fri Nov 30, 2012 6:40 am (PST) . Posted by:
"Andy" ahberger
I don't use all 1000. In fact, I only use 100. I simply like the clean format and speed of this template.
Further, I am not screening anything. I am tracking my watch list. I like tracking it in a spreadsheet rather than online because of the increased flexibility - hence my questions below.
I hope that helps, Kermit.
--- In smf_addin@yahoogroups.com , "Kermit W. Prather" <kermitp@...> wrote:
>
> Why in the world does anyone need 1000 stocks in a worksheet? Please help me
> understand why?
>
> Where is this spreadsheet? I'd like to see what it is all about? I'm curious
> now.
>
> There are numerous stock screeners, many FREE, to help narrow your list to a
> manageable list.
>
> -----Original Message-----
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
> Of Andy
> Sent: Thursday, November 29, 2012 5:30 PM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] 1000 Input Tickers Worksheet
>
> This is an awesome template. I have a few questions.
>
> 1. The buttons (Link, Remove Link, Force) do not work for me. I get an
> error message. Anyone know what is causing this or what the purpose of the
> buttons is?
>
> 2. I am able to change/replace a ticker but I am not able to add a new row
> altogether. Does anyone know how to add a new row?
>
> 3. What is the meaning of the color codes?
>
> Thanks,
> Andy
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Further, I am not screening anything. I am tracking my watch list. I like tracking it in a spreadsheet rather than online because of the increased flexibility - hence my questions below.
I hope that helps, Kermit.
--- In smf_addin@yahoogrou
>
> Why in the world does anyone need 1000 stocks in a worksheet? Please help me
> understand why?
>
> Where is this spreadsheet? I'd like to see what it is all about? I'm curious
> now.
>
> There are numerous stock screeners, many FREE, to help narrow your list to a
> manageable list.
>
> -----Original Message-----
> From: smf_addin@yahoogrou
> Of Andy
> Sent: Thursday, November 29, 2012 5:30 PM
> To: smf_addin@yahoogrou
> Subject: [smf_addin] 1000 Input Tickers Worksheet
>
> This is an awesome template. I have a few questions.
>
> 1. The buttons (Link, Remove Link, Force) do not work for me. I get an
> error message. Anyone know what is causing this or what the purpose of the
> buttons is?
>
> 2. I am able to change/replace a ticker but I am not able to add a new row
> altogether. Does anyone know how to add a new row?
>
> 3. What is the meaning of the color codes?
>
> Thanks,
> Andy
>
>
>
> ------------
>
> Yahoo! Groups Links
>
Fri Nov 30, 2012 6:50 am (PST) . Posted by:
"Ron Spruell" hashky
My thoughts exactly.
Files > Uploads by forum members >
Money making worksheets > 1000 input tickers with RCHGetYahooQuotes function-2.xlsm
I couldn't find a description of how they work.
>________________________________
> From: Kermit W. Prather <kermitp@tampabay.rr.com >
>To: smf_addin@yahoogroups.com
>Sent: Friday, November 30, 2012 6:59 AM
>Subject: RE: [smf_addin] 1000 Input Tickers Worksheet
>
>
>
>Why in the world does anyone need 1000 stocks in a worksheet? Please help me
>understand why?
>
>Where is this spreadsheet? I'd like to see what it is all about? I'm curious
>now.
>
>There are numerous stock screeners, many FREE, to help narrow your list to a
>manageable list.
>
>-----Original Message-----
>From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
>Of Andy
>Sent: Thursday, November 29, 2012 5:30 PM
>To: smf_addin@yahoogroups.com
>Subject: [smf_addin] 1000 Input Tickers Worksheet
>
>This is an awesome template. I have a few questions.
>
>1. The buttons (Link, Remove Link, Force) do not work for me. I get an
>error message. Anyone know what is causing this or what the purpose of the
>buttons is?
>
>2. I am able to change/replace a ticker but I am not able to add a new row
>altogether. Does anyone know how to add a new row?
>
>3. What is the meaning of the color codes?
>
>Thanks,
>Andy
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>
>
>
Files > Uploads by forum members >
Money making worksheets > 1000 input tickers with RCHGetYahooQuotes function-2.xlsm
I couldn't find a description of how they work.
>___________
> From: Kermit W. Prather <kermitp@tampabay.
>To: smf_addin@yahoogrou
>Sent: Friday, November 30, 2012 6:59 AM
>Subject: RE: [smf_addin] 1000 Input Tickers Worksheet
>
>
>
>Why in the world does anyone need 1000 stocks in a worksheet? Please help me
>understand why?
>
>Where is this spreadsheet? I'd like to see what it is all about? I'm curious
>now.
>
>There are numerous stock screeners, many FREE, to help narrow your list to a
>manageable list.
>
>-----Original Message-----
>From: smf_addin@yahoogrou
>Of Andy
>Sent: Thursday, November 29, 2012 5:30 PM
>To: smf_addin@yahoogrou
>Subject: [smf_addin] 1000 Input Tickers Worksheet
>
>This is an awesome template. I have a few questions.
>
>1. The buttons (Link, Remove Link, Force) do not work for me. I get an
>error message. Anyone know what is causing this or what the purpose of the
>buttons is?
>
>2. I am able to change/replace a ticker but I am not able to add a new row
>altogether. Does anyone know how to add a new row?
>
>3. What is the meaning of the color codes?
>
>Thanks,
>Andy
>
>-----------
>
>Yahoo! Groups Links
>
>
>
>
>
Fri Nov 30, 2012 7:16 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The speed of the template comes from using an array-entered version of
RCHGetYahooQuotes(). It can get numerous data items on up to 200 tickers in
one Internet access. So you could create your own worksheet pretty easily.
Another source of numerous data items on a ticker list (or all tickers) in
one Internet access is FinViz. See the LINKS are of the group for more info.
On Fri, Nov 30, 2012 at 7:40 AM, Andy <ahberger@yahoo.com > wrote:
> I don't use all 1000. In fact, I only use 100. I simply like the clean
> format and speed of this template.
>
> Further, I am not screening anything. I am tracking my watch list. I
> like tracking it in a spreadsheet rather than online because of the
> increased flexibility - hence my questions below.
>
RCHGetYahooQuotes(
one Internet access. So you could create your own worksheet pretty easily.
Another source of numerous data items on a ticker list (or all tickers) in
one Internet access is FinViz. See the LINKS are of the group for more info.
On Fri, Nov 30, 2012 at 7:40 AM, Andy <ahberger@yahoo.
> I don't use all 1000. In fact, I only use 100. I simply like the clean
> format and speed of this template.
>
> Further, I am not screening anything. I am tracking my watch list. I
> like tracking it in a spreadsheet rather than online because of the
> increased flexibility - hence my questions below.
>
Fri Nov 30, 2012 7:58 am (PST) . Posted by:
"Andy" ahberger
Thanks. Very helpful.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The speed of the template comes from using an array-entered version of
> RCHGetYahooQuotes(). It can get numerous data items on up to 200 tickers in
> one Internet access. So you could create your own worksheet pretty easily.
>
> Another source of numerous data items on a ticker list (or all tickers) in
> one Internet access is FinViz. See the LINKS are of the group for more info.
>
> On Fri, Nov 30, 2012 at 7:40 AM, Andy <ahberger@...> wrote:
>
> > I don't use all 1000. In fact, I only use 100. I simply like the clean
> > format and speed of this template.
> >
> > Further, I am not screening anything. I am tracking my watch list. I
> > like tracking it in a spreadsheet rather than online because of the
> > increased flexibility - hence my questions below.
> >
>
--- In smf_addin@yahoogrou
>
> The speed of the template comes from using an array-entered version of
> RCHGetYahooQuotes(
> one Internet access. So you could create your own worksheet pretty easily.
>
> Another source of numerous data items on a ticker list (or all tickers) in
> one Internet access is FinViz. See the LINKS are of the group for more info.
>
> On Fri, Nov 30, 2012 at 7:40 AM, Andy <ahberger@..
>
> > I don't use all 1000. In fact, I only use 100. I simply like the clean
> > format and speed of this template.
> >
> > Further, I am not screening anything. I am tracking my watch list. I
> > like tracking it in a spreadsheet rather than online because of the
> > increased flexibility - hence my questions below.
> >
>
Fri Nov 30, 2012 11:44 am (PST) . Posted by:
"Andy" ahberger
Is there a trick to adding a new ticker to the list? It seems to take a long time to process the way I am manually adding the ticker.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The speed of the template comes from using an array-entered version of
> RCHGetYahooQuotes(). It can get numerous data items on up to 200 tickers in
> one Internet access. So you could create your own worksheet pretty easily.
>
> Another source of numerous data items on a ticker list (or all tickers) in
> one Internet access is FinViz. See the LINKS are of the group for more info.
>
> On Fri, Nov 30, 2012 at 7:40 AM, Andy <ahberger@...> wrote:
>
> > I don't use all 1000. In fact, I only use 100. I simply like the clean
> > format and speed of this template.
> >
> > Further, I am not screening anything. I am tracking my watch list. I
> > like tracking it in a spreadsheet rather than online because of the
> > increased flexibility - hence my questions below.
> >
>
--- In smf_addin@yahoogrou
>
> The speed of the template comes from using an array-entered version of
> RCHGetYahooQuotes(
> one Internet access. So you could create your own worksheet pretty easily.
>
> Another source of numerous data items on a ticker list (or all tickers) in
> one Internet access is FinViz. See the LINKS are of the group for more info.
>
> On Fri, Nov 30, 2012 at 7:40 AM, Andy <ahberger@..
>
> > I don't use all 1000. In fact, I only use 100. I simply like the clean
> > format and speed of this template.
> >
> > Further, I am not screening anything. I am tracking my watch list. I
> > like tracking it in a spreadsheet rather than online because of the
> > increased flexibility - hence my questions below.
> >
>
Fri Nov 30, 2012 12:35 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I don't know anything about that worksheet. It's not one of mine.
But adding a new ticker to the normal RCHGetYahooQuotes() function is easy
-- I just set it up for the 200 tickers, and I can add or change any of the
200 ticker cells without an issue. If I need to go over 200 ticker symbols,
I just add another function for another 200 ticker symbols.
On Fri, Nov 30, 2012 at 12:44 PM, Andy <ahberger@yahoo.com > wrote:
> Is there a trick to adding a new ticker to the list? It seems to take a
> long time to process the way I am manually adding the ticker.
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > The speed of the template comes from using an array-entered version of
> > RCHGetYahooQuotes(). It can get numerous data items on up to 200 tickers
> in
> > one Internet access. So you could create your own worksheet pretty
> easily.
> >
> > Another source of numerous data items on a ticker list (or all tickers)
> in
> > one Internet access is FinViz. See the LINKS are of the group for more
> info.
>
But adding a new ticker to the normal RCHGetYahooQuotes(
-- I just set it up for the 200 tickers, and I can add or change any of the
200 ticker cells without an issue. If I need to go over 200 ticker symbols,
I just add another function for another 200 ticker symbols.
On Fri, Nov 30, 2012 at 12:44 PM, Andy <ahberger@yahoo.
> Is there a trick to adding a new ticker to the list? It seems to take a
> long time to process the way I am manually adding the ticker.
>
> --- In smf_addin@yahoogrou
> >
> > The speed of the template comes from using an array-entered version of
> > RCHGetYahooQuotes(
> in
> > one Internet access. So you could create your own worksheet pretty
> easily.
> >
> > Another source of numerous data items on a ticker list (or all tickers)
> in
> > one Internet access is FinViz. See the LINKS are of the group for more
> info.
>
Fri Nov 30, 2012 1:36 pm (PST) . Posted by:
"Andy" ahberger
Sorry, I didn't state my question well.
Does the smfUpdateDownloadTable macro work with RCHGetTableCell? I am trying to prevent frequent updates which bog down the program.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I don't know anything about that worksheet. It's not one of mine.
>
> But adding a new ticker to the normal RCHGetYahooQuotes() function is easy
> -- I just set it up for the 200 tickers, and I can add or change any of the
> 200 ticker cells without an issue. If I need to go over 200 ticker symbols,
> I just add another function for another 200 ticker symbols.
>
> On Fri, Nov 30, 2012 at 12:44 PM, Andy <ahberger@...> wrote:
>
> > Is there a trick to adding a new ticker to the list? It seems to take a
> > long time to process the way I am manually adding the ticker.
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > The speed of the template comes from using an array-entered version of
> > > RCHGetYahooQuotes(). It can get numerous data items on up to 200 tickers
> > in
> > > one Internet access. So you could create your own worksheet pretty
> > easily.
> > >
> > > Another source of numerous data items on a ticker list (or all tickers)
> > in
> > > one Internet access is FinViz. See the LINKS are of the group for more
> > info.
> >
>
Does the smfUpdateDownloadTa
--- In smf_addin@yahoogrou
>
> I don't know anything about that worksheet. It's not one of mine.
>
> But adding a new ticker to the normal RCHGetYahooQuotes(
> -- I just set it up for the 200 tickers, and I can add or change any of the
> 200 ticker cells without an issue. If I need to go over 200 ticker symbols,
> I just add another function for another 200 ticker symbols.
>
> On Fri, Nov 30, 2012 at 12:44 PM, Andy <ahberger@..
>
> > Is there a trick to adding a new ticker to the list? It seems to take a
> > long time to process the way I am manually adding the ticker.
> >
> > --- In smf_addin@yahoogrou
> > >
> > > The speed of the template comes from using an array-entered version of
> > > RCHGetYahooQuotes(
> > in
> > > one Internet access. So you could create your own worksheet pretty
> > easily.
> > >
> > > Another source of numerous data items on a ticker list (or all tickers)
> > in
> > > one Internet access is FinViz. See the LINKS are of the group for more
> > info.
> >
>
Fri Nov 30, 2012 1:59 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
For most uses of RCHGetTableCell() it does. Unfortunately, it doesn't work
with functions like RCHGetYahooQuotes() when they are used to return
multiple data items.
I have a number of workbooks with smfUpdateDownloadTable where I want to be
in control of when things update. Usually only once, after I open the
workbook.
Adding tickers to smfUpdateDownloadTable shouldn't be an issue -- it keeps
processing row after row until the ticker cell for a row is empty.
On Fri, Nov 30, 2012 at 2:36 PM, Andy <ahberger@yahoo.com > wrote:
>
> Does the smfUpdateDownloadTable macro work with RCHGetTableCell? I am
> trying to prevent frequent updates which bog down the program.
>
with functions like RCHGetYahooQuotes(
multiple data items.
I have a number of workbooks with smfUpdateDownloadTa
in control of when things update. Usually only once, after I open the
workbook.
Adding tickers to smfUpdateDownloadTa
processing row after row until the ticker cell for a row is empty.
On Fri, Nov 30, 2012 at 2:36 PM, Andy <ahberger@yahoo.
>
> Does the smfUpdateDownloadTa
> trying to prevent frequent updates which bog down the program.
>
Tidak ada komentar:
Posting Komentar