If you are looking to analyse stocks and shares in Excel then take a look at the Stock Data Type available in Excel 365. I…