Support Board
Date/Time: Thu, 06 Mar 2025 19:12:34 +0000
Post From: Multiple Spreadsheet System for Trading on the same instrument
| [2022-02-09 12:22:14] |
| FTDK - Posts: 13 |
|
I managed to get it working as i wanted to, first test seem to confirm that everything is working like it should. Everything is in 1 spreadsheet now, it took me quite some time to develop this system. All formulas combined (all entry formulas and SL price level and TP price level formulas) are close to 8 A4 sides, so it was a lot of work and these 8 pages of formulas are just for 1 instrument. Luckily i can now just use the same formulas for any other instrument. This is how i have done it to calculate the buy TP price levels (first 2) and short TP price levels (last 2): =IF(AND(FORMULA1), Z3-(Z3-D7)-0.25, IF(AND(FORMULA2), Z3-(Z3-D7)-0.25, IF(AND(FORMULA1), Z3+(C7-Z3)+0.25, IF(AND(FORMULA2), Z3+(C7-Z3)+0.25, 0))) And so on depending on how many different formulas you need. So now i get the stop or target price level for formula 1, if formula 1 is true, if formula 2 is true i get the levels for formula 2, if none are true it displays 0. The system is designed in such a way that there is never more than 1 formula true at the same time. I avoided getting multiple entries by only allowing 1 trade at a time and using the trading position quantity study in my formulas, so if a position is open and a new entry formula is true, it doesn't enter a trade and it doesn't calculate new stop or target levels. In total i am using about 56 formulas (per instrument), just to calculate all the stop and target levels my different entry systems are needing. I never expected it would be possible to create such a complex system in the Spreadsheet for trading study, but i am glad i didn't give up one it ;). Date Time Of Last Edit: 2022-02-09 12:25:19
|