![]() ![]() This URL is essentially a request to Yahoo to return a text file containing the stock data. The first part of the code assembles a URL from the arguments to the VBScript button (the two dates and the ticker symbol). ![]() The VBScript used to connect to Yahoo is decribed below. For example, you could calculate the Sharpe Ratio, the Value at Risk at a specific confidence level, or even the investment weights in a Mean-Variance Optimized Portfolio. You can now manipulate and analyze the data using all of Mathcad’s functionality. Some simple string manipulation then places the data into a table, ready for analysis. Mathcad then connects to Yahoo Finance (using some VBScript) and imports historical stock quotes for every day between the two dates. Simply supply two dates and a ticker symbol (for example, XOM for Exxon Mobil, WMT for Walmart or KO for Coca Cola). You don’t need to manually import the data with text files. This Mathcad worksheet automatically downloads historical stock quotes from Yahoo Finance with a VBScript button. ![]()
0 Comments
Leave a Reply. |