Processing Excel data into a graph

Hello, I am looking for / asking someone handy here in the MT5 environment who can connect and fully automate data from cells in an Excel spreadsheet, probably best into a 3D chart.

I will now describe in general why I want the 3D chart: I trade currency pairs, for which I have created a trading strategy that generates purchases and sales for me according to internal settings. The problem is that, for example, the EUR/USD currency pair creates unnecessary short trends lasting several minutes during the Asian session and losing or with minimal profit and only starts in the European and beginning of the American session and then again unnecessary short trends. = I need to track when (hour + minute) the given asset generates unnecessary signals every day. I don't care if the entry into the trade was, for example, 5.3.2024 or 6.8.2024 or on Monday or Friday, i.e. I am only interested in the hour and minute of entering the trade, how long it lasted = when to exit and immediately buy in the opposite direction or just exit and wait for the next signal, whether it was a short/long trade and whether it was profitable/losing and how much profit or loss was in % = ultimately how many trades were opened in total in a given minute in a given hour during the entire tested period. The length of the backtested period can be different = the number of trades can also be different. The goal of this system will be to visualize the individual trades in a suitable and clear way (see the distribution described here earlier), so that I can then exclude trading in specific trading windows/sessions in the internal settings of my EA to avoid too short or unprofitable trades. HOW DO YOU PROCESS THIS = USING A PROGRAM (EXCEL GRAPH, PYTHON, ...) I LEAVE IT UP TO YOU = I AM INTERESTED IN THE RESULT. below I describe my proposal for a solution to a 3D Excel chart, but it is not the only solution ...

The automation you created must allow me to upload a new sheet prepared in advance to an automatically generated Excel file after a back-test from tradingview and metatrader separately, which will be able to read the correct input data from the relevant sheets/columns/rows = cells (see my description here) and generate a visual preview for me = i.e. after reading the data, it will first divide the trades according to the entry times (hour/minute = NOT day of the week, date, ... = I do NOT care), then it will divide these sums into the duration of the trade according to the time of exit from the trade, then it will divide them into the direction of the trade long or short, then it will divide this into whether it is profitable or unprofitable, then these into profit/loss in ?,?? %. Finally, these sums and divisions are plotted in a 3D chart above the horizontal line according to the entry time in columns in a row (NOT next to each other) from the lowest to the highest according to the duration of the trade, which will be plotted on the side vertical line, and each column (located above the specific hour and minute of entry) is divided into long (black framed column) / short (white framed column = therefore the overall background of the chart is gray), and profitable (green column fill) / losing (red column fill) according to ?,?? % profit/loss in color. Because the horizontal line will have a time axis from 00:00 to 24:00 and trades above it by minutes of trade entries = there will be many time variants (24 hours and each hour 60 minutes), the basic main chart will be divided into hourly intervals, BUT when I click on a given hour, a more detailed chart will open "next to" it, which will only display the given hour divided into minutes from the 1st to the 59th minute.

The source of input data for you will be files automatically generated after the back-test from two platforms: Tradingview and MetaTrader5. Always MS.Office Excel format = .xlsx. Excel from MT5 is organized differently than from TV! Here in the attachment I am sending compressed sample excel files that the respective MT5 or TV platform generates for me automatically = I cannot change their content. These will be "source files".

File from Tradingview = only the 4th sheet "List of trades" is important for you, where:

- column 1. "Trade #" = each trade consists of two instructions: entry and exit = this column contains trade numbers, where each trade has 2 lines with the same number in column 1 = THERE ARE TWO LINES FOR EACH TRADE FOLLOWED. Furthermore, in this column there are 4 possible entries: "Entry short" or "Exit short" or "Entry long" or "Entry long" = from the second word of this entry you can find out whether the trade was long or short.

- column 2. "Type" = here the given trade is already divided into "entry" and "exit" lines according to the same serial number in column 1

- column 8. "Profit %" = here you are only interested in the number in ?,?? % in the "exit" row where if 0.00 then nothing, if the "minus" sign before ?,?? % = loss and if without a sign but the number is 0.01 inclusive and higher = profit. important: TV lists 2 lines for each trade and the number ?,?? % is duplicated for each line of the given trade = we are only interested in it once and that is in the "exit" row of the given trade number.

- column 4. "Date/Time" = here you are interested ONLY in the time, i.e. NOT the date! and that is in the row for entry and exit = the difference between the entry and exit time is the duration of the trade being monitored.

+ for the "title" of the graph, the last sheet "Properties" and rows 1 to 16, columns 1 and 2 are important. Important: the number of these monitored rows may vary depending on the entered parameters of the tested strategy, i.e. if there are more pre-selected variants in the strategy, then logically more rows will be listed here, i.e. it does not always end with line 16 but always with the last line, which precedes the line that has "Initial capital" written in column 1

The file from MetaTrader5 = there is only one sheet "Sheet 1", where :

- we are only interested in the lines that are under the line called "Deals", where the next 2 lines do NOT interest us (where in the first line the column headings and in the second line "balance) = see the attachment here

- each trade has 2 lines below it to divide the entry and exit from the trade. this is stated in column 5 where "in" is the entry into the trade and "out" is the exit from the trade

- column 1 = we are only interested in the time WITHOUT the date = the times of entries and exits from the trades individually (see as I wrote above = each trade 2 lines immediately after each other divided into IN and OUT in column 5)

- the division of trades into long and short directions in MT5 is not explicitly stated, unfortunately = for this a function must be created that first compares the values ​​in column 7 in the "in" and "out" rows of the given trade with each other; and then the function looks at column number 11 of the corresponding "out" row of the given trade = i.e. the SHORT direction of the trade was when the difference between the values ​​in column 7 "in" minus the value in "out" is negative and in column 11 there is a positive value OR the difference between the values ​​in column 7 will be positive and in column 11 there will be a negative value. i.e. the price was speculated on (the "in" value is greater than the value in "out") and a profit was made. For the LONG direction it is logically the opposite.

- whether the trade was profitable or unprofitable is determined from the value in column 11 in the "out" row of the given trade = i.e. when there is a value without a sign = profit, when there is a value with "-" / minus = loss. This must be taken into account according to the long / short direction variant!

- for the "title" of the graph, lines 4 to the last line preceding the line that has "Company:" written in column 3 are important

If you have any questions = contact me anytime.

Thank you and I am here for you and thank you for your work so far!

Have a nice day