#### ride2esc

##### New Member
Hello everyone
I am trying to make multi-calculation at once in excel, and firs I want to know if possible, and if yes..then how

From another tool I get some data which look like this:

Bot, [03.02.21 20:48]
Sell order executed at Bittrex
43.14492517 ZRX @ 0.73 USDT
Total: 31.49 USDT
Fees paid: 0.06 USDT
Average rate: 0.70 USDT
Break Even Price: 0.70 USDT
Profit/Loss of this trade: 1.50 USDT (5.28%)
Overall Profit/Loss: 6.19 USDT

Bot, [03.02.21 21:05]
Sell order executed at Binance
15634 HOT @ 0.00 USDT
Total: 12.99 USDT
Fees paid: 0.01 USDT
Average rate: 0.00 USDT
Break Even Price: 0.00 USDT
Profit/Loss of this trade: 0.41 USDT (3.38%)
Overall Profit/Loss: 3.85 USDT

And so on..
I want to extract in another sheet or in another column the following data:

 Date Market (bittrex, binance, etc) Profit/loss Overall profit/loss 03.02.21 20:48 Bittrex 1.50 3.85

After this is done, I want to do some calculations. Sums, and other, but those I know how.
So, I can copy and paste from the other program the data, then paste it in excel then the report.

Thank you

#### ride2esc

##### New Member
nope. No error but it does nothing..

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

#### Fluff

##### MrExcel MVP, Moderator
Is your data in col A?

Yes, column A!

#### Fluff

##### MrExcel MVP, Moderator
Using the code from mohadin in post#8 with the mods I made
VBA Code:
``````Sub test()
Dim a As Variant
Dim ar As Range
Range(Cells(1, 3), Cells(1, 6)) = Array("Date", "Market (bittrex, binance, etc)", "Profit/loss", "Overall profit/loss")
For Each ar In Columns("A:A").SpecialCells(xlCellTypeConstants, 2).Areas
a = ar
a(1, 1) = Split(Split(a(1, 1), "[")(1), "]")(0)
a(2, 1) = Split(a(2, 1), "at")(1)
a(3, 1) = Split(Split(a(8, 1), ": ")(1), "USDT")(0) * 1
a(4, 1) = Split(Split(a(9, 1), ": ")(1), " ")(0) * 1
Cells(Cells(Rows.Count, 3).End(xlUp).Row + 1, 3).Resize(, 4) = Application.Transpose(a)
Next
End Sub``````
gives me
+Fluff 1.xlsm
ABCDEF
1Bot, [03.02.21 20:48]DateMarket (bittrex, binance, etc)Profit/lossOverall profit/loss
2Sell order executed at Bittrex03.02.21 20:48 Bittrex1.56.19
343.14492517 ZRX @ 0.73 USDT03.02.21 21:05 Binance0.413.85
4Total: 31.49 USDT
5Fees paid: 0.06 USDT
6Average rate: 0.70 USDT
7Break Even Price: 0.70 USDT
8Profit/Loss of this trade: 1.50 USDT (5.28%)
9Overall Profit/Loss: 6.19 USDT
10
11Bot, [03.02.21 21:05]
12Sell order executed at Binance
1315634 HOT @ 0.00 USDT
14Total: 12.99 USDT
15Fees paid: 0.01 USDT
16Average rate: 0.00 USDT
17Break Even Price: 0.00 USDT
18Profit/Loss of this trade: 0.41 USDT (3.38%)
19Overall Profit/Loss: 3.85 USDT
20
21
Master

#### ride2esc

##### New Member

This code works also for me now!!!!
Thank you so MUCH!

#### Fluff

##### MrExcel MVP, Moderator
Glad we could help & thanks for the feedback.

#### ​

@Fluff Thanks in deed

Replies
3
Views
166

1,141,712
Messages
5,708,008
Members
421,540
Latest member
quocbinh

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back