VBA developer

[MemphisFlash]

the sheets i create are no where near as complicated as this. i did not know VBA code before i started with bet Angel. i am mostly self taught from you tube clips and i work with excel so i have people around me that can help if i get in a jam. this is way out of my league. there are too many sub routines i do not know where to start.

[spreadbetting]

Yep far too many routines to search thru to see where it's slowing down, looks a nightmare sheet tbh, events are left on so they'd be triggering all over the place and just copying and pasting code into each sheet really isn't the way to code things properly. Hope you didn't pay too much for it

[michaelg2708]

I know it's not great and there is alot of code that probably isn't needed and paid too much for it but it has got me to a stage where I know I have a good strategy just need the sheet to be quicker to get out the kinks. If there are any VBA developers reading this that are able to do this for a price please get in touch
Cheers, michael

[spreadbetting]

I know it's not great and there is alot of code that probably isn't needed and paid too much for it but it has got me to a stage where I know I have a good strategy just need the sheet to be quicker to get out the kinks. If there are any VBA developers reading this that are able to do this for a price please get in touch
Cheers, michael

Did they do a custom sheet to your spec or just tweak one of their own because if half the stuff isn't needed you might be better off just getting someone like nigel to code one from scratch to your exact specs. If there's a lot of unneccesary bits leftover from their sheets it might be best just to start from scratch as it's always hard to try and tweak a poorly coded sheet and sometimes best just to scrap it. Hopefully you'll get someone to do it as if it makes you money it's worth paying the initial outlay as bots can be easy money makers

[michaelg2708]

They just tweaked one of their own. Was emailing Nigel back and forward then he stopped replying so I posted on here to see if anyone else could help, fingers crossed

[Derek27]

If you've got the time, it may be worth learning the basics of VBA and see if you feel you might be able to manage it on your own. It can be quite surprising how quickly you pick things up once you get started.

[michaelg2708]

That had went through my head and at this stage it's looking like thats the only option but I'll miss the summer racing then. Only started using excel when I started using bet angel before that I didn't even know there was such a thing as an IF function. I would rather pay to get it sorted quickly and start making money

[spreadbetting]

Do they all need to run off the same sheet, i.e could you split up the sheets into individual ones to run your strategy?

[michaelg2708]

I use it to make custom graphs so sheet 1 is the first race with custom graphs and sheet 2 is the next race and so on. Each sheet is separate and doesn't affect any other sheet if that's what u mean

[Kafkaesque]

That had went through my head and at this stage it's looking like thats the only option but I'll miss the summer racing then. Only started using excel when I started using bet angel before that I didn't even know there was such a thing as an IF function. I would rather pay to get it sorted quickly and start making money

That last sentence is a bold statement If you're that certain it's a money-spinner, then by all means pay someone for it. If you're not as certain as that statement comes off, then fwiw remember that there's other benefits to learning it besides not paying someone for it right now. In learning to do it yourself, you'd be surprised at the ahaaaaa moments coming your way. These will help if and when this strategy needs tweaking, and in developing new strategies. What happens if you find a bug in the strategy? Back to paying someone to work on the nitty gritty part again?

[Derek27]

If you do decide to learn it yourself, make sure you learn good programming practices (structures, naming conventions, etc). It will make work a lot easier in the long run.

[ShaunWhite]

If you do decide to learn it yourself, make sure you learn good programming practices (structures, naming conventions, etc). It will make work a lot easier in the long run.

Narrrr, just dive in and get something working. There's plenty of time for all that dusty old stuff when you've had a little buzz of "I can do this". When you go on your hols do you want to order a beer, or learn how to conjugate verbs ?

The good practice will start to happen the first time you look at month old code, and it doesn't make any sense .

[Derek27]

If you do decide to learn it yourself, make sure you learn good programming practices (structures, naming conventions, etc). It will make work a lot easier in the long run.

Narrrr, just dive in and get something working. There's plenty of time for all that dusty old stuff when you've had a little buzz of "I can do this". When you go on your hols do you want to order a beer, or learn how to conjugate verbs ?

The good practice will start to happen the first time you look at month old code, and it doesn't make any sense .

I've got some old code I wrote in a hurry that I'm still using and it's a nightmare modifying it. Just spending half-an-hour reading about good programming practice can save you a lot of time and even get the project completed quicker!