Sheet1Click File > Make a copy.. to start using this spreadsheet

Ticker
: Fill in the tickers you wish to add to you watchlist in this columnPrice
: Current stock priceChange %
: The percentage the stock price has moved relative to its previous close. Red is lower, green is higher.PE
: Price/Earnings ratio52wklow
: The lowest price the stock has traded at in the last 52 weeks52wkhigh
: The highest price the stock has traded at in the last 52 weeks%>low
: How far the current price is from the 52wklow. Green is less than 10%, red is more than 60%Div. Yield
: The dividend yield of the stockIBM165.49-0.3610.51149.52196.410.68%3.10%KO40.030.0225.2739.06452.48%3.30%More spreadsheets onAAPL126.75-0.5915.6790.77134.5439.64%1.60%valuespreadsheet.comUVE24.41.2910.5511.8827.73105.39%2.00%JPM68.960.4212.6454.2669.8227.09%2.60%INTC31.02-3.0313.1729.3137.95.83%3.00%EZPW7.66-2.0510.147.112.357.89%COH36.121.1521.4532.7243.8710.39%3.80%TFM32.590.6225.6729.3142.1211.19%EW146.081.0218.0884.05150.4173.80%BRLI41.614.3622.926.3246.7458.09%CHRW63.040.9120.0161.4677.492.57%2.40%FRAN13.85-0.1419.0711.0218.2325.68%MYGN34.141.4327.2431.3440.58.93%NOV49.410.909.5446.0886.557.23%3.70%JNJ99.650.5417.8495.1109.494.78%3.00%BEN50.480.6413.1849.1259.432.77%1.20%CPA83.2-1.2111.3983.18157.980.02%4.00%DDD20.05-2.1019.8369.561.11%0.60%BBBY71.112.7213.8856.1879.6426.58%