STOCK FORMULAS
STOCK FORMULAS
Formulas for creating a STOCK INDEX chart.?
Hi thanks in advance for your help,
I'm trying to create a stock index chart. This chart should show how various stocks are doing against the S&P over a period of time. Once I down load the historical stock prices into excel what are the two formulas I need to enter in the "blank" columns to the right to get the information I need to create my graph.
Sounds like you are trying to create an index.
For the S&P or any of the stocks you choose, you want to divide the day's closing price by the 1st day's closing price.
If you pulled data from January 1st, 2007 for today, you would divide the closing price on May 2, 2008 by Jan 1, 2007. You should probably multiply your results by 100. This will give you an index value where Day 1 = 100
 |
New Wedding Engagement Set Ring 155 Ct Diamond Round Cut H SI2 14K White Gold | US $1,171.00 | 19m |
 |
Stud Earrings 129 Ct I SI2 Round Cut Natural Diamond 14K Yellow Gold | US $1,103.00 | 1h 34m |
 |
Oliver Velez Essential Strategies to Trade for Life 1 System Passive Income | US $59.00 | 1h 36m |
 |
New Engagement Ring 183 Ct Natural Diamond Round Cut F VS2 18K White Gold | US $3,049.00 | 9h 8m |
 |
CHIC Bean™ NaturalCare lip balm Sweet Orange Clove with Organic Shea Butter | US $5.26 | 10h 8m |
 |
Wei East Gift of BeautyNEW | US $16.50 | 10h 43m |
 |
Wei East Buy One Get One Chestnut Eye Beauty Treatment | US $12.99 | 10h 44m |
 |
Wei East Chestnut Lifting Serum and Firming Essence | US $8.25 | 10h 46m |
 |
1 PACK Bolt Buffer RUGER 10 22 DONT GET RIPPED | US $7.98 | 11h 5m |
 |
2PACK BOLT BUFFERS FOR RUGER 10 22 DONT GET RIPPED | US $18.01 | 11h 5m |
 |
2PCK BOLT BUFFERS FOR RUGER 10 22 DONT GET RIPPED | US $15.50 | 11h 5m |
 |
BOLT BUFFER FOR RUGER 10 22 MAGNUM DONT GET RIPPED | US $8.95 | 11h 7m |
 |
BOLT BUFFER FOR THE RUGER 10 22 17m2 CONVERSIONS | US $8.98 | 11h 7m |
 |
3PCK BOLT BUFFERS RUGER 10 22 DONT GET RIPPED | US $17.98 | 11h 7m |
 |
BREAST ENHANCING ENLARGEMENT FIRMING ADVANCED CREAM Pueraria Mirific SILICA | US $6.99 | 11h 9m |
 |
MENS ADVANCED ANTI AGING POWERFUL PHEROMONES BODY CREAM OLIGOPEPTIDE | US $10.00 | 11h 18m |
 |
BEAUTIFUL HAND BLOWN GLASS ART VASE | US $159.00 | 11h 59m |
 |
Wei East White Lotus Moonlight Recovery Cream | US $10.99 | 13h 6m |
 |
CHIC Bean™ NaturalCare lip balm Sweet Mandarin Nutmeg with Organic Shea Butter | US $5.26 | 14h 58m |
 |
Red Stag Testosterone Booster Male Enhancement Two Months Supply | US $16.05 | 15h 13m |
 |
Real Princess Cut Natural Diamond H SI2 172 Ct Cross Pendant 18K White Gold | US $1,045.00 | 16h 5m |
 |
Foundations of Finance The Logic and Practice of Financial Management by | US $6.99 | 16h 13m |
 |
HAND DYED RUG HOOKING WOOL Over Dyed FERN HOLLOW | US $10.50 | 17h 9m |
 |
Tincture Herbal Extracts Chamomile Licorice Rt Marshmallow Rt Ginko etc 1 oz | US $8.85 | 17h 18m |
 |
MAYBELLINE SUPERSTAY SILKY FOUNDATION CARAMEL | US $9.95 | 18h 25m |
 |
Survival Gun books solar cooker alternative energy low tech house building SHTF | US $6.95 | 18h 41m |
 |
ANTIFUNGAL FUNGAL NAIL TOENAIL FUNGUS PEDICURE NA080 1 | US $1.57 | 18h 58m |
 |
Perlier Red Gold Skincare Beauty Kit w Pink Bag NEW | US $12.99 | 19h 7m |
 |
MAYBELLINE SUPERSTAY SILKY FOUNDATION COCOA | US $9.95 | 19h 8m |
 |
Brand NEW Sealed 2007 Mosbys Nursing Drug CardsOn SaleFREE Shipping | US $65.00 | 21h 33m |
 |
18K Yellow Gold 106 Ct I SI2 Round Cut Diamond Anniversary Engagement Ring Set | US $858.00 | 21h 44m |
 |
HAND DYED RUG HOOKING WOOL Over Dyed SMOKIN | US $12.50 | 22h 28m |
 |
USP Labs New OxyElite Pro Super Thermogenic Fat Burner 90 Caps FREE Sample | US $35.08 | 22h 48m |
 |
CHICKEN COOP PLANS HEN HOUSE FEED HATCHING EGG CANDLER WATERER HOW TO FEED NEST | US $9.95 | 22h 52m |
 |
SAUSAGE MAKING RECIPES MEAT CURING BOOKS DELI SECRETS BUTCHER PORK SMOKE FISH CD | US $9.95 | 22h 53m |
 |
GOOD dark Epidote crystals Ex Kendig Collection Calumet Mine Salida COLORADO | US $1.98 | 23h 4m |
 |
Who Knew 3 Book Set with 2 Reusable Shopping Totes | US $17.02 | 1d 1h 11m |
 |
Formulas For Stress And Strain Roark 1965 Copyright 4th Edition Brown | US $24.99 | 1d 1h 27m |
 |
14K WG 053 Ct H SI2 Princess Cut Diamond 3 Matching Stone Engagement Ring | US $465.00 | 1d 3h 17m |
 |
Lot of 2 Business Financal Books Paperback | US $.99 | 1d 9h 15m |
 |
CHIC Bean™ NaturalCare lip balm Vanilla Macadamia Nut with Vitamin E | US $5.26 | 1d 10h 50m |
 |
Wardleys PH Down 8OZ BRAND NEW from Factory growingfishplantsAquarium | US $2.20 | 1d 11h |
 |
Wardleys PH Down 8ozBRAND NEW from FactorygrowingfishplantsAquarium | US $2.20 | 1d 11h |
 |
THAI AMULET Phra Khunpaen Wear Insignia Luang Phor Boon Wat Klang Bang Kaew | US $14.00 | 1d 11h 10m |
 |
CHIC Bean™ SpotLight Ready High Light Cover Up with Vitamin E | US $16.60 | 1d 11h 18m |
 |
ALGEBRA Study Guide Books Childrens Math Reference | US $4.00 | 1d 11h 42m |
 |
Thai Amulet Black Khunpaen Wear Insignia LP Boon Pendant | US $14.00 | 1d 11h 57m |
 |
SECRET FORMULAS Science Teacher Guide Books Childrens Gr 1 3 projects lessons | US $4.95 | 1d 12h 16m |
 |
Microsoft Office Excel 2007 Data Analysis and Business Modeling by Wayne L | US $15.00 | 1d 12h 22m |
 |
New Engagement Wedding Ring 076 Ct Diamond Round Cut F VS1 18K White Gold | US $1,319.00 | 1d 13h 7m |
 |
Wall Street Money Machine Revised for the New Millennium by Wade Cook and | US $6.95 | 1d 13h 36m |
 |
1892 Victorian Needlework Book Young Ladies Work Table Tat Crochet Knit Netting | US $17.99 | 1d 14h |
 |
HOW TO RETIRE RICH by JAMES OSHAUGHNESSY HB DJ GREAT CONDITION LOW SHIPPING | US $4.99 | 1d 15h 5m |
 |
New Wedding Band Ring 067 Ct Natural Diamond Princess Cut G SI1 14K White Gold | US $600.00 | 1d 15h 20m |
 |
OPEN OFFICE MICROSOFT WORD EXCEL POWERPOINT COMPATIBLE | US $3.75 | 1d 17h 30m |
 |
HAND DYED RUG HOOKING WOOL Over Dyed CHIMNEY SMOKE | US $10.50 | 1d 17h 49m |
 |
Princess Cut Natural Diamond Stud Earring 067 Ct F VS2 14K White Gold | US $728.00 | 1d 18h 6m |
 |
Stocks Investing Finding Winners Among Low Priced Stocks by Richard L Evans | US $11.99 | 1d 18h 12m |
 |
Wall Street Money Machine by Wade B Cook Wade Cook 1996 Hardcover | US $13.99 | 1d 18h 57m |
 |
Young Living INNER DEFENSE Essential Oils 30 Caps | US $16.50 | 1d 19h 1m |