8) To refresh you data click the cell in which the data is located then go to tab 'Data' -- A reader, JDe M, mentioned a couple other tips for non "American-centric" followers.
1) If you place a country code before the stock ticker symbol separated with a colon (:) it will pull up the right exchange.
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.
s=" & str Ticker & _ "&a=" & Month(dt Prev Date) - 1 & _ "&b=" & Day(dt Prev Date) & _ "&c=" & Year(dt Prev Date) & _ "&d=" & Month(dt Date) - 1 & _ "&e=" & Day(dt Date) & _ "&f=" & Year(dt Date) & _ "&g=d&ignore=.csv" ' Debug. Furthermore, reader René has uploaded an instructional video that shows how to implement this script.
Today, there is literally a multitude of ways to link external stock market data into Excel.
Some financial models need to reference stock quotes at certain dates.
Only advanced users can create a spreadsheet as Macros are required to download the data.
The CSV can then be opened in Excel and manipulated as required. The workbook requires a data connection (to download data from the internet - duh!
Real-time data is limited to a few US exchanges and most countries have a 10-30min delay due to licensing restrictions. ) You must accept/enable both for the spreadsheet to work.
For example, ca: BCE for BCE on the CDN TSX Exchange.
Similarly you can request a specific stock exchange.