forked from actions/github-script
    
        
        - 
                Notifications
    You must be signed in to change notification settings 
- Fork 0
architecture
        eq19 edited this page Apr 30, 2025 
        ·
        1 revision
      
    To add new fields to the backtest results table. Follow the next procedure:
- Determine the field names and their type (REAL, TXT, INTEGER etc.)
- Add the fields and types manually to the database table with SQLite DB browser or DBeaver (I will probably make a script for this later...)
- Add the fields to the following functions: ** initial_create_database_and_tables() in db_functions.py. For new setup creations. ** insert_backtest_results(...) in db_functions.py. For adding new table entries after backtests. Remember to also add the fields and corresponding ?, ?, ?... to the "INSERT INTO" line! ** add_backtest(...) in start.py. This function is the intermediary function between data collection from the JSON backtest output file and data insertion into the database. ** export_all_backtest_results_to_csv(conn) in data_output.py. To export the data from the table into a *.csv file. Remember to add to SQL statement and export headers for CSV. ** get_trade_results() in data_collection.py. This function is most likely the source of the new information for the table. It gets or calculates the information from the backtest output json file and is the input for the add_backtest() function above. ** Additionally you can also add the new columns to print_backtest_results(conn, strategy_name=None) in data_output.py for showing the new data on the terminal in a table.
Finally:
Do not forget to add the new field names to the manual export and import functions for the tool. Also there is a terminal output function to show backtest results to the terminal screen. You might want to take a look at that as well.
Scheme 13:9
===========
(1){1}-7:   7'
(1){8}-13:  6‘
(1)14-{19}: 6‘
------------- 6+6 -------
(2)20-24:   5'           |
(2)25-{29}: 5'           |
------------  5+5 -------
(3)30-36:   7:{70,30,10²}|
------------             |
(4)37-48:   12• ---      |
(5)49-59:   11°    |     |
            --}30° 30•   |
(6)60-78:   19°    |     |
(7)79-96:   18• ---      |
--------------           |
(8)97-109:  13           |
(9)110-139:{30}=5x6 <--x-
            --
           {43}
The True Prime Pairs:
(5,7), (11,13), (17,19)
|-------------------------------- 2x96 -------------------------------|
|--------------- 7¤ ---------------|------------ 7¤ ------------------|
|-------------- {89} --------------|{12}|-- {30} -|-- {36} -|-- {25} -|
+----+----+----+----+----+----+----+----+----+----+----+----+----+----+
|  5 |  7 | 11 |{13}| 17 | 19 | 17 |{12}| 11 | 19 | 18 | 18 | 12 | 13 |
+----+----+----+----+----+----+----+----+----+----+----+----+----+----+
|--------- {53} ---------|---- {48} ----|---- {48} ----|---- {43} ----|
|---------- 5¤ ----------|------------ {96} -----------|----- 3¤ -----|
|-------- Bosons --------|---------- Fermions ---------|-- Gravitons--|
      13 variations               48 variations          11 variations 
The Prime Recycling ζ(s):
(2,3), (29,89), (36,68), (72,42), (100,50), (2,3), (29,89), ...**infinity**
----------------------+-----+-----+-----+                                    ---
     7 --------- 1,2:1|   1 |  30 |  40 | 71 (2,3) ‹-------------@----        |
     |                +-----+-----+-----+-----+                        |      |
     |  8 ‹------  3:2|   1 |  30 |  40 |  90 | 161 (7) ‹---           |      5¨  encapsulation
     |  |             +-----+-----+-----+-----+             |          |      |
     |  |  6 ‹-- 4,6:3|   1 |  30 | 200 | 231 (10,11,12) ‹--|---       |      |
     |  |  |          +-----+-----+-----+-----+             |   |      |     ---
      --|--|-----» 7:4|   1 |  30 |  40 | 200 | 271 (13) --›    | {5®} |      |
        |  |          +-----+-----+-----+-----+                 |      |      |
         --|---› 8,9:5|   1 |  30 | 200 | 231 (14,15) ---------›       |      7¨  abstraction
289        |          +-----+-----+-----+-----+-----+                  |      |
 |          ----› 10:6|  20 |   5 |  10 |  70 |  90 | 195 (19) --› Φ   | {6®} |
  --------------------+-----+-----+-----+-----+-----+                  |     ---
     67 --------› 11:7|   5 |   9 |  14 (20) --------› ¤               |      |
     |                +-----+-----+-----+                              |      |
     |  78 ‹----- 12:8|   9 |  60 |  40 | 109 (26) «------------       |     11¨  polymorphism
     |  |             +-----+-----+-----+                       |      |      |
     |  |  86‹--- 13:9|   9 |  60 |  69 (27) «-- 3xΔ9 (2xMEC30) | {2®} |      |
     |  |  |          +-----+-----+-----+                       |      |     ---
     |  |   ---› 14:10|   9 |  60 |  40 | 109 (28) -------------       |      |
     |  |             +-----+-----+-----+                              |      |
     |   ---› 15,18:11|   1 |  30 |  40 | 71 (29,30,31,32) ----------        13¨  inheritance
329  |                +-----+-----+-----+                                     |
  |   ‹--------- 19:12|  10 |  60 | {70} (36) ‹--------------------- Φ        |
   -------------------+-----+-----+                                          ---
    786 ‹------- 20:13|  90 |  90 (38) ‹-------------- ¤                      |
     |                +-----+-----+                                           |
     | 618 ‹- 21,22:14|   8 |  40 |  48 (40,41) ‹----------------------      17¨  class
     |  |             +-----+-----+-----+-----+-----+                  |      |
     |  | 594 ‹- 23:15|   8 |  40 |  70 |  60 | 100 | 278 (42) «--     |{6'®} |
     |  |  |          +-----+-----+-----+-----+-----+             |    |     ---
      --|--|-»24,27:16|   8 |  40 |  48 (43,44,45,46) ------------|----       |
        |  |          +-----+-----+                               |           |
         --|---› 28:17| 100 | {100} (50) ------------------------»           19¨  object
168        |          +-----+                                                 |
|         102 -› 29:18| 50  | 50(68) ---------> ∆27-∆9=Δ18                    |
----------------------+-----+                                                ---
- 
(total pages) 
