|
PureBytes Links
Trading Reference Links
|
Hi,
Copy& paste to Excel is the easiest way that I know of.
Also Excel has a useful counting function, "COUNTIF".
In the first part you specify the column and the maximum possible number of rows of data.
In the second part, you can specify some condition that you are interested in.
For example,
If you want to count how many items in column A of your exploration have value greater than 2.618, use the Excel formula:
=COUNTIF(A1:A9999,">2.618")
and to count how many items (non-blank lines) there are altogether, use the Excel formula:
=COUNTIF(A1:A9999,"<>")
Cheers,
TonyM in Moscow
=========================
----- Original Message ----
From: Ron Berlin <rsb_44@xxxxxxxxxxx>
To: equismetastock@xxxxxxxxxxxxxxx
Sent: Monday, April 2, 2007 5:13:38 PM
Subject: RE: [EquisMetaStock Group] Total Number of results in an Exploration
Instead of actually counting the result set, copy and paste the results into
Excel being sure to start on row 1. Subtract 1 from the number of rows with
data.
>From: "kevin_de1" <kevinde@xxxxxxxxx rr.com>
>Reply-To: equismetastock@ yahoogroups. com
>To: equismetastock@ yahoogroups. com
>Subject: [EquisMetaStock Group] Total Number of results in an Exploration
>Date: Sun, 01 Apr 2007 03:35:03 -0000
>
>Is there anyone that can show me how to write a formula that will
>display or show the total number of results (stocks)in an exploration.
>I'm trying to insert a formula in one of the exploration columes (A B C
>D or E) that will display the "number of results" for the exploration
>criteria without having to physicaly count the number of results.
>For example: I'm trying to determine the number or percentage of stocks
>that closed higher...the number or percentage of stocks that closed
>lower...or the number or percentage of stocks unchanged in a particular
>group of stocks used in an exploration.
>Thankyou...
>Any help would be greatly appreciated.
>
<!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a {
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc {
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o {font-size:0;}
.MsoNormal {
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq {margin:4;}
-->
____________________________________________________________________________________
Food fight? Enjoy some healthy debate
in the Yahoo! Answers Food & Drink Q&A.
http://answers.yahoo.com/dir/?link=list&sid=396545367
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/equismetastock/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/equismetastock/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:equismetastock-digest@xxxxxxxxxxxxxxx
mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx
<*> To unsubscribe from this group, send an email to:
equismetastock-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|