Task #1 Finance 327

Task #1 Finance 327 - T ask#1 Yahoo Finance How to find the...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Task #1- Yaho Finance How to find the info 1 Go to Yaho Finance page 2 Type in name of company 3 In left hand column go to "Historical Prices" 4 Type in desired time frame (i.e. Sept 17 20 3 - 2013) 5 Select "We kly" (or daily, monthly etc) How to download into Excel 6 Scrol to bot om and select "Download to spreadshe t" Any other useful resources 7 8 Any other way to get this information, compare to Yaho ! Finance 9 Any financial page with a SWOT analysis could provide similar information however, the way that yaho finance combines al the information makes it easier to read and navigate to important comparison figures 10 If you go to Go gle finance, it as wel has a very similar layout including "Historical Prices" to the left and an option to download to spreadshe t NIKE Details Date Open High Low Close Volume Adj Close Date,Open,High,Low,Close,Volume,Adj Close 2013-09-09,65.06,65.59,64.93,65.40,207390 ,65.40 2013-09-03,63.61,65.58,63.50,64.98,315240 ,64.98 2013-08-26,64.20,64.53,62.60,62.82,268380 ,62.82 2013-08-19,63.70,65.71,63.50,64.21,3 2890 ,64.0 2013-08-12,6 .09,6 .75,63.16,63.65,261510 ,63.4 2013-08-05,6 .20,6 .85,65.61,6 .31,270480 ,6 .09 2013-07-29,62.25,6 .61,62.25,6 .30,43250 0,6 .08 2013-07-2 ,63.1 ,63.58,62.03,62.53,290 50 ,62.32 2013-07-15,63.46,63.78,62.47,63.35,292730 ,63.14 2013-07-08,64.0 ,64.6 ,63.32,63.67,306420 ,63.46 2013-07-01,63.94,64.59,61.90,63.64,379180 ,63.43 2013-06-24,60.16,64.07,59.1 ,63.68,708490 ,63.47 2013-06-17,62.38,62.72,60.07,60.57,457180 ,60.37 2013-06-10,62.91,63.48,61.03,61.89,295170 ,61.68 2013-06-03,61.60,63.57,61.1 ,62.75,3 2 50 ,62.54 2013-05-28,63.57,64.1 ,61.6 ,61.6 ,3 4010 ,61.46 2013-05-20,65.27,65.57,61.56,62.79,3636 0 ,62.37 2013-05-13,64.51,6 .07,64.16,65.32,312510 ,64.89 2013-05-06,64.40,64.79,63.65,64.76,283860 ,64.3 2013-04-29,62.0 ,64.96,61.62,64.5 ,364170 ,64.12 2013-04-2 ,61.09,62.49,60.63,61.89,254 90 ,61.48 2013-04-15,60.46,61.31,59.67,60.92,358420 ,60.52 2013-04-08,58.89,61.38,58.82,60.58,349670 ,60.18 2013-04-01,59.0 ,59.53,57.98,58.97,351 60 ,58.58 2013-03-25,59.39,59.98,58.14,59.01,504040 ,58.62 2013-03-18,54.43,60.25,53.53,59.53,742030 ,59.13 2013-03-1 ,54.57,54.9 ,53.27,54.78,423130 ,54.42 2013-03-04,54.5 ,5 .65,54.41,54.69,3290 0 ,54.3 2013-02-25,54.54,54.9 ,53.94,54.82,356870 ,54.46 2013-02-19,54.89,5 .16,53.9 ,54.47,391360 ,53.90 2013-02-1 ,5 .28,5 .90,54.32,54.95,320570 ,54.37 2013-02-04,53.59,5 .19,53.50,54.59,25 730 ,54.02 2013-01-28,5 .40,5 .52,53.4 ,53.70,375130 ,53.14 2013-01-2 ,53.42,5 .57,52.81,5 .5 ,404360 ,54.97 2013-01-14,53.19,54.0 ,52.89,53.29,284090 ,52.73 2013-01-07,52.79,53.42,52.17,53.10,36230 0,52.54 2012-12-31,50.83,53.04,50.59,52.8 ,3543 0 ,52.3 2012-12-24,104.56,106.23,50.93,50.9 ,429650 ,50.46 2012-12-17,97.21,105.48,96.80,105.10,640150 ,52.0 2012-12-10,98.67,10 .0 ,96.85,96.91,432740 ,47.95 2012-12-03,97.6 ,98.9 ,96.61,98.59,389 0 0,48.78 2012-1 -26,95.48,10 .3 ,95.38,97.48,516170 ,48.02 2012-1 -19,93.49,96.76,93.46,96.75,378520 ,47.6 2012-1 -12,92.50,93.20,89.65,92.59,459 80 ,45.61 2012-1 -05,94.5 ,96.13,91.68,92.31,395 20 ,45.47 2012-10-31,91.05,96.74,90.78,94.54,51080 0,46.57 2012-10-2 ,95.42,96.35,90.32,91.15,5078 0 ,4 .90 2012-10-15,94.67,98.10,94.38,96.45,418040 ,47.51 2012-10-08,95.01,95.79,94.15,94.42,3710 0 ,46.51 2012-10-01,94.91,96.53,93.62,95.2 ,5945 0 ,46.91 2012-09-24,95.60,96.64,92.79,94.91,864350 ,46.76 2012-09-17,96.32,10 .50,96.08,96.52,681580 ,47.5 2012-09-10,9 .25,10 .92,95.89,96.64,679320 ,47.61 2012-09-04,97.19,9 .75,96.24,9 .29,374 0 0,48.91 2012-08-27,96.92,9 .29,95.85,97.36,48010 0,47.96 2012-08-20,96.2 ,97.13,94.94,96.86,389860 ,47.54 2012-08-13,94.31,96.46,93.43,96.26,545830 ,47.25 2012-08-06,94.73,97.19,94.3 ,94.50,421070 ,46.38 2012-07-30,96.93,97.75,91.04,94.57,512360 ,46.42 2012-07-23,92.05,97.45,91.34,97.03,503540 ,47.63 2012-07-16,93.81,95.98,91.91,93.08,561450 ,45.69 2012-07-09,91.21,94.29,90.0 ,93.97,72190 0,46.12 2012-07-02,8 .39,92.70,8 .03,91.38,961920 ,4 .85 2012-06-25,98.38,9 .61,85.10,87.78,1429320 ,43.09 2012-06-18,101.53,102.72,98.28,9 .40,65 460 ,48.79 2012-06-1 ,109.12,109.91,9 .36,101.75,823590 ,49.94 2012-06-04,104.5 ,108.7 ,103.14,108.64,415130 ,53.32 2012-05-29,109.51,1 0.92,104.18,104.60,490810 ,51.34 2012-05-21,105.31,109.19,105.31,108.79,430780 ,53.2 2012-05-14,107.65,109.01,104.27,105.4 ,480180 ,51.58 2012-05-07,1 1.40,1 2.30,106.56,108.26,457360 ,52.96 2012-04-30,1 1.0 ,1 4.81,1 0.50,1 1.81,4784 0 ,54.70 2012-04-23,109.83,1 1.56,106.34,1 0.64,435750 ,54.13 2012-04-16,109.07,1 1.4 ,108.68,1 0.7 ,384090 ,54.19 2012-04-09,108.89,1 1.0 ,105.93,108.80,57480 0,53.23 2012-04-02,108.42,1 0.53,107.9 ,1 0.39,453260 ,54.0 2012-03-26,107.8 ,109.18,106.28,108.4 ,490 50 ,53.05 2012-03-19,1 1.90,1 2.97,106.07,107.42,831470 ,52.5 2012-03-12,108.80,1 1.78,108.60,1 1.2 ,479390 ,54.41 2012-03-05,108.70,1 0.15,106.97,109.98,365470 ,53.80 2012-02-27,105.8 ,109.06,105.54,108.74,32 860 ,53.20 2012-02-21,106.59,107.18,104.71,106.29,301040 ,51.82 2012-02-13,105.80,107.63,104.29,106.68,389450 ,52.01 2012-02-06,103.04,106.6 ,102.68,105.41,346 0 0,51.40 2012-01-30,101.45,104.94,10 .87,103.50,692080 ,50.46 2012-01-23,101.92,103.29,101.02,102.1 ,407410 ,49.79 2012-01-17,98.70,102.0 ,98.05,101.76,482860 ,49.62 2012-01-09,98.10,9 .14,97.68,98.30,409060 ,47.93 2012-01-03,97.37,98.75,96.51,97.9 ,456750 ,47.78 201 -12-27,96.98,98.0 ,96.28,96.37,35 750 ,46.9 201 -12-19,93.92,97.29,92.89,96.90,709780 ,47.25 201 -12-12,97.34,97.79,93.41,93.67,545380 ,45.67 201 -12-05,96.73,98.25,95.0 ,97.68,48 680 ,47.63 201 -1 -28,92.04,97.50,91.90,96.25,589790 ,46.93 201 -1 -21,91.62,92.62,89.79,90.28,324 90 ,43.85 201 -1 -14,95.84,96.89,90.90,92.75,41 90 0,45.05 201 -1 -07,94.52,96.41,91.61,96.15,4759 0 ,46.71 201 -10-31,95.76,97.68,93.46,94.38,5353 0 ,45.85 201 -10-24,94.34,96.93,92.73,96.75,598 20 ,47.0 201 -10-17,92.27,94.35,87.98,94.35,487120 ,45.83 201 -10-10,89.78,93.18,89.34,92.97,479870 ,45.16 201 -10-03,84.95,89.87,81.01,8 .15,636 70 ,42.82 201 -09-26,89.56,92.56,85.4 ,85.51,768970 ,41.54 201 -09-19,8 .24,91.18,82.2 ,8 .64,1 09840 ,43.06 201 -09-12,81.76,89.98,81.45,89.7 ,643540 ,43.61 201 -09-06,81.15,87.49,80.20,82.50,610 30 ,40.07 201 -08-29,87.1 ,8 .60,83.80,84.04,70 080 ,40.82 201 -08-2 ,80.03,86.49,79.03,86.29,63040 0,41.7 201 -08-15,84.61,85.53,78.50,78.58,653760 ,38.03 201 -08-08,81.38,85.05,76.98,84.24,9032 0 ,40.7 201 -08-01,90.42,90.46,80.34,83.87,83 920 ,40.59 201 -07-25,90.34,91.41,8 .5 ,90.15,519320 ,43.63 201 -07-18,90.90,92.59,90.17,91.71,589 40 ,4 .39 201 -07-1 ,91.87,93.05,90.64,91.70,54510 0,4 .38 201 -07-05,91.28,94.23,90.93,93.24,741230 ,45.13 201 -06-27,80.92,91.9 ,80.92,91.82,143 610 ,4 .4 201 -06-20,80.86,84.83,80.63,81.18,694180 ,39.29 201 -06-13,80.51,82.43,79.4 ,81.1 ,535250 ,39.26 201 -06-06,80.37,82.32,79.5 ,79.6 ,5456 0 ,38.56 201 -05-31,84.84,84.95,80.2 ,80.36,526160 ,38.90 201 -05-23,84.10,84.80,82.9 ,84.62,369230 ,40.80 201 -05-16,85.74,86.48,83.97,85.05,48 380 ,41.01 201 -05-09,81.80,86.53,81.70,86.26,502170 ,41.59 201 -05-02,82.78,83.48,81.41,82.02,52 830 ,39.5 201 -04-25,80.61,82.73,79.40,82.32,43030 0,39.69 201 -04-18,78.07,80.63,7 .20,80.19,573420 ,38.67 201 -04-1 ,7 .26,80.41,7 .25,78.73,57040 0,37.96 201 -04-04,76.78,79.0 ,76.35,7 .39,639 80 ,37.32 201 -03-28,76.68,7 .0 ,75.62,76.53,6 3 80 ,36.90 201 -03-21,7 .62,7 .95,69.43,76.6 ,14515 0 ,36.96 201 -03-14,86.86,86.8 ,76.83,7 .59,12 6510 ,37.41 201 -03-07,90.0 ,91.12,85.47,87.17,597940 ,42.03 201 -02-28,8 .29,90.0 ,87.23,89.8 ,541320 ,43.34 201 -02-2 ,87.60,8 .32,85.50,87.98,507450 ,42.27 201 -02-14,86.32,8 .83,84.40,8 .82,510410 ,42.68 201 -02-07,85.80,87.70,85.6 ,86.21,37 240 ,41.42 201 -01-31,81.52,85.89,81.01,85.74,451290 ,41.20 201 -01-24,82.0 ,84.34,81.30,81.46,4 6120 ,39.14 201 -01-18,84.42,84.98,82.19,82.30,459820 ,39.54 201 -01-10,83.25,84.80,82.37,84.07,421540 ,40.40 201 -01-03,85.83,86.58,83.27,83.53,501630 ,40.14 2010-12-27,85.98,86.78,85.12,85.42,3 4860 ,41.04 2010-12-20,90.53,92.49,85.43,86.05,10 8010 ,41.35 2010-12-13,89.64,90.52,87.7 ,90.05,462840 ,43.27 2010-12-06,87.51,8 .50,86.40,87.80,294730 ,42.19 2010-1 -29,85.40,8 .28,83.92,87.53,453930 ,42.06 2010-1 -2 ,85.08,86.97,84.8 ,85.96,3 5810 ,41.16 2010-1 -15,82.91,86.32,80.26,85.81,593020 ,41.09 2010-1 -08,83.6 ,83.9 ,82.04,82.62,401 50 ,39.56 2010-1 -01,81.8 ,84.1 ,80.59,84.1 ,406460 ,40.27 2010-10-25,82.57,83.03,80.27,81.4 ,427010 ,38.9 2010-10-18,82.0 ,82.84,80.08,81.92,40480 0,39.2 2010-10-1 ,81.62,83.40,81.34,82.0 ,605790 ,39.26 2010-10-04,79.92,82.60,79.04,82.04,64650 0,39.28
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Ask a homework question - tutors are online