1 answer
Hello,
In Excel 2021, the "Stocks" tab has been removed from the "Data" section. To obtain stock information, you can use Internet Explorer as an external data source. Here’s how to proceed:
1. Open your Excel file.
2. Go to the "Data" tab.
3. Click on "Get External Data".
4. Select "From Web Page".
5. A "Data Navigator" window will appear.
6. Enter the URL of the stock page you want to use as a source (for example, finance.yahoo.com).
7. Click "OK".
8. Select the stock data you wish to import into your Excel sheet.
9. Click "Import".
This should allow you to get the necessary stock information to create your portfolio. Feel free to reach out to me if you have any further questions.
Sincerely.
In Excel 2021, the "Stocks" tab has been removed from the "Data" section. To obtain stock information, you can use Internet Explorer as an external data source. Here’s how to proceed:
1. Open your Excel file.
2. Go to the "Data" tab.
3. Click on "Get External Data".
4. Select "From Web Page".
5. A "Data Navigator" window will appear.
6. Enter the URL of the stock page you want to use as a source (for example, finance.yahoo.com).
7. Click "OK".
8. Select the stock data you wish to import into your Excel sheet.
9. Click "Import".
This should allow you to get the necessary stock information to create your portfolio. Feel free to reach out to me if you have any further questions.
Sincerely.