Tenspeed39355
03-10-2006, 02:40 PM
Good Afternoon guys This is what I would like to do.
I have stock symbols in column A. In column J I have a list of numbers.
If the numbers in column J are more than 70 I would like to put the symbol that is in column A in column K. If this is posable please let me know.
Can I use a IF statement or what do you suggest. Again thanks for your help
Max
YTD 2004 Price Date Perf EMA EMA
DJ30 Dow Jones 30
10,766.33 0.4% 0.8% 2.2% 3.4% 2.0% 2.8% -0.2% 3.1% 10,936.86 3/7/05 -1.6% 2.5% 2.8%
NASDAQ Nasdaq Composite
2,227.07 0.3% 1.1% 2.7% 6.5% 4.3% 8.8% 2.4% 8.6% 2,227.07 11/18/05
0.0% 4.0% 6.4%
NDX Nasdaq 100
1,679.85 0.2% 1.6% 3.2% 7.0% 6.7% 9.9% 3.6% 10.4% 1,679.85 11/18/05
0.0% 5.0% 8.2%
SPX S&P 500
1,248.27 0.4% 1.1% 2.3% 4.4% 2.3% 5.0% 3.0% 9.0% 1,248.27 11/18/05
0.0% 2.8% 4.1%
WIL5 Wilshire 5000
12,495.11 0.4% 1.1% 2.3% 4.8% 2.7% 6.5% 4.4% 10.8% 12,495.11 11/18/05
0.0% 2.9% 4.8%
IVW S&P LC 500 GROWTH
59.58 0.5% 1.2% 2.5% 3.9% 2.3% 4.1% 3.9% 5.7% 59.58 11/18/05
0.0% 2.8% 4.0%
IJK S&P MD 400 GROWTH
74.60 0.3% 1.6% 2.3% 6.7% 4.7% 10.5% 11.5% 14.3% 74.60 11/18/05
0.0% 4.1% 7.8%
IJT S&P SM 600 GROWTH
116.30 0.5% 1.3% 1.8% 4.9% 3.5% 10.8% 8.2% 21.2% 117.14 8/2/05 -0.7% 2.9% 6.3%
IVV S&P LC 500 INDEX
124.66 0.6% 0.8% 2.1% 4.8% 1.6% 4.7% 2.9% 8.9% 124.66 11/18/05
0.0% 2.5% 3.8%
IJH S&P MD 400 INDEX
73.06 0.4% 1.2% 2.0% 6.4% 3.5% 10.3% 11.5% 17.2% 73.06 11/18/05
0.0% 3.5% 7.2%
IJR S&P SM 600 INDEX
58.02 0.5% 0.8% 1.8% 4.7% 2.6% 10.4% 8.2% 24.4% 58.96 8/2/05 -1.6% 2.7% 6.1%
IVE S&P LC 500 VALUE
65.10 0.4% 0.9% 2.4% 5.2% 2.3% 6.0% 3.5% 13.6% 65.10 11/18/05
0.0% 2.9% 4.5%
IJJ S&P MD 400 VALUE
70.37 0.4% 1.2% 2.1% 6.3% 2.6% 10.2% 10.8% 19.5% 70.71 7/28/05 -0.5% 2.9% 6.6%
IJS S&P SM 600 VALUE
64.46 0.8% 0.6% 1.8% 4.8% 2.5% 9.5% 6.6% 24.1% 66.23 8/2/05 -2.7% 2.7% 5.6%
IWB Russell 1000
67.90 0.5% 1.1% 2.3% 6.3% 2.5% 5.8% 4.3% 9.3% 67.90 11/18/05
0.0% 2.9% 4.5%
IWD Russell 1000 Value
68.80 0.2% 0.4% 1.6% 4.1% 1.0% 4.3% 3.8% 13.5% 69.73 9/16/05 -1.3% 1.8% 3.2%
IWF Russell 1000 Growth
51.34 0.4% 1.2% 2.5% 5.0% 3.3% 6.7% 4.7% 4.8% 51.34 11/18/05
0.0% 3.4% 5.3%
IWM Russell 2000
66.88 0.8% 0.7% 2.1% 5.3% 2.7% 10.4% 4.2% 19.3% 68.37 8/2/05 -2.2% 2.9% 5.6%
IWV Russell 3000
72.12 0.6% 1.1% 2.3% 4.6% 2.4% 6.0% 4.3% 9.8% 72.12 11/18/05
0.0% 2.9% 4.6%
IWS Russell Mid Cap Value
123.73 0.4% 1.4% 2.4% 4.9% 1.9% 8.6% 9.7% 20.9% 124.97 9/12/05 -1.0% 2.5% 5.7%
IWO Russell 2000 Growth
69.56 0.9% 1.1% 2.6% 6.1% 4.1% 12.5% 3.4% 13.6% 70.16 8/2/05 -0.9% 3.6% 6.2%
IWN Russell 2000 Value
66.46 0.9% 0.3% 1.8% 4.9% 2.1% 8.9% 5.0% 25.9% 68.81 8/2/05 -3.4% 2.5% 5.1%
IWR Russell Mid Cap
87.03 0.3% 1.4% 2.2% 5.4% 2.7% 9.9% 10.5% 19.7% 87.19 9/12/05 -0.2% 2.9% 6.6%
MDY Mid Cap SPDRS
133.25 0.3% 1.2% 2.1% 6.4% 3.6% 10.1% 10.8% 15.9% 133.25 11/18/05
0.0% 3.4% 6.9%
IWC Russell Microcap
50.83 0.9% 0.3% 1.7% 4.4% 1.6% NA NA NA 52.00 9/12/05 -2.3% 2.2% 2.0%
FEZ Euro Stoxx 50
40.45 0.8% 1.3% 2.0% 1.8% -0.2% 5.8% 2.9% 16.2% 41.97 9/9/05 -3.6% 0.9% 3.0%
EZU EMU Index
75.35 0.6% 1.1% 1.7% 1.3% 0.5% 6.5% 3.8% 18.5% 77.97 9/9/05 -3.4% 0.8% 3.4%
IEV S&P Europe 350
79.10 -0.2% 0.4% 0.4% 3.3% 0.8% 6.3% 5.1% 19.4% 81.50 9/9/05 -2.9% 0.6% 3.6%
EWO MSCI Austria
26.14 1.2% 3.1% 0.8% 3.8% 2.2% 18.5% 13.6% 73.1% 27.56 9/9/05 -5.2% 1.3% 7.8%
EWK MSCI Belgium
18.96 0.1% 0.1% 1.7% 1.1% 0.4% 4.4% 2.2% 43.3% 19.64 8/11/05 -3.5% 0.4% 2.9%
EWQ MSCI France
25.11 0.8% 0.8% 0.8% 0.3% -1.6% 5.1% 5.2% 17.1% 26.43 8/11/05 -5.0% -0.2% 2.4%
EWG MSCI Germany
19.29 0.3% 1.5% 2.0% 3.0% 0.3% 9.6% 3.5% 15.1% 20.01 9/9/05 -3.6% 1.3% 4.6%
EWI MSCI Italy
24.87 -0.2% 0.6% 0.6% 1.3% -2.5% 1.1% -2.9% 29.8% 26.66 9/9/05 -6.7% -0.8% -0.1%
EWN MSCI Netherlands
19.60 0.8% 1.4% 4.0% 4.0% 2.3% 7.3% 6.5% 12.5% 19.90 3/7/05 -1.5% 2.7% 4.8%
EWP MSCI Spain
35.99 0.4% 0.3% 0.8% -2.1% 0.8% 5.3% 2.0% 27.9% 38.00 9/29/05 -5.3% -0.9% 2.5%
EWD MSCI Sweden
21.58 0.1% 0.3% 1.6% 1.7% -0.6% 5.5% 3.0% 34.4% 22.63 8/11/05 -4.6% 0.4% 3.1%
EWL MSCI Switzerland
18.99 1.4% 0.6% 2.5% 5.6% 7.5% 13.4% 10.4% 16.7% 18.99 11/18/05
0.0% 3.8% 8.8%
EWU MSCI United Kingdom
18.62 0.3% -0.9% -0.7% 3.8% -0.4% 4.4% 2.9% 16.1% 19.48 9/6/05 -4.4% 0.3% 2.2%
EWC MSCI Canada
20.43 -0.6% 0.5% -0.4% 2.2% 4.3% 21.7% 18.2% 21.3% 21.70 10/3/05 -5.9% 0.8% 8.1%
ADRA Asia 50 ADR
79.31 0.7% 2.5% 2.7% 7.6% 11.5% 19.5% 12.4% 7.7% 79.31 11/18/05
0.0% 5.1% 11.0%
EFA MSCI EAFE
57.95 0.8% 1.1% 1.8% 3.7% 4.6% 11.6% 8.5% 19.0% 58.48 9/29/05 -0.9% 2.4% 6.7%
EWJ MSCI Japan
12.53 0.5% 1.5% 2.2% 6.5% 14.7% 24.6% 14.7% 13.3% 12.53 11/18/05
0.0% 5.4% 13.5%
ITF Topix 150 Index
108.78 0.9% 1.9% 2.6% 7.1% 16.4% 26.0% 15.9% 12.3% 108.78 11/18/05
0.0% 5.9% 14.2%
EWY MSCI South Korea
40.81 0.0% 1.3% 5.7% 11.6% 15.4% 27.2% 39.5% 16.8% 40.81 11/18/05
0.0% 6.7% 17.5%
FXI Xinhua China 25
60.78 0.5% 1.0% 2.6% 2.0% -2.9% 11.5% 9.6% NA 65.80 8/15/05 -7.6% 1.2% 3.8%
EWH MSCI Hong Kong
12.80 0.3% 0.2% 0.6% 0.7% -2.6% 7.7% 5.9% 20.9% 13.62 9/29/05 -6.0% -0.1% 2.7%
EWT MSCI Taiwan
11.61 -0.1% -1.1% 3.2% 7.2% -2.6% -1.9% -3.7% 8.1% 12.65 8/3/05 -8.2% 1.7% -0.1%
EWA MSCI Australia
19.19 0.9% 2.6% 4.6% 5.7% 4.6% 16.1% 14.9% 25.0% 19.78 9/29/05 -3.0% 3.1% 8.0%
EWM MSCI Malaysia
7.09 1.3% -0.3% -1.8% -2.3% -3.5% 2.6% -0.8% 10.9% 7.60 7/21/05 -6.7% -1.4% -0.6%
EWS MSCI Singapore
7.85 1.2% 1.6% 2.2% 3.3% -1.1% 5.2% 9.5% 19.5% 8.28 8/2/05 -5.2% 1.0% 3.2%
ADRE Emerging Mrkts 50 ADR
109.86 -0.3% 2.1% 3.7% 9.0% 12.5% 28.7% 32.8% 14.6% 110.18 11/17/05 -0.3% 5.5% 16.1%
EEM MSCI Emerging Mrkts
84.35 0.3% 1.8% 2.8% 7.7% 10.2% 22.8% 25.4% 27.8% 85.42 10/3/05 -1.3% 4.6% 13.5%
ILF S&P Latin America
121.15 -0.8% 1.8% 3.0% 9.0% 21.3% 42.1% 50.4% 36.9% 122.12 11/17/05 -0.8% 6.4% 22.9%
EWW MSCI Mexico
33.86 0.3% 2.8% 4.2% 11.4% 14.4% 33.2% 34.6% 49.0% 33.86 11/18/05
0.0% 7.0% 19.6%
EWZ MSCI Brazil
32.88 -1.2% 0.2% 1.2% 7.3% 27.2% 43.5% 47.8% 30.8% 33.73 10/3/05 -2.5% 5.6% 23.1%
EZA MSCI South Africa
90.36 1.5% 4.3% 4.4% 9.5% 10.6% 27.5% 13.5% 41.5% 91.86 9/30/05 -1.6% 5.5% 13.8%
Cycle High Short
I have stock symbols in column A. In column J I have a list of numbers.
If the numbers in column J are more than 70 I would like to put the symbol that is in column A in column K. If this is posable please let me know.
Can I use a IF statement or what do you suggest. Again thanks for your help
Max
YTD 2004 Price Date Perf EMA EMA
DJ30 Dow Jones 30
10,766.33 0.4% 0.8% 2.2% 3.4% 2.0% 2.8% -0.2% 3.1% 10,936.86 3/7/05 -1.6% 2.5% 2.8%
NASDAQ Nasdaq Composite
2,227.07 0.3% 1.1% 2.7% 6.5% 4.3% 8.8% 2.4% 8.6% 2,227.07 11/18/05
0.0% 4.0% 6.4%
NDX Nasdaq 100
1,679.85 0.2% 1.6% 3.2% 7.0% 6.7% 9.9% 3.6% 10.4% 1,679.85 11/18/05
0.0% 5.0% 8.2%
SPX S&P 500
1,248.27 0.4% 1.1% 2.3% 4.4% 2.3% 5.0% 3.0% 9.0% 1,248.27 11/18/05
0.0% 2.8% 4.1%
WIL5 Wilshire 5000
12,495.11 0.4% 1.1% 2.3% 4.8% 2.7% 6.5% 4.4% 10.8% 12,495.11 11/18/05
0.0% 2.9% 4.8%
IVW S&P LC 500 GROWTH
59.58 0.5% 1.2% 2.5% 3.9% 2.3% 4.1% 3.9% 5.7% 59.58 11/18/05
0.0% 2.8% 4.0%
IJK S&P MD 400 GROWTH
74.60 0.3% 1.6% 2.3% 6.7% 4.7% 10.5% 11.5% 14.3% 74.60 11/18/05
0.0% 4.1% 7.8%
IJT S&P SM 600 GROWTH
116.30 0.5% 1.3% 1.8% 4.9% 3.5% 10.8% 8.2% 21.2% 117.14 8/2/05 -0.7% 2.9% 6.3%
IVV S&P LC 500 INDEX
124.66 0.6% 0.8% 2.1% 4.8% 1.6% 4.7% 2.9% 8.9% 124.66 11/18/05
0.0% 2.5% 3.8%
IJH S&P MD 400 INDEX
73.06 0.4% 1.2% 2.0% 6.4% 3.5% 10.3% 11.5% 17.2% 73.06 11/18/05
0.0% 3.5% 7.2%
IJR S&P SM 600 INDEX
58.02 0.5% 0.8% 1.8% 4.7% 2.6% 10.4% 8.2% 24.4% 58.96 8/2/05 -1.6% 2.7% 6.1%
IVE S&P LC 500 VALUE
65.10 0.4% 0.9% 2.4% 5.2% 2.3% 6.0% 3.5% 13.6% 65.10 11/18/05
0.0% 2.9% 4.5%
IJJ S&P MD 400 VALUE
70.37 0.4% 1.2% 2.1% 6.3% 2.6% 10.2% 10.8% 19.5% 70.71 7/28/05 -0.5% 2.9% 6.6%
IJS S&P SM 600 VALUE
64.46 0.8% 0.6% 1.8% 4.8% 2.5% 9.5% 6.6% 24.1% 66.23 8/2/05 -2.7% 2.7% 5.6%
IWB Russell 1000
67.90 0.5% 1.1% 2.3% 6.3% 2.5% 5.8% 4.3% 9.3% 67.90 11/18/05
0.0% 2.9% 4.5%
IWD Russell 1000 Value
68.80 0.2% 0.4% 1.6% 4.1% 1.0% 4.3% 3.8% 13.5% 69.73 9/16/05 -1.3% 1.8% 3.2%
IWF Russell 1000 Growth
51.34 0.4% 1.2% 2.5% 5.0% 3.3% 6.7% 4.7% 4.8% 51.34 11/18/05
0.0% 3.4% 5.3%
IWM Russell 2000
66.88 0.8% 0.7% 2.1% 5.3% 2.7% 10.4% 4.2% 19.3% 68.37 8/2/05 -2.2% 2.9% 5.6%
IWV Russell 3000
72.12 0.6% 1.1% 2.3% 4.6% 2.4% 6.0% 4.3% 9.8% 72.12 11/18/05
0.0% 2.9% 4.6%
IWS Russell Mid Cap Value
123.73 0.4% 1.4% 2.4% 4.9% 1.9% 8.6% 9.7% 20.9% 124.97 9/12/05 -1.0% 2.5% 5.7%
IWO Russell 2000 Growth
69.56 0.9% 1.1% 2.6% 6.1% 4.1% 12.5% 3.4% 13.6% 70.16 8/2/05 -0.9% 3.6% 6.2%
IWN Russell 2000 Value
66.46 0.9% 0.3% 1.8% 4.9% 2.1% 8.9% 5.0% 25.9% 68.81 8/2/05 -3.4% 2.5% 5.1%
IWR Russell Mid Cap
87.03 0.3% 1.4% 2.2% 5.4% 2.7% 9.9% 10.5% 19.7% 87.19 9/12/05 -0.2% 2.9% 6.6%
MDY Mid Cap SPDRS
133.25 0.3% 1.2% 2.1% 6.4% 3.6% 10.1% 10.8% 15.9% 133.25 11/18/05
0.0% 3.4% 6.9%
IWC Russell Microcap
50.83 0.9% 0.3% 1.7% 4.4% 1.6% NA NA NA 52.00 9/12/05 -2.3% 2.2% 2.0%
FEZ Euro Stoxx 50
40.45 0.8% 1.3% 2.0% 1.8% -0.2% 5.8% 2.9% 16.2% 41.97 9/9/05 -3.6% 0.9% 3.0%
EZU EMU Index
75.35 0.6% 1.1% 1.7% 1.3% 0.5% 6.5% 3.8% 18.5% 77.97 9/9/05 -3.4% 0.8% 3.4%
IEV S&P Europe 350
79.10 -0.2% 0.4% 0.4% 3.3% 0.8% 6.3% 5.1% 19.4% 81.50 9/9/05 -2.9% 0.6% 3.6%
EWO MSCI Austria
26.14 1.2% 3.1% 0.8% 3.8% 2.2% 18.5% 13.6% 73.1% 27.56 9/9/05 -5.2% 1.3% 7.8%
EWK MSCI Belgium
18.96 0.1% 0.1% 1.7% 1.1% 0.4% 4.4% 2.2% 43.3% 19.64 8/11/05 -3.5% 0.4% 2.9%
EWQ MSCI France
25.11 0.8% 0.8% 0.8% 0.3% -1.6% 5.1% 5.2% 17.1% 26.43 8/11/05 -5.0% -0.2% 2.4%
EWG MSCI Germany
19.29 0.3% 1.5% 2.0% 3.0% 0.3% 9.6% 3.5% 15.1% 20.01 9/9/05 -3.6% 1.3% 4.6%
EWI MSCI Italy
24.87 -0.2% 0.6% 0.6% 1.3% -2.5% 1.1% -2.9% 29.8% 26.66 9/9/05 -6.7% -0.8% -0.1%
EWN MSCI Netherlands
19.60 0.8% 1.4% 4.0% 4.0% 2.3% 7.3% 6.5% 12.5% 19.90 3/7/05 -1.5% 2.7% 4.8%
EWP MSCI Spain
35.99 0.4% 0.3% 0.8% -2.1% 0.8% 5.3% 2.0% 27.9% 38.00 9/29/05 -5.3% -0.9% 2.5%
EWD MSCI Sweden
21.58 0.1% 0.3% 1.6% 1.7% -0.6% 5.5% 3.0% 34.4% 22.63 8/11/05 -4.6% 0.4% 3.1%
EWL MSCI Switzerland
18.99 1.4% 0.6% 2.5% 5.6% 7.5% 13.4% 10.4% 16.7% 18.99 11/18/05
0.0% 3.8% 8.8%
EWU MSCI United Kingdom
18.62 0.3% -0.9% -0.7% 3.8% -0.4% 4.4% 2.9% 16.1% 19.48 9/6/05 -4.4% 0.3% 2.2%
EWC MSCI Canada
20.43 -0.6% 0.5% -0.4% 2.2% 4.3% 21.7% 18.2% 21.3% 21.70 10/3/05 -5.9% 0.8% 8.1%
ADRA Asia 50 ADR
79.31 0.7% 2.5% 2.7% 7.6% 11.5% 19.5% 12.4% 7.7% 79.31 11/18/05
0.0% 5.1% 11.0%
EFA MSCI EAFE
57.95 0.8% 1.1% 1.8% 3.7% 4.6% 11.6% 8.5% 19.0% 58.48 9/29/05 -0.9% 2.4% 6.7%
EWJ MSCI Japan
12.53 0.5% 1.5% 2.2% 6.5% 14.7% 24.6% 14.7% 13.3% 12.53 11/18/05
0.0% 5.4% 13.5%
ITF Topix 150 Index
108.78 0.9% 1.9% 2.6% 7.1% 16.4% 26.0% 15.9% 12.3% 108.78 11/18/05
0.0% 5.9% 14.2%
EWY MSCI South Korea
40.81 0.0% 1.3% 5.7% 11.6% 15.4% 27.2% 39.5% 16.8% 40.81 11/18/05
0.0% 6.7% 17.5%
FXI Xinhua China 25
60.78 0.5% 1.0% 2.6% 2.0% -2.9% 11.5% 9.6% NA 65.80 8/15/05 -7.6% 1.2% 3.8%
EWH MSCI Hong Kong
12.80 0.3% 0.2% 0.6% 0.7% -2.6% 7.7% 5.9% 20.9% 13.62 9/29/05 -6.0% -0.1% 2.7%
EWT MSCI Taiwan
11.61 -0.1% -1.1% 3.2% 7.2% -2.6% -1.9% -3.7% 8.1% 12.65 8/3/05 -8.2% 1.7% -0.1%
EWA MSCI Australia
19.19 0.9% 2.6% 4.6% 5.7% 4.6% 16.1% 14.9% 25.0% 19.78 9/29/05 -3.0% 3.1% 8.0%
EWM MSCI Malaysia
7.09 1.3% -0.3% -1.8% -2.3% -3.5% 2.6% -0.8% 10.9% 7.60 7/21/05 -6.7% -1.4% -0.6%
EWS MSCI Singapore
7.85 1.2% 1.6% 2.2% 3.3% -1.1% 5.2% 9.5% 19.5% 8.28 8/2/05 -5.2% 1.0% 3.2%
ADRE Emerging Mrkts 50 ADR
109.86 -0.3% 2.1% 3.7% 9.0% 12.5% 28.7% 32.8% 14.6% 110.18 11/17/05 -0.3% 5.5% 16.1%
EEM MSCI Emerging Mrkts
84.35 0.3% 1.8% 2.8% 7.7% 10.2% 22.8% 25.4% 27.8% 85.42 10/3/05 -1.3% 4.6% 13.5%
ILF S&P Latin America
121.15 -0.8% 1.8% 3.0% 9.0% 21.3% 42.1% 50.4% 36.9% 122.12 11/17/05 -0.8% 6.4% 22.9%
EWW MSCI Mexico
33.86 0.3% 2.8% 4.2% 11.4% 14.4% 33.2% 34.6% 49.0% 33.86 11/18/05
0.0% 7.0% 19.6%
EWZ MSCI Brazil
32.88 -1.2% 0.2% 1.2% 7.3% 27.2% 43.5% 47.8% 30.8% 33.73 10/3/05 -2.5% 5.6% 23.1%
EZA MSCI South Africa
90.36 1.5% 4.3% 4.4% 9.5% 10.6% 27.5% 13.5% 41.5% 91.86 9/30/05 -1.6% 5.5% 13.8%
Cycle High Short