In this example, "MCD" is the stock exchange ticker symbol for McDonald's, and DATEVALUE("") means that you want the quote for 30 November 2011. Once included, you can use the formula as follows: The code in this tutorial allows you to retrieve stock prices from Yahoo! Finance. Long story short, you can develop a VBA function that is usable as an Excel spreadsheet formula. This tutorial uses the concept of user-defined functions (UDF) - for an introduction, read this article. Instead of using those as hard-coded input data, you can create an Excel formula that will retrieve stock prices for a given date. Some financial models need to reference stock quotes at certain dates.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |