....matched.
How could I mess about with Excel to pick out the highest/lowest matched runners?
Im at a loss, just doing trial and error jut now but nothings sticking.
Are there any example shets out there with the matched totals listed as a triger?
New to BetAngel, want to bet on horses depending on total ma
-
marketgarden
- Posts: 15
- Joined: Fri Jan 31, 2014 11:28 am
So far I've been able to create a separate spreadsheet that extracts the traded volume from the default betangel market and then sorts the runners in order of volume rather than the horses number.
I guess that answers the first part of my question above but now I'm at a loss on how to use the second spreadsheet to place a bet.
The videos are helpful but they dont go into enough detail for my experience level.
I guess that answers the first part of my question above but now I'm at a loss on how to use the second spreadsheet to place a bet.
The videos are helpful but they dont go into enough detail for my experience level.
-
marketgarden
- Posts: 15
- Joined: Fri Jan 31, 2014 11:28 am
Forget that, as the data updates, the second spreadsheets table doesnt stay sorted in the order I want to view it in.
Try again...
Try again...
-
marketgarden
- Posts: 15
- Joined: Fri Jan 31, 2014 11:28 am
Sorry for the posts lol.
OK, I have figured out how to manipulate the bet angel side of things to view the runners in the order I want.
I wont post again.
OK, I have figured out how to manipulate the bet angel side of things to view the runners in the order I want.
I wont post again.
-
marketgarden
- Posts: 15
- Joined: Fri Jan 31, 2014 11:28 am
OK.
I will learn how to use the rank function.
First I'll try to learn what a function is.
I will learn how to use the rank function.
First I'll try to learn what a function is.
-
marketgarden
- Posts: 15
- Joined: Fri Jan 31, 2014 11:28 am
viewtopic.php?f=31&t=7397
im currently trying to back engineer this spreadsheet to do the same thing but with the traded volume.
Easier said than done, I've no idea how hes managed to sort the runners by their price but I will get there.
im currently trying to back engineer this spreadsheet to do the same thing but with the traded volume.
Easier said than done, I've no idea how hes managed to sort the runners by their price but I will get there.
-
marketgarden
- Posts: 15
- Joined: Fri Jan 31, 2014 11:28 am
Well, I'm half way there now, just need to figure out the code for placing bets with triggers and things direct form a spreadsheet.
-
marketgarden
- Posts: 15
- Joined: Fri Jan 31, 2014 11:28 am
So I have manipulated the spreadsheets, I have got the runners moving around in the order I want, I just cant seem to transfer the data back to the 'Bet Angel' sheet so that I can type in bets to be placed.
None of the tutorial videos have this info there, just how to create a custom spreadsheet and how to order a bet on the main one, no explanation of how to either bet form the new custom sheet or how to transfer data back to the first one.
Unless I've missed something?
None of the tutorial videos have this info there, just how to create a custom spreadsheet and how to order a bet on the main one, no explanation of how to either bet form the new custom sheet or how to transfer data back to the first one.
Unless I've missed something?
-
marketgarden
- Posts: 15
- Joined: Fri Jan 31, 2014 11:28 am
Looks like I'm out of my depth.
I can create the spreadsheet that dynamically updates as the bets are being placed, I can call in the data from the next race in chronological order easy enough, I just cant seem to find a way to place the bets that I want automatically.
As for learning an entire programming language to learn what will end up being one line of code, I can't justify the time.
There has to be a way here, the bet angel software is pretty awesome.
I can create the spreadsheet that dynamically updates as the bets are being placed, I can call in the data from the next race in chronological order easy enough, I just cant seem to find a way to place the bets that I want automatically.
As for learning an entire programming language to learn what will end up being one line of code, I can't justify the time.
There has to be a way here, the bet angel software is pretty awesome.
M
Unfortunately there is no quick way.
Myself or a number of others on here could no doubt create a spreadsheet that does what you want, but we would be doing you no favours. There will come a time when you may tweak/adjust it in some way and if its wrong, your full bank will be gone.
My advice: Watch all the bet angel videos on excel. Watch them again. (Everything you need is shown in one video or another)
Create a very simple excel worksheet, then slowly start to build outwards (NB: USE THE PRACTICE MODE!). I have some spreadsheets that are now >80 columns wide and full of VBA. I knew virtually nothing of excel/VBA when I started.
The journey is important as you will learn what works and what doesn't.
regards
Peter
Unfortunately there is no quick way.
Myself or a number of others on here could no doubt create a spreadsheet that does what you want, but we would be doing you no favours. There will come a time when you may tweak/adjust it in some way and if its wrong, your full bank will be gone.
My advice: Watch all the bet angel videos on excel. Watch them again. (Everything you need is shown in one video or another)
Create a very simple excel worksheet, then slowly start to build outwards (NB: USE THE PRACTICE MODE!). I have some spreadsheets that are now >80 columns wide and full of VBA. I knew virtually nothing of excel/VBA when I started.
The journey is important as you will learn what works and what doesn't.
regards
Peter
-
marketgarden
- Posts: 15
- Joined: Fri Jan 31, 2014 11:28 am
Yep, I think I've cracked it using this in a horribly convoluted fashion, using half a dozen if's-
http://www.betangel.com/user-guide/crea ... =&sct=NTg1
but hey, I'm no programmer, if it works it works.
http://www.betangel.com/user-guide/crea ... =&sct=NTg1
but hey, I'm no programmer, if it works it works.