Microsoft Excel : How to get Stock market data for your watch list.

on
Prerequisite : You will need Office 365.

Step 1 : Click on Data --->  Stocks




Step 2 : Select  the data and to get the live stock information, please have the watchlist in Column A.

      
      Step 3: Please check the data transformation in Column A.


Step 4 : Select Cell A2 and click on the small pop up box to see the fields that you can get for the first stock ( Vodafone Idea).

Step 5: Fill in all the relevant columns that you need for the first row only. ( For example: 52 week high, 52 week low, change percentage, market cap and price). Please type in column Headers as well)

Step 6 : Use fill handle to pull for other companies stock  info.
















Comments

Post a Comment