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

Termos de Referência

I need a Microsoft Excel file 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.

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


📌 Requirements:

  • The file must be created entirely in Microsoft Excel
    ❌ No macros, ❌ no programming, ❌ no Google Sheets

  • 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 Excel 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 and EUR (Net) columns are required in addition.

Respondido

1
Desenvolvedor 1
Classificação
(11)
Projetos
15
20%
Arbitragem
3
67% / 0%
Expirado
0
Trabalhando
Pedidos semelhantes
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
I am looking for someone who can further develop my MT5 EA (XAU/USD). I would like to add a machine learning/neural network extension to improve performance. If anyone is knowledgeable in this area, please feel free to contact me so we can discuss it
Project Request: ATAS Visual Signal & Dynamic Exit System (EUR/USD, M5) Dear Developer, I’m looking for an experienced ATAS specialist who can build a visual signal and dynamic exit system for EUR/USD on the M5 timeframe. Important: This is not an autotrading system – I only need signal detection, alerts, and visual output. Entry Signal Conditions (BUY/SELL – all must be fulfilled simultaneously): CVD divergence
Hier sind also die Anforderungen an den HFT MT4 EA. Der EA muss eine Short - Position eröffnen , wenn der installierte Filter Long anzeigt und umgekehrt . Der Filter sollte ein gleitender Durchschnitt sein , aber nur einer. Natürlich muss man ihn separat einstellen können , das ist klar . Hier ein Beispiel für den antizyklischen Handel . Goldpreis : 3000 Dollar. Gleitender Durchschnitt ist Long . Der Handel soll

Informações sobre o projeto

Orçamento
70+ USD
IVA (20%): 14 USD
Total: 84 USD
Desenvolvedor
63 USD

Cliente

(1)
Pedidos postados3
Número de arbitragens0