File size: 5,414 Bytes
c5ef85d
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
```

Backend/

β”œβ”€β”€ main_watchdog.py        # The "Brain": Constantly monitors for new files                      script

β”œβ”€β”€ Drop_xlsx_here/         # The "Trigger": Put your raw Excel files here                        folder

β”œβ”€β”€ Process/                                                                                      folder

β”‚   β”œβ”€β”€ 1_layer.py          # parsing the entire one xlxs                      - outputs 1 csv    script

β”‚   β”œβ”€β”€ 2_layer.py          # extracts the order&deals tables                  - outputs 2 csv    script

β”‚   β”œβ”€β”€ 3_layer.py          # from 2 csv, merge into one                       - outputs 1 csv    script

β”‚   β”œβ”€β”€ 4_layer.py          # only all red-rolling_28-metrics (MT5)            - outputs 1 csv    script

β”‚   β”œβ”€β”€ 5_layer.py          # only all blue-rolling_13-metrics (non-MT5)       - outputs 1 csv    script

β”‚   β”œβ”€β”€ 6_layer.py          # from 2 csv, all balance-based_41-metrics         - outputs 1 csv    script

β”‚   β”œβ”€β”€ 7_layer.py          # only all orange (equity-based) rolling_metrics   - outputs 1 csv    script

β”‚   β”œβ”€β”€ 8_layer.py          # from 1 csv, all equity-based_35metrics           - outputs 1 csv    script

β”‚   └── 9_layer.py          # all balance & equity-based_76metrics             - outputs 1 csv    script

β”œβ”€β”€ Output_csv_files/       # The "Result": Final processed data ends up here                     folder

β”œβ”€β”€ Others/                                                                                       

β”‚   β”œβ”€β”€ cells_dataframe_counter.py                                                                

β”‚   β”œβ”€β”€ linechart_one_row_tester.py                                                               

β”‚   └── PQI.py                                                                                         

└── workflow.md





















QuasarVaultage

β”œβ”€β”€ .venv/

β”œβ”€β”€ .vscode/

β”œβ”€β”€ backend/

β”‚   β”œβ”€β”€ [1]_main_watchdog.py       # The "Brain": Constantly monitors for new files                     

β”‚   β”œβ”€β”€ [2]_Drop_xlsx_here/        # The "Trigger": Put your raw Excel files here                        

β”‚   β”œβ”€β”€ [3]_Process/                                                                                      

β”‚   β”‚   β”œβ”€β”€ 1_layer.py          # parsing the entire one xlxs                     

β”‚   β”‚   β”œβ”€β”€ 2_layer.py          # extracts the order&deals tables                

β”‚   β”‚   β”œβ”€β”€ 3_layer.py          # from 2 csv, merge into one                     

β”‚   β”‚   β”œβ”€β”€ 4_layer.py          # only all red-rolling_28-metrics (MT5)           

β”‚   β”‚   β”œβ”€β”€ 5_layer.py          # only all blue-rolling_13-metrics (non-MT5)       

β”‚   β”‚   β”œβ”€β”€ 6_layer.py          # from 2 csv, all balance-based_41-metrics         

β”‚   β”‚   β”œβ”€β”€ 7_layer.py          # only all orange (equity-based) rolling_metrics  

β”‚   β”‚   β”œβ”€β”€ 8_layer.py          # from 1 csv, all equity-based_35metrics          

β”‚   β”‚   └── 9_layer.py          # all balance & equity-based_76metrics             

β”‚   β”œβ”€β”€ [4]_output_csv_files/   # The "Result": Final processed data ends up here      

β”‚   β”‚   β”œβ”€β”€ Upload-1_ID/            # This is where the parsed file for first uploaded file

β”‚   β”‚   |   β”œβ”€β”€ 1_layer_output.csv  # example file

β”‚   β”‚   |   β”œβ”€β”€ 2_layer_output.csv  # example file

β”‚   β”‚   |   β”œβ”€β”€ 3_layer_output.csv  # example file 

β”‚   β”‚   |   β”œβ”€β”€ 4_layer_output.csv  # example file

β”‚   β”‚   |   β”œβ”€β”€ 5_layer_output.csv  # example file

β”‚   β”‚   |   β”œβ”€β”€ 6_layer_output.csv  # example file

β”‚   β”‚   |   β”œβ”€β”€ 7_layer_output.csv  # example file 

β”‚   β”‚   |   β”œβ”€β”€ 8_layer_output.csv  # example file

β”‚   β”‚   |   └── 9_layer_output.csv  # example file

β”‚       β”œβ”€β”€ Upload-2_ID/             # This is where the parsed file for second uploaded file

β”‚       β”œβ”€β”€ Upload-3_ID/             # This is where the parsed file for third uploaded file

β”‚       └── Upload-4_ID/            # and so on, the pattern goes infinite

β”œβ”€β”€ database/                   # only stores metadata

β”œβ”€β”€ authentication/             # mont secure authentication process which mainly include email and no password needed 

└── frontend/













QuasarVaultage

β”œβ”€β”€ .venv/

β”œβ”€β”€ .vscode/

β”œβ”€β”€ backend/

β”‚   β”œβ”€β”€ [1]_main_watchdog.py                      

β”‚   β”œβ”€β”€ [2]_Drop_xlsx_here/             

β”‚   β”œβ”€β”€ [3]_Process/                                                                                      

β”‚   β”‚   β”œβ”€β”€ 1_layer.py                     

β”‚   β”‚   β”œβ”€β”€ 2_layer.py                      

β”‚   β”‚   β”œβ”€β”€ 3_layer.py                           

β”‚   β”‚   β”œβ”€β”€ 4_layer.py                  

β”‚   β”‚   β”œβ”€β”€ 5_layer.py             

β”‚   β”‚   β”œβ”€β”€ 6_layer.py              

β”‚   β”‚   β”œβ”€β”€ 7_layer.py         

β”‚   β”‚   β”œβ”€β”€ 8_layer.py         

β”‚   β”‚   └── 9_layer.py          

β”‚   └── [4]_output_csv_files/      

β”œβ”€β”€ database/                  

β”œβ”€β”€ authentication/            

└── frontend/