Current updating stock prices
Investors look closely at trends to make a judgment about the current a future direction of a stock. It is often easier to determine a stock trend by looking at a chart of stock prices over a period of time, along with the total volume generated during the trading day in relation to the closing price for the day. Apart from just using it for regular stuff, you can even pull or fetch stock quotes in excel. To fetch stock quotes in excel, you do not need to install any additional add-on to your excel sheet.
The intervals (aside from the Intraday) are for 5 days, 1 Month, 3 Months, 6 Months and from 1 to 10 years (if the company has 10 years of price and volume data available).Click on the “Properties” to open “Connection Properties” pop up.Check the option “Enable background refresh” and any other options as you require. Tap on the “Data” tab once again and click on “Existing Connections”.I will take you through the steps to be followed to achieve this. Then, click on “Connections” which opens “Workbook Connections” and click on “Add” button.Select “MSN Money Central Investor Stock Quotes” and double click on it.