Is there a limit to the number of stocks being updated in Excel? If so, is there a premium service to update several thousand stocks?
Is there a limit to the number of stocks being updated in Excel? If so, is there a premium service to update several thousand stocks?
I don't think so. You can add as many as you want, but that might consume more resources.
In the Microsoft Office system, you can insert stock quotes on MSN in the workspace using the Research task pane. In Microsoft Office Excel 2003 and Microsoft Office Word 2003 provide extended functionality to add the Office 2003 Stock Quotes, which allows you to perform actions such as "Insert concise stock table" or "Insert refreshable stock data".
After you insert a table into the workspace when you hover over it displays the actions for the smart tag. You can make dynamic changes such as "Display full table" or "Viewing the structure of XML».
- In the Tools menu, click Help.
- In the list, select Search for stock quotes on MSN Money: U.S..
- In the Search box, type the stock symbol you want. The results will be displayed in the task pane.
- To view the insert should scroll down the information about the shares.
- Do one of the following.
- Click the Add button price.
- This tool is applicable only in Word or Excel. Press the down arrow on the Add button and follow the price action.
- Select the desired action.
- Select Check for new actions. With the Microsoft Web site, download the Office 2003 add-Stock Actions. For installation instructions on the page. Close Internet Explorer and all open applications, Office, then re-open Word or Excel. To see the new action, repeat step 1 and click the down arrow on the Add button price. Select the desired action.
Bookmarks