MT5 Trading Report – Add Net Profit/Loss in EUR Using Daily ECB Rate (for my austrian tax report)

Spécifications

I need a report based on the original MetaTrader 5 (MT5) account statement (trading history export).
The original structure and all columns of the MT5 report must remain unchanged.

Only new columns may be added – as described below.


✅ Additional columns to be added:

  1. Fixed Fees (optional)
    – For example, in swap-free accounts or other broker-specific charges not already listed as swap or commission.

  2. Net USD
    – The net result per trade in USD, calculated as:
    Net USD = Profit − Swap − Commission − Fixed Fees

  3. ECB Rate (USD/EUR)
    – The official daily reference exchange rate of the European Central Bank, based on the trade closing date. The rates are at the ezb website („**ECB SDW REST-API**, **EXR**, **eurofxref XML**“)

  4. EUR (Net)
    – The converted net amount in EUR, calculated as:
    EUR = Net USD ÷ ECB Rate


📌 Requirements:

  • The program should be able to automatically generate PDF tax reports based on the MT5 report. If it's easier, an Excel file is also acceptable.

  • ECB rates must be fetched automatically or via Power Query, using this official ECB CSV file:
    📎 https://www.ecb.europa.eu/stats/eurofxref/eurofxref-hist.csv

  • The correct ECB rate must be used for the closing date of each trade (daily accuracy).

  • The sheet must be based on a standard MT5 account history export.
    No existing columns may be removed or renamed.


🎯 Purpose:

The file is used for tax reporting in Austria.
According to local tax law, I must declare the net realized profit/loss per trade in EUR, converted using the official ECB exchange rate on the day the trade was closed.

All trading data must remain fully visible in the original MT5 format.
Only the calculated Net USD , the ECB Rate and EUR (Net) columns are required in addition.

Répondu

1
Développeur 1
Évaluation
Projets
1
0%
Arbitrage
0
En retard
0
Travail
2
Développeur 2
Évaluation
(83)
Projets
142
51%
Arbitrage
5
20% / 60%
En retard
22
15%
Gratuit
Commandes similaires
Project Description I need a fully error-free Expert Advisor (MT5) with the following requirements: Requirements: Balance Mode – the EA must support different trading modes (Balanced, Aggressive, Conservative). Daily Loss Limit – once the daily loss reaches 30 €, the EA must automatically stop trading for the rest of the day. Indicators – integration of up to 5 indicators (from CodeBase or custom indicators, source
Ich suche einen erfahrenen MQL5-Entwickler , der einen vollautomatischen Trendfolge-Expert Advisor (EA) für MetaTrader 5 programmiert. Der EA soll speziell für Prop Trading Challenges entwickelt werden und daher strenge Risikoregeln einhalten. Zusätzlich muss er in der Lage sein, auch Seitwärtsmärkte zu handeln, um die Challenge schneller zu bestehen. Anforderungen an den EA Handelslogik Trendfolge : Entwickler
I need a professional Expert Advisor (EA) for MetaTrader 5 with the following requirements: 1. Source code (.mq5) must be delivered (not only .ex5). 2. Trading logic: - The EA should take signals from an indicator (e.g. IQ Gold Gann Levels or similar). - Buy = long signal, Sell = short signal. - Timeframes: M15 and H1. 3. Risk Management: - Maximum loss per trade: 100 € (lot size auto-calculated). - Profit
I am looking for an experienced MQL5 developer to program a professional OCO Breakout Expert Advisor (EA) for MetaTrader 5. The EA will primarily be designed for XAU/USD and should run on the M5 chart (5 minutes) by default. The main idea: • The EA identifies the significant Highs and Lows (Swing Points) on the M5 chart. • Based on these levels, it places two pending orders at a defined time: • Buy Stop above the
I need a trading system or indicator for EUR/USD on the M5 chart for day trading. The system must not be an Expert Advisor, but only an indicator with entry and exit signals. Key requirements: The hit rate should be around 80%. A dynamic exit must be implemented and automatically marked on the chart. For a buy signal, a blue arrow should appear, both visually and with a sound alert. For a sell signal, a red arrow
Request for the Development of a Trading System (MT5, EUR/USD, M5) Dear [Name], I am looking for a developer who can create a trading system (not an Expert Advisor, but an indicator system with visual signals) for day trading EUR/USD on the M5 chart. Requirements: The system should generate as many pips per day as possible High win rate (to be confirmed by backtests) Clear visual signals on the chart (e.g., arrows
Development of a Prop-Trading-Compliant Trend-Following EA for MetaTrader 5 with News Filter, Risk Control, and Backtesting I am looking for an experienced MQL5 developer to create a fully automated trend-following Expert Advisor (EA) for MetaTrader 5. The EA must be specifically designed for prop trading challenges , following strict risk management rules. Additionally, it should trade during sideways markets
Ich suche einen erfahrenen MQL5-Entwickler , der einen vollautomatischen Trendfolge-Expert Advisor (EA) für MetaTrader 5 programmiert. Der EA soll speziell für Prop Trading Challenges entwickelt werden und daher strenge Risikoregeln einhalten. Zusätzlich muss er in der Lage sein, auch Seitwärtsmärkte zu handeln, um die Challenge schneller zu bestehen. Anforderungen an den EA Handelslogik Trendfolge : Entwickler wählt

Informations sur le projet

Budget
100+ USD
TVA (20%): 20 USD
Total: 120 USD
Pour le développeur
90 USD

Client

(1)
Commandes passées4
Nombre d'arbitrages0