Multiple task at once

ride2esc

New Member
Joined
Jun 13, 2015
Messages
12
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.

Please advise.
Thank you
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
62,507
Office Version
  1. 365
Platform
  1. Windows
Is your data in col A?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
62,507
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Jun 13, 2015
Messages
12

ADVERTISEMENT

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

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
62,507
Office Version
  1. 365
Platform
  1. Windows
Glad we could help & thanks for the feedback.
 

Forum statistics

Threads
1,141,572
Messages
5,707,166
Members
421,495
Latest member
jono_oh

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top