Howdy, Stranger!
Categories
- All Categories
- 2.3K StockCharts
- 390 SharpCharts
- 144 Other Charting Tools
- 67 Saved Charts and ChartLists
- 1.5K Scanning
- 72 Data Issues
- 173 Other StockCharts Questions
- 215 Technical Analysis
- 154 Using Technical Analysis
- 2 InterMarket and International
- 19 Market and Breadth Indicators
- 40 Market Analysis
- 105 Trading
- 105 Trading Strategies
- 164 S.C.A.N the StockCharts Answer Network forum
- 65 Using this StockCharts Answer Network forum
- 99 s.c.a.n. archives
- 17 Off-Topic
- 10 The Cogitation & Rumination Emporium
- 7 Forum Test Area
New Members: Be sure to confirm your email address by clicking on the link that was sent to your email inbox. You will not be able to post messages until you click that link.
Know the value of a variable that is most represented over a given period.
Hello everyone,
I'd like to ask you if you know of any methods and/or sources for finding out, for a given market/sector..., the value of a variable that is the most represented over a given period.
- For example, to know on a given date what was the most represented price on all S&P 500 stocks.
- Another example, to find out on a given date what was the most represented ATR value on all S&P 500 stocks.
Thank you in advance for your answers.
I'd like to ask you if you know of any methods and/or sources for finding out, for a given market/sector..., the value of a variable that is the most represented over a given period.
- For example, to know on a given date what was the most represented price on all S&P 500 stocks.
- Another example, to find out on a given date what was the most represented ATR value on all S&P 500 stocks.
Thank you in advance for your answers.
0
Comments
do you mean most frequently occurring?
The scan engine only returns symbols, not numbers, so you can't do counts in a scan.
But, you can include a "rank by" statement in your scan that will display the requested values in order on the results page, if that helps.
An example:
[group is sp500]
rank by close
Another example:
[group is sp500]
rank by ATR(14)
For actual counts, you could try downloading the scan results as a .csv file (download button at the top of results page), importing it into Excel or another spreadsheet, and using a function like COUNTIF( ) or COUNTIFS( ). Or maybe functions for average, mean, mode, etc.