Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 18 May 2024 10:42:34 +0000
Post From: Trade size % when backtesting
| [2016-06-20 23:06:45] |
| Sawtooth - Posts: 4000 |
|
OK, try this in J26: =FLOOR((48000+J11)/8000) Since 50,000 is not evenly divided by 8,000, I used a 48,000 example. With 48000 and J11 at 0, the quantity is 6. With 48000 and J11 at 7999 (55999 total), the quantity is 6. With 48000 and J11 at 8000 (56000 total), the quantity is 7. With 48000 and J11 at -8000, (42000 total) the quantity is 5. The quantity changes at multiples of 8000. |