You cynical bunch!
But seriously, trust is an important aspect of what you want. But a lot can depend on what you want as market selection is obviously key also.
I built up a relationship with LeeCal before I felt I could recommend him. But if you want excel stuff you should check out: -
https://www.tigerspreadsheetsolutions.co.uk/
I've got to know Chris and he speaks the write language and is very professional.
bot builder recommendation
I see what you did there, speaks the write languageEuler wrote: ↑Wed Apr 28, 2021 8:35 pmYou cynical bunch!
But seriously, trust is an important aspect of what you want. But a lot can depend on what you want as market selection is obviously key also.
I built up a relationship with LeeCal before I felt I could recommend him. But if you want excel stuff you should check out: -
https://www.tigerspreadsheetsolutions.co.uk/
I've got to know Chris and he speaks the write language and is very professional.
Thanks for the recommendation.
- paspuggie48
- Posts: 630
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Might be more for beginners but I'd recommend looking at this website too
https://www.excel-easy.com/
Step-by-step screenshots which are very well put together and easy to understand.
https://www.excel-easy.com/
Step-by-step screenshots which are very well put together and easy to understand.
I'll take a look into that... I would really like to do more in VBA but learning through videos on topics that just don't interest me drains my attention spanpaspuggie48 wrote: ↑Sat May 01, 2021 8:21 amMight be more for beginners but I'd recommend looking at this website too
https://www.excel-easy.com/
Step-by-step screenshots which are very well put together and easy to understand.
Whenever I need to learn something Excel I go here,
https://youtube.com/user/ExcelIsFun
Look at the play list this guy has put together, it's impressive. I don't know why but what he says seems to sink in too, I think it's because he says pretty much everything twice.
Lots of excellent code available at https://www.excelforfreelancers.com/ you can download the workbooks to learn as you go
excellent for people who want to learn excel. visit the youtube channel
excellent for people who want to learn excel. visit the youtube channel
Nice, they offer a VBA course.Eyesnack wrote: ↑Sat May 01, 2021 12:02 pmLots of excellent code available at https://www.excelforfreelancers.com/ you can download the workbooks to learn as you go
excellent for people who want to learn excel. visit the youtube channel
- paspuggie48
- Posts: 630
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
jamesg46 wrote: ↑Sat May 01, 2021 11:00 amI'll take a look into that... I would really like to do more in VBA but learning through videos on topics that just don't interest me drains my attention spanpaspuggie48 wrote: ↑Sat May 01, 2021 8:21 amMight be more for beginners but I'd recommend looking at this website too
https://www.excel-easy.com/
Step-by-step screenshots which are very well put together and easy to understand.
Whenever I need to learn something Excel I go here,
https://youtube.com/user/ExcelIsFun
Look at the play list this guy has put together, it's impressive. I don't know why but what he says seems to sink in too, I think it's because he says pretty much everything twice.
Aye, Mike is great and explains even the most complicated formulas easily...reminds me of the way Johnny Ball used to teach us on TV
Am always happy to help people with VBA issues or code not working, within reason though.
I'd rather see people learn for themselves, on top of the fact that I have a full-time job, whilst treating trading as if it were full-time whilst having the benefit of not going into the office for the last year hence why I wouldn't volunteer even for payment to help someone create a bot as what I get paid doing it for a full time job most people on here would want it cheaper, and I just simply don't have the time.
My one bit of advice is to put error trapping in and destroy objects at the end of routines when you're done with them. VBA isn't like the .Net languages in that it doesn't have automatic garbage collection of objects.
Every routine I write the first bits to go in are as follows
The second resume goes into the error catch as I can put a break point on the msgbox and just drag it down to the resume to jump to the bit of code that has the issue.
I'd rather see people learn for themselves, on top of the fact that I have a full-time job, whilst treating trading as if it were full-time whilst having the benefit of not going into the office for the last year hence why I wouldn't volunteer even for payment to help someone create a bot as what I get paid doing it for a full time job most people on here would want it cheaper, and I just simply don't have the time.
My one bit of advice is to put error trapping in and destroy objects at the end of routines when you're done with them. VBA isn't like the .Net languages in that it doesn't have automatic garbage collection of objects.
Every routine I write the first bits to go in are as follows
Code: Select all
Private Sub mMySubGoesHere()
on error goto err_Catch
' Code goes here
finally:
On Error Resume Next
' Kill your objects here
Exit Sub
err_Catch:
Msgbox "Error encountered in mMySubGoesHere" & vbNewline & Err.Number & ": " & Err.Description, vbcritial
Resume finally
Resume
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
There's quiet few VBA nuggets hidden around the forum. Thankfully VBA is fairly unique thing to search for.
I remebered I did this viewtopic.php?p=148328#p148328 but it was a couple of years ago and I'm not sure even I understand it now. And pls no comments about how it could be better , it was just to give some sort of idea about reading a writing cells.
Once you can read cells, compare or do maths on them, and write something back to a cell, you're half way there. Add a button to your sheet that runs that bit of code and your starting to feel pretty fancy. Then change that code to read a whole sheet full of numbers and put the outputs in a column where a chart is pointing and....tada!
Coding is really just a set of instructions describing what you'd do if you did it by hand, but written so a really stupid person could do it. Don't be afraid to start with 'pseudo code', literally all the little steps written down in plain English. If you find any that repeat then mark them as candidates for making a little chunk of code you can write once and reuse. If you have line that says pick the Racing Post nap then you know you have issues unless it somehow knows it.
I remebered I did this viewtopic.php?p=148328#p148328 but it was a couple of years ago and I'm not sure even I understand it now. And pls no comments about how it could be better , it was just to give some sort of idea about reading a writing cells.
Once you can read cells, compare or do maths on them, and write something back to a cell, you're half way there. Add a button to your sheet that runs that bit of code and your starting to feel pretty fancy. Then change that code to read a whole sheet full of numbers and put the outputs in a column where a chart is pointing and....tada!
Coding is really just a set of instructions describing what you'd do if you did it by hand, but written so a really stupid person could do it. Don't be afraid to start with 'pseudo code', literally all the little steps written down in plain English. If you find any that repeat then mark them as candidates for making a little chunk of code you can write once and reuse. If you have line that says pick the Racing Post nap then you know you have issues unless it somehow knows it.
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
Go easy on my code fragment Paul, my code comes straight from the days when manuals were elaboratly illustrated by monks. No joke, my first program was on punched card, using a teletype machine and a phone linked to a computer 20 miles away to run it on. And they say cloud computing is new.
It's not that bad to be fair, the fact that you used named ranges is better than 90%!ShaunWhite wrote: ↑Sun May 02, 2021 5:18 amGo easy on my code fragment Paul, my code comes straight from the days when manuals were elaboratly illustrated by monks. No joke, my first program was on punched card, using a teletype machine and a phone linked to a computer 20 miles away to run it on. And they say cloud computing is new.
Although you didn't declare SourceSheet so it's defined as a variant rather than a string
There's no need to use Call before a routine, that was discontinued about 20 years ago, you're showing your punchcard age
Worksheets I tend to declare the reference to them and am super explicit that its an Excel worksheet rather than using Sheets for example
Code: Select all
Dim objWs as Excel.Worksheet
Set objWs = Thisworkbook.worksheets("Bet Angel")
- paspuggie48
- Posts: 630
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
I thought when I first saw a BBC Computer using Basic at the age of 16 was ancient stuff but yours beats that LOL. I recall the days of writing:ShaunWhite wrote: ↑Sun May 02, 2021 5:18 amGo easy on my code fragment Paul, my code comes straight from the days when manuals were elaboratly illustrated by monks. No joke, my first program was on punched card, using a teletype machine and a phone linked to a computer 20 miles away to run it on. And they say cloud computing is new.
5 Goto Line 10
10 Type "Hello"
20 Goto Line 5
....and watch in amazement as it filled the screen
Here is the beast > https://www.bbc.co.uk/news/technology-15969065
First chance I had at a BBC Micro was when I was 6-7
Taught myself basic on that, then got an Atari XL 800 and thought me copying out code snippets from the magazines and getting them to work I was the lord almighty himeself.
Moved onto the Amiga 500 where I learnt C at about the age of 11-12 for the Motorola 6800 chip
Followed by assembler on the first generation PCs that had come out about 5-6 years beforehand (I started on MS Dos 3.0 so they had been about a few years, this was before the x86 architecture)
The fact I was learning C & assembler at 11-12 should have indicated to me earlier that I was a touch on the spectrum.
These days most of what I do in day job via VBA is connect to Oracle via ODBC connections to our local DBs and via HTTP to our cloud options, trigger some SQL and go and make myself a brew.
Taught myself basic on that, then got an Atari XL 800 and thought me copying out code snippets from the magazines and getting them to work I was the lord almighty himeself.
Moved onto the Amiga 500 where I learnt C at about the age of 11-12 for the Motorola 6800 chip
Followed by assembler on the first generation PCs that had come out about 5-6 years beforehand (I started on MS Dos 3.0 so they had been about a few years, this was before the x86 architecture)
The fact I was learning C & assembler at 11-12 should have indicated to me earlier that I was a touch on the spectrum.
These days most of what I do in day job via VBA is connect to Oracle via ODBC connections to our local DBs and via HTTP to our cloud options, trigger some SQL and go and make myself a brew.
I am looking for an easy way to analyze my Betfair Profit/Loss from UK/Australian horse racing and greyhound. I suppose it makes most sense to do it through Excel. Since I don't know much about Excel I want a very simple way to do it. I want to filter the results by at least country/type of race/odds. If you would like to help me out, when can you have it done and how much will it cost?
(Have also been in contact with [email protected], but for the last 2 months he has been too busy)
(Have also been in contact with [email protected], but for the last 2 months he has been too busy)
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
https://www.udemy.com/courses/search/?p ... ce&src=ukwlotora wrote: ↑Wed Jun 23, 2021 1:35 pmI am looking for an easy way to analyze my Betfair Profit/Loss from UK/Australian horse racing and greyhound. I suppose it makes most sense to do it through Excel. Since I don't know much about Excel I want a very simple way to do it. I want to filter the results by at least country/type of race/odds. If you would like to help me out, when can you have it done and how much will it cost?
(Have also been in contact with [email protected], but for the last 2 months he has been too busy)
Much faster, and free. Spend 20-30mins a day on your personal development and in a few weeks you'll have a useful new skill.