PDA

View Full Version : Using symbols



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

mdmackillop
03-10-2006, 03:16 PM
In K1, insert =IF(J1>70,A1) and copy down
Regards
MD

smc2911
03-10-2006, 07:26 PM
Note that the formula =IF(J1>70,A1) will give the result "FALSE" in any cell where the value in column A is less than or equal to 70. To improve the aesthetics you might want to use =IF(J1>70,A1,"") or =IF(J1>70,A1,"-") to have a blank cell or "-" respectively instead.

Sean.