Yahoo! Finance Spreadsheet.xls - URL =...

Info icon This preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
URL = Yahoo tags = nd1t1l1ohgc1p2wj1ryr5m3m8m4m6 DETAILS DATA Code Company Date Time Last wmt Wal-Mart Stores 03-Sep-15 4:01pm 64.86 gs Goldman Sachs Group 03-Sep-15 4:00pm 185.06 vrsn VeriSign 03-Sep-15 4:00pm 68.23 nov National Oilwell Varco 03-Sep-15 4:03pm 40.97 meg Media General 03-Sep-15 4:04pm 11.36 ups United Parcel Servicem 03-Sep-15 4:00pm 96.77 lee Lee Enterprises 03-Sep-15 4:00pm 1.84 ^NDX NASDAQ-100 03-Sep-15 5:15pm 4,234.65 AAPL Apple Inc. 03-Sep-15 4:00pm 110.37 HPQ Hewlett-Packard Company Co 03-Sep-15 4:01pm 27.95 IBM International Business Machine 03-Sep-15 4:01pm 146.78 INTC Intel Corporation 03-Sep-15 4:00pm 29.08 nab.ax NAT. BANK FPO 04-Sep-15 4:10pm 29.80 MCD McDonald's Corporation Comm 03-Sep-15 4:00pm 96.01 V Visa Inc. 03-Sep-15 4:01pm 70.40 DIS Walt Disney Company (The) C 03-Sep-15 4:00pm 101.99 MSFT Microsoft Corporation 03-Sep-15 4:00pm 43.50 ^FTSE FTSE 100 04-Sep-15 9:32am 6,109.64 VOD.L VODAFONE GROUP 04-Sep-15 9:32am 224.85 TSCO.L TESCO PLC 04-Sep-15 9:32am 187.55 SBRY.L SAINSBURY 04-Sep-15 9:32am 240.50 Advanced Select the data fields you wish to pull from Yahoo Enter the Yahoo tags in C1 You will need to change the headers in Row 5
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
lee+^NDX+AAPL+HPQ+IBM+INTC+nab.ax+MCD+V+DIS+MSFT+^FTSE+VOD.L+TSCO.L+SBRY.L&f VALUATIO FUNDA Open High Low Change % Chg 52w Range Market Cap. PE 64.72 65.01 64.39 0.42 0.65% 61.50 - 90.97 208.91B 13.5 185.00 187.89 184.28 0.55 0.30% 171.26 - 218.77 83.55B 11.0 68.23 68.78 67.85 0.19 0.28% 52.10 - 71.82 7.74B 26.9 40.94 41.76 40.50 0.11 0.27% 34.54 - 83.89 15.72B 9.0 11.31 11.59 11.12 0.05 0.44% 10.88 - 18.00 1.45B 36.0 97.10 97.45 96.42 0.06 0.06% 93.64 - 114.40 86.72B 22.6 1.88 1.89 1.83 -0.02 -1.08% 1.82 - 3.95 100.37M 5.9 4,267.34 4,300.30 4,222.38 -21.58 -0.51% 3700.23 - 4694.13 N/A N/A 112.45 112.78 110.04 -1.97 -1.75% 92.00 - 134.54 629.41B 12.8 28.03
Image of page 2
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern