Excel Trading Tutorials help you naviagte in the process of setting up your own automated Excel Trading System. Trading through an excel API is one of the easiest ways to automate your trading. However, to set up an automated trading system is not a path without obstacles.
AlgoJi List of Excel Trading Tutorials
- Why Use Excel For Algo Trading
- Learn Formulae for Technical Analysis in Excel
- Excel Trading Spreadsheet for Backtesting Strategies
- Options Trading Excel Calculator
- Forex Excel Spreadsheet For Backtesting Strategies
- Integrate your Excel API with Interactive Brokers’ Trading Workstation
- Pairs Trading Excel Spreadsheet
Other resources helpful in learning Excel for Algo Trading:
Stack Overflow is the most popular go-to website most developers use to solve their debugging problems. If you are going to use an excel API, chances are, you’ll have to modify/write some of your own VBA code, and when writing code, it is almost inevitable that you’ll face many bugs and error messages by the compiler. If you do face any such problems, you’ll probably find the solution on Stack Overflow.
If initially, you are not used to coding, then the Macro Recorder is for you. Click on the macro recorder button, and perform the steps which you want to be replicated. The macro recorder will generate code to mimic exactly what you did. You can then also go through this code to get a feel of VBA programming.
The Microsoft Guide
Microsoft has put up a useful guide to get started with Excel VBA. It is a guide which will teach you the basics, but it is also diverse. It also tells you where to go once you complete the basic tutorials, and is the perfect place for beginners. Here is the link for this guide.
ExcelDemy is an excellent website which offers tons of tutorials on excel and VBA programming.
The articles on this website are written such that it is very easy to read. You can start from a complete beginner, and this website will help you get the grasp of Excel and VBA programming pretty quickly. If you are a person that likes to learn through reading, and get through material quickly, then this is where you should start. This website also provides several videos of excel VBA too.
Free VBA MOOC
VBA MOOC is a free self-paced introductory course for learning Excel VBA. It can help you to learn the most important concepts in VBA programming. This course will teach you everything, right from the basics, so if you are a beginner programmer, you are in the right place.
ExcelVBAIsFun a wide variety of tutorials, which even experienced VBA programmers can use to refresh their knowledge. But, this channel is especially beginner friendly, and will definitely teach you a lot about Excel VBA in a very short period of time. VBA Programming is a playlist by another helpful youtube channel. It covers the most important topics in a sequential manner. If you are a complete noob, then this place is for you.
Reddit VBA Community
The VBA community on Reddit (embed URL: https://www.reddit.com/r/vba/) is a group of programmers who try to solve each others’ problems.
It is filled with programming veterans, as well as novices. Even quite difficult bugs/errors in the code get fixed here.
Pratique is another helpful website with easy to understand tutorials with downloadable spreadsheets.