Microsoft Excel can also with Financial Data.

Here we have 4 companies mentioned in B3:B6.

001.png

To convert to Stocks Data Type, select Data > Stocks.

002.png
003.png

Click on the Icon to see a Description of the Company.

004.png

Select the cell and add a Period (.) to see various details.

006.png

We can select Industry, High and P/E Ratio.

005.png
007.png
008.png
009.png
010.png
011.png

Options available are:

012.png
013.png
014.png

GET SAMPLE FILE AND SOLUTION

Send an email at:

havish@havishmconsulting.com 

  • LinkedIn
  • YouTube
  • Instagram

©2020 by HAVISH M. CONSULTING. Proudly created with Wix.com