StockFetcher Forums · Announcements · New Feature: Occurrences -- Count()<< 1 2 >>Post Follow-up
cello13
88 posts
msg #51237
Ignore cello13
4/20/2007 5:48:29 AM

Hi Tomb

I'm wondering if it's possible to count, how many stocks closed above the close 1 day ago? And if so, how to display that figure?

I tried it with the following combination:

Fetcher[set{hi, count(close above close 1 day ago,1)}
and date offset is 1
]




But this shows only 1 or 0 as for each stock. What I'm looking for is the figure, how much stocks in Nasdaq closed above and how many below the day before. Any possibility to show these figures?

TIA

bosscasey
9 posts
msg #91006
Ignore bosscasey
4/10/2010 8:13:38 AM

I realize this thread is several years old, but is there an answer to this question?

Am I looking in the wrong place?

TIA

bc


chetron
2,817 posts
msg #91025
Ignore chetron
4/10/2010 2:38:12 PM

NO YOU CAN NOT POOL STOCKS TOGETHER FOR A SINGLE RESULT.
YOU NEED TO DOWNLOAD YOUR FILTER RESULTS, AND LOAD THEM INTO A SPREAD SHEET FOR THAT TYPE OF FUNCTION.

four
5,087 posts
msg #91026
Ignore four
modified
4/10/2010 5:59:21 PM

Fetcher[
Show stocks where the count(close > close 1 day ago, 1) is above 0

set{countx, count(close > close 1 day ago, 1) above 0}
add column countx

offset 4/1/2010
Market is NASDAQ
]


/*
look below [Change to Table View] : value is 1477 - is this what you are looking for?
*/


bosscasey
9 posts
msg #91038
Ignore bosscasey
4/11/2010 4:57:25 AM

Thanks Chetron and four. After screwing around with this issue most of the night, I have to agree with you.

four - yes, that number is exactly what I am looking for. I'll manually download it into a spreadsheet. As the stock market generals continue to melt-up these days, I wanted a way to check on the participation of the foot soldiers. This will help in that endeavor.

Again, thanks for the input.

bc


four
5,087 posts
msg #91044
Ignore four
4/11/2010 1:53:48 PM

Thanks for the feedback.

TheRumpledOne
6,411 posts
msg #100363
Ignore TheRumpledOne
4/22/2011 11:51:45 AM

There is a limit of 100 days for accumulating the counts. This restriction is based on performance and hopefully we will be able to increase that value.


Can this be increased?

250 would be nice!!



lis
37 posts
msg #161022
Ignore lis
4/21/2024 12:02:20 AM

I'm trying to do this, but it's giving me zero values for 'hit_btm' or 'hit_top' when there were actually times the high was above the up5 and/or the low was below the down5. What am I doing wrong?

Fetcher[
set{ channeltop, close 100 day high 1 day ago }
set{ channelbtm, close 100 day low 1 day ago }

set{ channel_total_size, channeltop - channelbtm }
set{ half_val, channel_total_size * 0.5 }
set{ channelmid, channeltop - half_val }

set{ pct5_val, channelmid * 0.05 }
set{ up5, channelmid + pct5_val }
set{ down5, channelmid - pct5_val }

set{ hit_btm, count(low below down5, 100) }
set{ hit_top, count(high above up5, 100) }

show stocks where chart-time is 100 days
and chart-type is OHLC
and market is not OTCBB
and market is not ETF
and volume 1 year low 1 day ago > 1,000,000

and add column down5
and draw price line at down5
and do not draw down5

and add column up5
and draw price line at up5
and do not draw up5

and add column hit_btm
and add column hit_top
]



StockFetcher Forums · Announcements · New Feature: Occurrences -- Count()<< 1 2 >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2022 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.