List Go to GogoJungle Home
icon List
Go to GogoJungle Log In Create Article
Enhancement methods for EA performance using data analysis in EXCEL Investment Navi+
Enhancement methods for EA performance using data analysis in EXCEL
EA名人
2
5

Share


■EA Performance Enhancement Method Using Excel Data Analysis■ ・Recently, wonderful tools such as Mr. Gogo-JAN's "EA Tool" have been developed, making it easy for anyone to create EAs. However, even if you can create an EA, it still feels difficult to make high-performing and highly profitable EAs with consistently high P&L. ・I used to place various indicators on the chart and find entry and exit points by combining several indicators, then create an EA that incorporated them. Every day, every day, I glued myself to the chart for hours, thinking about the EA logic. However, in the short term, profits came, but it was difficult to maintain stable profits in the long term. ・Therefore, I thought that if we process the data statistically and think about the EA logic statistically, we could create a better, higher-performance EA. ・However, MT4 has hardly any functions to analyze data. On the other hand, Excel contains many data analysis tools and can process large amounts of data relatively quickly. ・This method moves MT4 data to Excel, analyzes it in Excel, and aims to improve the performance of the EA. ・It will be explained in a series of about four to five installments.
All 5 Articles
The 5th Session (Development Examples and Achievements: EA Sen-shi Man-koh)
1. Creating a Basic EAUsing Bollinger Bands and Stochastic to create a simple EA 2. Collecting Filter DataCollect 150 types of filter data at entry ...
12/26/2019 03:23
Performance improvement method of EA using Excel data analysis 第4回 (Effective filters)
Session 4 (Effective Filters) 1. Effective Filters We introduce filters that are believed to be effective, selected by Excel correlation analysis. ...
12/13/2019 05:59
Performance improvement method of EA using Excel data analysis, Part 3 (VBA program)
Third Session (VBA Program) 1. What is VBA ・A software for automating repetitive tasks built into Microsoft Office, a program that automatically han...
12/6/2019 01:28
Enhancing EA performance using Excel data analysis - Session 2 (Correlation analysis)
第2回(相関分析) 1.フィルタ選定の難しさ When backtesting the created EA, there are trades that yield profit and trades that yield a loss. Therefore, everyone hopes to...
11/29/2019 03:49
Methods to Improve EA Performance Using Excel Data Analysis – Part 1 (Background)
Performance enhancement methods for EAs using Excel data analysis Part 1 (Background) • Recently, wonderful tools like Gogojan-sama's "EA Creator" hav...
11/21/2019 04:40

Add to your blog

Frame color
  ※Please set your color
Text color
  ※Please set your color