Short Price Novice Racing
I am sure I can, just thought somebody might already have an excel template for this that I could "buy, borrow or steal".
I have rarely visited a betting shop, do everything online unless I am at a racecourse (very rare sadly) when occasionally I have bet on course with predictably losing results - just not clued up (or pissed up) on those past occasions.
The extra place odds are available on Betfair exchange Ian. If you use the website, it's on a tab e.g. 4TBP (four to be placed).
I can help you with a spreadsheet to record and analyse the results if you give me a few days.
If you're still at the experimental stage you will probably also want a sheet to hold a dataset of historic exported data so you can analyse it in different ways. Again, if you decide on your factors/racecard, I can help with this.
I've seen the extra place odds; just did not know that they where called enhanced odds. Very decent of you to offer help regarding spreadsheet. I will gladly take you up on this although I did not want to cause too much trouble - I probably should be able to work this out for myself.
No pressure at all on timescales. No Novice selections for me tomorrow. Don't like the grond or the possible novice races.
I've knocked up a quick spreadsheet for you to try Ian.
I've kept it simple so there's no automation just a few formulas and functions. I've included some notes but ask if you have any questions. Let me know if anything doesn't work or anything you need changing.
Kingsoft spreadsheets are free to download if anyone looking for this
Thank you Andrew - a fantastic gift - I have a decent grasp of statistics and can work out the bigger picture but the detailed maths ability escapes me and irritates me when I use Excel. Takes me ages to create and build what evidently comes as second nature to you.
You're welcome Ian.
Been messing around with spreadsheets since the days of Lotus 123. I just poke around and work it out as I go. Never had a lesson and still can't do the really clever VBA stuff.
Shout if anything doesn't work or needs tweaking.
I do miss Lotus, macros were so much easier to write !
It probably shows our age !
I remember Lotus, but always preferred Excel! These days I prefer databases 🙂
Thanks Audrey - I shall have a look.
My life with spreadsheets started within an Acorn Electron, this used a slimmed-down version of BBC basic, which I think became popular in schools, after I left. The spreadsheet program needed an extension to the base computer, which allowed cartridges to be added. Used the knowledge gained to create files within SuperCalc on a SuperBrain computer at work. Came into contact with Excel when I purchased a newer computer. It went out of favour for a while after an upgrade, There was a lot more that could be done, but it took a long time getting to grips with the higher functions, and navigating the new menus.
Now I use excel for a lot of my records. Have attempted to use Lotus in the past, but I guess excel had become too engraved in my mind.
And Michael, databases, I use, and was given lessons at work on how to use Excel as a database program.
I never managed to figure out how to use Excel as a database. I remember trying for a bit and getting peed off and learnt MySQL instead 😀
I know we're a bit off-topic but for me it's a case of horses for courses. Database for joining data tables, storage etc. then export data sub-sets to spreadsheet for analysis. If my analysis were repetitive I might go to the trouble of learning SQL but for me analysis is quicker and more flexible in Excel.
With modern computer power and memory (64 bit addressing), Excel + Power BI makes it feasible to link Excel direct to csv tables and act like a database. However, when working with the whole database (1.2 million records and 100+ fields) it can be a bit a bit sluggish.
Big data and AI have certainly added a whole new dimension to predictive analysis (and manipulation).
My life with spreadsheets started within an Acorn Electron, this used a slimmed-down version of BBC basic. The spreadsheet program needed an extension to the base computer, which allowed cartridges to be added.
Blimey Paul, that must have been a challenge. I waited until I had the luxury of an PC clone with an 8086 processor before tackling spreadsheets. Hard to visualise those pre-GUI spreadsheets now but at the time we thought they were great.
Time for an update:
So a bit of a mixed bag - not progressing but still a small profit. No need to give up on the strategy as yet. 23 bets have been made. The strategy is beginning to become a part of me - I want it to work but I have to accept that my thinking is not communicated to the race track. It becomes interesting to await the next result. Slowly but surely you assess this process as a probability game... devoid of emotion, well not quite.
I will go through briefly each bet. I'll get better at this, hopefully, as we go along, as I admit I have not been taking notes on every bet, in fact any.
So for new readers check previous posts to find the last screenshot of the results. Better still read the whole thread.
Jatiluwih - qualifier so straight back bet and result.
Lyricist Voice - 12 runners and this horse well backed but close odds with Overpriced Mixer (eventual fav), I chose to place bet this one and result was a result with my horse in 2nd. Not sure I will do this again as caught out later with same strategy (Qaseeda).
Gold Legend - qualifier so straight back bet and result.
Qaseeda - I had assessed this race as between Qaseeda and So Sharp. Qaseeda was odds on BUT there was not a significant gap between the two. The rest seemed clearly out of touch. So I went for a place bet on Qaseeda who only managed fifth. Ummm...
Tsar - qualifier so straight back bet and result.
So basically in one day Qaseeda spoiled my party...
Echiquier - qualifier so straight back bet and result.
Minella Beat - qualifier and just odds on but just beaten - probably just one of those things - winner returned at 23 BF
Lucky Flight - qualifier so straight back bet and result. This one also appeared on my other system for CD winners - I used to think that this validated my choice but bear in mind that qualifier under one system does not necessarily validate a qualifier in another.
So still in profit but not progressing - if and when we do pass the milestone (set after the nine successive wins) then the whole strategy will probably lose interest for this forum. We are not there yet.
Thanks for reading.