excel vba | Excel Trading and Investing Models

The Basics of Excel Trading VBA

Top quality trading VBA must be written in a highly module-based manner. Applying Microsoft’s native VBA capabilities, you can create a selection of custom functions which will then be called within your VBA and with user controls such as checkboxes. The more...

Building an Excel Trading Model Using a Hybrid Approach

Articles, Excel Models

You can often get the best of both worlds by buying or developing an add-in toolkit and combining it with custom formulas and VBA. This allows you to focus on the parts of your model that are specific to your needs while gaining efficiency and functionality in those...

FAQ: I am having difficulty getting a section of the Excel VBA code to work. Some of the code is highlighted in blue and some is in yellow.

FAQs, Fund Model FAQs, VBA Code

Here is the code that was highlighted in blue: ’open data .csv file and copy column B data to \Data/ sheet Also, this phrase was highlighted in yellow: Sub Load_Data( ) This problem is typically caused by a missing or mis-named .csv data file, ticker symbol, or data...

Building an Excel Trading Model Using Formulas and VBA

Articles, Excel Models

Building a trading model from scratch using a combination of Excel formulas and VBA can be a lot of work, but has the advantage of full control over the model and what it needs to do. Individual spreadsheets are used for data capture, trade rule logic, and calculating...