If you download and install the free MSN Money Stock Quote Add-in, you will be able to use the MSNStockQuote() function to pull stock quote data directly into your worksheet. One of the benefits of using this function over a web query is that you can place this function wherever you want within your spreadsheet.
The following article provides more information about downloading stock quote data into Excel.
Free Stock Quotes in Excel
Bookmark
Excel Templates
Labels
- Math (6)
- dates (6)
- finance (6)
- Formatting (3)
- Text (3)
- statistics (2)
- Arrays (1)
- logical (1)
- lookup (1)
Excel Links
Subscribe
Posts
Comments
About Me
- Jon Wittwer
- Jon Wittwer is the founder of Vertex42.com, an internet-based software development company that specializes in the creation of spreadsheet templates and financial calculators. Vertex42.com began in 2003, and since then Dr. Wittwer has created numerous templates and spreadsheets for small business, personal finance, time management, education, statistics, and engineering, almost all of which can be downloaded for free.
0 comments:
Post a Comment