I have seen example online which are able to download information regarding shares directly into excel.
However i have been unable to get the macro to work. I have attached an example of the information included.
Can someone please assist.
From the instructions in your spreadsheet, it looks like a Google Spreadsheet. The formulae written for Google will not work in Excel.