Expert Advisor or script for creation of statistics.

EA/script should to record highest profit and highest loss at certain time from current opened positions. And next should to record average profit and loss at certain time from current opened positions. This average profit and loss should be counted from highest profit and highest loss, that was created always at one hour.

The statistics should be recorded to excel file.

Setting:

Time-1: 120 (Setting for recording of highest profit and highest loss in minutes. If there is a set value 120, so it mean that script should to record the values for last 2 hours.)

Time-2: 60 (Setting for recording of average profit and loss, if there is a set value 60, so it mean that script should to count average profit and loss from values, that was reached each 1 hour, i.e. 12:00h – 13:00h. If is a set value 120, so it mean that values should be to count from each the hour, i.e. 12:00h - 13:00h and 13:00 - 14:00h. As is mentioned this values are counted always from each hour, if there is a set more than 1 hour.) note. This values should be counted from starting of the EA/script and it must not be always exact hour, but it can be i.e. 12:25h – 13:25h.


Other:

The profit and loss should be counted from opened positions (open profit/loss) and in currency, not in points or pips.


Example of record:

Time-1 (Highest profit and highest loss at certain time):

1. day = 100 (-70)
2. day = 50 (-60)
3. day = 70 (-90)

Highest profit and highest loss should be saved in following format.

Date –           Trade Time -     Time-1 –  Highest profit – Highest loss - Instruments
25.6.2021      12:00-14:00         120               100                    -70              eurusd,gbpusd
26.6.2021      12:00-14:00         120                 50                    -60              eurusd,gbpusd
27.6.2021      12:00-14:00         120                 70                    -90              eurusd,gbpusd


Example of the count:

Time-2 (Average profit and loss at certain time):

The value is a set on 120 minutes = 2 hours

1 day = 100, 30, (-70), (-90)

Highest average profit = 100+30 = 130 / 2 = 65.00
Highest average loss = 70+90 = 160 / 2 = -80.00

Average highest profit and highest loss should be saved in following format.

Date –          Trade time -     Time-2 –  Average profit – Average loss - Instruments
25.6.2021   12:00-13:00         120              100.00                -70.00           eurusd,gbpusd
25.6.2021   13:00-14:00         120                30.00                -90.00           eurusd,gbpusd