Question: Does the results log grow for ever if the price log workbook is never closed, or will it self-limit at some size and clear entries from the end of the log?
BTW, Gary, the code that fills it is EVER so clever! I've tried fooling it with blank rows, wrong bet references, etc. and it never fails. I am seriously impressed!
Will be subscribing in a day or two, so perhaps I can take this opportunity to say how much I admire BA, and your continuing dedication to it.
Results Log size
Moderator: 2020vision
5 posts
• Page 1 of 1
Results Log size
by Roger » Mon Jun 30, 2008 8:54 am
- Roger
- Posts: 140
- Joined: Fri Nov 18, 2005 10:45 pm
by GaryRussell » Mon Jun 30, 2008 9:55 am
It will keep growing, but only when you place bets. You would have to be placing a seriously large number of bets to cause a problem since the maximimum rows is 65535.
Last edited by GaryRussell on Mon Jun 30, 2008 10:21 am, edited 1 time in total.
-
GaryRussell - Site Admin
- Posts: 9871
- Joined: Fri Nov 18, 2005 8:09 pm
- Location: Birmingham, UK
- Roger
- Posts: 140
- Joined: Fri Nov 18, 2005 10:45 pm
by throwmeadisc » Mon Jun 30, 2008 10:22 am
Not in Excel 2007, max number of rows 1,048,576 and just for reference max number of columns 16,384
-
throwmeadisc - Posts: 165
- Joined: Fri Dec 14, 2007 11:06 am
- Location: London, UK
by Roger » Tue Jul 01, 2008 6:06 am
I will probably manually prune the log periodically. I am using it for loss-chasing, and only need the top few races anyway.
- Roger
- Posts: 140
- Joined: Fri Nov 18, 2005 10:45 pm
5 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 53 guests