Create Excel (or other app) function to match and rank optimization data from stragety tester

Tâche terminée

Temps d'exécution 1 jour
Commentaires de l'employé
Clearly project specification, good communication. Recommend! Thanks

Spécifications

I have back testing results from optimization on the MT5 strategy tester for various tests saved in different tabs on excel. 
I would like to generate an excel function to find the matching parameters that give the best results based on profit within all tabs (the left most column), so the function needs to find the matching parameters, calculate the sum of the profit of matching parameters (TOTAL PROFIT), and rank them. All the backtesting results will be based on the same timeframe. I think the function needs to work like this:
1. calculate the sum of the profit for each matching parameter = TOTAL PROFIT 
2. rank by the TOTAL PROFIT (top 10 parameters only), highest to lowest and display on a new tab or blank area on an existing tab.
The CSV file attached is an example of the type of data, but it will be in one excel file (I couldn't attach an excel file). The tab titled RANK shows an example of how the data needs to be displayed after ranking. Currently the data is in excel format, but any other application that you think would work better is fine. Please advise. 

Répondu

1
Développeur 1
Évaluation
(16)
Projets
35
23%
Arbitrage
4
0% / 50%
En retard
2
6%
Travail
2
Développeur 2
Évaluation
(7)
Projets
8
13%
Arbitrage
6
33% / 33%
En retard
0
Gratuit
3
Développeur 3
Évaluation
(1)
Projets
2
0%
Arbitrage
0
En retard
0
Gratuit
4
Développeur 4
Évaluation
(11)
Projets
18
28%
Arbitrage
4
50% / 50%
En retard
1
6%
Gratuit
Commandes similaires
حلل لي اصل مالي ) اكتب هنا مثلا XAU EUR USD USD اريد تحليلا تعليما و ليس توصية مالية ۱- نوع التحليل المطلوب : ( فني / اساسي / سلوك سعري ) ٢ - المدي الزمني : ( قصير / متوسط / طويل ) M15 / H1 / H4 / ) اذكر الفريمات المطلوبه + (D1 ما اريد استخراجه من التحليل : الاتجاه العام اقوي مستويات دعم و مقاومة رقمية سيناريو صعود و سيناريو هبوط مع شروط كل سيناريو ( IF / THEN ) اين يصبح السيناريو لاغيا مناطق دخول و خروج تعليمية (
Project Description I have three detailed CSV files containing: OHLC price data Timestamps Aggregated time & sales data A column called Arrow showing where signals occurred The data was captured using NinjaTrader 8 with NinZa Renko 8:4 bars on the ES market. All arrows are non-repainting and appear on candle close. Objective The goal is to create a NinjaTrader 8 indicator that reproduces the arrows in real-time
AutoTrade_v4_Arbon-v4 35 - 250 USD
============================================================ GOLD AI INSTITUTIONAL TERMINAL v4.0 - AutoTrade + EA Indikator EDISI GABUNGAN Sinkronisasi MT4 Realtime + Dasbor PWA + AI Multi-TF Menggabungkan MT4 + Server AI Node.js ============================================================ CARA MENJALANKAN (MUDAH): -------------------------- 1. Ekstrak ZIP ke folder manapun (misal: C:\GoldAI\) 2. Buka folder hasil
SEagle 35+ USD
The love of God will provide you with the fire of the time and frame that are defeated the wrong moves. However the best strategy with provide you with success in the long run. Profits are then needed and profitability keys a stopped car to move in less motion, that's key you have and I'm the car for motion
I am looking for an experienced quantitative developer to analyze and optimize an MT5 Expert Advisor that I have already developed. The EA is relatively complex and includes: Multiple strategies (Trend Pullback, Breakout, Mean Reversion, EMA Reclaim) Scoring system combining technical score and probabilistic filter Regime detection (ADX based) Volatility filters (ATR regime) Correlation and cluster exposure control
Until zone detection is coded , you will be from that point . Trailing Stop Optimization for live chart . Apply with Specific Currency Support . Clean Code . Zone Upper Limit and Lower Limit . Apply with careful understanding of the project requirement
hello, please take a moment to review my project. It is for Quanttower. it is very detailed in the instructions. Thank you, Just let me know if you can do it and the whats the cost and timeframe
GoldAI_v2_FINAL 30 - 70 USD
========================================================== Terminal Institusional GOLD AI v2.10 Sinkronisasi Realtime MT4 + Dasbor PWA + AI Multi-TF ========================================================== CARA MENJALANKAN (MUDAH): -------------------------- 1. Ekstrak ZIP ke folder manapun (misal: C:\GoldAI\) 2. Buka folder hasil ekstrak 3. Klik dua kali: INSTALL.bat → installotomatis 4. Klik dua kali
XAUUSD - TREND TRADER 30 - 500 USD
Find a good entry point and enter the trade .after the first profit of 25% is done then exit the trade .find the good market analysis of the trend and know when the market is on a good trend. After that now know the entry point and the take profit of the slot you have opened .have also a risk management strategy
Required Filters are working as per specification and requirement . Stop Loss Trailing needs correct execution for live chart . Need a little advice on trailing stop loss correction . Live chart only

Informations sur le projet

Budget
30+ USD
Délais
de 1 à 2 jour(s)