Assign a Bank to a Strategy
Would it be possible to assign a bank to a specific strategy that could keep a running profit and loss(in guardian) to allow for progressive staking for that strategy? So if bet one wins and you are staking 1% of a 100 point bank and it increased by 5 points your nect bet with that strategy would be based on 1% of 105 points. Likewise if the reverse were true?
-
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
- Location: Wolverhampton
Within a spreadsheet I use a formula which refers to the 'balance' cell C6.
So:
=IF(C6>10,2,"") (IF balance is greater than £10 then stake £2, if not then £0)
You could chain these so overtime you hit a profit target the stake increases or if it drops below it decreases. I use a semi-complicated one in this manner. I'm not sure how you would go about using this for multiple strategies (Perhaps if you could quantify each strategy so a designated cell would show "Strategy A", "Strategy B" etc and then combine this information with the previously stated chained formula? I hope this has helped or at least given you a little food for though.
\/ Example of a chained staking plan for £2,£4,£8 stakes \/
=IF(C6>10,2,IF(C6>50,4,IF(C6>100,8,0)))
Callum
So:
=IF(C6>10,2,"") (IF balance is greater than £10 then stake £2, if not then £0)
You could chain these so overtime you hit a profit target the stake increases or if it drops below it decreases. I use a semi-complicated one in this manner. I'm not sure how you would go about using this for multiple strategies (Perhaps if you could quantify each strategy so a designated cell would show "Strategy A", "Strategy B" etc and then combine this information with the previously stated chained formula? I hope this has helped or at least given you a little food for though.
\/ Example of a chained staking plan for £2,£4,£8 stakes \/
=IF(C6>10,2,IF(C6>50,4,IF(C6>100,8,0)))
Callum