Excel Eod Stock Market Downloads By Zip


Posted by Admin

Excel Eod Stock Market Downloads By Zip

Excel Eod Stock Market Downloads By Zip

Microsoft Excel

Excel can save an investor a ton of money. The idea here is to use excel to analyze potential hedge positions to add to an investors portfolio in order to protect the portfolio's returns from drops in the stock market. InvestorWords.com ,defines a hedge as, "an investment made in order to reduce the risk of adverse price movements in a security, such as an option or a short sale."

Historical Stock QuotesUsing excel an investor is able to pick out an ETF that will best protect the portfolio from "adverse movements in the stock market." The first step towards figuring this all out is to download the historical data on closing prices on all the stocks in an investors portfolio. Servers such as, Yahoofinance.com ,have links to historical data.

Calculating the Portfolio's ReturnThe next step in the process is to calculate the portfolios "daily" returns. To do this simply take ((X2-X1)/(X2)). For example, suppose X1 represents the stocks closing price today, X2 would represent what the stock closed at yesterday. Below is an example. The investor would calculate the return for each stock included in their portfolio.