ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Instructions to use the CSV import feature.
2
0
Goto FILE > MAKE A COPY.. to your own Google Drive to be able to edit the sheet within GoogleSheets. *This sheet has not been tested at all with Excel.
3
1
Download the CSV by going to BitMEX > Account > Balances > Save as CSV the wallet history of transactions for combined Deposit / RealisedPNL / Withdrawals.
4
2
Select the desired numbered PASTE sheet and make sure cell A1 is selected.
5
6
7
Change Log6.74
All bot column E changed to fill in 0's when the bot is turned off
8
Totals column L added for Earned USD and chart on Summary Tan updated
9
6.72
Accounting for YYYY-MM-DD and DD-MM-YYYY formats with spaces after the date
10
3
From the menu select FILE > IMPORT.
11
12
13
14
15
16
17
18
19
20
21
4
Click on the UPLOAD menu tab.
22
23
24
25
26
27
28
5
Click the select file button and choose the desired .csv Bitmex history file.
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
6
Choose the following options for import: Replace Data, comma seperated.
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
7
Click Import Data button.
65
8
Repeat steps 1-8 for each bot.
66
9
DON'T Localise the regional date settings of your copy of this spreadsheet.
67
10
When finished check SUMMARY tab.
68
11
If you would like to override the starting date from the CSV, enter a new date in the SUMMARY TAB
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100