I posted this last week on a page. But it occurred to me that most people land on the posts page and may not have spotted it 🙂
Excel integration in Gruss is something I have used for many years. The reason is it’s very straightforward and I am not to clever. I am no expert in Excel by any means, and everything I have learned is thanks to YouTube and the generosity of other people.
What I wanted to do is introduce Excel to the guys who would be scared to have a go with it. There is no doubt it’s daunting at first. But you know what? It isn’t that bad once you get into it.
So what I have done is created a “simple” sheet that will enable you to Lay, In Play once a certain price is met. Big Deal! I hear you cry. But it isn’t about the strategy (that may or may not work). It’s about getting you thinking about how you could try out something and showcase what can be done. I don’t want to turn this into a Excel lesson. I am rubbish at it. I’m sure someone will watch this and manage to do the same thing with half the formula’s that I did. There is a guy on the Gruss Forum who is legendary with helping people with Excel related stuff. I stress again. I am a beginner. I say several times in the videos that I was unsure about sharing this sheet and how I didn’t want to spend hours helping you with Excel equations. But that’s what I do. help people. So give me a try and I’ll do my best. With no promises of success! Will I share my sheet? Well if you watch the videos, there is no reason why you cannot replicate it exactly. The only reason i can see you would ask for the sheet is if you can’t be arsed to try for yourself. I have taken the time to show you, so it’s a learning experience 🙂
So what does the sheet do?
I have set up a series of cells that will show when a certain condition you specify is met. Once all the criteria is met, then a bet is triggered via Excel to Betfair. The criteria can be adjusted easily using a “command” cell. I’ll run though all the formatting, connection to Gruss and the Excel formula required to make the sheet work. I hope that my videos explain the process in simple terms.
Please don’t ask for the sheet – I am not being “funny” or miserable about this. I want to educate and stimulate ideas. These videos are a DIY kit and hopefully opening a door into the murky world of Excel. Hope it’s of use.
Remember to TEST the sheet and ensure you have MINIMUM stakes possible BEFORE you connect the sheet. You can lose a lot of money if you get it wrong. You can test the sheet by DISCONNECTING it and typing in the data required to trigger the sheet. As I did in the videos.