4 New Messages
Digest #2855
Messages
Tue Nov 12, 2013 7:19 pm (PST) . Posted by:
altaclip
If anyone else subscribes to zacks and would like to try this I created a screen of ZR 1 & 2, price >$1,exclude OTC, & ave vol >100K. It looks like any screens saved by users get a unique id# so anyone can run them. I think this array currently returns about 420+ rows and 12-13 columns.
=smfGetCSVFile("http://screener.zacks.com/export"&LEFT(RCHGetWebData("http://screener.zacks.com/screens/1781886/run",1,1),0))
---In smf_addin@yahoogroups.com, <altaclip@...> wrote:
I worked and returned 126 rows (125 stocks) once I clicked on the web query import data and entered my zacks account info. Errors prior to logging in.
There currently are about 228 ZR #1's
"Solid Growth and Low Valuations" also worked for me and returned the following items (not sure how many columns)
ABG BGFV DAL HIG LAD LCC MTOR
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Since you use Zacks, can you try something for me?
Array-enter this over a 300-row by 3-column range:
=smfGetCSVFile("http://screener.zacks.com/export http://screener.zacks.com/export"&LEFT(RCHGetWebData("http://screener.zacks.com/screens/1781741/run http://screener.zacks.com/screens/1781741/run",1,1),0))
If it works properly, it should return a list of the Zacks #1 stocks.
The "http://screener.zacks.com/screens/1781741/run http://screener.zacks.com/screens/1781741/run" runs a saved screen I have and then the "http://screener.zacks.com/export http://screener.zacks.com/export" exports a CSV file containing the results of that screen.
I know it works for my saved screens and predefined screens. I'm just curious if the saved screens are unassociated with users when running them, or if they are keyed to specific users and only they can run them.
This would be Zack's predefined screen for "Solid Growth and Low Valuations":
=smfGetCSVFile("http://screener.zacks.com/export http://screener.zacks.com/export"&LEFT(RCHGetWebData("http://screener.zacks.com/screens/16536/run http://screener.zacks.com/screens/16536/run",1,1),0))
On Tue, Nov 12, 2013 at 6:18 PM, <altaclip@... mailto:altaclip@...> wrote:
The new Zacks element definitions seem to be working well but I wonder why the Zacks Rank is not updating in a timely manner.
i.e. JAZZ was upgraded to ZR #1 on Nov 8. I've updated my smfupdatedownloadtable many times every day Nov 9-12 and it still shows #3 for ZR.
There are other examples.
I am a Zacks premium subscriber.
Anyone else notice certain Z elements not updating in a timely manenr?
=smfGetCSVFile(
---In smf_addin@yahoogrou
I worked and returned 126 rows (125 stocks) once I clicked on the web query import data and entered my zacks account info. Errors prior to logging in.
There currently are about 228 ZR #1's
"Solid Growth and Low Valuations" also worked for me and returned the following items (not sure how many columns)
ABG BGFV DAL HIG LAD LCC MTOR
---In smf_addin@yahoogrou
Since you use Zacks, can you try something for me?
Array-enter this over a 300-row by 3-column range:
=smfGetCSVFile(
If it works properly, it should return a list of the Zacks #1 stocks.
The "http://screener.
I know it works for my saved screens and predefined screens. I'm just curious if the saved screens are unassociated with users when running them, or if they are keyed to specific users and only they can run them.
This would be Zack's predefined screen for "Solid Growth and Low Valuations"
=smfGetCSVFile(
On Tue, Nov 12, 2013 at 6:18 PM, <altaclip@
The new Zacks element definitions seem to be working well but I wonder why the Zacks Rank is not updating in a timely manner.
i.e. JAZZ was upgraded to ZR #1 on Nov 8. I've updated my smfupdatedownloadta
There are other examples.
I am a Zacks premium subscriber.
Anyone else notice certain Z elements not updating in a timely manenr?
Tue Nov 12, 2013 9:20 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. Not working for me. Tells me "no results returned", and the criteria
don't match what you cite below.
So maybe the screens aren't transferable from person to person?
On Tue, Nov 12, 2013 at 8:19 PM, <altaclip@gmail.com> wrote:
> If anyone else subscribes to zacks and would like to try this I created
> a screen of ZR 1 & 2, price >$1,exclude OTC, & ave vol >100K. It looks like
> any screens saved by users get a unique id# so anyone can run them. I think
> this array currently returns about 420+ rows and 12-13 columns.
>
> =smfGetCSVFile("http://screener.zacks.com/export"&LEFT(RCHGetWebData("
> http://screener.zacks.com/screens/1781886/run",1,1),0))
>
don't match what you cite below.
So maybe the screens aren't transferable from person to person?
On Tue, Nov 12, 2013 at 8:19 PM, <altaclip@gmail.
> If anyone else subscribes to zacks and would like to try this I created
> a screen of ZR 1 & 2, price >$1,exclude OTC, & ave vol >100K. It looks like
> any screens saved by users get a unique id# so anyone can run them. I think
> this array currently returns about 420+ rows and 12-13 columns.
>
> =smfGetCSVFile(
> http://screener.
>
Tue Nov 12, 2013 10:52 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I tried a few other numbers at random, and they seemed to work.
I wonder if it takes a while for a new screen to be available to others.
On Tue, Nov 12, 2013 at 8:19 PM, <altaclip@gmail.com> wrote:
> If anyone else subscribes to zacks and would like to try this I created a
> screen of ZR 1 & 2, price >$1,exclude OTC, & ave vol >100K. It looks like
> any screens saved by users get a unique id# so anyone can run them. I think
> this array currently returns about 420+ rows and 12-13 columns.
>
> =smfGetCSVFile("http://screener.zacks.com/export"&LEFT(RCHGetWebData("
> http://screener.zacks.com/screens/1781886/run",1,1),0))
>
>
I wonder if it takes a while for a new screen to be available to others.
On Tue, Nov 12, 2013 at 8:19 PM, <altaclip@gmail.
> If anyone else subscribes to zacks and would like to try this I created a
> screen of ZR 1 & 2, price >$1,exclude OTC, & ave vol >100K. It looks like
> any screens saved by users get a unique id# so anyone can run them. I think
> this array currently returns about 420+ rows and 12-13 columns.
>
> =smfGetCSVFile(
> http://screener.
>
>
Tue Nov 12, 2013 11:19 pm (PST) . Posted by:
altaclip
Sorry I think I deleted that screen while editing.
I saved another one 1781996 if you want to test a screen from another user.
Zacks Rank 1/2/3
Ave Vol >100K, Price >$1, exclude OTC
5 yr ESP growth >8%
5 Yr Div growth >10%
Cur yield >2%
PEG <1.5
P/E (F2) <18
EG this yr >14%
Approx. 13 results but none are ZR1 atm.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
I tried a few other numbers at random, and they seemed to work.
I wonder if it takes a while for a new screen to be available to others.
On Tue, Nov 12, 2013 at 8:19 PM, <altaclip@... mailto:altaclip@...> wrote:
If anyone else subscribes to zacks and would like to try this I created a screen of ZR 1 & 2, price >$1,exclude OTC, & ave vol >100K. It looks like any screens saved by users get a unique id# so anyone can run them. I think this array currently returns about 420+ rows and 12-13 columns. =smfGetCSVFile("http://screener.zacks.com/export http://screener.zacks.com/export"&LEFT(RCHGetWebData("http://screener.zacks.com/screens/1781886/run http://screener.zacks.com/screens/1781886/run",1,1),0))
I saved another one 1781996 if you want to test a screen from another user.
Zacks Rank 1/2/3
Ave Vol >100K, Price >$1, exclude OTC
5 yr ESP growth >8%
5 Yr Div growth >10%
Cur yield >2%
PEG <1.5
P/E (F2) <18
EG this yr >14%
Approx. 13 results but none are ZR1 atm.
---In smf_addin@yahoogrou
I tried a few other numbers at random, and they seemed to work.
I wonder if it takes a while for a new screen to be available to others.
On Tue, Nov 12, 2013 at 8:19 PM, <altaclip@
If anyone else subscribes to zacks and would like to try this I created a screen of ZR 1 & 2, price >$1,exclude OTC, & ave vol >100K. It looks like any screens saved by users get a unique id# so anyone can run them. I think this array currently returns about 420+ rows and 12-13 columns. =smfGetCSVFile(
Tidak ada komentar:
Posting Komentar