Job description
I am looking for a person who can create automation in excel. How will the automation work?
1. there will be X .csv files in a folder (example attached) - each file will have an asset name such as APPLE
2. you will need to convert this file into an excel file
3. then copy the contents or the entire tab and rename the tab to the file name i.e. APPLE to the excel master file.
4. then you will need to write a rule to check how many losses in a row (let's call it loss levels) - (this can be done on the principle if + then in the cell insert yes, if - then insert no and measure how many will be out of a row).
Then if we will have it in the main file (each csv is a separate tab)
5. you will need to record or somehow mark trades that will be at level 5, 6, 7, 8, 9 in a row.
6. then look for places where there will be 5 or more situations in which there are positions at a loss level of min 6 and list all those hours in which there was such a situation indicating:
(a) the number of assets above level 5
b) the list of assets with an indication of the level