Welcome to the FTS Forum - Read the introduction here

Avatar
Please consider registering
Guest
Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Feed
Topic Rating: +5 Topic Rating: +5 (7 votes) 
sp_TopicIcon
Automating the boring stuff
Avatar
Beeble
Beginner
Members
Forum Posts: 43
Member Since:
July 31, 2019
sp_UserOfflineSmall Offline
1
November 20, 2019 - 9:07 pm
sp_Permalink sp_Print
+1

I’m a big fan of automating the boring stuff as a lot of what we do is fairly monotonous.  I’ve written a number of scripts and macros (other than the simple filtering of systems) and I wondered if anyone else was willing to share/describe anything they’ve automated.

For example, I have a macro that downloads the daily RTS macro sheet, opens it, runs the macros and then copies the filtered selections to my own sheet.  I then have a macro that creates a file for BF Bot Manager so it can place the bets on those selections.  So what might take 10-15 minutes a day manually, only takes a minute with a couple of button clicks (ideal for a toilet break at work Laugh).

I’ve got similar macros for the FTS sheets too which download the sheets, copies them to mine, filters the selections for all my systems and outputs a BF Bot Manager file.  When you’ve got a lot of systems, it can save a lot of time!

I’m hoping this might spark a conversation about more efficient ways of working and inspire me to automate more of my processes. If anyone’s willing to discuss things that they’ve done, that would be great.

The following users say thank you to Beeble for this useful post:

Neil, bettyblogger, Callum, becker, gitboy, maineroad1923
Avatar
Callum
LONDON / ATX
Beginner
Members
Forum Posts: 62
Member Since:
January 20, 2019
sp_UserOfflineSmall Offline
2
November 22, 2019 - 4:01 pm
sp_Permalink sp_Print
0

Love hearing about people’s processes because there’s always something new to learn (to me at least). I’d love to get to a stage where I can automate my processes to the level you’ve described. At the moment I am automating only the placing of bets after manually filtering and adding selections to a trading software. Where would you recommend I start if I wanted to begin automating more of this process?

Always learning...

Avatar
Beeble
Beginner
Members
Forum Posts: 43
Member Since:
July 31, 2019
sp_UserOfflineSmall Offline
3
November 22, 2019 - 6:31 pm
sp_Permalink sp_Print
+1

The downloading, opening and copying and pasting is all done in a macro. I’ve literally just used Google to find how to do things, there’s always plenty of examples.

I’m a software developer by day, so maybe slightly easier for me to pick up, but there’ll be plenty of free courses online to learn how to write your own macros, rather than just recording them.

I’d suggest trying to automate one part of the process at a time. So start by trying to download the file. Then once that’s working move on to opening it and copying data, etc..

As for the placing of bets, I’ve only just started using BF Bot Manager. I’m slowly getting used to it, but I’ve got plenty left to learn.

The following users say thank you to Beeble for this useful post:

Callum, airdrieonians
Avatar
ArtTest
Moderator
Moderators

Members
Forum Posts: 244
Member Since:
March 6, 2016
sp_UserOfflineSmall Offline
4
November 22, 2019 - 8:00 pm
sp_Permalink sp_Print
0

Gruss Betting Assistant and Bet Angel (I believe), there may be others, can interface with Excel so you can use them to place bets, monitor results, etc.

Arthur

The following users say thank you to ArtTest for this useful post:

Callum
Avatar
Geeky Boy
Essex
Admin
Forum Posts: 31
Member Since:
July 2, 2019
sp_UserOfflineSmall Offline
5
November 29, 2019 - 10:33 am
sp_Permalink sp_Print
+3

I’ve done something similar in excel with regards to downloading the data, automating the selections and syncing up the reports.

I love my Gruss integration with excel and do my best to automate the betting side of things, capturing the transaction ID’s of the bets as it goes and placing them in a ledger file. I am using Power Query (in Excel) a lot of the time now which was a bit of a learning curve at the time but means we can do things like importing the transactions from BF, show real P&L in the ledger and pretty much do all the accounting/bank management for you. 

We am working on bringing some of these elements directly into FTS and I am going to preview some of them to Ian later on today.

I am wondering if its a good idea to arrange a meetup of Excel geeks, pool our resources and strategies together and see what tools we can make for the community.

The following users say thank you to Geeky Boy for this useful post:

ArtTest, andyfm, becker
Avatar
ArtTest
Moderator
Moderators

Members
Forum Posts: 244
Member Since:
March 6, 2016
sp_UserOfflineSmall Offline
6
November 29, 2019 - 11:31 am
sp_Permalink sp_Print
0

I’d be up for it and can help with .Net integration and removing the need for Gruss. If you do this, remember to invite Alistair.

Avatar
andyfm
Beginner
Members
Forum Posts: 9
Member Since:
August 2, 2013
sp_UserOfflineSmall Offline
7
November 30, 2019 - 6:10 am
sp_Permalink sp_Print
0

Geeky Boy said
I’ve done something similar in excel with regards to downloading the data, automating the selections and syncing up the reports.

I love my Gruss integration with excel and do my best to automate the betting side of things, capturing the transaction ID’s of the bets as it goes and placing them in a ledger file. I am using Power Query (in Excel) a lot of the time now which was a bit of a learning curve at the time but means we can do things like importing the transactions from BF, show real P&L in the ledger and pretty much do all the accounting/bank management for you. 

We am working on bringing some of these elements directly into FTS and I am going to preview some of them to Ian later on today.

I am wondering if its a good idea to arrange a meetup of Excel geeks, pool our resources and strategies together and see what tools we can make for the community.

  

I’d be up for that.

Avatar
philhughes
Beginner
Members

KickStarter 2020
Forum Posts: 8
Member Since:
September 25, 2018
sp_UserOfflineSmall Offline
8
December 5, 2019 - 9:15 am
sp_Permalink sp_Print
0

andyfm said

Geeky Boy said

I’ve done something similar in excel with regards to downloading the data, automating the selections and syncing up the reports.

I love my Gruss integration with excel and do my best to automate the betting side of things, capturing the transaction ID’s of the bets as it goes and placing them in a ledger file. I am using Power Query (in Excel) a lot of the time now which was a bit of a learning curve at the time but means we can do things like importing the transactions from BF, show real P&L in the ledger and pretty much do all the accounting/bank management for you. 

We am working on bringing some of these elements directly into FTS and I am going to preview some of them to Ian later on today.

I am wondering if its a good idea to arrange a meetup of Excel geeks, pool our resources and strategies together and see what tools we can make for the community.

  

I’d be up for that.

  

Me too

Avatar
maineroad1923
Beginner
Members
Forum Posts: 7
Member Since:
March 14, 2017
sp_UserOfflineSmall Offline
9
December 6, 2019 - 11:11 am
sp_Permalink sp_Print
0

I would be interested in this too.

Avatar
leewillo75
Beginner
Members
Forum Posts: 92
Member Since:
July 9, 2019
sp_UserOfflineSmall Offline
10
December 8, 2019 - 5:57 pm
sp_Permalink sp_Print
0

me too

Forum Timezone: Europe/London
Most Users Ever Online: 92
Currently Online: ultras
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Lord Dio: 121
leewillo75: 92
@capitalchrisw: 72
des911: 64
Callum: 62
Neil: 50
jamiep: 49
gurds1991: 48
chasanddave: 48
jb8426: 47
Newest Members:
deereckjof
craigash
androidemex
milchgeldmafia
anthonypuppy
norvezhskiydomteert
kenchov
haroldedump
anotherdarkhorse
martin
Forum Stats:
Groups: 5
Forums: 24
Topics: 256
Posts: 2048

 

Member Stats:
Guest Posters: 3
Members: 4662
Moderators: 2
Admins: 2
Administrators: Ian, Geeky Boy
Moderators: ArtTest, davefts