Exporting your data
- Lesson 4 of 7
- Using Okkana
- steps
- 6
- terms explained
- 4
About this lesson
What you'll learn
How to download the signals report: where it is, the period and which signals it covers, the bot's result next to yours, and how to read and open the file.
Where the report is
The signals report is a file with one row per signal: what the bot's virtual position did, next to what you registered. It opens from the Export button on the Signals page and from the page of each bot.
On the Signals page you can pick any bot or all of them, and a bot already filtered there is the starting choice. On a bot's page the report is fixed to that bot. The file comes as CSV or Excel.
Choose the period
The period is a start and an end date in UTC, both days included. The presets cover the last 7, 30 or 90 days up to today, and you can type any other range.
A report covers at most 366 days. A range with the start after the end, or longer than that, isn't sent. A report also holds at most 50,000 signals: with more than that, narrow the range or pick a bot.
The file is named okkana-signals, followed by the first and the last day.
Which signals go in
The Operation option picks signals by what you did with them. Pending ones have no operation yet, open ones have an entry and no exit, and closed ones have both. At least one has to be ticked.
Signals you discarded are never part of the report, and there is no option for them.
A pending or open signal still carries the bot's side of the result once its virtual position has closed.
The columns
Every row starts with the signal's number, bot, market, the bot's direction, the trigger time in UTC and the status. The paper result is the bot's virtual position: entry, exit, return, gross PnL, funding, fees and net PnL, plus the best and worst move in 24 hours. The real result is your operation: direction, entry, notional, exit, return and the same PnL breakdown.
The Result option picks the sides: the bot and yours, only the bot's, or only yours. The two difference columns only exist when both sides are in the file.
Reading the rows
A paper value is filled once the bot's virtual position has closed, and a real value once you registered the exit. Until then the cell stays empty. The entry data of an open operation is already there.
The difference is your return minus the bot's, in percentage points, and your net PnL minus the bot's. It's only calculated on rows where both sides have closed.
The last row is the total: the sum of the paper net PnL, the real net PnL and their difference. Each sum counts only the rows that have that value, so the totals can cover different signals.
Opening the file
The CSV starts with a mark that makes Excel read accents correctly. The Excel file has one sheet, Signals, with the header and the totals row in bold. Numbers are written as plain numbers in both, so you can sort them and add them up.
Text that starts with =, +, - or @, like a bot name, gets an apostrophe in front so the spreadsheet doesn't run it as a formula.
With the bot's result next to yours, you can filter by bot or market and compare entry and exit prices, times and returns signal by signal.
These lessons explain what each number measures. They are not trading advice, and the lesson charts use simulated data. Preview build: market data on this site is simulated.