Forum Discussion
Solved
Company Stocks - can create stock names list but can't add columns for price, p/e etc
I want to create a list of stocks and some details on them that update automatically. I've found help how to do this and have created a table with a list of company stocks using the Stock button, all ok so far. Selecting the table an 'add' function appears with the dropdown list see below, when I select one eg price the add function disappears but the requested data eg price does not get inserted. I've tried and tried different approaches with the same result. I'm stuck no idea why it doesn't work as in the various video's and online help. I'm thinking some config issue but I've run out of ideas, any help much appreciated.
After having this problem I noticed calculations on the spreadsheet were not performed, I switched to manual calc then back to auto calc which allowed calculations to be performed again. When I try to add a column with price again once more no automatic calculations are performed.
I'm based in the UK is that make any difference.
Thank you for your reply, much appreciated. Before following up on some of your suggestions I thought I'd try a repair of Office 365 just in case something rather subtle had broken. The repair resulted in ending up with just old versions of Excel, Outlook etc, so then having no Office 365 I had to reinstall it. The result, the problems gone!!!
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.
Thank you for your reply, much appreciated. Before following up on some of your suggestions I thought I'd try a repair of Office 365 just in case something rather subtle had broken. The repair resulted in ending up with just old versions of Excel, Outlook etc, so then having no Office 365 I had to reinstall it. The result, the problems gone!!!
