Hi all,
I am compiling data of 35+ leagues, and have created certain parameters that have to be satisfied to place a bet 5 minutes before a football match starts.
Each league has their own profile, thus their own parameters.
I plan to make a multi-tabbed excel for each league, which has on each tab a fairly straightforward calculation that determines if a bet needs to be placed, and checks if time to KO is less than 5 minutes.
Two questions;
1. Since I don't need the data refresh after the game has gone in play, is there a way to stop refreshing at that point in time? I want to keep the load as low as possible.
2. Speaking of which; loading all the games of the leagues in Guardian and then assigning all games in the same league to one spreadsheet, and that 35 times....am I looking at potential trouble there in terms of refreshing or performance? Hard to answer that second part I realize, for context; 64 bits Win 10, Intel Core 15-6200 @2.30 GHZ, 12 GB RAM, SSD of 256GB with plenty of free space.
I wonder what the maximum amount is of multi-tabbed excel files BA can handle...
Thanks in advance!
Questions about opening several multi-tabbed excel-files and performance.
-
CallumPerry
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
1) Within Guardian you can look at turning on restrict refresh before/after the event start time. 300 seconds before and 0 after would give you 5 minutes out until Kick Off as you requested.
2) Could you not have the parameters all within one sheet which could be easily duplicated? For example, a cell to look up the teams playing alongside a list of team names and have the cell output the league name i.e. look up cell (Chelsea) vs (Man Utd) = England Prem
Then the Prem parameters you have preset could trigger from this. Would involve a bit of work combining 35+ leagues together but once it's done it is massively flexible!
2) Could you not have the parameters all within one sheet which could be easily duplicated? For example, a cell to look up the teams playing alongside a list of team names and have the cell output the league name i.e. look up cell (Chelsea) vs (Man Utd) = England Prem
Then the Prem parameters you have preset could trigger from this. Would involve a bit of work combining 35+ leagues together but once it's done it is massively flexible!
Hi, and thanks for your answer.
I was thinking something else...does the standard multi-tabbed spreadsheet (I intend to alter it to suit my needs) come with a league identifier of some sorts? Is that information somewhere to be downloaded into Excel?
I understand your other suggestion, and I think I could maybe work on that. As you suggest this, I take that you think opening all these spreadsheets is a bad idea?
Cheers.
I was thinking something else...does the standard multi-tabbed spreadsheet (I intend to alter it to suit my needs) come with a league identifier of some sorts? Is that information somewhere to be downloaded into Excel?
I understand your other suggestion, and I think I could maybe work on that. As you suggest this, I take that you think opening all these spreadsheets is a bad idea?
Cheers.
-
CallumPerry
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
It depends on if speed is a necessity to you, it isn't for me but I like things to be kept simple and flexible. Another user suggested before having a bunch of Boolean triggers in place. For example you may just have a cell show a 1 or a 0 if the league is the English Prem. All of the other triggers could activate but unless this one does no bet will enter the market. A single bet may require 5/6 gates before a bet is made i.e all the following have to return a 1: League = Eng Prem, price is between this range, money is greater than this amount, time is less then this amount etc etc
You also need to think about how quickly Guardian cycles through the markets. If you could look in the morning and see there are i.e. 124 markets you need, you could run a quick bit of VBA to duplicate this flexible master sheet that many times. If you just have a lazy 1000x markets appear - many of which are irrelevant to your strategy - then Guardian is just wasting time cycling through a lot of useless worksheets.
Just some food for thought.
You also need to think about how quickly Guardian cycles through the markets. If you could look in the morning and see there are i.e. 124 markets you need, you could run a quick bit of VBA to duplicate this flexible master sheet that many times. If you just have a lazy 1000x markets appear - many of which are irrelevant to your strategy - then Guardian is just wasting time cycling through a lot of useless worksheets.
Just some food for thought.
I cant give you an absolute answer to your question but I do use relatively large multi tabbed excel workbooks on a i5-8400 @ 2.8 Ghz with 16gb ram and NVMe SSD.
I use Bet Angel/Guardian and Excel in conjunction all with UK/Ireland races each day and basically that peaks at over 80 races per day around Boxing Day and New Year Bank Holidays. I also use 3 instances of Bet Angel/Excel with different settings so I run up to about 240 tabs. 1 instance has "Restrict Refresh" set to 1200 seconds so I guess that means I have maxed at running around 160 fully connected Bet Angel tabs across 2 instances on 1 PC without issues.