Excel Trader
We all have many programs installed on our computers. Moreover, many of them have already become so familiar that we do not attach much importance to them. But in vain. The well-known Microsoft Excel, which is found on almost any PC, contains enormous computing power for... trading. Yes, yes, you heard right, the most ordinary Excel allows you to: test trading ideas, conduct an in-depth analysis of the market, your statistics, and even build indicator charts. And that's not all...
Our new video collection Excel Trader is dedicated to using Excel as a tool for the Forex trader.
Why is it necessary to study this collection?
There are many reasons for this and here are some of them.
We all understand that standard terminal reports provide a limited amount of statistics. For many, this is enough, but most use Myfxbook to analyze their trading. Some people use paid programs to analyze expert advisor tests, for example, SQ EA Analyzer. With Excel, you can get all these statistical data in any format convenient for you and even much more! Do you want to plot the distribution of the profit factor by hour of the day, see graphically the number of profitable trades depending on the day of the week, calculate a trade quality coefficient named after you, or calculate the probability that your next trade will be unprofitable? All this and much more can be done in Excel in just five minutes.
Do you have an idea for a trading system that you want to test on historical data, but no time or desire to learn the programming language and no money to pay a programmer? And indeed, to master the mql4 language you need to spend up to a month of time. To hire a specialist, you will have to pay at least a hundred dollars. At the same time, in just a couple of hours you can build the project of your system in Excel yourself and test it on any currency pairs. In fact, on any instruments at all, even on a chart of monthly fluctuations in average hourly temperatures in the Stavropol Territory! At the same time, let me remind you that you will be able to get any statistics on your trading system that your imagination can come up with.
Or maybe you don’t have a trading system, but are looking for a way to create one? In Excel, you can build a whole generator of trading systems that will allow you to find tens and hundreds of profitable trading systems.
Traders who trade manually can use Excel to create a cozy trade diary with advanced statistics compared to many programs, various beautiful charts and a whole bunch of different statistics. And by describing your trading system in your diary, you can get backtesting and even optimize trading parameters if results worsen!
Using Excel, you can easily analyze any data from the Internet. For example, the impact of the release of certain news on the exchange rate of a particular currency, calculate the correlation between two instruments, analyze the performance of PAMM accounts and much more.
After subscribing you will have access to more than 10 hours of detailed step-by-step videos with homework for reinforcement. After viewing the collection, you will learn how to use Excel to solve any problems that a trader may encounter.
Many tasks can only be solved using third-party programs. For example, comparing quotes from two different brokers to understand their quality. Now you will not have to rack your brains over how to solve one problem or another, or pay huge amounts of money to a programmer just to test your idea, which may even be wrong. After studying this collection, you will be able to solve most of the tasks that arise every day for most traders.
What will this collection give you?
You will learn:
- Basics of working with Excel;
- Main functions of the program: mathematical, statistical, working with text and time, etc. ;
You will learn how:
- Build beautiful diagrams and convenient tables;
- Build charts of the main classical indicators from the MT4 terminal;
- Automatically receive data from the network and build graphs based on it;
And also you will create your own:
- Lot calculator;
- Trader's diary with detailed statistics on trades;
- A trading system generator that will allow you to get more than one profitable trading system;
- A trading system and test it on historical data.
The author of the collection is Dmitry, known on our forum under the nickname Silentspec. He worked as an engineer for a long time, using Excel every day to solve work-related tasks. He transferred this experience to his main hobby as well: trading in the financial markets.
For fifteen years now, in one way or another, he has been using Excel for various calculations, analysis and other tasks almost every day. He believes that without knowledge of this program when trading on the Forex market he would be like without hands, and that it is a very powerful, flexible and convenient tool for researching markets, strategies, advisors and trading results.
As a result of studying the collection, you
- You will acquire an indispensable tool - an assistant in solving your daily tasks;
- Learn to create your own books for calculating risks, testing trading systems or keeping a manual trading diary;
- Master a new program that will help you not only with regard to the Forex market, but also in life in general. You will see that Excel is an ideal program for planning anything, maintaining a family or personal budget, drawing up schedules for solving various tasks and projects, and so on;
- Get a powerful tool with which you can explore the Forex market limitlessly, which means you will gain a ton of new knowledge that will ultimately increase your profitability as a trader;
- You will learn about the capabilities of Excel, which will greatly complement your algorithmic trading, testing and writing advisors.
If you have long wanted to dive deeper into the world of trading, learn the hidden mysteries and secret secrets hidden behind candlestick charts, but did not know which tool to dig with, click the "Get collection" button.
Best regards, Dmitry aka Silentspec
Tlap.io
How to use Excel in forex trading to test and generate strategies, create calculators, analysis, etc.