You are missing trading opportunities:
- Free trading apps
- Over 8,000 signals for copying
- Economic news for exploring financial markets
Registration
Log in
You agree to website policy and terms of use
If you do not have an account, please register
Check out the new article: Market Simulation (Part 16): Sockets (X).
The code that needs to be implemented in VBA is not complex. In fact, much of what will be shown is already done by those who write scripts in VBA. But there are a couple of points that may be more or less difficult, at least for some. However, we would like to emphasize that everything here is arranged as simply and educationally as possible. Furthermore, the code provided in the previous article will remain unchanged. All that needs to be done is to create elements in VBA to perform the necessary tasks or settings depending on what you intend to do.
To begin, let's take a look at the Excel interface. We can see it below:
If you know how to use Excel, you should have noticed that in the image above, the buttons are shapes. They allow you to create an interface with rounded corners. However, their operation is not much different from standard controls, as they can be linked to a macro. Therefore, when you click on one of these shapes, Excel interprets it as interacting with a regular button and makes the appropriate call to execute the macro associated with the click event on that shape or button.
Author: Daniel Jose