Excel Place Program

This a 'Target Betting'strategy. The target can be any amount. Lets say for this example it is $50. First bet has odds/price of 1.70. First bet should be whatever is required for a profit of $50. This is decimal odds betting (e.g. even money is 2.00 which means if I put $1 on and win, I would receive $2 back in total which is a profit of $1; if odds are 1.70 and I put $1 on and win, I receive $1.70, a 70 cent profit etc) This is also a loss recovery plan. If a bet loses, the next bet will be the plan target of $50 PLUS the previous loss. So scenario is that all accumulated losses are rolled into the next bet PLUS target. This could conceivably be 10 losses in a row. Each loss rolls into the next bet PLUS the target of $50.

In the very simple Excel example provided (attached), first bet in the sequence, A2 is multiplied by B2 by amount that is required to reach a PROFIT target of $50 (i.e. if I want a profit of $50 and the price is $1.70, I must place a bet of $70.50 to get return of $119.85 i.e. a $50 profit over and above my stake). In the example, I lose. C2 is result Win or Lose column. D2 is the cumulative profit or loss. If win at C2, next row is as normal i.e target of $50 etc. However, If a loss at C2, A3 bet is to recoup the $70.50 PLUS original target of $50. All losses keep accumulating and each bet is calculated to recoup all previous losses. All of these calculations are dependant on the price in the B column.

The prices at B are decimal and start at 1.01 with increments of 1 cent all the way to infinity. Can I have the ability to change target amount in the same worksheet? If not, different target amounts like $10, $20, $50, $100, $150, $200 on separate sheets would be good so I can adjust my strategy upper or lower depneding on my bank.. Hope this makes sense. Tried to make it as clear as I can , but im not a great explainer of detail. Could you give a quote on this?

Εισαγωγή Δεδομένων Επεξεργασία Δεδομένων Excel Αρχιτεκτονική Λογισμικού Visual Basic

Ταυτότητα Εργασίας: #17976634

Σχετικά με την εργασία