Auto staking based on hedged outcome

[Blondie]

I have toyed around with staking approaches. I am trying to get stakes for each ladder that will produce the same amount of money per tick after hedging. Ive used auto staking based on tick size, but after hedging its very different. is there any solution?

[ShaunWhite]

It's not possible because the difference in hedged amount changes between each tick. Even one tick up and one down aren't equivalent and that's without the step size changes.


.

[Blondie]

I wondered if it wasn't possible, now i know, thx.
Whats the next best thing? I would guess at least some people want a similar kind of thing, to make each trade on any ladder/price to equate to a roughly similar amount of profit after hedging. Maybe just manual staking is the way to get as close as possibe. not sure where to start other than guessing numbers and seeing how it works out. Maybe start at £10 on 2.0 and below, £5 on 3-4, £4 on 4-6, £3 6-10, £2 for higher. Does that sound like roughly a good ratio?

[ShaunWhite]

Just stake according to the risk you want in that specific situation. Having the same £/tick on everything doesn't make sense. And let's say you bet 20, it does want you expect so you have another 10, then later take half out because the run is petering out, what £/tick then? 'Trading' isn't having pairs of bets.

[Euler]

The way you should be trading is to trade in and out of a position and then when complete hedge your position at that point. It doesn't make sense to hedge as you go.

If you have a stake of £10 and trade a 10% profit on it five times. Your total market risk has decreased on each trade. So your trading should be focused on that and only hedging when that process is complete.

[Blondie]

Bet Angel has a feature to auto stake based on tick size. Why have that if my point isn't at least of interest to some people? I just wondered if that can be extended to apply to hedged £ per tick, rather than unhedged £ per tick which is already a feature.

It isn't for a way to trade. I am just curious that if for example I think the favourite is going to move 10 ticks, i can take those ticks or i could try trading a drift on the second favourite instead. I am playing with numbers and just trying to get a feel for how the returns differ for trading one ladder or another one. wanted to see how 7 ticks on ladder 2 at 4.5 compared to 7-10 ticks on ladder 1 at 1.95, madeup numbers here.

I know it cant be done and i understand why now. was just playing and wondered so thought i'd ask in case someone had some plug-in or servant that did something like it.

[ShaunWhite]

.. . wanted to see how 7 ticks on ladder 2 at 4.5 compared to 7-10 ticks on ladder 1 at 1.95, madeup numbers here.

You're best option is to knock up a spreadsheet with price and size cells, and a line for each ladder step with the calculated hedged amount.

Hedged = pl if it loses + (( pl if it wins - pl if it loses) /closing price)

Eg back 50 at 3....and close at 2.8
(-50 + ((100 - - 50)/2.8) = 3.57

[Blondie]

Thank you. i have never used excel and formulas are not my strong point! I will just guess and adjust. i really want to find a way to track my results. nothing too complex but to be able to see which types of races/odds i win or lose most on. that would be really useful. i looked at some threads and looks like have to use excel for that. i dont have it. i can get free office (libre office or whatever) but it probably wont work the same. i am going to have to learn about excel properly i reckon

[tico]

Hi Blondie,

I was just wondering if this could be done in Excel (using VBA perhaps) I used to do something similar year ago on other software ,but similarly BA also facilitates the use of Excel . I Have used excel with software(BA) to say things like 'If a price falls below a certain level then lay/bet it in relation to volume etc etc blah blah ad infinitum '.So there is a possibility that you could automate most other stuff.
Kinders
tico

[ShaunWhite]

You can buy an Office Pro licence (word excel etc) for under 20 quid. Search for Cheap Excel Key. Eg https://www.productcodes.co.uk/product/ ... LEEALw_wcB

I think most would say basic Excel is essential, and Udemy do quality free courses.

[Blondie]

Hi Blondie,

I was just wondering if this could be done in Excel (using VBA perhaps) I used to do something similar year ago on other software ,but similarly BA also facilitates the use of Excel . I Have used excel with software(BA) to say things like 'If a price falls below a certain level then lay/bet it in relation to volume etc etc blah blah ad infinitum '.So there is a possibility that you could automate most other stuff.
Kinders
tico

Title of the thread wasn't a good choice! I am not looking at any automation stuff, just want to get my P&L tracking soon to see which race types win/lose me the most. But looks like you need to be an Excel guru to do that!

[Blondie]

You can buy an Office Pro licence (word excel etc) for under 20 quid. Search for Cheap Excel Key. Eg https://www.productcodes.co.uk/product/ ... LEEALw_wcB

I think most would say basic Excel is essential, and Udemy do quality free courses.

Useful link that thanks. I didnt know it could be got for that sort of money. I saw £150 somewhere which shocked me. I was going to try to find Excel on its own but no need to if can get office suite for £20 or so.
The learning task still needs doing which is a bit scary, I wonder how much time it will take to get to the level needed to understand these complex P&L analysis spreadsheets. think i saw some on the board here. But i know i really must analyse my results soon to see any patterns. i am sure there are some.

[Dallas]

Hi Blondie,

I was just wondering if this could be done in Excel (using VBA perhaps) I used to do something similar year ago on other software ,but similarly BA also facilitates the use of Excel . I Have used excel with software(BA) to say things like 'If a price falls below a certain level then lay/bet it in relation to volume etc etc blah blah ad infinitum '.So there is a possibility that you could automate most other stuff.
Kinders
tico

Title of the thread wasn't a good choice! I am not looking at any automation stuff, just want to get my P&L tracking soon to see which race types win/lose me the most. But looks like you need to be an Excel guru to do that!

Try this method, no excel skill needed just a bit of copy/pasting at the end of each day
viewtopic.php?t=12327

[Blondie]

Thanks Dallas. I'll have a read - sounds right up my alley!

[ShaunWhite]

You don't need to be a guru. It's loading the BetHistory.csv, sorting it by whatever is useful (eg matched price, time before start, side etc) , add a running total, highlight that and 'insert chart'. One decent session guided by gpt would do it. You'll need Excel if you're serious so it's an easy one to start with.