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: +4 Topic Rating: +4 (6 votes) 
sp_TopicIcon
Automating the boring stuff
sp_NewTopic Add Topic
Avatar
Beginner
Members
Forum Posts: 19
Member Since:
July 31, 2019
sp_UserOfflineSmall Offline
1
November 20, 2019 - 9:07 pm
sp_Permalink sp_Print
+1
sp_QuotePost
sp_ReportPost

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
LONDON / ATX
Beginner
Members
Forum Posts: 34
Member Since:
January 20, 2019
sp_UserOfflineSmall Offline
2
November 22, 2019 - 4:01 pm
sp_Permalink sp_Print
0
sp_QuotePost
sp_ReportPost

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
Beginner
Members
Forum Posts: 19
Member Since:
July 31, 2019
sp_UserOfflineSmall Offline
3
November 22, 2019 - 6:31 pm
sp_Permalink sp_Print
+1
sp_QuotePost
sp_ReportPost

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
Moderator
Moderators

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

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
Essex
Admin
Forum Posts: 31
Member Since:
July 2, 2019
sp_UserOfflineSmall Offline
5
November 29, 2019 - 10:33 am
sp_Permalink sp_Print
+2
sp_QuotePost
sp_ReportPost

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
Moderator
Moderators

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

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
Beginner
Members
Forum Posts: 4
Member Since:
August 2, 2013
sp_UserOfflineSmall Offline
7
November 30, 2019 - 6:10 am
sp_Permalink sp_Print
0
sp_QuotePost
sp_ReportPost

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
Beginner
Members
Forum Posts: 7
Member Since:
September 25, 2018
sp_UserOfflineSmall Offline
8
December 5, 2019 - 9:15 am
sp_Permalink sp_Print
0
sp_QuotePost
sp_ReportPost

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
Beginner
Members
Forum Posts: 1
Member Since:
March 14, 2017
sp_UserOfflineSmall Offline
9
December 6, 2019 - 11:11 am
sp_Permalink sp_Print
0
sp_QuotePost
sp_ReportPost

I would be interested in this too.

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

me too

Forum Timezone: Europe/London
Most Users Ever Online: 92
Currently Online: deano12366
6
Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Callum: 34
des911: 27
jamiep: 27
Beeble: 19
Steve: 18
Nick: 16
Forum Stats:
Groups: 4
Forums: 22
Topics: 117
Posts: 773

 

Member Stats:
Guest Posters: 2
Members: 3803
Moderators: 1
Admins: 2
Administrators: Ian, Geeky Boy
Moderators: ArtTest