Education in research methods · Quantic Eagle operates only with its own capital. No client funds, investment advice or trading signals.

DATA PREPARATION / IN YOUR BROWSER

Equity CSV converter for drawdown analysis

Exported dates and account values with different column names? Tell this tool which column contains each value and it will prepare the CSV the calculator needs. A list of profits from closed trades is not enough: it misses changes in value while those trades were open.

Equity is the total value of the account at a given time, including unrealised profits and losses on open positions. Balance excludes those unrealised results. Treatment of credit, fees and other components depends on the source. The tool uses the values you supply; it cannot reconstruct missing observations or verify how they were calculated.

Deposits and withdrawals: this tool accepts only series with no external cash flows. If you supply cash_flow, every value must be zero; a non-zero value stops the check or conversion. If the column is absent, you must confirm that there were no flows. Do not replace deposits or withdrawals with zeros to bypass this check: they require an adjustment method that this tool does not provide.

Why this restriction? Withdrawing €200 from a €1,000 account reduces its value to €800 even if no trade has lost money. Treating that fall as a 20% trading loss would confuse a withdrawal with trading results. This tool does not separate the two effects.

Times must already be converted to UTC, the common time reference. For example, 2026-01-20T16:00:00Z means 20 January 2026 at 16:00 UTC. Z declares that reference; adding it to a local time does not convert the time. The tool cannot infer the original time zone.

UTF-8 CSV only: up to 5 MB, 50,000 observations and 64 columns.

Your file stays in your browser. No account, server upload or email required.

The False Green Museum

From your column names to the calculator’s CSV

This small invented file records account value in euros at three UTC times, with no deposits or withdrawals. Download the sample using the link below. In the converter, select a semicolon as the column delimiter and a comma as the decimal separator, then open the downloaded file. Map recorded_at to timestamp and account_value to equity; leave balance and cash_flow unselected and confirm the two statements about equity and cash flows. Run the conversion and download the resulting CSV.

Original CSV

recorded_at;account_value
2026-01-01T00:00:00Z;10000,00
2026-01-02T00:00:00Z;12000,00
2026-01-03T00:00:00Z;9000,00

CSV produced by the converter

timestamp,equity
2026-01-01T00:00:00Z,10000.00
2026-01-02T00:00:00Z,12000.00
2026-01-03T00:00:00Z,9000.00

The converter changes column names and decimal separators. It keeps the timestamps and values: it neither converts time zones nor reconstructs account value from closed trades. Open the output in the drawdown calculator, confirm the absence of cash flows and expect a maximum decline of 25%.

Download the conversion sample · Open the drawdown calculator

The fieldbook is in preparation. The resources on this website are free to use. You can request one email when the fieldbook is ready; no purchase or reservation is available.

Notify me when it is ready

Written by Quantic Eagle LTD · General education in research methods. About.

Back to top