What tools / PL are used to create a trading robot?

Question

API

For the Quik terminal, it is indicated that Lua and Qpile can be used when creating a trading robot. At the same time, there is a lot of information on the Internet on writing trading robots in a variety of languages ​​(VBA, C, Python, R, etc.).
In this connection, the question arises: what programming languages ​​can be used to write an exchange robot and what tools are needed for different stages? Unfortunately, I could not find a single and clear answer to my question on the Internet.
As I see these steps (probably wrong):
1. Output information from the terminal. How to display information (in Excel or in a database), whether using Qpile alone?
2. Analysis of information, creation of a robot. Does the stage of information analysis followed by the creation of logic directly need to be performed on Qpile / Lua supported by the terminal, or can other PLs be used? I am potentially considering VBA / R options, to a lesser extent - Python, so I'm most interested in the possibility of using these PLs.
3. Reverse input of information into the terminal. Is there an interface (API) for such an operation, or again, do I need to use Lua / Qpile? In what form should output information be stored?
Perhaps other terminals, unlike QUIK, offer a more convenient way to create a trading robot and input/output information, if so, please clarify.
I have no technical education, and, as such, no experience in programming, so I ask knowledgeable people to help me understand the subject matter in stages

Answer 1

I have experience in writing a trading robot on MT4 with their MQL, so I can’t say anything specifically about QUIK. However, I do not think that it will be a big problem to implement the trading strategy that is needed - on any PL, and then simply send requests to it from the trading terminal through the same QUIK. That is, for the terminal you write one method that, upon receiving a peak, sends information to the robot, waits for a response and reacts to it (makes or does not make a bet).

Answer 2

If there is an api, you can write in any programming language, even in assembler

Answer 3

I am writing in C# using the transqconnector library. I don't write in "built-in" languages ​​(such as Qpile). they have limited possibilities and with a glass, for example, they cannot work.
There is also the Tradematic platform. There is C#, but there are also limited development opportunities.