Now we should do some work with excel.
With excel, switch to "Power Query" tab and go to "From File -> From Folder"
Now we loaded metadata of our csv files
In the first column "Content" we need right click and choose "Remove other colums"
Now click to "Close & Load" button and choose "Close & Load To ..."
In the new window you should select "Only Create Connection" and "Add this data to the Data Model"
and click to "Load" button
switch to "Power Query" tab and go to "Launch Editor" in "Workbook Queries" group
Select the Query on left and give him name that makes sense to you. For example "trades data"
Now click in the column "Content" to any row to "Binary" link
In the new windows we see that we have loaded data from our csv files
We sholud tell to excel what types of data we have
So for "Entry price, Exit price" we can select "Decimal number", for "Profit, MAE, MFE" Currency
and for "Entry time and Exit Time" select Date/Time
Now we can do some PowerQuery formula (is it a little different than excel formula but is powerful ;)
In Query Editor select "Add column" tab and click on "Add column button", and type