Data-capture spreadsheet

Post Reply
User avatar
mugsgame
Posts: 1235
Joined: Wed Mar 25, 2009 11:41 pm

Personally I am gutted to hear about Switesh's quitting. He told me last week. I tried to talk him out of it. But was is determined to quit.

He was one of the most generous and genuinely nice guys I have come across during my time trading. He is super intelligent and has an open mind. Like I said to him."You will be successful in whatever you do".

I am hoping he may come back after a break. I think we all go through the tough times trading. You have periods of darkness that make you feel like you want to try something else. I'm sure all of us who have been at it for a while understand that you have to put a serious amount of time and hard work into getting to the point where you actually make decent money. Switesh did that (and some) I think he was so close to that tipping point.

I thought long and hard about quitting no so long back. Not because of money or how successful I am. Just because sitting in a dark room in your underwear day after day sort of sucks the life out of you.
For me that corner has turned and I am full of energy and enthusiasm for my new projects. I think my 6 stone weight loss has the most to do with this. I feel reborn. But the weight gain was due to my trading lifestyle (and the fact I am a lazy bastard) :)

I am sure that everyone who Switesh has helped along his journey would join me in wishing this thoroughly nice chap all the very best in whatever he does. I hope to see him grace these pages again one day.

MG
Top
User avatar
LeTiss
Posts: 5480
Joined: Fri May 08, 2009 6:04 pm

I know Switesh would have been a serious success had he stuck at it. Maybe he joined Sports Trading 5 years too late, as manipulation and powerful bots have changed the landscape, making it more unpredictable in the eyes of newcomers and this effects one's confidence

Ultimately, we also don't know what Switesh's financial situation is - perhaps he cannot afford to keep making small amounts for a sustained period. I was lucky, I would never have stuck at this game without having had a decent lump behind me when I entered.

Also, I know first hand how this trading game leads to difficulties in maintaining a social/love/family life - it's not easy getting the balance right, but if you're in Australia and you're trying to trade UK markets during the middle of the night, that simply intensifies the need to make this work sooner rather than later

All the best to him anyway, and thanks for the excellent spreadsheet!
Top
drans33
Posts: 19
Joined: Thu Jun 07, 2012 10:05 am

images/icons/misc/star.gif
Without doubt the Switesh Pre-Off data-capture spreadsheet is a 'Masterclass' and yes he appears to be a very humble guy.
Yes it surprises me to learn that he's giving up, it could be for abundance of reasons. Maybe he should create a spreadsheet that includes all factors that made him draw his opinion to stop and grade the points by a mark of 1 to 10 (Then have a tipping point)
1. Is trading neglecting family and personal life.
2. Not a sufficient a bank roll, to sustain long losing periods.
3. Chosen trading strategies not working.
4. Not enough knowledge of Excel or Automation.
5. A more paid job offer.
6. Too many hours trading.

These are some of the questions that could be graded.

1. You you must create a balance and spend time with your love ones.
2. I guess Switesh is intelligent enough to adjust his own personal bank roll.
3. This could be his weakness, for watching his video, he several times relates to not knowing if the chart data etc would be helpful .. I guess he spent so long developing this fantastic spreadsheet and did not have too much time to analyse all this data.
4. This would clearly not be Switesh's problem.
5. Could well have been offered a better paid job. Although his knowledge would allow him to set up certain automation to run in the background.
6. Too many trading hours, yes we should all try and create a balance of quality time off and time with our loved ones.

Whatever Switesh's new path is, he should take pride even if he suffered some losses .. for the road of life has twists and turns and who knows it may lead him back .. " Stronger and Wiser "

Personally I feel his spreadsheet is uber useful, if the data is then related to other factors.

Good luck to Switesh for the future.
Top
garymarlow
Posts: 5
Joined: Thu May 08, 2014 12:10 pm

This really is an astonishing piece of work for someone who claims not to be an Excel guru.

One specific point of interest - what are other forum users' thoughts about what the price action of a horse during the last five minutes before the off can actually tell us.

The natural assumption is that the more a horse drifts, the merits of a lay come into play. Conversely, one that's shortening might warrant a bet.

However, if 'the market always knows best', does that simply mean the chances/probability have now been factored in (and the smart investors are those who did their backing/laying prior to the price movement?)

Has anyone carried out volume analysis which points to whether a late market drift/shortening in price is especially significant? Obviously I wouldn't wish anyone to share anything that's particularly lucrative!
Top
LinusP
Posts: 1917
Joined: Mon Jul 02, 2012 10:45 pm

I think betfair did a study on it and there used to be a slight edge in backing drifters. Look at the 1420 at goodwood, the fav drifted from 1.5 to 3+ and it won..

Peter has mentioned that there is value there but I doubt anyone will give away their secrets :D
Top
User avatar
mugsgame
Posts: 1235
Joined: Wed Mar 25, 2009 11:41 pm

LinusP wrote:I think betfair did a study on it and there used to be a slight edge in backing drifters. Look at the 1420 at goodwood, the fav drifted from 1.5 to 3+ and it won..

Peter has mentioned that there is value there but I doubt anyone will give away their secrets :D
Everyone loves a secret :)
Top
kidis21
Posts: 5
Joined: Wed Jun 26, 2013 1:00 am

Thank you very much, for our work. Hope that this spreadsheet would bring much needed light into some of my questions. Thank you again.
Top
burdo77
Posts: 351
Joined: Sun Jun 09, 2013 4:13 am

i cant download this sheet, is it no longer available?
Top
bariska
Posts: 2
Joined: Thu Sep 25, 2014 3:54 am

yep same problem for me , cant download ...
Top
doncht
Posts: 74
Joined: Mon May 05, 2014 3:57 pm

Is there a new link already? I tried it earlier but it's not working. Thank you in advance.
Top
switesh
Posts: 527
Joined: Mon Jul 11, 2011 8:43 am

Google Drive:
https://drive.google.com/open?id=0B8rbB ... authuser=0

Dropbox:
https://www.dropbox.com/s/zxnp9q6ib6y2w ... .xlsm?dl=0
Top
User avatar
gazuty
Posts: 2556
Joined: Sun Jun 26, 2011 11:03 am

Welcome back Switesh.
Top
bilko
Posts: 147
Joined: Thu Oct 29, 2009 8:56 pm

Hi Switesh

Thanks for the spreadsheet.
Read your post on Steve's site glad to see you back.
Your a highly intelligent guy.
Thanks again for sharing.
Top
nickdelves
Posts: 11
Joined: Fri Oct 03, 2014 7:37 pm

Hi All

Looking for a data capture sheet to get similar results to PW as per here:-
http://www.betangel.com/blog_wp/2015/02 ... um=twitter

Is the sheet provided here my best option?

Thanks
Nick
Top
cains
Posts: 36
Joined: Mon Aug 20, 2012 8:01 pm

Any macro experts that can help with this great excel sheet.
I cant trade horses, so im looking to use this sheet for soccer. I want to record odds both pre match and inplay, to see if i can sport some market trends. But where do i set the timer to do this ??
Im looking to get 15min prematch and inplay from 45min to 65min.

Dont think i can see it in the start timer macro sheet where to make the changes.

Hope someone can help.

/ Carsten
Top
Post Reply

Return to “Betfair Data”