Import stock quotes and do technical analysis in Excel (VBA) | Free template

Import of stock quotes and technical analysis in Excel is a free template that can be used as a workbook or an add-in to import historical stock quotes and to do technical analysis for a share.

In this template to import stock quotes and to do technical analysis there is a custom menu and an form where you can enter the parameters for the import. The custom menu are located in the menu tab "Extensions" in Excel 2007 and in the toolbar when it comes to earlier versions of Excel.

This template is in four different versions where two versions are saved as add-ins, a workbook that is saved as an Excel add-in have the extension ". Xlam" or ". Xla". An Excel add-in that has been enabled in Excel can be used in all workbooks that are opened in Excel. An add-in contains only forms and VBA code, this means that it is necessary to create a custom menu to access the functionality of an add-in.

In this template for importing stock quotes and do technical analysis in Excel, you must first open the form by clicking on "Import quotes" in the custom menu in the menu tab "Extensions". In the form you have to enter the symbol (Yahoo) for the stock, any name, a start date, a end date, the unit for the quotes and the technical indicators that should be calculated. When you press the button "Get Quotes" this will create a new worksheet in which historical financial information is imported, the chosen technical indicators are calculated, and charts are created for share price, volume and technical indicators.

In this template to import stock quotes and to do technical analysis in Excel there is code (VB) to handle the event when a workbook is opened, code for the form "input data form" and code in a module that handles the import, calculations and creation of graphs. In order to view and modify the code in this template you will need to have the add-in "Analysis ToolPak - VBA" enabled in Excel and it can also be helpful to activate the menu tab "Developer". Updated: 01/01/2015 | Created by All-templates.biz

Download Import stock quotes and do technical analysis in Excel (VBA) | Free template »

Tags: trading decision making financial calculations