I have a 15 stock portfolio with a dynamic weight. The weight in the portfolio is based in the "score". I wanted to create a screen formula that in some way, could mirror this weight, but I need some ideas on how to do so.
The formula is basically something like this: Target Weight = 4.78 + 0.12 * Score. So if the total score is 8, the screening formula should do be like this: Target Weight = 4.78 + 0.12 * 8 = 7.14%. ( linear regression - R^2 value of 0.98)
But fore some reason, when trying this in the screen: showvar(@Weight1,4.78+0.12*(@Totalscore)), it only shows the first number " 4.78", why?
Here is the table from Excel:
| Ticker | Action | Name | Shares | Price | Commission | Amount | Target Weight | Score | Rank | Complete | Formula weight TEST |
|---|---|---|---|---|---|---|---|---|---|---|---|
| BODI | BUY | The Beachbody Co., Inc. | 2167 | 9.14 | -19.81 | 19786.57 | 19.96 | 122.34 | 99.72 | 8.009310417 | 19.4608 |
| SRTS | BUY | Sensus Healthcare, Inc. | 1983 | 3.76 | -7.46 | 7448.62 | 7.51 | 22.66 | 99.62 | -37.5607299 | 7.4992 |
| DSP | BUY | Viant Technology, Inc. | 730 | 10.17 | -7.42 | 7416.68 | 7.48 | 22.14 | 99.94 | 7.4368 | |
| SHIP | BUY | Seanergy Maritime Holdings Corp. | 745 | 8.96 | -6.68 | 6668.52 | 6.73 | 16.17 | 99.97 | 6.7204 | |
| APT | BUY | Alpha Pro Tech Ltd. | 1040 | 6.19 | -6.44 | 6431.16 | 6.49 | 14.41 | 99.68 | 6.5092 | |
| DR:CAN | BUY | Medical Facilities Corp. | 797 | 7.56 | -6.03 | 6019.14 | 6.07 | 11.04 | 99.84 | 6.1048 | |
| DRX:CAN | BUY | ADF Group, Inc. | 969 | 5.94 | -5.76 | 5750.49 | 5.8 | 8.91 | 99.87 | 5.8492 | |
| SNPO | BUY | Snap One Holdings Corp. | 661 | 7.95 | -5.25 | 5249.7 | 5.3 | 4.98 | 99.59 | 5.3776 | |
| VLN | BUY | Valens Semiconductor Ltd. | 2355 | 2.19 | -5.16 | 5152.29 | 5.2 | 4.22 | 99.78 | 5.2864 | |
| OPTN | BUY | OptiNose, Inc. | 3381 | 1.5 | -5.07 | 5066.43 | 5.11 | 3.51 | 99.53 | 5.2012 | |
| LTRX | BUY | Lantronix, Inc. | 1490 | 3.4 | -5.07 | 5060.93 | 5.1 | 3.41 | 99.75 | 5.1892 | |
| MRAM | BUY | Everspin Technologies, Inc. | 609 | 8.04 | -4.9 | 4891.46 | 4.93 | 1.95 | 99.56 | 5.014 | |
| BDT:CAN | BUY | Bird Construction, Inc. | 349 | 13.61 | -4.75 | 4745.35 | 4.79 | 0.74 | 99.91 | 4.8688 | |
| ADEN:CAN | BUY | ADENTRA, Inc. | 160 | 29.53 | -4.72 | 4719.31 | 4.76 | 0.55 | 99.65 | 4.846 | |
| CEU:CAN | BUY | CES Energy Solutions Corp. | 1359 | 3.47 | -4.72 | 4716.99 | 4.76 | 0.41 | 99.81 | 4.8292 |