8 New Messages
Digest #2961
Messages
Sun Feb 9, 2014 1:08 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The 200-ticker limit has been in place as long as I've been using Yahoo's
CSV file...
The oldest message I can find on this Yahoo group about the 200-ticker
limit is from 2006, but I was using the CSV file before I started this
group.
I originally wrote some of the early add-in routines when I was on the
XLTraders group. The earliest message I could find that mentions the
200-ticker limit there is from 2001.
On Sun, Feb 9, 2014 at 1:29 AM, <dustinsmoak@live.com> wrote:
>
> Just wondering: When did the 200 ticker limit start in Yahoo's end? I was
> def. able to load far more than 200 tickers with a single array formula in
> the past. It very well may have been over a year ago, though.
>
CSV file...
The oldest message I can find on this Yahoo group about the 200-ticker
limit is from 2006, but I was using the CSV file before I started this
group.
I originally wrote some of the early add-in routines when I was on the
XLTraders group. The earliest message I could find that mentions the
200-ticker limit there is from 2001.
On Sun, Feb 9, 2014 at 1:29 AM, <dustinsmoak@
>
> Just wondering: When did the 200 ticker limit start in Yahoo's end? I was
> def. able to load far more than 200 tickers with a single array formula in
> the past. It very well may have been over a year ago, though.
>
Sun Feb 9, 2014 6:46 am (PST) . Posted by:
mrothaus
I expected that there would be some undesirable side effect from the fix for blank tickers, but didn't know of one until now. However, if somebody has 20 tickers interspersed through 200 rows (not contiguous and not starting in rows 1 - 20), I think it is worse to have the result range shifted and mis-aligned with the input range. I'd rather have the error instead.
Sun Feb 9, 2014 5:59 pm (PST) . Posted by:
"Jason Strauss" g3m1n1980
Randy,
Do you have an Element to screen for RS (relative strength) as shown by market smith or IDB?
I'm not talking about element 1280 - relative strength index.
Jason
Do you have an Element to screen for RS (relative strength) as shown by market smith or IDB?
I'm not talking about element 1280 - relative strength index.
Jason
Sun Feb 9, 2014 6:21 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
No elements, but you should find other formulas to do what you need on this
template:
RCHGetTableCell-Template-IBD-Stock-Checkup.xls
Before using the add-in functions to access their web pages, you'll need to
create an IE security cookie by either logging in via EXCEL's Web Query
dialog (preferred, keyboard shortcut alt+d+d+w) or with IE. Logging in with
something like FireFox will not work.
Also, note that IBD's terms of service limit how many Stock Checkups you
can access within a 24-hour period. I think it's 300 or so?
On Sun, Feb 9, 2014 at 6:59 PM, Jason Strauss <xxjaysonxx@aol.com> wrote:
>
> Do you have an Element to screen for RS (relative strength) as shown by
> market smith or IDB?
>
> I'm not talking about element 1280 - relative strength index.
>
template:
RCHGetTableCell-
Before using the add-in functions to access their web pages, you'll need to
create an IE security cookie by either logging in via EXCEL's Web Query
dialog (preferred, keyboard shortcut alt+d+d+w) or with IE. Logging in with
something like FireFox will not work.
Also, note that IBD's terms of service limit how many Stock Checkups you
can access within a 24-hour period. I think it's 300 or so?
On Sun, Feb 9, 2014 at 6:59 PM, Jason Strauss <xxjaysonxx@aol.
>
> Do you have an Element to screen for RS (relative strength) as shown by
> market smith or IDB?
>
> I'm not talking about element 1280 - relative strength index.
>
Sun Feb 9, 2014 7:00 pm (PST) . Posted by:
"J@Y" g3m1n1980
I cant locate this template in the files section. What am I missing?
-----Original Message-----
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Sun, Feb 9, 2014 9:21 pm
Subject: Re: [smf_addin] RS
No elements, but you should find other formulas to do what you need on this template:
RCHGetTableCell-Template-IBD-Stock-Checkup.xls
Before using the add-in functions to access their web pages, you'll need to create an IE security cookie by either logging in via EXCEL's Web Query dialog (preferred, keyboard shortcut alt+d+d+w) or with IE. Logging in with something like FireFox will not work.
Also, note that IBD's terms of service limit how many Stock Checkups you can access within a 24-hour period. I think it's 300 or so?
On Sun, Feb 9, 2014 at 6:59 PM, Jason Strauss <xxjaysonxx@aol.com> wrote:
Do you have an Element to screen for RS (relative strength) as shown by market smith or IDB?
I'm not talking about element 1280 - relative strength index.
-----Original Message-----
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin <smf_addin@yahoogrou
Sent: Sun, Feb 9, 2014 9:21 pm
Subject: Re: [smf_addin] RS
No elements, but you should find other formulas to do what you need on this template:
RCHGetTableCell-
Before using the add-in functions to access their web pages, you'll need to create an IE security cookie by either logging in via EXCEL's Web Query dialog (preferred, keyboard shortcut alt+d+d+w) or with IE. Logging in with something like FireFox will not work.
Also, note that IBD's terms of service limit how many Stock Checkups you can access within a 24-hour period. I think it's 300 or so?
On Sun, Feb 9, 2014 at 6:59 PM, Jason Strauss <xxjaysonxx@aol.
Do you have an Element to screen for RS (relative strength) as shown by market smith or IDB?
I'm not talking about element 1280 - relative strength index.
Sun Feb 9, 2014 7:02 pm (PST) . Posted by:
"J@Y" g3m1n1980
Nevermind found it
-----Original Message-----
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Sun, Feb 9, 2014 9:21 pm
Subject: Re: [smf_addin] RS
No elements, but you should find other formulas to do what you need on this template:
RCHGetTableCell-Template-IBD-Stock-Checkup.xls
Before using the add-in functions to access their web pages, you'll need to create an IE security cookie by either logging in via EXCEL's Web Query dialog (preferred, keyboard shortcut alt+d+d+w) or with IE. Logging in with something like FireFox will not work.
Also, note that IBD's terms of service limit how many Stock Checkups you can access within a 24-hour period. I think it's 300 or so?
On Sun, Feb 9, 2014 at 6:59 PM, Jason Strauss <xxjaysonxx@aol.com> wrote:
Do you have an Element to screen for RS (relative strength) as shown by market smith or IDB?
I'm not talking about element 1280 - relative strength index.
-----Original Message-----
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin <smf_addin@yahoogrou
Sent: Sun, Feb 9, 2014 9:21 pm
Subject: Re: [smf_addin] RS
No elements, but you should find other formulas to do what you need on this template:
RCHGetTableCell-
Before using the add-in functions to access their web pages, you'll need to create an IE security cookie by either logging in via EXCEL's Web Query dialog (preferred, keyboard shortcut alt+d+d+w) or with IE. Logging in with something like FireFox will not work.
Also, note that IBD's terms of service limit how many Stock Checkups you can access within a 24-hour period. I think it's 300 or so?
On Sun, Feb 9, 2014 at 6:59 PM, Jason Strauss <xxjaysonxx@aol.
Do you have an Element to screen for RS (relative strength) as shown by market smith or IDB?
I'm not talking about element 1280 - relative strength index.
Sun Feb 9, 2014 7:12 pm (PST) . Posted by:
"J@Y" g3m1n1980
Randy,
Last question. To use this template, do you need to have access to the paid service? I dont think the checkup area if for all visitors
My guess is yes as im now getting error returned.
-----Original Message-----
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin <smf_addin@yahoogroups.com>
Sent: Sun, Feb 9, 2014 9:21 pm
Subject: Re: [smf_addin] RS
No elements, but you should find other formulas to do what you need on this template:
RCHGetTableCell-Template-IBD-Stock-Checkup.xls
Before using the add-in functions to access their web pages, you'll need to create an IE security cookie by either logging in via EXCEL's Web Query dialog (preferred, keyboard shortcut alt+d+d+w) or with IE. Logging in with something like FireFox will not work.
Also, note that IBD's terms of service limit how many Stock Checkups you can access within a 24-hour period. I think it's 300 or so?
On Sun, Feb 9, 2014 at 6:59 PM, Jason Strauss <xxjaysonxx@aol.com> wrote:
Do you have an Element to screen for RS (relative strength) as shown by market smith or IDB?
I'm not talking about element 1280 - relative strength index.
Last question. To use this template, do you need to have access to the paid service? I dont think the checkup area if for all visitors
My guess is yes as im now getting error returned.
-----Original Message-----
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin <smf_addin@yahoogrou
Sent: Sun, Feb 9, 2014 9:21 pm
Subject: Re: [smf_addin] RS
No elements, but you should find other formulas to do what you need on this template:
RCHGetTableCell-
Before using the add-in functions to access their web pages, you'll need to create an IE security cookie by either logging in via EXCEL's Web Query dialog (preferred, keyboard shortcut alt+d+d+w) or with IE. Logging in with something like FireFox will not work.
Also, note that IBD's terms of service limit how many Stock Checkups you can access within a 24-hour period. I think it's 300 or so?
On Sun, Feb 9, 2014 at 6:59 PM, Jason Strauss <xxjaysonxx@aol.
Do you have an Element to screen for RS (relative strength) as shown by market smith or IDB?
I'm not talking about element 1280 - relative strength index.
Sun Feb 9, 2014 7:27 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Yes, you do have to be a member. That's why you need to log in and create
the IE security cookie.
On Sun, Feb 9, 2014 at 8:12 PM, J@Y <xxjaysonxx@aol.com> wrote:
>
> Last question. To use this template, do you need to have access to the
> paid service? I dont think the checkup area if for all visitors
>
> My guess is yes as im now getting error returned.
>
the IE security cookie.
On Sun, Feb 9, 2014 at 8:12 PM, J@Y <xxjaysonxx@aol.
>
> Last question. To use this template, do you need to have access to the
> paid service? I dont think the checkup area if for all visitors
>
> My guess is yes as im now getting error returned.
>
Tidak ada komentar:
Posting Komentar