Back Testing Portfolio Simulator Low Latency Trading
Previous | Back Testing Algorithmic Trading Modern Portfolio Simulator - Some Code | Next |
1
2 |ExSan| C++ |ExSan| MSVSC2022_V17_6.3@06.16-toolSet(v143)-
3 Wed Jul 12 07:27:31 2023
4
5
6 exsan.plusplus@gmail.com https://twitter.com/#!/ExSan_com
7 JOB: hft_2731
8
9 Clock now: 767740890792800 nanoseconds since boot
10 GLUTo Mon Jan 1, 2024
11 License Grant for: 165 days more
12 DBfile: stockDB_8.txt dbfileID: 4
13 StockCounterDB Number of files: 42
14
16 :409: 1 dbfileID: 7 stockDB15.txt
17 :410: 2 nTickRead: 99999
18 :411: 3 cols: 7
19 :416: 7 minDB: 2
20 Read From File myInvestment: 10018 Savings: 90
21
22 pp_lastIN 0 ppnt_time 1 ppnt_data 2
23 stockCounterDB: 42 mu: 0.33 Limit Trading / Savings: 10000 FactoRun: 2
24 ******************
25 <--------E-x-S-a-n---------->
26 Generate Exsan ( 43 , 44 )
27
28 Total Number of assets allocated: 42
29
30 PARAMETERS
31 Investment: 10018 min Inv/Stock: 50 # Ticks -cols-: 7 beta: 0.02 ep(little ball): 0.0001
32 HedgeBand 0.15055 <-- 0.6989 --> 0.84945 R( 0.34013 ; 0.45013 )r Lineal #Ticks: 3
33 Expected Return: 2.7 % minDB: 2 timesLapse: 2 timeZoomFactor: 1 retFactor: 0.1
34 Check Trigger Counter: 4 Number of times dice is thrown: 99999 EndLess: 0
35 Run: 3 onlyInteger 0 hedge: 1 ntNodes: 1 limitWeightFactor: 0.33 tickLimitToClear: 33
37 |<--------E-x-S-a-n---HFT------->|
38
Calculating Correlation in HFT (Low Latency Trading)
52
53
54
55
56 78125000 nanoseconds since thread start-up
57 :1611: ExSan Frame ready for Volatily dependent selection DB Counter: 1 pp: 9
58 WORKSHEET 9 I[30, 7] FLOAT
59 A B C D E F G
60 >-------------------------------------------------<
61 6 0.00 ANUL 1: 10.90 10.77 10.53 10.88 10.44 10.78 7.19
62 5 0.00 ADVN 2:157.09 157.32 151.62 152.37 151.72 39.27 103.68
63 8 0.00 ABMD 3: 19.56 24.62 22.62 20.25 16.50 16.31 19.25
64 7 0.00 ATLU 4:278.87 279.97 282.96 282.12 279.28 278.33 277.46
65 13 0.00 CAB 5: 23.90 23.88 23.66 23.77 23.69 23.45 24.07
66 6 0.00 ALV 6: 52.58 52.48 52.88 55.40 53.88 54.14 34.70
67 5 0.00 APTO 7: 7.00 7.16 7.75 7.56 7.40 1.75 4.62
68 6 0.00 BF 8:144.30 147.57 150.04 148.30 147.54 148.95 95.24
69 4 0.00 AAL 9: 27.74 27.86 28.35 30.15 0.00 6.93 18.31
70 6 0.00 BHI 10: 27.32 26.83 26.90 26.40 25.84 25.68 18.03
71 5 0.00 AAPL 11: 22.80 23.13 23.14 22.68 22.63 5.70 15.05
72 7 0.00 ARNA 12: 63.40 62.00 63.20 69.80 79.50 71.70 72.90
73 9 0.00 AMD 13: 7.82 8.07 7.37 7.44 7.60 7.40 7.61
74 8 0.00 BLS 14: 66.21 65.26 65.00 65.22 65.57 66.39 66.53
75 10 0.00 AKSH 15:101.33 97.14 98.66 102.61 104.97 104.19 107.00
76 7 0.00 BAC 16: 12.17 11.96 11.98 11.80 11.96 11.65 11.79
77 5 0.00 AKS 17: 11.92 11.65 12.18 12.17 12.30 2.98 7.87
78 6 0.00 ANRA 18: 12.20 12.50 13.30 13.60 13.80 13.40 8.05
79 7 0.00 BBY 19: 17.88 17.21 15.96 17.19 18.17 18.29 18.98
80 4 0.00 BMY 20: 32.37 32.01 31.57 31.48 0.00 8.09 21.36
81 9 0.00 CAMP 21: 28.19 32.25 28.12 26.88 27.50 28.25 28.75
82 3 0.00 BOX 22: 19.64 20.53 18.20 0.00 0.00 4.91 12.96
83 8 0.00 ATTU 23: 59.13 69.50 69.00 67.50 67.00 65.50 62.50
84 7 0.00 ASCMA 24: 27.90 28.00 28.20 24.94 24.41 24.57 24.50
85 3 0.00 AMRN 25: 51.25 50.94 50.00 0.00 0.00 12.81 33.83
86 7 0.00 ATHN 26: 28.25 28.31 28.12 29.18 28.92 28.75 29.32
87 1 0.00 BRLC 27: 19.00 0.00 0.00 0.00 0.00 4.75 12.54
88 1 0.00 BSQR 28:144.00 0.00 0.00 0.00 0.00 36.00 95.04
89 7 0.00 ARAC 29: 11.70 12.26 12.39 12.40 12.38 12.66 12.14
90 7 0.00 CAR 30: 14.32 13.95 14.23 14.04 13.67 13.76 13.20
91 <------------------------------------------------->
92 1 2 3 4 5 6 7
93
94
95
96 :3192: PORTFOLIO Selected Stocks ppDB
97 WORKSHEET 4 D[29, 7] FLOAT
98 A B C D E F G
99 >-------------------------------------------------<
100 15 34331828.57 ANUL 1: 10.63 10.60 10.58 10.81 11.00 11.14 11.15
101 8 41945771.43 ADVN 2:157.32 151.62 152.37 151.72 151.40 149.97 149.60
102 8 49409585.71 BF 8:147.57 150.04 148.30 147.54 148.95 145.39 143.80
103 16 25702157.14 ARAC 29: 12.47 12.84 12.49 12.42 12.57 12.95 12.38
104 <------------------------------------------------->
105 1 2 3 4 5 6 7
106
107 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.81088485 -Sum: 0.00000000 +Sum - -Sum: 0.810884
108 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.81088485
109 -Sum: 0.00000000 +Sum - -Sum: 0.81088485 last col W, previous N
110
111
112 :3192: PORTFOLIO Selected Stocks ppDB
113 WORKSHEET 4 D[29, 7] FLOAT
114 A B C D E F G
115 >-------------------------------------------------<
116 15 35689628.57 ANUL 1: 10.63 10.60 10.58 10.81 11.00 11.14 11.15
117 8 43303571.43 ADVN 2:157.32 151.62 152.37 151.72 151.40 149.97 149.60
118 11 42920985.71 ABMD 3: 16.50 16.31 19.25 19.56 19.75 21.50 22.00
119 8 50767385.71 BF 8:147.57 150.04 148.30 147.54 148.95 145.39 143.80
120 12 36950428.57 ARNA 12: 71.70 72.90 70.50 71.60 74.60 73.40 71.40
121 11 51675385.71 CAMP 21: 27.50 28.25 28.75 28.19 32.25 34.19 32.38
122 11 46205514.29 ATTU 23: 67.00 65.50 62.50 59.13 60.00 60.75 62.00
123 16 27059957.14 ARAC 29: 12.47 12.84 12.49 12.42 12.57 12.95 12.38
124 <------------------------------------------------->
125 1 2 3 4 5 6 7
126
128 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.79048803
129 -Sum: -0.02546389 +Sum - -Sum: 0.81595192 last col W, previous N
130
131
132 :3192: PORTFOLIO Selected Stocks ppDB
133 WORKSHEET 4 D[29, 7] FLOAT
134 A B C D E F G
135 >-------------------------------------------------<
136 13 33979042.86 ARNA 12: 72.90 70.50 71.60 74.60 73.40 71.40 71.70
137 11 34380057.14 AKS 17: 12.30 12.86 12.96 13.27 13.44 13.91 13.72
138 10 30114700.00 BMY 20: 31.48 30.89 31.75 30.86 30.27 29.24 28.91
139 16 33712657.14 ARAC 29: 12.47 12.84 12.49 12.42 12.57 12.95 12.38
140 <------------------------------------------------->
141 1 2 3 4 5 6 7
142
143 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.52723285 -Sum: 0.00000000 +Sum - -Sum: 0.527232
144 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.52723285
145 -Sum: 0.00000000 +Sum - -Sum: 0.52723285 last col W, previous N
146 :3300: -----------------------------------------------
149 :3216: run: 3 counter: 2
151 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 6907.00 = 3111.00
2952 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.65380872
2953 -Sum: 0.00000000 +Sum - -Sum: 0.65380872 last col W, previous N
2954
2955
2956 :3192: PORTFOLIO Selected Stocks ppDB
2957 WORKSHEET 4 D[15, 7] FLOAT
2958 A B C D E F G
2959 >-------------------------------------------------<
2960 9 15732042.86 BOX 14: 22.91 22.42 22.11 22.59 22.60 22.86 23.28
2961 8 16904314.29 ATLU 15:165.78 168.69 167.23 168.14 164.72 164.06 163.00
2962 <------------------------------------------------->
2963 1 2 3 4 5 6 7
2964
2965 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.65380872 -Sum: 0.00000000 +Sum - -Sum: 0.653808
2966 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.65380872
2967 -Sum: 0.00000000 +Sum - -Sum: 0.65380872 last col W, previous N
2968
2969
2970 :3192: PORTFOLIO Selected Stocks ppDB
2971 WORKSHEET 4 D[15, 7] FLOAT
2972 A B C D E F G
2973 >-------------------------------------------------<
2974 9 16828542.86 BOX 14: 22.91 22.42 22.11 22.59 22.60 22.86 23.28
2975 8 18000814.29 ATLU 15:165.78 168.69 167.23 168.14 164.72 164.06 163.00
2976 <------------------------------------------------->
2977 1 2 3 4 5 6 7
2978
2979 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.65380872 -Sum: 0.00000000 +Sum - -Sum: 0.653808
2980 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.65380872
2981 -Sum: 0.00000000 +Sum - -Sum: 0.65380872 last col W, previous N
2982
2983
2984 :3192: PORTFOLIO Selected Stocks ppDB
2985 WORKSHEET 4 D[15, 7] FLOAT
2986 A B C D E F G
2987 >-------------------------------------------------<
2988 9 17825342.86 BOX 14: 22.91 22.42 22.11 22.59 22.60 22.86 23.28
2989 8 18997614.29 ATLU 15:165.78 168.69 167.23 168.14 164.72 164.06 163.00
2990 <------------------------------------------------->
2991 1 2 3 4 5 6 7
2992
2993 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.65380872 -Sum: 0.00000000 +Sum - -Sum: 0.653808
2994 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.65380872
2995 -Sum: 0.00000000 +Sum - -Sum: 0.65380872 last col W, previous N
2996
2997
2998 :3192: PORTFOLIO Selected Stocks ppDB
2999 WORKSHEET 4 D[22, 7] FLOAT
3000 A B C D E F G
3001 >-------------------------------------------------<
3002 13 16910371.43 CAR 6: 30.68 31.03 31.11 31.09 31.20 31.72 31.84
3003 10 18236628.57 AMUY 10:107.65 107.25 110.04 107.65 108.84 115.14 115.42
3004 10 17635757.14 BOX 14: 22.42 22.11 22.59 22.60 22.86 23.28 23.63
3005 9 17311342.86 ATLU 15:168.69 167.23 168.14 164.72 164.06 163.00 165.06
3006 11 17495614.29 ARNA 18: 50.00 49.40 48.40 47.30 44.60 42.70 43.80
3007 14 15665500.00 BBY 22: 17.00 17.24 17.31 17.81 17.66 18.12 18.76
3008 <------------------------------------------------->
3009 1 2 3 4 5 6 7
3010
3012 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.52644160
3013 -Sum: -0.07140527 +Sum - -Sum: 0.59784686 last col W, previous N
3014
3015
3016 :3192: PORTFOLIO Selected Stocks ppDB
3017 WORKSHEET 4 D[18, 7] FLOAT
3018 A B C D E F G
3019 >-------------------------------------------------<
3020 14 14364314.29 CAR 6: 31.03 31.11 31.09 31.20 31.72 31.84 31.29
3021 11 14393585.71 AMUY 10:107.25 110.04 107.65 108.84 115.14 115.42 116.62
3022 12 13832514.29 ARNA 18: 49.40 48.40 47.30 44.60 42.70 43.80 43.70
3023 <------------------------------------------------->
3024 1 2 3 4 5 6 7
3025
3026 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.71139870 -Sum: 0.00000000 +Sum - -Sum: 0.711398
3027 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.71139870
3028 -Sum: 0.00000000 +Sum - -Sum: 0.71139870 last col W, previous N
3029
3030
3031 :3192: PORTFOLIO Selected Stocks ppDB
3032 WORKSHEET 4 D[18, 7] FLOAT
3033 A B C D E F G
3034 >-------------------------------------------------<
3035 16 7822228.57 CAR 6: 31.09 31.20 31.72 31.84 31.29 31.33 31.82
3036 13 9932342.86 BOX 14: 22.60 22.86 23.28 23.63 24.39 24.26 25.38
3037 13 11668328.57 ARNA 18: 48.40 47.30 44.60 42.70 43.80 43.70 43.40
3038 <------------------------------------------------->
3039 1 2 3 4 5 6 7
3040
3042 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.68118081
3043 -Sum: -0.09679349 +Sum - -Sum: 0.77797430 last col W, previous N
3044
3045
3046 :3192: PORTFOLIO Selected Stocks ppDB
3047 WORKSHEET 4 D[18, 7] FLOAT
3048 A B C D E F G
3049 >-------------------------------------------------<
3050 16 9126028.57 CAR 6: 31.09 31.20 31.72 31.84 31.29 31.33 31.82
3051 13 11236142.86 BOX 14: 22.60 22.86 23.28 23.63 24.39 24.26 25.38
3052 13 12972128.57 ARNA 18: 48.40 47.30 44.60 42.70 43.80 43.70 43.40
3053 <------------------------------------------------->
3054 1 2 3 4 5 6 7
3055
3057 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.68118081
3058 -Sum: -0.09679349 +Sum - -Sum: 0.77797430 last col W, previous N
3059
3060
3061 :3192: PORTFOLIO Selected Stocks ppDB
3062 WORKSHEET 4 D[18, 7] FLOAT
3063 A B C D E F G
3064 >-------------------------------------------------<
3065 16 10335828.57 CAR 6: 31.09 31.20 31.72 31.84 31.29 31.33 31.82
3066 15 5585857.14 BOX 14: 23.28 23.63 24.39 24.26 25.38 26.47 27.13
3067 11 14896314.29 ATLU 15:168.14 164.72 164.06 163.00 165.06 164.83 163.40
3068 13 14181928.57 ARNA 18: 48.40 47.30 44.60 42.70 43.80 43.70 43.40
3069 <------------------------------------------------->
3070 1 2 3 4 5 6 7
3071
3073 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.72624772
3074 -Sum: -0.06118075 +Sum - -Sum: 0.78742847 last col W, previous N
3075
3076
3077 :3192: PORTFOLIO Selected Stocks ppDB
3078 WORKSHEET 4 D[18, 7] FLOAT
3079 A B C D E F G
3080 >-------------------------------------------------<
3081 19 10481914.29 CAR 6: 31.84 31.29 31.33 31.82 31.76 31.70 31.54
3082 15 12706857.14 AMUY 10:115.14 115.42 116.62 106.85 108.68 108.84 108.64
3083 23 7494671.43 BOOM 13: 47.66 46.24 43.97 40.20 42.15 40.65 46.40
3084 11 14626457.14 BMY 16: 12.92 13.31 13.59 13.50 12.99 13.60 13.52
3085 16 11839757.14 BRLC 17: 19.06 19.06 19.06 19.06 19.07 19.07 19.06
3086 17 10759614.29 ARNA 18: 43.80 43.70 43.40 45.70 46.00 45.50 45.00
3087 <------------------------------------------------->
3088 1 2 3 4 5 6 7
3089
3091 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.82329920
3092 -Sum: -0.01885215 +Sum - -Sum: 0.84215135 last col W, previous N
3093
3094
3095 :3192: PORTFOLIO Selected Stocks ppDB
3096 WORKSHEET 4 D[24, 7] FLOAT
3097 A B C D E F G
3098 >-------------------------------------------------<
3099 10 23331828.57 AAL 2: 7.17 7.06 7.37 7.16 7.15 7.25 7.45
3100 19 22659542.86 AKSH 3: 33.75 34.40 32.00 29.14 28.52 29.54 29.75
3101 21 20489442.86 BHI 4: 32.91 33.11 33.28 33.48 33.56 33.46 33.20
3102 22 19586514.29 ADVN 5: 18.26 18.29 18.14 17.82 17.66 17.58 17.79
3103 19 16979957.14 AMUY 10:108.68 108.84 108.64 114.03 114.62 108.24 111.83
3104 27 15532185.71 BOOM 13: 42.15 40.65 46.40 46.13 45.50 46.74 47.95
3105 22 5433042.86 BOX 14: 28.52 27.35 27.14 27.54 27.65 27.68 28.12
3106 18 12268100.00 ATLU 15:164.61 157.70 158.93 158.51 153.76 158.09 159.00
3107 21 18760714.29 ARNA 18: 46.00 45.50 45.00 43.90 44.40 45.50 45.70
3108 15 19350357.14 BLS 21: 77.56 76.19 76.09 75.33 76.27 75.21 75.08
3109 20 18771200.00 BBY 22: 18.76 18.66 19.31 19.94 19.56 20.19 21.35
3110 20 13479957.14 AAPL 24: 48.23 48.62 49.92 49.97 50.75 51.42 52.05
3111 <------------------------------------------------->
3112 1 2 3 4 5 6 7
3113
3115 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.87550149
3116 -Sum: -0.09361217 +Sum - -Sum: 0.96911366 last col W, previous N
3117
3118
3119 :3192: PORTFOLIO Selected Stocks ppDB
3120 WORKSHEET 4 D[7, 7] FLOAT
3121 A B C D E F G
3122 >-------------------------------------------------<
3123 41 5761942.86 AMCSA 1: 40.72 40.88 40.85 40.34 40.21 40.16 40.37
3124 21 5128985.71 AMRN 7: 16.60 16.50 17.00 17.30 27.00 22.90 24.80
3125 <------------------------------------------------->
3126 1 2 3 4 5 6 7
3127
3128 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.70171798 -Sum: 0.00000000 +Sum - -Sum: 0.701717
3129 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.70171798
3130 -Sum: 0.00000000 +Sum - -Sum: 0.70171798 last col W, previous N
3131
3132
3133 :3192: PORTFOLIO Selected Stocks ppDB
3134 WORKSHEET 4 D[9, 7] FLOAT
3135 A B C D E F G
3136 >-------------------------------------------------<
3137 41 6845942.86 AMCSA 1: 40.72 40.88 40.85 40.34 40.21 40.16 40.37
3138 22 6228514.29 AAL 2: 8.67 8.23 7.97 7.12 7.27 8.22 7.35
3139 21 6212985.71 AMRN 7: 16.60 16.50 17.00 17.30 27.00 22.90 24.80
3140 30 5031971.43 ATHN 9:129.80 128.29 128.28 128.10 130.03 131.17 134.35
3141 <------------------------------------------------->
3142 1 2 3 4 5 6 7
3143
3144 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.70171798 -Sum: 0.00000000 +Sum - -Sum: 0.701717
3145 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.70171798
3146 -Sum: 0.00000000 +Sum - -Sum: 0.70171798 last col W, previous N
3147
3148
3149 :3192: PORTFOLIO Selected Stocks ppDB
3150 WORKSHEET 4 D[30, 7] FLOAT
3151 A B C D E F G
3152 >-------------------------------------------------<
3153 25 9169442.86 AAL 2: 7.12 7.27 8.22 7.35 7.26 7.37 7.53
3154 31 14128728.57 BHI 4: 32.96 33.00 32.71 33.08 33.06 32.50 32.94
3155 33 7951271.43 ADVN 5: 17.82 17.32 17.75 17.53 17.51 17.87 17.68
3156 26 7419842.86 AMRN 7: 22.90 24.80 35.00 23.50 20.40 18.30 18.20
3157 29 3007671.43 ALV 19: 90.52 90.43 90.90 88.57 89.02 90.33 89.91
3158 32 11289385.71 BBY 22: 20.83 21.94 22.03 21.78 21.75 21.97 21.43
3159 30 11768357.14 BF 23:102.97 102.73 102.22 104.66 106.22 107.26 105.93
3160 17 11342400.00 BREV 30: 8.33 7.92 7.81 8.58 8.39 8.40 8.70
3161 <------------------------------------------------->
3162 1 2 3 4 5 6 7
3163
3164 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.92371366 -Sum: 0.00000000 +Sum - -Sum: 0.923713
3165 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.92371366
3166 -Sum: 0.00000000 +Sum - -Sum: 0.92371366 last col W, previous N
3167
3168
3169 :3192: PORTFOLIO Selected Stocks ppDB
3170 WORKSHEET 4 D[23, 7] FLOAT
3171 A B C D E F G
3172 >-------------------------------------------------<
3173 37 8807571.43 ADVN 5: 17.51 17.87 17.68 17.81 17.72 17.93 17.89
3174 37 7771842.86 ATLU 15:168.51 168.36 165.61 164.80 167.01 165.07 165.27
3175 34 8324985.71 BF 23:106.22 107.26 105.93 105.02 104.63 105.51 104.77
3176 <------------------------------------------------->
3177 1 2 3 4 5 6 7
3178
3179 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.94248967 -Sum: 0.00000000 +Sum - -Sum: 0.942489
3180 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.94248967
3181 -Sum: 0.00000000 +Sum - -Sum: 0.94248967 last col W, previous N
3182
3183
3184 :3192: PORTFOLIO Selected Stocks ppDB
3185 WORKSHEET 4 D[23, 7] FLOAT
3186 A B C D E F G
3187 >-------------------------------------------------<
3188 39 4896071.43 ADVN 5: 17.68 17.81 17.72 17.93 17.89 17.97 18.48
3189 37 9336242.86 ATLU 15:168.51 168.36 165.61 164.80 167.01 165.07 165.27
3190 23 11597928.57 BMY 16: 13.60 13.50 13.38 12.84 12.52 12.64 12.82
3191 22 11516500.00 ASCMA 20: 41.95 40.87 42.51 42.62 46.53 45.20 46.50
3192 34 9889385.71 BF 23:106.22 107.26 105.93 105.02 104.63 105.51 104.77
3193 <------------------------------------------------->
3194 1 2 3 4 5 6 7
3195
3196 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.77990001 -Sum: 0.00000000 +Sum - -Sum: 0.779900
3197 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.77990001
3198 -Sum: 0.00000000 +Sum - -Sum: 0.77990001 last col W, previous N
3199
3200
3201 :3192: PORTFOLIO Selected Stocks ppDB
3202 WORKSHEET 4 D[23, 7] FLOAT
3203 A B C D E F G
3204 >-------------------------------------------------<
3205 39 6419571.43 ADVN 5: 17.68 17.81 17.72 17.93 17.89 17.97 18.48
3206 22 12473071.43 BLGS 11: 11.46 11.38 12.30 12.38 12.78 12.70 13.00
3207 37 10859742.86 ATLU 15:168.51 168.36 165.61 164.80 167.01 165.07 165.27
3208 23 13121428.57 BMY 16: 13.60 13.50 13.38 12.84 12.52 12.64 12.82
3209 22 13040000.00 ASCMA 20: 41.95 40.87 42.51 42.62 46.53 45.20 46.50
3210 34 11412885.71 BF 23:106.22 107.26 105.93 105.02 104.63 105.51 104.77
3211 <------------------------------------------------->
3212 1 2 3 4 5 6 7
3213
3215 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.68463440
3216 -Sum: -0.21343055 +Sum - -Sum: 0.89806495 last col W, previous N
3217
3218
3219 :3192: PORTFOLIO Selected Stocks ppDB
3220 WORKSHEET 4 D[20, 7] FLOAT
3221 A B C D E F G
3222 >-------------------------------------------------<
3223 39 8430271.43 ADVN 5: 17.68 17.81 17.72 17.93 17.89 17.97 18.48
3224 23 9565814.29 BLGS 11: 11.38 12.30 12.38 12.78 12.70 13.00 12.80
3225 24 10578314.29 BMY 16: 13.50 13.38 12.84 12.52 12.64 12.82 12.43
3226 23 9642971.43 ASCMA 20: 40.87 42.51 42.62 46.53 45.20 46.50 49.13
3227 <------------------------------------------------->
3228 1 2 3 4 5 6 7
3229
3230 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.95941610 -Sum: 0.00000000 +Sum - -Sum: 0.959416
3231 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.95941610
3232 -Sum: 0.00000000 +Sum - -Sum: 0.95941610 last col W, previous N
3233 :3300: -----------------------------------------------
3236 :3216: run: 3 counter: 2
3238 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 6948.79 = 3069.21
3239 :3501: Before if - Stock counter: 0 <---=> 2 <-: minDB
3240 :3502: Not invested fraction %deltaPrice: 3069.21/ 10018.00 = -0.3063695
3241
3242
3243 :3192: PORTFOLIO Selected Stocks ppDB
3244 WORKSHEET 4 D[21, 7] FLOAT
3245 A B C D E F G
3246 >-------------------------------------------------<
3247 11 7703428.57 ADVN 18: 17.74 17.70 17.57 17.38 17.63 18.07 18.09
3248 13 4794085.71 BLS 21: 75.03 76.58 76.86 76.66 76.39 75.98 75.74
3249 <------------------------------------------------->
3250 1 2 3 4 5 6 7
3251
3252 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.85459395 -Sum: 0.00000000 +Sum - -Sum: 0.854593
3253 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.85459395
3254 -Sum: 0.00000000 +Sum - -Sum: 0.85459395 last col W, previous N
3255 :3300: -----------------------------------------------
3258 :3216: run: 3 counter: 2
3260 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 8061.98 = 1956.02
3261 :3501: Before if - Stock counter: 0 <---=> 2 <-: minDB
3262 :3502: Not invested fraction %deltaPrice: 1956.02/ 10018.00 = -0.1952502
3263
3264
3265 :3192: PORTFOLIO Selected Stocks ppDB
3266 WORKSHEET 4 D[22, 7] FLOAT
3267 A B C D E F G
3268 >-------------------------------------------------<
3269 8 3172514.29 BBY 1: 22.70 22.58 22.65 22.71 22.47 22.59 22.22
3270 8 3043614.29 ABT 18: 8.34 8.68 8.47 8.61 8.58 8.51 8.44
3271 11 3172271.43 ADVN 22: 17.89 17.18 17.17 17.07 17.30 17.70 17.79
3272 <------------------------------------------------->
3273 1 2 3 4 5 6 7
3274
3275 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.95991536 -Sum: 0.00000000 +Sum - -Sum: 0.959915
3276 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.95991536
3277 -Sum: 0.00000000 +Sum - -Sum: 0.95991536 last col W, previous N
3278 :3300: -----------------------------------------------
3281 :3216: run: 3 counter: 2
3283 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 8243.14 = 1774.86
3284 :3501: Before if - Stock counter: 0 <---=> 2 <-: minDB
3285 :3502: Not invested fraction %deltaPrice: 1774.86/ 10018.00 = -0.1771667
3286
3287
3288 :3192: PORTFOLIO Selected Stocks ppDB
3289 WORKSHEET 4 D[25, 7] FLOAT
3290 A B C D E F G
3291 >-------------------------------------------------<
3292 8 5965057.14 BAC 2: 13.44 13.46 13.36 13.39 13.23 13.73 13.81
3293 11 6496114.29 AMRN 16: 14.50 14.40 14.60 13.80 14.40 13.50 14.80
3294 9 6500385.71 ANRA 25: 68.00 65.10 67.70 68.70 70.00 70.10 69.20
3295 <------------------------------------------------->
3296 1 2 3 4 5 6 7
3297
3298 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.58468116 -Sum: 0.00000000 +Sum - -Sum: 0.584681
3299 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.58468116
3300 -Sum: 0.00000000 +Sum - -Sum: 0.58468116 last col W, previous N
3301
3302
3303 :3192: PORTFOLIO Selected Stocks ppDB
3304 WORKSHEET 4 D[25, 7] FLOAT
3305 A B C D E F G
3306 >-------------------------------------------------<
3307 9 5917100.00 BAC 2: 13.46 13.36 13.39 13.23 13.73 13.81 14.04
3308 11 5362057.14 ANRA 25: 67.70 68.70 70.00 70.10 69.20 67.40 67.10
3309 <------------------------------------------------->
3310 1 2 3 4 5 6 7
3311
3312 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.78982359 -Sum: 0.00000000 +Sum - -Sum: 0.789823
3313 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.78982359
3314 -Sum: 0.00000000 +Sum - -Sum: 0.78982359 last col W, previous N
3315 :3300: -----------------------------------------------
3318 :3216: run: 3 counter: 2
3320 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 8474.14 = 1543.86
3321 :3501: Before if - Stock counter: 0 <---=> 2 <-: minDB
3322 :3502: Not invested fraction %deltaPrice: 1543.86/ 10018.00 = -0.1541086
3323
3324
3325 :3192: PORTFOLIO Selected Stocks ppDB
3326 WORKSHEET 4 D[19, 7] FLOAT
3327 A B C D E F G
3328 >-------------------------------------------------<
3329 11 37084042.86 BTC 15: 10.60 10.89 11.20 10.57 10.47 10.64 10.80
3330 12 37806700.00 AMUY 19:123.00 122.60 121.20 123.99 132.56 135.35 125.59
3331 <------------------------------------------------->
3332 1 2 3 4 5 6 7
3333
3334 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.80117049 -Sum: 0.00000000 +Sum - -Sum: 0.801170
3335 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.80117049
3336 -Sum: 0.00000000 +Sum - -Sum: 0.80117049 last col W, previous N
3337
3338
3339 :3192: PORTFOLIO Selected Stocks ppDB
3340 WORKSHEET 4 D[24, 7] FLOAT
3341 A B C D E F G
3342 >-------------------------------------------------<
3343 11 38193042.86 BTC 15: 10.60 10.89 11.20 10.57 10.47 10.64 10.80
3344 13 28475500.00 AMUY 19:122.60 121.20 123.99 132.56 135.35 125.59 130.71
3345 10 39552971.43 ADVN 24: 17.73 17.55 17.63 17.75 17.95 17.98 18.06
3346 <------------------------------------------------->
3347 1 2 3 4 5 6 7
3348
3349 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.79897240 -Sum: 0.00000000 +Sum - -Sum: 0.798972
3350 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.79897240
3351 -Sum: 0.00000000 +Sum - -Sum: 0.79897240 last col W, previous N
3352
3353
3354 :3192: PORTFOLIO Selected Stocks ppDB
3355 WORKSHEET 4 D[19, 7] FLOAT
3356 A B C D E F G
3357 >-------------------------------------------------<
3358 12 32636428.57 BTC 15: 10.89 11.20 10.57 10.47 10.64 10.80 10.75
3359 18 38393742.86 AKSH 18: 28.16 29.09 29.27 30.42 29.04 27.93 26.88
3360 14 23572385.71 AMUY 19:121.20 123.99 132.56 135.35 125.59 130.71 127.58
3361 <------------------------------------------------->
3362 1 2 3 4 5 6 7
3363
3364 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.81839613 -Sum: 0.00000000 +Sum - -Sum: 0.818396
3365 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.81839613
3366 -Sum: 0.00000000 +Sum - -Sum: 0.81839613 last col W, previous N
3367
3368
3369 :3192: PORTFOLIO Selected Stocks ppDB
3370 WORKSHEET 4 D[19, 7] FLOAT
3371 A B C D E F G
3372 >-------------------------------------------------<
3373 13 23076042.86 BTC 15: 11.20 10.57 10.47 10.64 10.80 10.75 10.90
3374 15 14417285.71 AMUY 19:123.99 132.56 135.35 125.59 130.71 127.58 128.38
3375 <------------------------------------------------->
3376 1 2 3 4 5 6 7
3377
3378 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.81932435 -Sum: 0.00000000 +Sum - -Sum: 0.819324
3379 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.81932435
3380 -Sum: 0.00000000 +Sum - -Sum: 0.81932435 last col W, previous N
3381
3382
3383 :3192: PORTFOLIO Selected Stocks ppDB
3384 WORKSHEET 4 D[26, 7] FLOAT
3385 A B C D E F G
3386 >-------------------------------------------------<
3387 19 9649085.71 ATHN 7:131.25 135.55 134.76 138.53 139.34 139.95 140.27
3388 22 8875728.57 AMCSA 14: 41.14 39.98 40.00 40.01 39.83 40.08 40.82
3389 18 6066142.86 ATLU 26:153.77 153.69 156.28 155.90 156.26 154.35 153.87
3390 <------------------------------------------------->
3391 1 2 3 4 5 6 7
3392
3393 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.56796689 -Sum: 0.00000000 +Sum - -Sum: 0.567966
3394 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.56796689
3395 -Sum: 0.00000000 +Sum - -Sum: 0.56796689 last col W, previous N
3396 :3300: -----------------------------------------------
3399 :3216: run: 3 counter: 2
3401 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 7725.74 = 2292.26
3402 :3501: Before if - Stock counter: 0 <---=> 2 <-: minDB
3403 :3502: Not invested fraction %deltaPrice: 2292.26/ 10018.00 = -0.2288143
3404
3405
3406 :3192: PORTFOLIO Selected Stocks ppDB
3407 WORKSHEET 4 D[26, 7] FLOAT
3408 A B C D E F G
3409 >-------------------------------------------------<
3410 7 8715300.00 BMY 13: 11.80 11.47 11.56 11.59 11.36 11.75 11.97
3411 10 6944671.43 BREV 14: 10.86 13.20 14.31 14.84 14.55 16.05 17.55
3412 8 7755942.86 BOX 15: 17.21 17.11 17.00 16.97 17.54 18.30 19.05
3413 9 7862728.57 CAB 17: 16.33 16.50 16.52 16.68 16.86 17.21 16.75
3414 8 8283757.14 AKSH 19: 26.85 26.22 27.00 26.96 27.18 25.90 26.08
3415 8 7547042.86 BLS 23: 69.81 70.05 72.90 74.23 73.34 73.35 74.81
3416 12 5894128.57 BTC 26: 11.80 11.73 11.77 12.42 12.35 12.41 12.48
3417 <------------------------------------------------->
3418 1 2 3 4 5 6 7
3419
3421 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.84001364
3422 -Sum: -0.10247922 +Sum - -Sum: 0.94249286 last col W, previous N
3423
3424
3425 :3192: PORTFOLIO Selected Stocks ppDB
3426 WORKSHEET 4 D[23, 7] FLOAT
3427 A B C D E F G
3428 >-------------------------------------------------<
3429 12 6653242.86 CAR 5: 34.29 34.59 33.98 33.89 34.08 33.92 33.32
3430 12 7279328.57 CAB 17: 16.68 16.86 17.21 16.75 16.51 16.43 16.13
3431 11 7392142.86 BLS 23: 74.23 73.34 73.35 74.81 76.89 76.66 77.59
3432 <------------------------------------------------->
3433 1 2 3 4 5 6 7
3434
3435 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.63547855 -Sum: 0.00000000 +Sum - -Sum: 0.635478
3436 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.63547855
3437 -Sum: 0.00000000 +Sum - -Sum: 0.63547855 last col W, previous N
3438
3439
3440 :3192: PORTFOLIO Selected Stocks ppDB
3441 WORKSHEET 4 D[23, 7] FLOAT
3442 A B C D E F G
3443 >-------------------------------------------------<
3444 12 7927742.86 CAR 5: 34.29 34.59 33.98 33.89 34.08 33.92 33.32
3445 13 6389828.57 CAB 17: 16.86 17.21 16.75 16.51 16.43 16.13 16.48
3446 11 8666642.86 BLS 23: 74.23 73.34 73.35 74.81 76.89 76.66 77.59
3447 <------------------------------------------------->
3448 1 2 3 4 5 6 7
3449
3450 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.63547855 -Sum: 0.00000000 +Sum - -Sum: 0.635478
3451 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.63547855
3452 -Sum: 0.00000000 +Sum - -Sum: 0.63547855 last col W, previous N
3453
3454
3455 :3192: PORTFOLIO Selected Stocks ppDB
3456 WORKSHEET 4 D[23, 7] FLOAT
3457 A B C D E F G
3458 >-------------------------------------------------<
3459 12 9172842.86 CAR 5: 34.29 34.59 33.98 33.89 34.08 33.92 33.32
3460 8 11353300.00 ARNA 9: 74.90 75.30 73.20 69.30 69.60 67.70 68.30
3461 13 7634928.57 CAB 17: 16.86 17.21 16.75 16.51 16.43 16.13 16.48
3462 10 12010500.00 AKSH 19: 27.00 26.96 27.18 25.90 26.08 25.73 25.88
3463 11 9911742.86 BLS 23: 74.23 73.34 73.35 74.81 76.89 76.66 77.59
3464 <------------------------------------------------->
3465 1 2 3 4 5 6 7
3466
3468 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.55680883
3469 -Sum: -0.05279715 +Sum - -Sum: 0.60960598 last col W, previous N
3470
3471
3472 :3192: PORTFOLIO Selected Stocks ppDB
3473 WORKSHEET 4 D[28, 7] FLOAT
3474 A B C D E F G
3475 >-------------------------------------------------<
3476 13 11028614.29 BOOM 4: 40.05 41.66 40.95 42.52 43.77 42.85 43.14
3477 12 10835942.86 CAR 5: 34.29 34.59 33.98 33.89 34.08 33.92 33.32
3478 8 13016400.00 ARNA 9: 74.90 75.30 73.20 69.30 69.60 67.70 68.30
3479 12 14177385.71 AAPL 11: 52.70 54.45 54.19 54.48 51.43 51.01 50.69
3480 13 9298028.57 CAB 17: 16.86 17.21 16.75 16.51 16.43 16.13 16.48
3481 10 13673600.00 AKSH 19: 27.00 26.96 27.18 25.90 26.08 25.73 25.88
3482 11 11574842.86 BLS 23: 74.23 73.34 73.35 74.81 76.89 76.66 77.59
3483 7 11911814.29 ALV 28: 91.57 91.01 88.33 89.35 89.63 86.47 86.27
3484 <------------------------------------------------->
3485 1 2 3 4 5 6 7
3486
3488 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.56568434
3489 -Sum: -0.06644369 +Sum - -Sum: 0.63212802 last col W, previous N
3490
3491
3492 :3192: PORTFOLIO Selected Stocks ppDB
3493 WORKSHEET 4 D[30, 7] FLOAT
3494 A B C D E F G
3495 >-------------------------------------------------<
3496 18 17084314.29 BTC 26: 12.48 12.25 12.20 12.35 12.45 12.57 12.56
3497 12 10391342.86 BF 30:101.97 104.88 104.20 103.70 103.77 102.19 99.67
3498 <------------------------------------------------->
3499 1 2 3 4 5 6 7
3500
3501 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.95404237 -Sum: 0.00000000 +Sum - -Sum: 0.954042
3502 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.95404237
3503 -Sum: 0.00000000 +Sum - -Sum: 0.95404237 last col W, previous N
3504
3505
3506 :3192: PORTFOLIO Selected Stocks ppDB
3507 WORKSHEET 4 D[30, 7] FLOAT
3508 A B C D E F G
3509 >-------------------------------------------------<
3510 18 18046714.29 BTC 26: 12.48 12.25 12.20 12.35 12.45 12.57 12.56
3511 9 18503300.00 ASCMA 27: 49.38 49.23 48.16 47.11 48.06 47.75 46.47
3512 12 11353742.86 BF 30:101.97 104.88 104.20 103.70 103.77 102.19 99.67
3513 <------------------------------------------------->
3514 1 2 3 4 5 6 7
3515
3516 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.96284023 -Sum: 0.00000000 +Sum - -Sum: 0.962840
3517 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.96284023
3518 -Sum: 0.00000000 +Sum - -Sum: 0.96284023 last col W, previous N
3519
3520
3521 :3192: PORTFOLIO Selected Stocks ppDB
3522 WORKSHEET 4 D[30, 7] FLOAT
3523 A B C D E F G
3524 >-------------------------------------------------<
3525 18 19301814.29 BTC 26: 12.48 12.25 12.20 12.35 12.45 12.57 12.56
3526 9 19758400.00 ASCMA 27: 49.38 49.23 48.16 47.11 48.06 47.75 46.47
3527 12 12608842.86 BF 30:101.97 104.88 104.20 103.70 103.77 102.19 99.67
3528 <------------------------------------------------->
3529 1 2 3 4 5 6 7
3530
3531 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.96284023 -Sum: 0.00000000 +Sum - -Sum: 0.962840
3532 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.96284023
3533 -Sum: 0.00000000 +Sum - -Sum: 0.96284023 last col W, previous N
3534
3535
3536 :3192: PORTFOLIO Selected Stocks ppDB
3537 WORKSHEET 4 D[30, 7] FLOAT
3538 A B C D E F G
3539 >-------------------------------------------------<
3540 14 19070671.43 ARAC 7: 9.85 9.99 9.42 9.33 9.29 8.74 9.24
3541 12 19726671.43 BAC 18: 14.97 15.06 15.07 15.02 15.04 14.91 14.94
3542 20 18612200.00 BTC 26: 12.20 12.35 12.45 12.57 12.56 12.50 12.68
3543 14 17823742.86 BF 30:104.20 103.70 103.77 102.19 99.67 97.11 97.00
3544 <------------------------------------------------->
3545 1 2 3 4 5 6 7
3546
3547 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.90633061 -Sum: 0.00000000 +Sum - -Sum: 0.906330
3548 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.90633061
3549 -Sum: 0.00000000 +Sum - -Sum: 0.90633061 last col W, previous N
3550
3551
3552 :3192: PORTFOLIO Selected Stocks ppDB
3553 WORKSHEET 4 D[25, 7] FLOAT
3554 A B C D E F G
3555 >-------------------------------------------------<
3556 13 14328000.00 BAC 18: 15.06 15.07 15.02 15.04 14.91 14.94 15.45
3557 13 16084742.86 AMRN 25: 12.30 12.50 11.60 11.20 11.70 11.50 11.00
3558 <------------------------------------------------->
3559 1 2 3 4 5 6 7
3560
3561 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.91826132 -Sum: 0.00000000 +Sum - -Sum: 0.918261
3562 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.91826132
3563 -Sum: 0.00000000 +Sum - -Sum: 0.91826132 last col W, previous N
3564
3565
3566 :3192: PORTFOLIO Selected Stocks ppDB
3567 WORKSHEET 4 D[25, 7] FLOAT
3568 A B C D E F G
3569 >-------------------------------------------------<
3570 13 15351400.00 BAC 18: 15.06 15.07 15.02 15.04 14.91 14.94 15.45
3571 13 17108142.86 AMRN 25: 12.30 12.50 11.60 11.20 11.70 11.50 11.00
3572 <------------------------------------------------->
3573 1 2 3 4 5 6 7
3574
3575 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.91826132 -Sum: 0.00000000 +Sum - -Sum: 0.918261
3576 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.91826132
3577 -Sum: 0.00000000 +Sum - -Sum: 0.91826132 last col W, previous N
3578
3579
3580 :3192: PORTFOLIO Selected Stocks ppDB
3581 WORKSHEET 4 D[25, 7] FLOAT
3582 A B C D E F G
3583 >-------------------------------------------------<
3584 20 19147657.14 BOOM 4: 43.55 44.73 45.48 43.41 43.26 42.86 33.47
3585 13 16180700.00 BAC 18: 15.06 15.07 15.02 15.04 14.91 14.94 15.45
3586 13 17937442.86 AMRN 25: 12.30 12.50 11.60 11.20 11.70 11.50 11.00
3587 <------------------------------------------------->
3588 1 2 3 4 5 6 7
3589
3590 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.91826132 -Sum: 0.00000000 +Sum - -Sum: 0.918261
3591 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.91826132
3592 -Sum: 0.00000000 +Sum - -Sum: 0.91826132 last col W, previous N
3593
3594
3595 :3192: PORTFOLIO Selected Stocks ppDB
3596 WORKSHEET 4 D[23, 7] FLOAT
3597 A B C D E F G
3598 >-------------------------------------------------<
3599 16 10105842.86 ARAC 7: 9.42 9.33 9.29 8.74 9.24 9.42 9.39
3600 13 18113200.00 BAC 18: 15.06 15.07 15.02 15.04 14.91 14.94 15.45
3601 12 21230000.00 ABMD 22: 7.72 7.75 7.64 7.48 7.32 7.29 7.28
3602 16 28059500.00 BLS 23: 76.66 77.59 78.40 78.20 78.14 78.37 77.86
3603 <------------------------------------------------->
3604 1 2 3 4 5 6 7
3605
3606 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.85261994 -Sum: 0.00000000 +Sum - -Sum: 0.852619
3607 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.85261994
3608 -Sum: 0.00000000 +Sum - -Sum: 0.85261994 last col W, previous N
3609
3610
3611 :3192: PORTFOLIO Selected Stocks ppDB
3612 WORKSHEET 4 D[29, 7] FLOAT
3613 A B C D E F G
3614 >-------------------------------------------------<
3615 17 8181128.57 ARAC 7: 9.33 9.29 8.74 9.24 9.42 9.39 9.38
3616 14 24229357.14 ARNA 9: 68.30 63.30 59.70 60.70 59.90 58.10 60.00
3617 13 19409200.00 BAC 18: 15.06 15.07 15.02 15.04 14.91 14.94 15.45
3618 12 22526000.00 ABMD 22: 7.72 7.75 7.64 7.48 7.32 7.29 7.28
3619 16 29355500.00 BLS 23: 76.66 77.59 78.40 78.20 78.14 78.37 77.86
3620 14 14693871.43 AMRN 25: 12.50 11.60 11.20 11.70 11.50 11.00 10.50
3621 13 24708628.57 ATLU 29:150.83 152.14 151.51 151.00 149.83 152.13 153.19
3622 <------------------------------------------------->
3623 1 2 3 4 5 6 7
3624
3625 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.93661445 -Sum: 0.00000000 +Sum - -Sum: 0.936614
3626 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.93661445
3627 -Sum: 0.00000000 +Sum - -Sum: 0.93661445 last col W, previous N
3628
3629
3630 :3192: PORTFOLIO Selected Stocks ppDB
3631 WORKSHEET 4 D[29, 7] FLOAT
3632 A B C D E F G
3633 >-------------------------------------------------<
3634 15 13668028.57 BHI 6: 36.54 36.07 35.95 35.89 35.59 35.03 35.42
3635 15 14311057.14 ABMD 22: 7.48 7.32 7.29 7.28 7.39 7.46 7.47
3636 20 14511571.43 BLS 23: 78.14 78.37 77.86 78.55 75.60 74.39 71.98
3637 17 14178657.14 ATLU 29:149.83 152.13 153.19 154.27 154.29 153.84 152.04
3638 <------------------------------------------------->
3639 1 2 3 4 5 6 7
3640
3641 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.99033836 -Sum: 0.00000000 +Sum - -Sum: 0.990338
3642 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.99033836
3643 -Sum: 0.00000000 +Sum - -Sum: 0.99033836 last col W, previous N
3644
3645
3646 :3192: PORTFOLIO Selected Stocks ppDB
3647 WORKSHEET 4 D[23, 7] FLOAT
3648 A B C D E F G
3649 >-------------------------------------------------<
3650 17 10018242.86 ABT 2: 9.18 9.27 9.40 9.42 9.62 9.75 9.81
3651 27 6604642.86 CAR 5: 34.73 35.09 35.57 34.88 34.93 34.81 34.12
3652 18 7905714.29 ANRA 12: 60.60 59.20 58.30 58.50 58.90 58.70 58.50
3653 26 2295442.86 CAB 17: 16.05 15.64 15.86 15.82 15.67 15.68 15.86
3654 23 11175771.43 BLS 23: 78.55 75.60 74.39 71.98 71.72 71.80 74.51
3655 <------------------------------------------------->
3656 1 2 3 4 5 6 7
3657
3658 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.98211936 -Sum: 0.00000000 +Sum - -Sum: 0.982119
3659 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.98211936
3660 -Sum: 0.00000000 +Sum - -Sum: 0.98211936 last col W, previous N
3661 :3300: -----------------------------------------------
3664 :3216: run: 3 counter: 3
3666 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 6288.73 = 3729.27
3667 :3501: Before if - Stock counter: 0 <---=> 2 <-: minDB
3668 :3502: Not invested fraction %deltaPrice: 3729.27/ 10018.00 = -0.3722565
3669
3670
3671 :3192: PORTFOLIO Selected Stocks ppDB
3672 WORKSHEET 4 D[21, 7] FLOAT
3673 A B C D E F G
3674 >-------------------------------------------------<
3675 11 15558514.29 ARNA 2: 69.20 70.10 70.00 68.70 67.70 65.10 68.00
3676 13 16020471.43 ALV 6: 95.86 95.39 94.87 95.73 95.62 95.56 95.80
3677 10 14619100.00 ATLU 7:155.91 157.08 156.99 153.94 152.97 151.59 152.05
3678 8 14889671.43 BTC 16: 13.39 13.43 13.56 13.70 13.60 13.49 13.30
3679 7 16409857.14 AMRN 17: 11.20 10.20 10.10 11.20 9.80 9.70 9.00
3680 11 10705171.43 ATHN 21:200.96 193.87 195.05 204.41 195.07 191.00 185.16
3681 <------------------------------------------------->
3682 1 2 3 4 5 6 7
3683
3684 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.70195297 -Sum: 0.00000000 +Sum - -Sum: 0.701952
3685 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.70195297
3686 -Sum: 0.00000000 +Sum - -Sum: 0.70195297 last col W, previous N
3687
3688
3689 :3192: PORTFOLIO Selected Stocks ppDB
3690 WORKSHEET 4 D[30, 7] FLOAT
3691 A B C D E F G
3692 >-------------------------------------------------<
3693 14 7356385.71 ARAC 8: 8.61 8.79 9.04 8.88 9.01 9.19 9.20
3694 21 8024214.29 ATHN 21:178.22 175.50 174.91 183.47 178.33 178.42 170.88
3695 8 7956885.71 ATSG 30: 7.02 7.00 7.19 7.08 7.22 7.65 7.86
3696 <------------------------------------------------->
3697 1 2 3 4 5 6 7
3698
3699 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.80873630 -Sum: 0.00000000 +Sum - -Sum: 0.808736
3700 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.80873630
3701 -Sum: 0.00000000 +Sum - -Sum: 0.80873630 last col W, previous N
3702
3703
3704 :3192: PORTFOLIO Selected Stocks ppDB
3705 WORKSHEET 4 D[23, 7] FLOAT
3706 A B C D E F G
3707 >-------------------------------------------------<
3708 30 6323471.43 BTC 16: 13.40 13.50 13.44 13.45 13.59 13.74 13.77
3709 40 4536400.00 ATHN 21:155.22 142.50 139.13 140.29 139.92 147.87 145.58
3710 27 6325200.00 BF 23: 92.90 92.31 92.05 91.98 90.44 89.53 88.26
3711 <------------------------------------------------->
3712 1 2 3 4 5 6 7
3713
3714 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.96415772 -Sum: 0.00000000 +Sum - -Sum: 0.964157
3715 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.96415772
3716 -Sum: 0.00000000 +Sum - -Sum: 0.96415772 last col W, previous N
3717
3718
8489 :3192: PORTFOLIO Selected Stocks ppDB
8490 WORKSHEET 4 D[27, 7] FLOAT
8491 A B C D E F G
8492 >-------------------------------------------------<
8493 9 12919642.86 ADVN 2: 20.69 21.27 21.05 21.43 21.32 21.82 21.66
8494 12 7897514.29 AMCSA 11: 25.00 25.15 25.50 25.51 26.00 27.10 25.93
8495 10 15814685.71 ALV 22: 78.37 77.22 77.51 75.86 75.75 72.95 71.34
8496 17 10577285.71 AAPL 23: 13.11 13.11 13.89 13.74 13.74 14.18 13.79
8497 11 13138000.00 ARAC 27: 12.08 12.93 13.26 12.89 12.60 12.45 11.94
8498 <------------------------------------------------->
8499 1 2 3 4 5 6 7
8500
8501 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.64745084 -Sum: 0.00000000 +Sum - -Sum: 0.647450
8502 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.64745084
8503 -Sum: 0.00000000 +Sum - -Sum: 0.64745084 last col W, previous N
8504
8505
8506 :3192: PORTFOLIO Selected Stocks ppDB
8507 WORKSHEET 4 D[28, 7] FLOAT
8508 A B C D E F G
8509 >-------------------------------------------------<
8510 10 20271928.57 ABMD 1: 9.20 8.86 9.28 9.38 9.50 9.32 9.99
8511 17 18718514.29 AKS 5: 15.28 15.37 15.72 16.04 16.38 17.12 16.72
8512 10 20305385.71 BMY 6: 13.06 13.06 13.09 13.42 13.61 13.35 13.40
8513 9 23326428.57 ATHN 7: 44.34 44.03 45.15 46.17 45.13 44.90 45.00
8514 11 18497014.29 BOOM 9: 20.92 20.23 20.31 20.34 20.45 21.02 21.18
8515 9 18033200.00 BGG 10: 9.61 10.01 9.51 9.61 9.64 9.86 9.77
8516 15 7221928.57 AMCSA 11: 25.51 26.00 27.10 25.93 25.62 26.32 26.34
8517 11 16825457.14 BLS 15: 35.47 37.73 37.05 36.45 34.59 33.54 33.37
8518 8 22636571.43 ANRA 16: 25.90 25.60 26.10 27.90 29.50 28.30 29.00
8519 14 13256971.43 AAL 28: 51.91 52.18 52.16 51.34 51.31 51.94 50.36
8520 <------------------------------------------------->
8521 1 2 3 4 5 6 7
8522
8524 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.73455852
8525 -Sum: -0.20339087 +Sum - -Sum: 0.93794939 last col W, previous N
8526 :3300: -----------------------------------------------
8529 :3216: run: 3 counter: 5
8531 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 6278.70 = 3739.30
8532 :3501: Before if - Stock counter: 0 <---=> 2 <-: minDB
8533 :3502: Not invested fraction %deltaPrice: 3739.30/ 10018.00 = -0.3732577
8534
8535
8536 :3192: PORTFOLIO Selected Stocks ppDB
8537 WORKSHEET 4 D[20, 7] FLOAT
8538 A B C D E F G
8539 >-------------------------------------------------<
8540 11 3776271.43 BGG 2: 8.69 8.24 8.00 7.55 7.37 7.68 7.77
8541 9 3627628.57 AAPL 9: 14.54 14.97 15.28 14.84 15.01 15.43 15.51
8542 14 3393657.14 ABT 17: 17.37 18.21 17.55 17.63 18.03 17.38 16.05
8543 8 2548414.29 BAC 20: 14.45 14.21 13.62 13.78 13.50 13.19 12.92
8544 <------------------------------------------------->
8545 1 2 3 4 5 6 7
8546
8547 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.92982813 -Sum: 0.00000000 +Sum - -Sum: 0.929828
8548 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.92982813
8549 -Sum: 0.00000000 +Sum - -Sum: 0.92982813 last col W, previous N
8550 :3300: -----------------------------------------------
8553 :3216: run: 3 counter: 3
8555 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 6267.52 = 3750.48
8556 :3501: Before if - Stock counter: 0 <---=> 2 <-: minDB
8557 :3502: Not invested fraction %deltaPrice: 3750.48/ 10018.00 = -0.3743746
8558
8559
8560 :3192: PORTFOLIO Selected Stocks ppDB
8561 WORKSHEET 4 D[23, 7] FLOAT
8562 A B C D E F G
8563 >-------------------------------------------------<
8564 11 4825771.43 CAB 3: 14.99 15.04 15.07 14.94 14.92 15.05 14.84
8565 11 4840014.29 BOOM 6: 21.10 20.93 20.70 20.62 20.44 20.69 20.55
8566 14 5494257.14 BF 13:120.75 120.00 127.17 129.50 130.99 131.29 129.69
8567 10 3136600.00 AKS 17: 14.62 14.60 14.56 14.22 15.03 14.83 15.19
8568 10 6401242.86 AAPL 23: 15.92 15.55 15.71 15.68 16.18 15.99 16.09
8569 <------------------------------------------------->
8570 1 2 3 4 5 6 7
8571
8572 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.81795486 -Sum: 0.00000000 +Sum - -Sum: 0.817954
8573 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.81795486
8574 -Sum: 0.00000000 +Sum - -Sum: 0.81795486 last col W, previous N
8575
8576
8577 :3192: PORTFOLIO Selected Stocks ppDB
8578 WORKSHEET 4 D[27, 7] FLOAT
8579 A B C D E F G
8580 >-------------------------------------------------<
8581 18 6388700.00 CAB 3: 14.95 14.94 15.14 15.24 15.36 15.14 15.49
8582 17 5571928.57 BOX 11: 21.95 21.89 21.84 22.29 22.12 22.75 23.09
8583 14 7252485.71 AMUY 14: 18.80 18.70 19.16 19.00 18.60 19.10 19.20
8584 19 7135600.00 BBY 16: 31.42 32.30 32.45 33.69 34.06 34.07 33.74
8585 27 6285471.43 BMY 18: 12.37 12.58 12.62 11.96 12.40 11.90 12.07
8586 16 8397757.14 ABT 20: 16.81 16.87 16.57 16.42 16.27 16.18 16.46
8587 14 3251400.00 CAR 25: 8.55 8.84 8.94 9.39 9.23 9.60 10.47
8588 17 6481457.14 ARAC 27: 13.44 13.43 13.46 13.65 13.97 13.80 13.92
8589 <------------------------------------------------->
8590 1 2 3 4 5 6 7
8591
8593 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.69762326
8594 -Sum: -0.28518433 +Sum - -Sum: 0.98280760 last col W, previous N
8595
8596
8597 :3192: PORTFOLIO Selected Stocks ppDB
8598 WORKSHEET 4 D[27, 7] FLOAT
8599 A B C D E F G
8600 >-------------------------------------------------<
8601 18 9139700.00 CAB 3: 14.95 14.94 15.14 15.24 15.36 15.14 15.49
8602 17 8322928.57 BOX 11: 21.95 21.89 21.84 22.29 22.12 22.75 23.09
8603 14 10003485.71 AMUY 14: 18.80 18.70 19.16 19.00 18.60 19.10 19.20
8604 19 9886600.00 BBY 16: 31.42 32.30 32.45 33.69 34.06 34.07 33.74
8605 27 9036471.43 BMY 18: 12.37 12.58 12.62 11.96 12.40 11.90 12.07
8606 16 11148757.14 ABT 20: 16.81 16.87 16.57 16.42 16.27 16.18 16.46
8607 14 6002400.00 CAR 25: 8.55 8.84 8.94 9.39 9.23 9.60 10.47
8608 18 7375742.86 ARAC 27: 13.43 13.46 13.65 13.97 13.80 13.92 14.08
8609 <------------------------------------------------->
8610 1 2 3 4 5 6 7
8611
8613 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.84698507
8614 -Sum: -0.11697914 +Sum - -Sum: 0.96396421 last col W, previous N
8615 :3300: -----------------------------------------------
8618 :3216: run: 3 counter: 5
8620 :3464: w updated Portfolio, availability $myInvestment: 10018.00 minDB: 2 ppCorr
8621 WORKSHEET 8 H[27, 29] FLOAT
8622 Z AA AB AC AD
8623 >------------------------------------<
8624 1 0.00 CAB 3: 2146.91 138.56 15.49 0.21
8625 1 0.00 BOX 11: 1215.69 52.65 23.09 0.12
8626 1 0.00 AMUY 14: 3063.62 159.56 19.20 0.31
8627 1 0.00 BMY 18:-2522.11 208.99 12.07 -0.25
8628 1 0.00 ARAC 27: 1069.56 75.96 14.08 0.11
8629 <------------------------------------>
8630 26 27 28 29
8631 $ n price Wi
8632 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 10017.90 = 0.10
8633 :3501: Before if - Stock counter: 5 <---=> 2 <-: minDB
8634 :3502: Not invested fraction %deltaPrice: 0.10/ 10018.00 = -0.0000100
8635 EXECUTE PORTFOLIO myInvestment: 10018.0000000 TickToClearPortfolio: 1000 #TicksPerStock: 33 RUN:
8636 R: 0.3401300 r: 0.4501300 beta: 0.0200000 %r: 2.7000000 timesLaspse: 2.0000000
8637 0.1505500 0.8494500 fabs(negSum): 0.1169791 posSum 0.8469851 Stock Counter: 5
8638 :2893: VALID PORTFOLIO initialInvestment 10017.8998200 Not invested fraction: 0.0010000% is less than 10
8639 :2904: AT THE BEGINING Remaining Stocks to beat: 5 geNSTOCKS: 0 expectedReturn: 0.2700000
8640
8641
8642
8643 :2924: Tick:-> 1 row: 11 BOX(1) -*-*-> 23.5200000
8645 :3798: AbsRet: 0.00 + 22.64 = 22.64 = 0.00 + 52.65 * (23.52 - 23.09) :3800: deltaPrice: 0.43 / 23.52 = 0
8647 :3162: Initial pivot val: 23.52 :3160: current: 23.52 < >> 23.09
8648
8649 :2924: Tick:-> 2 row: 14 AMUY(1) -*-*-> 19.18
8653 :3162: Initial pivot val: 19.20
8655 :3128: Abrupt Opposite Jump abs retStock: 0.0010 >>> 0.0000 <- 0.0000*0.1000 final bad_tick_counter : 2
8656
8657 :2924: Tick:-> 3 row: 11 BOX(2) -*-*-> 24
8659 :3798: AbsRet: -3.19 + 38.43 = 35.24 = -3.19 + 52.65 * (23.82 - 23.09) :3800: deltaPrice: 0.73 / 23.82 =
8661 :3857: pivot val now is: 23.82 :3866: #No change -remains in ZERO- in badTickerCounter: 0.00
8662
8663 :2924: Tick:-> 4 row: 18 BMY(1) -*-*-> 12.51
8667 :2991: Initial #SPivot is: -12.07
8670
8671 :2924: Tick:-> 5 row: 27 ARAC(1) -*-*-> 13.6900
8675 :3162: Initial pivot val: 14.08
8677 :3128: Abrupt Opposite Jump abs retStock: 0.0285 >>> 0.0000 <- 0.0000*0.1000 final bad_tick_counter : 2
8678
8679 :2924: Tick:-> 6 row: 14 AMUY(2) -*-*-> 19
8683 :3863: #Good Direction, this data greather than previous, discount Bad hit counter: 1.00
8684
8685 :2924: Tick:-> 7 row: 27 ARAC(2) -*-*-> 13.31
8689 :3184: opposite direction, ticker counter was: 2 :3186: becomes: 3
8692 :3196: bad_tick_counter was: 3 :3199: becomes: 4
8693 :3884: Clear this stock -badTick reached the limit: 3 -1
8694
8695 :2924: Tick:-> 9 row: 3 CAB(1) -*-*-> 16
8699 :3162: Initial pivot val: 15.60 :3160: current: 15.60 < >> 15.49
8700
8701 :2924: Tick:-> 10 row: 11 BOX(3) -*-*-> 23.01
8705 :3184: opposite direction, ticker counter was: 0 :3186: becomes: 1
8708 :3196: bad_tick_counter was: 1 :3199: becomes: 2
8709
8710 :2924: Tick:-> 11 row: 14 AMUY(3) -*-*-> 19
8714 :3857: pivot val now is: 19.26
8715 :3863: #Good Direction, this data greather than previous, discount Bad hit counter: 0.00
8716
8717 :2924: Tick:-> 12 row: 14 AMUY(4) -*-*-> 18.90
8721 :3184: opposite direction, ticker counter was: 0 :3186: becomes: 1
8724 :3196: bad_tick_counter was: 1 :3199: becomes: 2
8725
8726 :2924: Tick:-> 13 row: 14 AMUY(5) -*-*-> 19
8730 :3184: opposite direction, ticker counter was: 2 :3186: becomes: 3
8733 :3196: bad_tick_counter was: 3 :3199: becomes: 4
8734 :3884: Clear this stock -badTick reached the limit: 3 -1
8735
8736 :2924: Tick:-> 14 row: 18 BMY(2) -*-*-> 12
8740 :3006: no change in pivot: -12.07
8741 :3004: #Good Direction, this data less than previous, discount Bad hit counter: 1.00
8742
8743 :2924: Tick:-> 15 row: 3 CAB(2) -*-*-> 15.64
8747 :3857: pivot val now is: 15.64 :3866: #No change -remains in ZERO- in badTickerCounter: 0.00
8748
8749 :2924: Tick:-> 17 row: 3 CAB(3) -*-*-> 15.60
8753 :3184: opposite direction, ticker counter was: 0 :3186: becomes: 1
8756 :3196: bad_tick_counter was: 1 :3199: becomes: 2
8757
8758 :2924: Tick:-> 18 row: 11 BOX(4) -*-*-> 23
8762 :3184: opposite direction, ticker counter was: 2 :3186: becomes: 3
8765 :3196: bad_tick_counter was: 3 :3199: becomes: 4
8766 :3884: Clear this stock -badTick reached the limit: 3 -1
8767
8768 :2924: Tick:-> 19 row: 18 BMY(3) -*-*-> 13
8772 :2983: opposite direction to short, ticker counter was: 1 :2985: becomes: 2 no change in pivot: -12.
8774 :2991***: Abrupt Jump respect Pivot - real Strock ret: 0.00
8776 :2992: Bad Tick counter was: 2.00 becomes: 3.00
8777 :3031: #Short! -stock leaves- Portfolio expectedReturn 0.0027 meanRealReturnStock: 0.0000
8778
8779 :2924: Tick:-> 22 row: 3 CAB(4) -*-*-> 15.6008
8780
8781 :2924: Tick:-> 23 row: 3 CAB(4) -*-*-> 15.6202
8785 :3863: #Good Direction, this data greather than previous, discount Bad hit counter: 1.00
8786
8787 :2924: Tick:-> 27 row: 3 CAB(5) -*-*-> 15.31
8791 :3184: opposite direction, ticker counter was: 1 :3186: becomes: 2
8794 :3196: bad_tick_counter was: 2 :3199: becomes: 3
8795 :3884: Clear this stock -badTick reached the limit: 3 -1
8796 :3390: AT THE END Remaining Stocks to beat: 0 geNSTOCKS: 1002 expectedReturn: 0
8797
8798 :3392: RUN 3 COL 7 Portfolio remaining after closing position pre-Final Portfolio Report ppDataIn
8799 WORKSHEET 9 I[27, 9] FLOAT
8800 A B C D E F G H I
8801 >---------------------------------------------------------------<
8802 6 3.00 CAB 3: 15.49 15.31 -0.18 -1.19 -25.53 -1.19 2146.91 138.56 -1.00
8803 5 4.00 BOX 11: 23.09 22.79 -0.30 -1.30 -15.80 -0.27 5884.72 52.65 -1.00
8804 6 4.00 AMUY 14: 19.20 18.60 -0.60 -3.12 -95.74 -1.07 8948.34 159.56 -1.00
8805 4 3.00 BMY 18: -12.07 12.92 -0.85 -7.05 -177.80 -3.81 4669.03 208.99 -1.00
8806 3 4.00 ARAC 27: 14.08 13.31 -0.77 -5.47 -58.49 -0.58 10017.90 75.96 -1.00
8807 <--------------------------------------------------------------->
8808 1 2 3 4 5 6 7 8 9
8809 nTick badTicks Vo Vf d %r R=(Vf-Vo)*n %R Portf nhit/miss
8810 :3394: geNSTOCKS:-> 1002 <--->1000 <-:geNSTOCKSlimit
8812 :3503: NOTHING TO CLEAR --- all stocks processed
8814 :3560: Transaction costs tc * nStocks 5*0.00 = 0.00
8815 :3551: Transaction costs tshort * nStocks 2*0.00 = 0.00
8816 :3562: Net Return -373.35 - 0.00 - 0.00 = -373.35
8817 :3464: Net Return -373.35
8818 :4012: NOT GOOD PORTFOLIO, KEEP PREVIOUS INVESTMENT 9644.00
8819 :4107: next investment ok dbDataSumOnRowCol 9924.00
8820 counter: 5 Total Ticks: 1002 Mean Tick: 200
8821
8822 :4256: Starts a New Round, run: 2 reset geNSTOCKS: 99999
8823 :3822: minDB: 1502.70 stTo = 0.45 * myInvestment / minDB : 4508.10 / 3 V
8824 :3834: ??????CLOSES if (!(posSum > 7. || fabs(negSum) > 7.) && counter > 1) {
8825
8826
8827 :3192: PORTFOLIO Selected Stocks ppDB
8828 WORKSHEET 4 D[27, 7] FLOAT
8829 A B C D E F G
8830 >-------------------------------------------------<
8831 13 15528528.57 ARNA 7: 80.00 79.60 80.50 80.00 79.80 79.60 79.90
8832 17 11497557.14 BOX 8: 20.59 20.63 21.19 21.40 20.89 20.92 20.70
8833 17 10225314.29 CAB 9: 15.66 15.67 15.76 16.07 16.05 16.11 15.81
8834 15 11719242.86 BBY 13: 34.89 34.54 35.10 34.78 35.11 35.31 35.46
8835 9 18274157.14 BF 17:128.57 127.54 127.88 127.82 129.05 128.88 130.24
8836 12 14030757.14 AMCSA 19: 27.40 27.38 26.81 26.63 26.98 26.83 26.23
8837 15 5670700.00 BLS 27: 30.88 31.83 33.09 32.26 34.80 35.08 35.02
8838 <------------------------------------------------->
8839 1 2 3 4 5 6 7
8840
8842 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.88777013
8843 -Sum: -0.08381962 +Sum - -Sum: 0.97158975 last col W, previous N
8844 :3300: -----------------------------------------------
8847 :3216: run: 2 counter: 4
8849 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 6997.35 = 3020.65
8850 :3501: Before if - Stock counter: 1 <---=> 3 <-: minDB
8851 :3502: Not invested fraction %deltaPrice: 3020.65/ 10018.00 = -0.3015220
8852
8853
8854 :3192: PORTFOLIO Selected Stocks ppDB
8855 WORKSHEET 4 D[27, 7] FLOAT
8856 A B C D E F G
8857 >-------------------------------------------------<
8858 16 50017000.00 BTC 3:1188.83 1189.27 1222.66 1255.47 1283.30 1264.32 1271.22
8859 18 60941885.71 AAPL 5: 18.55 18.67 18.56 18.41 18.10 18.06 17.67
8860 16 37431557.14 ALV 13: 77.46 79.25 79.72 79.19 80.13 79.85 79.03
8861 17 32758400.00 BMY 15: 13.06 12.60 12.75 12.73 12.89 13.42 13.74
8862 14 52401657.14 ADVN 17: 22.00 22.21 21.98 21.49 21.33 21.15 20.55
8863 20 46816714.29 AMCSA 20: 25.60 26.00 26.20 26.37 26.27 26.85 27.17
8864 13 56426157.14 BF 25:128.09 129.23 128.69 127.31 127.96 130.08 129.94
8865 21 49955742.86 CAR 26: 11.99 12.63 13.08 13.38 13.61 13.76 13.68
8866 13 19564928.57 ABT 27: 16.31 15.96 16.20 16.01 15.93 16.15 15.92
8867 <------------------------------------------------->
8868 1 2 3 4 5 6 7
8869
8871 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.81471721
8872 -Sum: -0.15796505 +Sum - -Sum: 0.97268226 last col W, previous N
8873 :3300: -----------------------------------------------
8876 :3216: run: 2 counter: 6
8878 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 5168.32 = 4849.68
8879 :3501: Before if - Stock counter: 0 <---=> 3 <-: minDB
8880 :3502: Not invested fraction %deltaPrice: 4849.68/ 10018.00 = -0.4840963
8881
8882
8883 :3192: PORTFOLIO Selected Stocks ppDB
8884 WORKSHEET 4 D[25, 7] FLOAT
8885 A B C D E F G
8886 >-------------------------------------------------<
8887 20 35307157.14 CAB 11: 16.41 16.71 16.37 16.30 16.80 17.30 17.29
8888 19 34952371.43 C 14:449.00 450.20 446.60 447.00 447.90 448.50 449.00
8889 12 28398371.43 BREV 18: 7.35 13.20 13.00 12.32 11.65 13.70 14.24
8890 14 35227628.57 AMCSA 20: 28.83 28.96 28.92 29.12 29.25 29.65 29.05
8891 10 33238457.14 AAL 25: 51.08 52.03 51.19 48.92 47.70 46.64 46.07
8892 <------------------------------------------------->
8893 1 2 3 4 5 6 7
8894
8896 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.54169598
8897 -Sum: -0.05263331 +Sum - -Sum: 0.59432930 last col W, previous N
8898
8899
8900 :3192: PORTFOLIO Selected Stocks ppDB
8901 WORKSHEET 4 D[29, 7] FLOAT
8902 A B C D E F G
8903 >-------------------------------------------------<
8904 26 15784085.71 AAPL 2: 18.37 18.36 18.95 19.03 19.58 19.73 19.55
8905 20 11736614.29 BMY 4: 12.10 12.58 12.69 12.46 12.54 12.64 12.84
8906 32 11653828.57 ALV 9: 70.68 70.05 72.30 70.31 71.04 71.71 72.15
8907 14 14754485.71 AMUY 13: 36.80 40.00 37.60 24.20 24.76 29.60 30.00
8908 24 14396057.14 CAR 22: 11.66 11.62 11.16 10.94 10.96 10.37 9.96
8909 18 14810042.86 AAL 25: 46.40 46.30 46.35 46.00 46.32 46.79 46.74
8910 30 14612800.00 ADVN 29: 21.53 21.66 21.60 21.77 21.54 21.72 21.56
8911 <------------------------------------------------->
8912 1 2 3 4 5 6 7
8913
8915 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.82414285
8916 -Sum: -0.12773331 +Sum - -Sum: 0.95187615 last col W, previous N
8917
8918
8919 :3192: PORTFOLIO Selected Stocks ppDB
8920 WORKSHEET 4 D[16, 7] FLOAT
8921 A B C D E F G
8922 >-------------------------------------------------<
8923 33 50734528.57 AKS 10: 14.43 14.62 14.06 14.17 14.10 14.33 14.85
8924 30 37769214.29 C 14:452.90 452.50 451.60 452.30 453.00 454.00 455.70
8925 22 48427557.14 ARNA 16: 80.50 81.40 80.90 81.20 84.70 77.00 75.50
8926 <------------------------------------------------->
8927 1 2 3 4 5 6 7
8928
8930 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.70095888
8931 -Sum: -0.10050467 +Sum - -Sum: 0.80146355 last col W, previous N
8932
8933
8934 :3192: PORTFOLIO Selected Stocks ppDB
8935 WORKSHEET 4 D[16, 7] FLOAT
8936 A B C D E F G
8937 >-------------------------------------------------<
8938 31 45206557.14 AAPL 2: 19.73 19.55 20.22 20.36 20.64 20.66 20.64
8939 24 56506714.29 BAC 8: 12.75 12.64 12.68 12.74 12.77 13.01 12.91
8940 18 53888928.57 AMUY 13: 24.76 29.60 30.00 32.20 33.20 31.60 34.60
8941 31 34835342.86 C 14:452.50 451.60 452.30 453.00 454.00 455.70 456.40
8942 24 30077314.29 ARNA 16: 80.90 81.20 84.70 77.00 75.50 74.10 71.60
8943 <------------------------------------------------->
8944 1 2 3 4 5 6 7
8945
8947 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.90723232
8948 -Sum: -0.05626544 +Sum - -Sum: 0.96349775 last col W, previous N
8949
8950
8951 :3192: PORTFOLIO Selected Stocks ppDB
8952 WORKSHEET 4 D[30, 7] FLOAT
8953 A B C D E F G
8954 >-------------------------------------------------<
8955 36 27336514.29 AKS 10: 14.17 14.10 14.33 14.85 14.39 14.96 14.77
8956 32 31871485.71 C 14:451.60 452.30 453.00 454.00 455.70 456.40 457.10
8957 25 25640957.14 ARNA 16: 81.20 84.70 77.00 75.50 74.10 71.60 70.00
8958 31 31384514.29 BLS 30: 40.73 43.34 44.32 54.32 53.41 49.29 49.33
8959 <------------------------------------------------->
8960 1 2 3 4 5 6 7
8961
8963 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.62568517
8964 -Sum: -0.07821396 +Sum - -Sum: 0.70389913 last col W, previous N
8965
8966
8967 :3192: PORTFOLIO Selected Stocks ppDB
8968 WORKSHEET 4 D[30, 7] FLOAT
8969 A B C D E F G
8970 >-------------------------------------------------<
8971 36 28866714.29 AKS 10: 14.17 14.10 14.33 14.85 14.39 14.96 14.77
8972 32 33401685.71 C 14:451.60 452.30 453.00 454.00 455.70 456.40 457.10
8973 26 19573657.14 ARNA 16: 84.70 77.00 75.50 74.10 71.60 70.00 71.10
8974 31 32914714.29 BLS 30: 40.73 43.34 44.32 54.32 53.41 49.29 49.33
8975 <------------------------------------------------->
8976 1 2 3 4 5 6 7
8977
8979 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.62319600
8980 -Sum: -0.07831718 +Sum - -Sum: 0.70151318 last col W, previous N
8981
8982
8983 :3192: PORTFOLIO Selected Stocks ppDB
8984 WORKSHEET 4 D[30, 7] FLOAT
8985 A B C D E F G
8986 >-------------------------------------------------<
8987 36 31946514.29 AKS 10: 14.17 14.10 14.33 14.85 14.39 14.96 14.77
8988 28 36640928.57 BTC 12:1045.14 1044.42 1041.90 1037.91 1079.11 1086.12 1097.40
8989 32 36481485.71 C 14:451.60 452.30 453.00 454.00 455.70 456.40 457.10
8990 26 22653457.14 ARNA 16: 84.70 77.00 75.50 74.10 71.60 70.00 71.10
8991 17 24995757.14 ABT 26: 18.09 18.29 18.49 18.53 18.05 18.03 18.16
8992 31 35994514.29 BLS 30: 40.73 43.34 44.32 54.32 53.41 49.29 49.33
8993 <------------------------------------------------->
8994 1 2 3 4 5 6 7
8995
8997 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.63016634
8998 -Sum: -0.02915989 +Sum - -Sum: 0.65932623 last col W, previous N
8999
9000
9001 :3192: PORTFOLIO Selected Stocks ppDB
9002 WORKSHEET 4 D[30, 7] FLOAT
9003 A B C D E F G
9004 >-------------------------------------------------<
9005 36 34119414.29 AKS 10: 14.17 14.10 14.33 14.85 14.39 14.96 14.77
9006 28 38813828.57 BTC 12:1045.14 1044.42 1041.90 1037.91 1079.11 1086.12 1097.40
9007 32 38654385.71 C 14:451.60 452.30 453.00 454.00 455.70 456.40 457.10
9008 26 24826357.14 ARNA 16: 84.70 77.00 75.50 74.10 71.60 70.00 71.10
9009 17 27168657.14 ABT 26: 18.09 18.29 18.49 18.53 18.05 18.03 18.16
9010 31 38167414.29 BLS 30: 40.73 43.34 44.32 54.32 53.41 49.29 49.33
9011 <------------------------------------------------->
9012 1 2 3 4 5 6 7
9013
9015 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.63016634
9016 -Sum: -0.02915989 +Sum - -Sum: 0.65932623 last col W, previous N
9017
9018
9019 :3192: PORTFOLIO Selected Stocks ppDB
9020 WORKSHEET 4 D[30, 7] FLOAT
9021 A B C D E F G
9022 >-------------------------------------------------<
9023 33 33296600.00 AAPL 2: 20.22 20.36 20.64 20.66 20.64 20.65 21.00
9024 37 25958771.43 AKS 10: 14.10 14.33 14.85 14.39 14.96 14.77 13.98
9025 27 24214628.57 ARNA 16: 77.00 75.50 74.10 71.60 70.00 71.10 68.10
9026 28 19960142.86 BREV 18: 17.00 15.98 13.05 13.00 13.99 14.89 17.02
9027 29 13339800.00 AMCSA 20: 27.17 27.33 27.15 27.02 26.53 26.40 25.57
9028 17 32658657.14 ABT 26: 18.09 18.29 18.49 18.53 18.05 18.03 18.16
9029 32 28549871.43 BLS 30: 43.34 44.32 54.32 53.41 49.29 49.33 53.89
9030 <------------------------------------------------->
9031 1 2 3 4 5 6 7
9032
9034 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.80414947
9035 -Sum: -0.00798700 +Sum - -Sum: 0.81213647 last col W, previous N
9036
9037
9038 :3192: PORTFOLIO Selected Stocks ppDB
9039 WORKSHEET 4 D[30, 7] FLOAT
9040 A B C D E F G
9041 >-------------------------------------------------<
9042 33 35440300.00 AAPL 2: 20.22 20.36 20.64 20.66 20.64 20.65 21.00
9043 37 28102471.43 AKS 10: 14.10 14.33 14.85 14.39 14.96 14.77 13.98
9044 29 30569142.86 BTC 12:1044.42 1041.90 1037.91 1079.11 1086.12 1097.40 1147.56
9045 21 26261514.29 AMUY 13: 32.20 33.20 31.60 34.60 33.20 33.40 34.16
9046 27 26358328.57 ARNA 16: 77.00 75.50 74.10 71.60 70.00 71.10 68.10
9047 28 22103842.86 BREV 18: 17.00 15.98 13.05 13.00 13.99 14.89 17.02
9048 29 15483500.00 AMCSA 20: 27.17 27.33 27.15 27.02 26.53 26.40 25.57
9049 17 34802357.14 ABT 26: 18.09 18.29 18.49 18.53 18.05 18.03 18.16
9050 32 30693571.43 BLS 30: 43.34 44.32 54.32 53.41 49.29 49.33 53.89
9051 <------------------------------------------------->
9052 1 2 3 4 5 6 7
9053
9055 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.70068582
9056 -Sum: -0.05820168 +Sum - -Sum: 0.75888750 last col W, previous N
9057
9058
9059 :3192: PORTFOLIO Selected Stocks ppDB
9060 WORKSHEET 4 D[30, 7] FLOAT
9061 A B C D E F G
9062 >-------------------------------------------------<
9063 36 17604128.57 ABMD 17: 8.48 8.51 8.45 8.25 8.15 8.27 8.18
9064 40 10438942.86 AMD 21: 8.83 8.88 8.69 8.68 8.79 8.60 8.36
9065 32 18833328.57 BOOM 24: 18.37 18.38 18.65 18.62 18.01 18.02 18.19
9066 33 16880728.57 AAL 25: 46.94 48.00 47.58 45.69 45.73 47.68 47.66
9067 26 9027985.71 ABT 26: 17.54 17.62 17.48 17.28 17.71 17.35 16.37
9068 43 15922300.00 BLS 30: 62.63 63.62 60.09 70.09 71.71 70.26 70.25
9069 <------------------------------------------------->
9070 1 2 3 4 5 6 7
9071
9072 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.77191413 -Sum: 0.00000000 +Sum - -Sum: 0.771914
9073 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.77191413
9074 -Sum: 0.00000000 +Sum - -Sum: 0.77191413 last col W, previous N
9075
9076
9077 :3192: PORTFOLIO Selected Stocks ppDB
9078 WORKSHEET 4 D[22, 7] FLOAT
9079 A B C D E F G
9080 >-------------------------------------------------<
9081 38 14236671.43 BBY 1: 28.85 28.94 29.48 29.36 29.25 29.41 29.59
9082 36 12615400.00 BMY 4: 14.16 14.29 13.87 14.15 13.19 12.91 12.78
9083 61 14795728.57 ALV 9: 69.11 68.36 66.77 66.31 66.27 66.16 65.14
9084 57 11900985.71 AKS 10: 15.82 15.07 14.99 15.33 14.82 15.17 14.87
9085 43 13364228.57 BTC 12:1220.74 1212.53 1176.20 1177.33 1176.99 1176.80 1194.01
9086 38 10570342.86 AMUY 13: 31.20 32.80 33.20 34.60 34.00 35.20 36.00
9087 37 15038442.86 ARNA 16: 71.40 71.80 71.00 69.80 68.70 69.30 70.10
9088 43 14385157.14 AMCSA 20: 25.78 24.68 25.41 25.10 25.39 26.45 26.43
9089 42 9477400.00 CAR 22: 10.03 10.46 10.85 10.93 10.78 10.34 10.12
9090 <------------------------------------------------->
9091 1 2 3 4 5 6 7
9092
9094 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.83780478
9095 -Sum: -0.09625580 +Sum - -Sum: 0.93406058 last col W, previous N
9096 :3300: -----------------------------------------------
9099 :3216: run: 2 counter: 7
9101 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 6068.76 = 3949.24
9102 :3501: Before if - Stock counter: 0 <---=> 3 <-: minDB
9103 :3502: Not invested fraction %deltaPrice: 3949.24/ 10018.00 = -0.3942144
9104
9105
9106 :3192: PORTFOLIO Selected Stocks ppDB
9107 WORKSHEET 4 D[28, 7] FLOAT
9108 A B C D E F G
9109 >-------------------------------------------------<
9110 12 27810028.57 BAC 9: 11.80 11.60 11.69 11.78 11.64 11.70 11.95
9111 14 35273257.14 ARNA 10: 74.10 75.00 75.10 73.30 71.10 71.80 70.90
9112 11 38223600.00 BOOM 23: 18.89 18.65 18.55 18.58 19.49 19.30 19.47
9113 11 36233357.14 C 26:456.20 456.10 454.80 454.40 455.00 455.50 456.60
9114 17 11834800.00 CAB 27: 16.54 16.41 16.37 16.19 15.99 16.11 16.00
9115 10 34624400.00 BLS 28: 69.90 70.67 72.23 73.70 76.77 78.60 80.09
9116 <------------------------------------------------->
9117 1 2 3 4 5 6 7
9118
9120 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.95544438
9121 -Sum: -0.00091127 +Sum - -Sum: 0.95635566 last col W, previous N
9122
9123
9124 :3192: PORTFOLIO Selected Stocks ppDB
9125 WORKSHEET 4 D[23, 7] FLOAT
9126 A B C D E F G
9127 >-------------------------------------------------<
9128 13 10988185.71 BTC 3:1248.18 1264.31 1286.63 1332.91 1329.62 1336.28 1351.91
9129 16 13812057.14 BAC 9: 11.64 11.70 11.95 11.84 11.66 11.67 11.55
9130 20 8203242.86 ARAC 15: 17.59 16.83 16.85 15.59 16.80 16.61 17.18
9131 18 10611728.57 ATHN 21: 49.73 52.12 53.00 55.26 54.41 53.96 50.33
9132 17 2853314.29 ABT 22: 15.38 15.78 15.04 14.90 15.03 15.08 15.50
9133 16 15601242.86 BOOM 23: 19.30 19.47 19.57 19.53 19.77 19.78 20.11
9134 <------------------------------------------------->
9135 1 2 3 4 5 6 7
9136
9138 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.99316838
9139 -Sum: -0.00522433 +Sum - -Sum: 0.99839271 last col W, previous N
9140
9141
9142 :3192: PORTFOLIO Selected Stocks ppDB
9143 WORKSHEET 4 D[23, 7] FLOAT
9144 A B C D E F G
9145 >-------------------------------------------------<
9146 13 13187385.71 BTC 3:1248.18 1264.31 1286.63 1332.91 1329.62 1336.28 1351.91
9147 16 16011257.14 BAC 9: 11.64 11.70 11.95 11.84 11.66 11.67 11.55
9148 20 10402442.86 ARAC 15: 17.59 16.83 16.85 15.59 16.80 16.61 17.18
9149 18 12810928.57 ATHN 21: 49.73 52.12 53.00 55.26 54.41 53.96 50.33
9150 17 5052514.29 ABT 22: 15.38 15.78 15.04 14.90 15.03 15.08 15.50
9151 16 17800442.86 BOOM 23: 19.30 19.47 19.57 19.53 19.77 19.78 20.11
9152 <------------------------------------------------->
9153 1 2 3 4 5 6 7
9154
9156 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.99316838
9157 -Sum: -0.00522433 +Sum - -Sum: 0.99839271 last col W, previous N
9158
9159
9160 :3192: PORTFOLIO Selected Stocks ppDB
9161 WORKSHEET 4 D[30, 7] FLOAT
9162 A B C D E F G
9163 >-------------------------------------------------<
9164 42 12334628.57 ADVN 2: 20.36 20.55 20.03 20.01 20.38 20.34 20.00
9165 34 13959357.14 AMUY 4: 40.87 43.86 45.65 46.05 50.43 57.01 57.81
9166 36 11832400.00 AAL 16: 40.28 38.64 38.82 37.71 37.94 38.62 39.53
9167 47 10544971.43 ATHN 21: 62.83 63.65 63.90 64.52 62.65 63.09 59.55
9168 36 10785300.00 C 26:462.50 462.70 461.30 462.60 462.10 460.00 462.60
9169 7 7831757.14 ATLU 30: 8.68 8.89 8.65 8.21 8.19 7.97 7.61
9170 <------------------------------------------------->
9171 1 2 3 4 5 6 7
9172
9174 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.78810644
9175 -Sum: -0.08270432 +Sum - -Sum: 0.87081077 last col W, previous N
9176
9177
9178 :3192: PORTFOLIO Selected Stocks ppDB
9179 WORKSHEET 4 D[30, 7] FLOAT
9180 A B C D E F G
9181 >-------------------------------------------------<
9182 43 14310571.43 BF 1:118.79 118.47 118.93 118.78 118.81 119.38 119.47
9183 46 17793071.43 ARNA 10: 58.00 57.90 59.10 52.70 51.10 50.00 49.40
9184 44 14225671.43 ANRA 11: 50.10 49.60 49.90 47.40 48.10 46.30 44.70
9185 57 11394671.43 ARAC 15: 19.09 18.15 16.76 16.69 16.09 15.58 16.17
9186 47 11497071.43 AAPL 20: 24.68 24.59 24.26 24.50 25.65 26.44 26.48
9187 43 14122914.29 ABMD 25: 10.00 10.15 9.93 9.64 9.47 9.31 9.44
9188 15 15678314.29 ATLU 30: 9.56 10.19 7.97 7.61 9.77 9.40 9.56
9189 <------------------------------------------------->
9190 1 2 3 4 5 6 7
9191
9193 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.64777258
9194 -Sum: -0.01220863 +Sum - -Sum: 0.65998121 last col W, previous N
9195
9196
9197 :3192: PORTFOLIO Selected Stocks ppDB
9198 WORKSHEET 4 D[25, 7] FLOAT
9199 A B C D E F G
9200 >-------------------------------------------------<
9201 68 11487642.86 ADVN 2: 17.90 17.89 17.70 17.32 17.73 17.01 16.86
9202 57 9750728.57 ANRA 11: 45.10 47.50 47.10 44.40 46.40 46.50 49.00
9203 73 12590842.86 AMCSA 12: 22.58 22.62 21.84 20.95 21.04 20.08 19.83
9204 80 9967142.86 ARAC 15: 14.55 14.70 14.76 14.53 15.09 15.53 13.51
9205 63 13279114.29 ABMD 25: 9.64 9.87 9.28 9.02 8.93 8.61 8.85
9206 <------------------------------------------------->
9207 1 2 3 4 5 6 7
9208
9210 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.55304292
9211 -Sum: -0.14179680 +Sum - -Sum: 0.69483971 last col W, previous N
9212
9213
9214 :3192: PORTFOLIO Selected Stocks ppDB
9215 WORKSHEET 4 D[23, 7] FLOAT
9216 A B C D E F G
9217 >-------------------------------------------------<
9218 73 10611914.29 ADVN 2: 17.01 16.86 16.89 16.88 16.63 16.25 16.31
9219 58 13106157.14 AMUY 4: 77.74 71.56 71.37 72.86 75.15 75.75 80.34
9220 62 13194171.43 CAR 5: 13.31 11.39 11.16 11.07 10.52 9.88 9.72
9221 61 11559885.71 BOOM 23: 22.09 22.13 21.83 21.93 21.13 21.18 20.65
9222 <------------------------------------------------->
9223 1 2 3 4 5 6 7
9224
9226 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.68096519
9227 -Sum: -0.18749353 +Sum - -Sum: 0.86845871 last col W, previous N
9228
9229
9230 :3192: PORTFOLIO Selected Stocks ppDB
9231 WORKSHEET 4 D[23, 7] FLOAT
9232 A B C D E F G
9233 >-------------------------------------------------<
9234 73 12348714.29 ADVN 2: 17.01 16.86 16.89 16.88 16.63 16.25 16.31
9235 59 9937471.43 AMUY 4: 71.56 71.37 72.86 75.15 75.75 80.34 84.32
9236 63 10863714.29 CAR 5: 11.39 11.16 11.07 10.52 9.88 9.72 10.52
9237 61 13296685.71 BOOM 23: 22.09 22.13 21.83 21.93 21.13 21.18 20.65
9238 <------------------------------------------------->
9239 1 2 3 4 5 6 7
9240
9242 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.69977413
9243 -Sum: -0.01407640 +Sum - -Sum: 0.71385053 last col W, previous N
9244
9245
9246 :3192: PORTFOLIO Selected Stocks ppDB
9247 WORKSHEET 4 D[28, 7] FLOAT
9248 A B C D E F G
9249 >-------------------------------------------------<
9250 71 12782857.14 AMUY 4: 81.73 84.12 96.88 101.67 103.46 100.07 102.86
9251 75 19287742.86 BOX 7: 18.00 18.96 18.85 18.21 18.83 18.67 18.94
9252 66 15538328.57 ANRA 11: 45.50 45.30 44.40 44.90 44.60 44.40 44.80
9253 60 19421657.14 BBY 14: 35.35 36.07 36.62 35.50 34.96 35.10 34.57
9254 87 23104000.00 ARAC 15: 14.85 16.33 16.47 16.30 16.40 16.65 15.84
9255 74 19614371.43 BLS 28: 85.35 80.61 80.47 81.51 82.05 81.93 83.47
9256 <------------------------------------------------->
9257 1 2 3 4 5 6 7
9258
9260 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.75763846
9261 -Sum: -0.05068152 +Sum - -Sum: 0.80831999 last col W, previous N
9262 :3300: -----------------------------------------------
9265 :3216: run: 2 counter: 4
9267 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 5744.37 = 4273.63
9268 :3501: Before if - Stock counter: 0 <---=> 3 <-: minDB
9269 :3502: Not invested fraction %deltaPrice: 4273.63/ 10018.00 = -0.4265955
9270
9271
9272 :3192: PORTFOLIO Selected Stocks ppDB
9273 WORKSHEET 4 D[29, 7] FLOAT
9274 A B C D E F G
9275 >-------------------------------------------------<
9276 14 28669657.14 ABMD 4: 9.43 9.74 9.79 9.87 9.73 9.52 9.54
9277 16 25967957.14 BLS 5: 85.10 83.93 85.19 85.64 82.76 84.03 82.39
9278 17 34641528.57 BGG 10: 11.70 11.45 10.95 12.41 12.81 13.01 14.35
9279 17 31752328.57 ALV 16: 56.19 56.52 53.96 54.71 56.10 55.86 54.28
9280 16 15078671.43 BF 25:110.45 109.64 110.84 110.51 110.61 108.99 110.63
9281 16 4641614.29 C 27:461.40 457.60 462.00 463.20 462.90 465.90 465.80
9282 12 25141385.71 ATLU 29: 8.74 9.93 8.90 8.72 9.18 9.77 9.05
9283 <------------------------------------------------->
9284 1 2 3 4 5 6 7
9285
9286 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.93138861 -Sum: 0.00000000 +Sum - -Sum: 0.931388
9287 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.93138861
9288 -Sum: 0.00000000 +Sum - -Sum: 0.93138861 last col W, previous N
9289
9290
9291 :3192: PORTFOLIO Selected Stocks ppDB
9292 WORKSHEET 4 D[29, 7] FLOAT
9293 A B C D E F G
9294 >-------------------------------------------------<
9295 15 24357871.43 ABMD 4: 9.74 9.79 9.87 9.73 9.52 9.54 9.45
9296 17 18980228.57 BLS 5: 83.93 85.19 85.64 82.76 84.03 82.39 80.83
9297 19 21076357.14 BGG 10: 10.95 12.41 12.81 13.01 14.35 15.02 15.79
9298 17 36368128.57 ALV 16: 56.19 56.52 53.96 54.71 56.10 55.86 54.28
9299 16 19694471.43 BF 25:110.45 109.64 110.84 110.51 110.61 108.99 110.63
9300 16 9257414.29 C 27:461.40 457.60 462.00 463.20 462.90 465.90 465.80
9301 12 29757185.71 ATLU 29: 8.74 9.93 8.90 8.72 9.18 9.77 9.05
9302 <------------------------------------------------->
9303 1 2 3 4 5 6 7
9304
9306 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.89164753
9307 -Sum: -0.06950262 +Sum - -Sum: 0.96115015 last col W, previous N
9308
9309
9310 :3192: PORTFOLIO Selected Stocks ppDB
9311 WORKSHEET 4 D[29, 7] FLOAT
9312 A B C D E F G
9313 >-------------------------------------------------<
9314 15 26685171.43 ABMD 4: 9.74 9.79 9.87 9.73 9.52 9.54 9.45
9315 17 21307528.57 BLS 5: 83.93 85.19 85.64 82.76 84.03 82.39 80.83
9316 19 23403657.14 BGG 10: 10.95 12.41 12.81 13.01 14.35 15.02 15.79
9317 17 38695428.57 ALV 16: 56.19 56.52 53.96 54.71 56.10 55.86 54.28
9318 17 13111657.14 BF 25:109.64 110.84 110.51 110.61 108.99 110.63 113.64
9319 16 11584714.29 C 27:461.40 457.60 462.00 463.20 462.90 465.90 465.80
9320 12 32084485.71 ATLU 29: 8.74 9.93 8.90 8.72 9.18 9.77 9.05
9321 <------------------------------------------------->
9322 1 2 3 4 5 6 7
9323
9325 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.87994853
9326 -Sum: -0.07929693 +Sum - -Sum: 0.95924545 last col W, previous N
9327
9328
9329 :3192: PORTFOLIO Selected Stocks ppDB
9330 WORKSHEET 4 D[29, 7] FLOAT
9331 A B C D E F G
9332 >-------------------------------------------------<
9333 15 29163871.43 ABMD 4: 9.74 9.79 9.87 9.73 9.52 9.54 9.45
9334 17 23786228.57 BLS 5: 83.93 85.19 85.64 82.76 84.03 82.39 80.83
9335 21 46980371.43 BHI 7: 44.88 44.56 44.61 45.88 45.72 45.43 44.50
9336 12 37254071.43 ATHN 8: 56.24 56.70 55.26 54.26 52.61 53.31 54.00
9337 19 25882357.14 BGG 10: 10.95 12.41 12.81 13.01 14.35 15.02 15.79
9338 14 47417914.29 AAPL 12: 25.41 25.32 25.35 24.94 24.38 24.50 25.52
9339 17 41174128.57 ALV 16: 56.19 56.52 53.96 54.71 56.10 55.86 54.28
9340 17 15590357.14 BF 25:109.64 110.84 110.51 110.61 108.99 110.63 113.64
9341 16 14063414.29 C 27:461.40 457.60 462.00 463.20 462.90 465.90 465.80
9342 12 34563185.71 ATLU 29: 8.74 9.93 8.90 8.72 9.18 9.77 9.05
9343 <------------------------------------------------->
9344 1 2 3 4 5 6 7
9345
9347 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.87765116
9348 -Sum: -0.08919613 +Sum - -Sum: 0.96684728 last col W, previous N
9349
9350
9351 :3192: PORTFOLIO Selected Stocks ppDB
9352 WORKSHEET 4 D[29, 7] FLOAT
9353 A B C D E F G
9354 >-------------------------------------------------<
9355 15 33516671.43 ABMD 4: 9.74 9.79 9.87 9.73 9.52 9.54 9.45
9356 17 28139028.57 BLS 5: 83.93 85.19 85.64 82.76 84.03 82.39 80.83
9357 21 51333171.43 BHI 7: 44.88 44.56 44.61 45.88 45.72 45.43 44.50
9358 12 41606871.43 ATHN 8: 56.24 56.70 55.26 54.26 52.61 53.31 54.00
9359 19 30235157.14 BGG 10: 10.95 12.41 12.81 13.01 14.35 15.02 15.79
9360 14 51770714.29 AAPL 12: 25.41 25.32 25.35 24.94 24.38 24.50 25.52
9361 17 45526928.57 ALV 16: 56.19 56.52 53.96 54.71 56.10 55.86 54.28
9362 13 42600857.14 BBY 20: 34.29 34.30 33.06 32.63 32.69 31.56 30.77
9363 17 19943157.14 BF 25:109.64 110.84 110.51 110.61 108.99 110.63 113.64
9364 17 14685871.43 C 27:457.60 462.00 463.20 462.90 465.90 465.80 462.60
9365 12 38915985.71 ATLU 29: 8.74 9.93 8.90 8.72 9.18 9.77 9.05
9366 <------------------------------------------------->
9367 1 2 3 4 5 6 7
9368
9370 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.86684921
9371 -Sum: -0.10927188 +Sum - -Sum: 0.97612110 last col W, previous N
9372
9373
9374 :3192: PORTFOLIO Selected Stocks ppDB
9375 WORKSHEET 4 D[29, 7] FLOAT
9376 A B C D E F G
9377 >-------------------------------------------------<
9378 15 39221271.43 ABMD 4: 9.74 9.79 9.87 9.73 9.52 9.54 9.45
9379 17 33843628.57 BLS 5: 83.93 85.19 85.64 82.76 84.03 82.39 80.83
9380 14 53614442.86 ANRA 6: 46.20 45.50 46.60 47.10 52.90 54.10 52.00
9381 21 57037771.43 BHI 7: 44.88 44.56 44.61 45.88 45.72 45.43 44.50
9382 12 47311471.43 ATHN 8: 56.24 56.70 55.26 54.26 52.61 53.31 54.00
9383 19 35939757.14 BGG 10: 10.95 12.41 12.81 13.01 14.35 15.02 15.79
9384 15 42262200.00 AAPL 12: 25.32 25.35 24.94 24.38 24.50 25.52 25.34
9385 17 51231528.57 ALV 16: 56.19 56.52 53.96 54.71 56.10 55.86 54.28
9386 13 48305457.14 BBY 20: 34.29 34.30 33.06 32.63 32.69 31.56 30.77
9387 17 25647757.14 BF 25:109.64 110.84 110.51 110.61 108.99 110.63 113.64
9388 17 20390471.43 C 27:457.60 462.00 463.20 462.90 465.90 465.80 462.60
9389 13 33816671.43 ATLU 29: 9.93 8.90 8.72 9.18 9.77 9.05 7.96
9390 <------------------------------------------------->
9391 1 2 3 4 5 6 7
9392
9394 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.87618350
9395 -Sum: -0.09766218 +Sum - -Sum: 0.97384568 last col W, previous N
9396
9397
9398 :3192: PORTFOLIO Selected Stocks ppDB
9399 WORKSHEET 4 D[29, 7] FLOAT
9400 A B C D E F G
9401 >-------------------------------------------------<
9402 16 33267457.14 ABMD 4: 9.79 9.87 9.73 9.52 9.54 9.45 9.42
9403 17 39705228.57 BLS 5: 83.93 85.19 85.64 82.76 84.03 82.39 80.83
9404 19 41801357.14 BGG 10: 10.95 12.41 12.81 13.01 14.35 15.02 15.79
9405 16 36211871.43 AAPL 12: 25.35 24.94 24.38 24.50 25.52 25.34 25.12
9406 18 41786142.86 ALV 16: 56.52 53.96 54.71 56.10 55.86 54.28 52.90
9407 17 31509357.14 BF 25:109.64 110.84 110.51 110.61 108.99 110.63 113.64
9408 17 26252071.43 C 27:457.60 462.00 463.20 462.90 465.90 465.80 462.60
9409 13 39678271.43 ATLU 29: 9.93 8.90 8.72 9.18 9.77 9.05 7.96
9410 <------------------------------------------------->
9411 1 2 3 4 5 6 7
9412
9414 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.82520468
9415 -Sum: -0.11942444 +Sum - -Sum: 0.94462912 last col W, previous N
9416
9417
9418 :3192: PORTFOLIO Selected Stocks ppDB
9419 WORKSHEET 4 D[29, 7] FLOAT
9420 A B C D E F G
9421 >-------------------------------------------------<
9422 16 36168757.14 ABMD 4: 9.79 9.87 9.73 9.52 9.54 9.45 9.42
9423 17 42606528.57 BLS 5: 83.93 85.19 85.64 82.76 84.03 82.39 80.83
9424 19 44702657.14 BGG 10: 10.95 12.41 12.81 13.01 14.35 15.02 15.79
9425 16 39113171.43 AAPL 12: 25.35 24.94 24.38 24.50 25.52 25.34 25.12
9426 18 44687442.86 ALV 16: 56.52 53.96 54.71 56.10 55.86 54.28 52.90
9427 14 44669128.57 BBY 20: 34.30 33.06 32.63 32.69 31.56 30.77 31.42
9428 17 34410657.14 BF 25:109.64 110.84 110.51 110.61 108.99 110.63 113.64
9429 17 29153371.43 C 27:457.60 462.00 463.20 462.90 465.90 465.80 462.60
9430 13 42579571.43 ATLU 29: 9.93 8.90 8.72 9.18 9.77 9.05 7.96
9431 <------------------------------------------------->
9432 1 2 3 4 5 6 7
9433
9435 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.82520468
9436 -Sum: -0.11942444 +Sum - -Sum: 0.94462912 last col W, previous N
9437
9438
9439 :3192: PORTFOLIO Selected Stocks ppDB
9440 WORKSHEET 4 D[27, 7] FLOAT
9441 A B C D E F G
9442 >-------------------------------------------------<
9443 17 28276271.43 ABMD 4: 9.87 9.73 9.52 9.54 9.45 9.42 9.73
9444 22 19047785.71 BGG 10: 13.01 14.35 15.02 15.79 15.73 15.47 15.10
9445 18 32010928.57 BF 25:110.84 110.51 110.61 108.99 110.63 113.64 113.71
9446 17 34068671.43 C 27:457.60 462.00 463.20 462.90 465.90 465.80 462.60
9447 <------------------------------------------------->
9448 1 2 3 4 5 6 7
9449
9450 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.99374276 -Sum: 0.00000000 +Sum - -Sum: 0.993742
9451 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.99374276
9452 -Sum: 0.00000000 +Sum - -Sum: 0.99374276 last col W, previous N
9453
9454
9455 :3192: PORTFOLIO Selected Stocks ppDB
9456 WORKSHEET 4 D[27, 7] FLOAT
9457 A B C D E F G
9458 >-------------------------------------------------<
9459 17 29693171.43 ABMD 4: 9.87 9.73 9.52 9.54 9.45 9.42 9.73
9460 23 15054628.57 BGG 10: 14.35 15.02 15.79 15.73 15.47 15.10 15.00
9461 19 41763600.00 ARNA 17: 57.20 58.50 60.70 64.00 64.40 65.20 66.60
9462 18 33427828.57 BF 25:110.84 110.51 110.61 108.99 110.63 113.64 113.71
9463 17 35485571.43 C 27:457.60 462.00 463.20 462.90 465.90 465.80 462.60
9464 <------------------------------------------------->
9465 1 2 3 4 5 6 7
9466
9467 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.94619823 -Sum: 0.00000000 +Sum - -Sum: 0.946198
9468 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.94619823
9469 -Sum: 0.00000000 +Sum - -Sum: 0.94619823 last col W, previous N
9470 :3300: -----------------------------------------------
9473 :3216: run: 2 counter: 3
9475 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 7871.53 = 2146.47
9476 :3501: Before if - Stock counter: 0 <---=> 3 <-: minDB
9477 :3502: Not invested fraction %deltaPrice: 2146.47/ 10018.00 = -0.2142617
9478
9479
9480 :3192: PORTFOLIO Selected Stocks ppDB
9481 WORKSHEET 4 D[27, 7] FLOAT
9482 A B C D E F G
9483 >-------------------------------------------------<
9484 9 10065614.29 C 4:468.80 469.00 468.70 468.30 468.50 467.70 468.00
9485 14 10062800.00 AAPL 9: 26.08 26.97 27.30 26.98 27.31 27.19 27.61
9486 9 9450085.71 ARAC 13: 9.76 9.29 9.39 9.83 9.99 9.97 9.20
9487 8 9421042.86 ATSG 14: 7.40 7.30 7.27 7.32 7.41 7.79 7.72
9488 11 8650457.14 BMY 16: 11.36 11.75 11.97 12.14 12.26 12.23 12.29
9489 9 9821785.71 ATLU 21: 9.28 10.12 10.48 10.45 10.33 10.20 11.40
9490 8 10156928.57 ANRA 26: 56.50 54.30 57.60 58.50 33.20 35.20 35.90
9491 10 9102757.14 BLS 27: 83.04 83.35 82.70 85.08 85.92 86.73 82.63
9492 <------------------------------------------------->
9493 1 2 3 4 5 6 7
9494
9496 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.73422874
9497 -Sum: -0.07111838 +Sum - -Sum: 0.80534711 last col W, previous N
9498 :3300: -----------------------------------------------
9501 :3216: run: 2 counter: 4
9503 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 7573.49 = 2444.51
9504 :3501: Before if - Stock counter: 0 <---=> 3 <-: minDB
9505 :3502: Not invested fraction %deltaPrice: 2444.51/ 10018.00 = -0.2440116
9506
9507
9508 :3192: PORTFOLIO Selected Stocks ppDB
9509 WORKSHEET 4 D[31, 7] FLOAT
9510 A B C D E F G
9511 >-------------------------------------------------<
9512 17 43681814.29 CAB 1: 14.93 15.03 14.97 14.67 14.83 14.81 14.97
9513 19 40387442.86 ABMD 4: 11.45 11.26 11.09 11.17 10.97 10.50 10.26
9514 16 40022114.29 BLS 5: 74.13 74.07 73.66 72.40 70.58 69.49 69.27
9515 19 33061242.86 ATHN 6: 49.37 48.02 49.52 49.30 49.10 49.37 49.25
9516 11 52424342.86 ARAC 8: 8.64 9.02 9.62 9.87 9.84 9.51 9.78
9517 15 43965471.43 ABT 9: 15.10 14.94 15.12 15.12 14.86 14.73 15.12
9518 20 26670057.14 ATLU 11: 12.04 12.55 12.70 14.54 13.80 13.71 13.78
9519 19 41307600.00 BBY 12: 27.60 27.01 28.07 28.04 28.02 27.82 28.87
9520 19 32985771.43 BHI 14: 44.89 45.77 45.81 45.51 43.58 44.15 45.83
9521 17 46593428.57 AAL 17: 37.83 38.19 37.63 39.15 37.15 38.30 38.72
9522 14 39196500.00 CAR 18: 14.91 14.74 14.75 15.29 15.00 14.23 14.25
9523 13 41722600.00 C 20:466.20 466.00 465.60 465.00 465.40 466.70 470.00
9524 10 39779485.71 AAPL 21: 27.35 27.11 26.80 27.18 27.02 26.57 27.75
9525 20 40294371.43 BOX 31: 17.05 17.52 17.69 17.82 17.79 17.93 17.92
9526 <------------------------------------------------->
9527 1 2 3 4 5 6 7
9528
9530 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.77873574
9531 -Sum: -0.13992016 +Sum - -Sum: 0.91865590 last col W, previous N
9532 :3300: -----------------------------------------------
9535 :3216: run: 2 counter: 9
9537 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 5269.68 = 4748.32
9538 :3501: Before if - Stock counter: 0 <---=> 3 <-: minDB
9539 :3502: Not invested fraction %deltaPrice: 4748.32/ 10018.00 = -0.4739784
9540
9541
9542 :3192: PORTFOLIO Selected Stocks ppDB
9543 WORKSHEET 4 D[26, 7] FLOAT
9544 A B C D E F G
9545 >-------------------------------------------------<
9546 13 51014700.00 ABT 2: 14.89 14.79 14.66 14.73 14.96 15.02 14.79
9547 13 38944457.14 BOOM 4: 18.13 18.11 17.91 17.82 17.36 17.02 16.42
9548 12 39096328.57 BLGS 5: 9.95 9.80 9.90 9.60 9.50 9.70 9.40
9549 15 41679457.14 AMUY 6:116.22 108.64 107.65 107.25 105.93 105.85 107.45
9550 12 43559128.57 BHI 9: 48.84 48.64 47.24 46.93 48.48 47.68 48.91
9551 12 31784128.57 BMY 11: 14.34 14.26 14.31 14.36 14.06 13.32 12.72
9552 19 32860300.00 BLS 12: 69.45 71.12 71.27 68.59 70.57 70.14 72.76
9553 16 22614457.14 BGG 18: 18.18 17.42 17.53 17.72 17.84 18.80 20.08
9554 13 52993442.86 AAL 20: 43.30 43.64 43.17 44.80 44.49 45.27 45.26
9555 11 46993771.43 BF 22:109.58 109.95 109.82 106.92 107.92 108.07 106.88
9556 16 48215342.86 BBY 25: 28.90 28.64 28.16 28.25 29.21 28.45 28.66
9557 9 30804328.57 BRLC 26: 17.44 16.83 15.91 15.30 14.08 14.69 16.83
9558 <------------------------------------------------->
9559 1 2 3 4 5 6 7
9560
9562 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.87704589
9563 -Sum: -0.12184117 +Sum - -Sum: 0.99888706 last col W, previous N
9564 :3300: -----------------------------------------------
9567 :3216: run: 2 counter: 9
9569 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 7654.16 = 2363.84
9570 :3501: Before if - Stock counter: 0 <---=> 3 <-: minDB
9571 :3502: Not invested fraction %deltaPrice: 2363.84/ 10018.00 = -0.2359595
9572
9573
9574 :3192: PORTFOLIO Selected Stocks ppDB
9575 WORKSHEET 4 D[27, 7] FLOAT
9576 A B C D E F G
9577 >-------------------------------------------------<
9578 9 17193057.14 ABT 1: 15.04 14.90 15.18 15.22 15.25 15.48 15.43
9579 12 13924357.14 C 3:471.00 469.00 466.90 466.00 463.20 464.00 466.80
9580 8 16444585.71 AMUY 4:108.64 107.65 107.25 110.04 107.65 108.84 115.14
9581 9 15198285.71 ATLU 6: 11.08 11.82 11.31 11.90 11.47 11.88 11.75
9582 9 16255800.00 BF 7:104.57 103.47 105.20 101.61 102.01 101.91 101.00
9583 8 16147342.86 ATSG 8: 7.78 7.55 7.57 7.51 7.49 7.52 7.41
9584 9 15706728.57 BHI 9: 50.90 51.51 51.77 51.79 51.67 50.61 50.65
9585 8 17279185.71 CAR 11: 14.10 13.35 12.33 11.74 12.53 13.14 13.50
9586 11 14817428.57 BOX 12: 17.24 17.20 17.08 16.95 16.87 16.83 16.86
9587 7 16425700.00 ALV 14: 52.98 53.49 55.26 55.53 56.27 56.49 56.36
9588 8 17151671.43 CAB 15: 14.12 14.03 13.95 14.09 13.93 13.97 14.25
9589 9 14227985.71 AAPL 19: 25.63 25.85 26.24 26.13 26.18 26.02 25.86
9590 7 16662785.71 BOOM 21: 16.27 16.35 16.24 16.43 16.77 16.52 16.37
9591 7 16444228.57 AAL 27: 44.68 45.03 45.27 45.40 44.55 44.52 44.27
9592 <------------------------------------------------->
9593 1 2 3 4 5 6 7
9594
9596 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.81746373
9597 -Sum: -0.07033994 +Sum - -Sum: 0.88780367 last col W, previous N
9598 :3300: -----------------------------------------------
9601 :3216: run: 2 counter: 13
9603 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 5865.12 = 4152.88
9604 :3501: Before if - Stock counter: 0 <---=> 3 <-: minDB
9605 :3502: Not invested fraction %deltaPrice: 4152.88/ 10018.00 = -0.4145421
9606
9607
9608 :3192: PORTFOLIO Selected Stocks ppDB
9609 WORKSHEET 4 D[30, 7] FLOAT
9610 A B C D E F G
9611 >-------------------------------------------------<
9612 10 41303885.71 ATSG 9: 7.68 7.60 7.66 7.70 7.94 7.95 7.99
9613 8 47811257.14 BLS 27: 69.82 70.35 68.21 68.07 68.70 65.95 65.14
9614 8 48863657.14 BGG 28: 20.18 21.48 21.37 21.34 20.23 20.24 20.16
9615 9 44066314.29 BOOM 30: 16.62 16.30 16.41 17.52 16.82 17.06 17.64
9616 <------------------------------------------------->
9617 1 2 3 4 5 6 7
9618
9619 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.97168040 -Sum: 0.00000000 +Sum - -Sum: 0.971680
9620 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.97168040
9621 -Sum: 0.00000000 +Sum - -Sum: 0.97168040 last col W, previous N
9622
9623
9624 :3192: PORTFOLIO Selected Stocks ppDB
9625 WORKSHEET 4 D[27, 7] FLOAT
9626 A B C D E F G
9627 >-------------------------------------------------<
9628 17 60374971.43 ADVN 1: 17.42 17.80 17.88 17.77 18.60 18.65 18.67
9629 16 68143342.86 CAR 7: 10.99 12.40 11.85 11.24 11.49 11.90 11.03
9630 11 90476085.71 ALV 10: 59.25 61.47 61.53 62.81 63.84 63.64 63.79
9631 13 85180514.29 ABT 16: 15.14 15.33 15.43 15.58 15.75 15.74 15.90
9632 9 80777500.00 ASCMA 25: 24.94 24.41 24.57 24.50 24.49 23.09 23.91
9633 12 73358757.14 BLS 27: 68.70 65.95 65.14 62.61 61.31 60.58 62.26
9634 <------------------------------------------------->
9635 1 2 3 4 5 6 7
9636
9638 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.51231544
9639 -Sum: -0.46941520 +Sum - -Sum: 0.98173064 last col W, previous N
9640
9641
9642 :3192: PORTFOLIO Selected Stocks ppDB
9643 WORKSHEET 4 D[27, 7] FLOAT
9644 A B C D E F G
9645 >-------------------------------------------------<
9646 17 62292671.43 ADVN 1: 17.42 17.80 17.88 17.77 18.60 18.65 18.67
9647 16 70061042.86 CAR 7: 10.99 12.40 11.85 11.24 11.49 11.90 11.03
9648 11 92393785.71 ALV 10: 59.25 61.47 61.53 62.81 63.84 63.64 63.79
9649 13 87098214.29 ABT 16: 15.14 15.33 15.43 15.58 15.75 15.74 15.90
9650 9 82695200.00 ASCMA 25: 24.94 24.41 24.57 24.50 24.49 23.09 23.91
9651 12 75276457.14 BLS 27: 68.70 65.95 65.14 62.61 61.31 60.58 62.26
9652 <------------------------------------------------->
9653 1 2 3 4 5 6 7
9654
9656 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.51231544
9657 -Sum: -0.46941520 +Sum - -Sum: 0.98173064 last col W, previous N
9658
9659
9660 :3192: PORTFOLIO Selected Stocks ppDB
16549 :3192: PORTFOLIO Selected Stocks ppDB
16550 WORKSHEET 4 D[31, 7] FLOAT
16551 A B C D E F G
16552 >-------------------------------------------------<
16553 10 6915814.29 ARAC 2: 12.37 12.40 12.48 12.87 12.46 13.06 13.44
16554 11 7230057.14 AKSH 5: 96.66 97.88 96.80 100.15 103.79 106.30 108.50
16555 9 7576685.71 ALV 6: 78.70 79.08 77.99 79.77 71.14 68.91 70.30
16556 10 7494971.43 AMUY 10: 87.91 87.63 92.30 88.11 86.91 88.71 87.71
16557 8 7827671.43 C 13:475.60 475.90 474.10 477.80 481.70 480.10 479.60
16558 12 7724671.43 BHI 17: 36.08 34.99 35.75 35.42 36.49 35.21 36.41
16559 10 7326300.00 ABMD 31: 22.00 22.06 20.94 19.44 19.12 18.50 18.88
16560 <------------------------------------------------->
16561 1 2 3 4 5 6 7
16562
16564 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.52673915
16565 -Sum: -0.06177388 +Sum - -Sum: 0.58851303 last col W, previous N
16566
16567
16568 :3192: PORTFOLIO Selected Stocks ppDB
16569 WORKSHEET 4 D[16, 7] FLOAT
16570 A B C D E F G
16571 >-------------------------------------------------<
16572 13 10468100.00 ARAC 2: 12.87 12.46 13.06 13.44 13.43 13.46 13.65
16573 11 12232314.29 ALV 6: 77.99 79.77 71.14 68.91 70.30 70.65 69.87
16574 8 12178557.14 BF 16: 77.22 78.54 78.29 76.80 77.91 77.00 76.43
16575 <------------------------------------------------->
16576 1 2 3 4 5 6 7
16577
16578 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.62672941 -Sum: 0.00000000 +Sum - -Sum: 0.626729
16579 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.62672941
16580 -Sum: 0.00000000 +Sum - -Sum: 0.62672941 last col W, previous N
16581 :3300: -----------------------------------------------
16584 :3216: run: 2 counter: 3
16586 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 8026.06 = 1991.94
16587 :3501: Before if - Stock counter: 0 <---=> 3 <-: minDB
16588 :3502: Not invested fraction %deltaPrice: 1991.94/ 10018.00 = -0.1988360
16589
16590
16591 :3192: PORTFOLIO Selected Stocks ppDB
16592 WORKSHEET 4 D[31, 7] FLOAT
16593 A B C D E F G
16594 >-------------------------------------------------<
16595 10 23038085.71 AMCSA 2: 42.84 42.30 43.08 43.00 42.86 42.71 42.57
16596 11 22179857.14 BF 4: 77.43 76.67 77.89 77.26 75.95 75.83 76.68
16597 8 23305214.29 ANRA 7: 45.00 47.50 45.70 45.50 44.40 43.90 45.00
16598 12 17755728.57 CAB 9: 11.79 12.16 12.35 12.64 12.72 12.66 12.53
16599 8 21965771.43 CAMP 10: 24.03 24.23 24.53 24.76 23.17 23.76 23.78
16600 11 23408685.71 AMD 13: 8.65 8.43 8.28 8.12 8.31 8.55 8.36
16601 9 23556014.29 BAC 14: 12.88 12.53 12.56 12.41 12.40 12.59 12.45
16602 11 21019628.57 BOX 15: 10.99 11.77 11.65 11.87 11.80 11.83 11.93
16603 8 23069185.71 AMUY 16: 87.19 87.31 86.71 89.71 87.91 86.32 88.11
16604 11 21432714.29 C 18:483.60 485.40 484.50 483.60 482.00 483.70 484.40
16605 8 18502885.71 BHI 20: 34.40 35.05 35.44 35.14 35.75 35.03 33.76
16606 12 19815885.71 ARNA 22: 47.70 45.60 45.10 43.10 43.70 45.10 43.20
16607 8 21837457.14 ABMD 23: 23.06 22.56 24.50 25.45 26.88 29.06 29.00
16608 7 24025985.71 BLS 26: 27.73 26.27 27.21 26.72 26.42 26.19 24.61
16609 9 21032071.43 AAL 27: 9.47 9.73 9.76 10.40 10.64 9.79 9.55
16610 7 22501300.00 BOOM 29: 24.72 24.69 23.91 25.39 23.32 26.91 27.12
16611 7 22769671.43 ALV 31: 69.42 68.85 69.32 69.80 68.20 69.11 68.36
16612 <------------------------------------------------->
16613 1 2 3 4 5 6 7
16614
16616 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.72074766
16617 -Sum: -0.23304131 +Sum - -Sum: 0.95378898 last col W, previous N
16618 :3300: -----------------------------------------------
16621 :3216: run: 2 counter: 11
16623 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 5975.22 = 4042.78
16624 :3501: Before if - Stock counter: 0 <---=> 3 <-: minDB
16625 :3502: Not invested fraction %deltaPrice: 4042.78/ 10018.00 = -0.4035517
16626
16627
16628 :3192: PORTFOLIO Selected Stocks ppDB
16629 WORKSHEET 4 D[31, 7] FLOAT
16630 A B C D E F G
16631 >-------------------------------------------------<
16632 10 9582814.29 ABMD 3: 27.06 27.75 27.12 26.81 28.31 29.38 26.38
16633 7 11279042.86 BLGS 12: 10.40 10.20 10.44 10.30 10.60 10.95 11.10
16634 14 11041685.71 BBY 13: 69.65 72.05 72.85 72.71 71.46 70.34 70.83
16635 9 10857100.00 BAC 16: 12.60 12.48 12.45 12.80 12.58 11.93 11.34
16636 11 8529485.71 CAB 21: 12.65 12.54 12.79 12.98 13.08 13.24 12.91
16637 11 11111771.43 AMCSA 23: 41.71 41.96 41.72 41.34 40.42 40.06 39.98
16638 10 10118200.00 ATLU 25: 48.35 49.05 49.53 52.72 54.95 57.07 58.73
16639 7 10662300.00 AKSH 31:109.16 109.43 111.03 110.01 110.08 111.18 109.08
16640 <------------------------------------------------->
16641 1 2 3 4 5 6 7
16642
16644 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.96602924
16645 -Sum: -0.00104979 +Sum - -Sum: 0.96707903 last col W, previous N
16646 :3300: -----------------------------------------------
16649 :3216: run: 2 counter: 5
16651 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 5988.93 = 4029.07
16652 :3501: Before if - Stock counter: 0 <---=> 3 <-: minDB
16653 :3502: Not invested fraction %deltaPrice: 4029.07/ 10018.00 = -0.4021828
16654
16655
16656 :3192: PORTFOLIO Selected Stocks ppDB
16657 WORKSHEET 4 D[31, 7] FLOAT
16658 A B C D E F G
16659 >-------------------------------------------------<
16660 10 6139428.57 BLGS 8: 10.40 11.04 10.99 11.16 10.98 11.20 11.60
16661 11 7634985.71 ADVN 12: 13.44 13.34 13.63 13.65 14.02 13.61 13.69
16662 14 6356371.43 BLS 15: 22.04 22.32 22.60 22.73 22.43 22.09 20.56
16663 12 7998400.00 BTC 22:325.43 322.55 324.24 327.96 338.01 347.67 341.87
16664 9 5267614.29 ATHN 24: 46.93 46.20 45.16 46.00 45.87 46.49 45.62
16665 9 8093828.57 ARNA 30: 47.70 49.00 46.50 46.40 44.40 47.10 47.50
16666 9 7104785.71 AMCSA 31: 39.49 38.72 38.57 38.37 38.30 38.44 38.50
16667 <------------------------------------------------->
16668 1 2 3 4 5 6 7
16669
16671 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.82889455
16672 -Sum: -0.08859252 +Sum - -Sum: 0.91748707 last col W, previous N
16673 :3300: -----------------------------------------------
16676 :3216: run: 2 counter: 4
16678 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 7875.18 = 2142.82
16679 :3501: Before if - Stock counter: 1 <---=> 3 <-: minDB
16680 :3502: Not invested fraction %deltaPrice: 2142.82/ 10018.00 = -0.2138967
16681
16682
16683 :3192: PORTFOLIO Selected Stocks ppDB
16684 WORKSHEET 4 D[31, 7] FLOAT
16685 A B C D E F G
16686 >-------------------------------------------------<
16687 16 35289671.43 ARAC 1: 12.98 13.15 12.84 13.14 13.51 13.95 14.06
16688 13 25243700.00 ATHN 4: 57.57 59.71 58.79 59.38 59.43 60.00 54.17
16689 17 32208771.43 ARNA 5: 47.40 49.90 49.60 50.10 48.00 47.00 45.10
16690 14 27499471.43 AMD 31: 8.71 8.70 8.88 8.95 9.07 9.10 9.03
16691 <------------------------------------------------->
16692 1 2 3 4 5 6 7
16693
16694 :3266: NORMALIZED-SCALED Adding Up Weights: +Sum:0.52906996 -Sum: 0.00000000 +Sum - -Sum: 0.529069
16695 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.52906996
16696 -Sum: 0.00000000 +Sum - -Sum: 0.52906996 last col W, previous N
16697 :3300: -----------------------------------------------
16700 :3216: run: 2 counter: 3
16702 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 8036.54 = 1981.46
16703 :3501: Before if - Stock counter: 0 <---=> 3 <-: minDB
16704 :3502: Not invested fraction %deltaPrice: 1981.46/ 10018.00 = -0.1977895
16705
16706
16707 :3192: PORTFOLIO Selected Stocks ppDB
16708 WORKSHEET 4 D[34, 7] FLOAT
16709 A B C D E F G
16710 >-------------------------------------------------<
16711 16 107405214.29 ADVN 1: 13.98 13.76 13.82 13.59 13.39 13.67 13.08
16712 26 89316771.43 BOOM 2: 13.90 14.63 13.79 14.80 14.52 16.25 17.34
16713 28 58237371.43 ATHN 4: 57.02 59.08 62.96 60.52 65.64 66.79 66.71
16714 26 90197085.71 ARNA 5: 44.70 44.40 44.90 42.20 42.00 43.20 43.60
16715 21 96212771.43 AKSH 7:102.66 103.66 103.14 100.25 97.59 101.01 105.59
16716 23 80767514.29 BAC 8: 11.99 12.13 11.88 11.75 11.65 11.86 11.91
16717 14 99567671.43 AAL 9: 8.54 8.64 8.39 8.46 8.42 8.14 8.09
16718 22 85622214.29 ARAC 10: 15.35 15.46 15.64 15.15 15.43 15.36 13.95
16719 19 103627142.86 ATLU 11: 56.25 56.40 58.65 57.11 55.54 56.42 55.28
16720 19 81776942.86 BMY 13: 62.08 61.98 62.32 59.35 58.37 59.25 60.05
16721 20 92529557.14 BBY 14: 72.12 70.49 69.82 71.72 70.91 71.30 71.13
16722 18 71472171.43 BTC 15:378.61 380.64 376.96 369.84 377.63 376.26 376.47
16723 25 91464971.43 ABMD 16: 19.10 19.20 20.00 20.20 19.43 19.13 18.32
16724 26 87903028.57 BOX 18: 15.74 15.65 15.23 15.02 14.74 14.61 14.55
16725 27 69486700.00 BHI 21: 25.04 24.17 24.90 24.53 24.17 25.40 25.54
16726 16 69650771.43 AKS 22: 15.87 15.83 15.35 15.45 15.23 15.09 15.28
16727 22 110229428.57 ASCMA 24: 17.62 17.49 17.87 17.76 17.47 16.97 17.40
16728 19 108894914.29 ALV 27: 50.92 48.50 50.19 46.14 49.44 49.78 51.71
16729 16 94251114.29 C 28:476.00 475.20 474.70 475.00 474.60 475.70 476.00
16730 21 68916257.14 BLS 31: 18.42 18.67 61.23 60.99 60.97 61.23 61.02
16731 19 112941771.43 ANRA 32: 69.60 70.90 70.60 69.60 68.00 68.30 70.90
16732 13 114624785.71 CAR 34: 33.41 34.67 33.01 31.90 31.79 31.98 32.31
16733 <------------------------------------------------->
16734 1 2 3 4 5 6 7
16735
16737 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.65456387
16738 -Sum: -0.17652363 +Sum - -Sum: 0.83108750 last col W, previous N
16739 :3300: -----------------------------------------------
16742 :3216: run: 2 counter: 12
16744 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 3984.44 = 6033.56
16745 :3501: Before if - Stock counter: 0 <---=> 3 <-: minDB
16746 :3502: Not invested fraction %deltaPrice: 6033.56/ 10018.00 = -0.6022721
16747
16748
16749 :3192: PORTFOLIO Selected Stocks ppDB
16750 WORKSHEET 4 D[33, 7] FLOAT
16751 A B C D E F G
16752 >-------------------------------------------------<
16753 9 16855257.14 CAMP 1: 20.90 21.00 21.15 21.16 21.03 21.11 21.36
16754 15 4024342.86 ANRA 3: 68.60 69.50 69.70 67.20 68.60 70.10 68.70
16755 12 12809071.43 BTC 4:348.24 349.35 345.37 330.22 320.02 310.34 317.78
16756 14 11218557.14 ASCMA 5: 17.17 17.04 17.29 17.43 16.51 16.92 15.76
16757 15 12312657.14 BOOM 7: 17.84 18.55 18.46 18.95 19.02 19.40 18.38
16758 11 11948214.29 BF 11: 64.34 65.60 64.40 64.19 64.50 64.29 65.78
16759 16 15392085.71 AMCSA 14: 35.11 35.02 35.12 35.00 34.75 34.34 33.71
16760 10 11894171.43 ABT 29: 51.41 51.65 50.96 52.42 52.14 52.46 52.53
16761 10 16528271.43 ABMD 30: 19.80 19.37 19.71 19.25 19.34 20.41 20.00
16762 9 19145600.00 BOX 33: 15.11 15.16 15.24 15.05 14.71 14.53 14.52
16763 <------------------------------------------------->
16764 1 2 3 4 5 6 7
16765
16767 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.94171265
16768 -Sum: -0.02208719 +Sum - -Sum: 0.96379985 last col W, previous N
16769 :3300: -----------------------------------------------
16772 :3216: run: 2 counter: 7
16774 :3500: deltaPrice = myInvestment - portfolioInvestment: 10018.00 - 5856.76 = 4161.24
16775 :3501: Before if - Stock counter: 0 <---=> 3 <-: minDB
16776 :3502: Not invested fraction %deltaPrice: 4161.24/ 10018.00 = -0.4153767
16777
16778
16779 :3192: PORTFOLIO Selected Stocks ppDB
16780 WORKSHEET 4 D[28, 7] FLOAT
16781 A B C D E F G
16782 >-------------------------------------------------<
16783 18 32754771.43 BOX 5: 14.96 15.01 15.32 15.30 15.22 15.47 15.34
16784 12 30529514.29 ANRA 8: 71.40 71.50 72.00 67.80 68.10 70.00 71.10
16785 18 35065500.00 BBY 26: 75.63 76.22 76.83 77.78 78.25 78.60 78.51
16786 9 36591614.29 BOOM 28: 15.02 15.00 15.41 13.93 12.20 11.74 11.09
16787 <------------------------------------------------->
16788 1 2 3 4 5 6 7
16789
16791 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.82509210
16792 -Sum: -0.12095834 +Sum - -Sum: 0.94605044 last col W, previous N
16793
16794
16795 :3192: PORTFOLIO Selected Stocks ppDB
16796 WORKSHEET 4 D[28, 7] FLOAT
16797 A B C D E F G
16798 >-------------------------------------------------<
16799 18 34264171.43 BOX 5: 14.96 15.01 15.32 15.30 15.22 15.47 15.34
16800 12 32038914.29 ANRA 8: 71.40 71.50 72.00 67.80 68.10 70.00 71.10
16801 19 27680257.14 BBY 26: 76.22 76.83 77.78 78.25 78.60 78.51 78.78
16802 9 38101014.29 BOOM 28: 15.02 15.00 15.41 13.93 12.20 11.74 11.09
16803 <------------------------------------------------->
16804 1 2 3 4 5 6 7
16805
16807 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.83210987
16808 -Sum: -0.14339797 +Sum - -Sum: 0.97550783 last col W, previous N
16809
16810
16811 :3192: PORTFOLIO Selected Stocks ppDB
16812 WORKSHEET 4 D[26, 7] FLOAT
16813 A B C D E F G
16814 >-------------------------------------------------<
16815 15 129319885.71 AAPL 2: 21.97 22.31 22.08 22.26 22.21 22.41 22.60
16816 16 118918828.57 ANRA 8: 68.10 70.00 71.10 71.60 74.10 75.50 77.00
16817 9 131670157.14 AMD 20: 7.54 7.67 7.50 7.19 7.00 7.22 7.06
16818 25 130159542.86 BBY 26: 78.78 78.25 78.30 75.47 75.95 70.62 19.08
16819 <------------------------------------------------->
16820 1 2 3 4 5 6 7
16821
16823 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.81801878
16824 -Sum: -0.04441015 +Sum - -Sum: 0.86242893 last col W, previous N
16825
16826
16827 :3192: PORTFOLIO Selected Stocks ppDB
16828 WORKSHEET 4 D[27, 7] FLOAT
16829 A B C D E F G
16830 >-------------------------------------------------<
16831 15 131170685.71 AAPL 2: 21.97 22.31 22.08 22.26 22.21 22.41 22.60
16832 13 131723971.43 BHI 3: 25.32 26.40 26.13 26.29 27.08 27.39 27.99
16833 16 120769628.57 ANRA 8: 68.10 70.00 71.10 71.60 74.10 75.50 77.00
16834 9 133520957.14 AMD 20: 7.54 7.67 7.50 7.19 7.00 7.22 7.06
16835 9 133081557.14 BF 25: 62.50 63.19 63.34 62.87 63.08 63.30 63.83
16836 25 132010342.86 BBY 26: 78.78 78.25 78.30 75.47 75.95 70.62 19.08
16837 15 123555814.29 ARAC 27: 17.69 17.46 17.12 17.44 17.55 17.17 17.98
16838 <------------------------------------------------->
16839 1 2 3 4 5 6 7
16840
16842 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.79951208
16843 -Sum: -0.19484408 +Sum - -Sum: 0.99435616 last col W, previous N
16844
16845
16846 :3192: PORTFOLIO Selected Stocks ppDB
16847 WORKSHEET 4 D[27, 7] FLOAT
16848 A B C D E F G
16849 >-------------------------------------------------<
16850 16 105354542.86 AAPL 2: 22.31 22.08 22.26 22.21 22.41 22.60 23.47
16851 13 134101871.43 BHI 3: 25.32 26.40 26.13 26.29 27.08 27.39 27.99
16852 16 162320485.71 ABMD 7: 26.90 25.60 25.25 25.00 24.78 25.40 25.76
16853 16 123147528.57 ANRA 8: 68.10 70.00 71.10 71.60 74.10 75.50 77.00
16854 10 150917014.29 BTC 11:335.25 322.40 318.99 329.98 315.34 316.53 314.12
16855 9 135898857.14 AMD 20: 7.54 7.67 7.50 7.19 7.00 7.22 7.06
16856 9 135459457.14 BF 25: 62.50 63.19 63.34 62.87 63.08 63.30 63.83
16857 25 134388242.86 BBY 26: 78.78 78.25 78.30 75.47 75.95 70.62 19.08
16858 16 94229057.14 ARAC 27: 17.46 17.12 17.44 17.55 17.17 17.98 17.44
16859 <------------------------------------------------->
16860 1 2 3 4 5 6 7
16861
16863 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.44143129
16864 -Sum: -0.25812085 +Sum - -Sum: 0.69955214 last col W, previous N
16865
16866
16867 :3192: PORTFOLIO Selected Stocks ppDB
16868 WORKSHEET 4 D[27, 7] FLOAT
16869 A B C D E F G
16870 >-------------------------------------------------<
16871 16 110438042.86 AAPL 2: 22.31 22.08 22.26 22.21 22.41 22.60 23.47
16872 17 101372228.57 ANRA 8: 70.00 71.10 71.60 74.10 75.50 77.00 84.70
16873 15 83488771.43 BLS 22: 63.56 64.34 64.73 64.14 64.57 64.25 63.00
16874 16 99312557.14 ARAC 27: 17.46 17.12 17.44 17.55 17.17 17.98 17.44
16875 <------------------------------------------------->
16876 1 2 3 4 5 6 7
16877
16879 :3275: end normalizar el output °°° Adding Up Weights sum: 0.00000000 +Sum:0.53226496
16880 -Sum: -0.03896861 +Sum - -Sum: 0.57123357 last col W, previous N
16881
16882
17389 -------E-x-S-a-n---------->
17390 :4484: Beep ExSan has been killed
17391 hft_2731 Elapsed Time: 33 sec CHRONO START: Wed Jul 12 07:27:31 2023
17392 STOP: Wed Jul 12 07:28:04 2023
17393
17394
17395 Boost version: 1.82.0
17396
17397 EXIT FROM EXSAN
Warning No C C
Previous | Back Testing Algorithmic Trading Modern Portfolio Simulator - Some Code | Next |
Comments
Post a Comment