After you click a button, Excel uses a VBA macro to connect to Google Finance to import the data. Just supply the ticker symbol, start date and end date. This VBA can be extended to calculate other things. For example, you can calculate and plot the relative strength indicator, average true range, or the historical volatility. As an example, the VBA in the spreadsheet calculates the mean daily return, standard deviation and the variance. Once you have the stock data, you can analyze it, conduct historical backtests and more. Everything is automated with some clever VBA (which you can view and extend.) Download historical stock quotes from Google Finance straight into Excel with this free spreadsheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |