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 |