Company Stocks - can create stock names list but can't add columns for price, p/e etc

Please considering:

• Check Data Types: Ensure that the cells containing your stock names are recognized as the "Stock" data type. You can do this by selecting the cells and checking if the "Stock" icon appears next to them.
• Refresh Settings: Sometimes, the data might not update automatically due to refresh settings. Right-click on the cell with the stock data, select "Data Type" > "Refresh Settings," and ensure it's set to refresh automatically.
• Manual Refresh: If automatic refresh isn't working, try refreshing the data manually. Go to the "Data" tab and click "Refresh All" or press CTRL+ALT+F5.
• VBA Code: If you're comfortable with VBA, you can use a simple script to refresh the data. Open the VBA editor (ALT+F11), insert a new module, and paste the following code:

Private Sub Workbook_Open()
    ThisWorkbook.RefreshAll
    MsgBox "Stock Information Updated."
End Sub

• Check Calculation Settings: Since you mentioned issues with calculations, ensure that your workbook is set to automatic calculation. Go to "Formulas" > "Calculation Options" and select "Automatic."
• Regional Settings: Being based in the UK shouldn't affect the functionality, but it's worth checking your regional settings. Go to "File" > "Options" > "Language" and ensure that your preferred language and region are set correctly.