I-XL's data capture spreadsheet multi market

User avatar
firlandsfarm
Posts: 2688
Joined: Sat May 03, 2014 8:20 am

Deleted … wrong thread
Last edited by firlandsfarm on Fri Mar 08, 2019 12:56 pm, edited 2 times in total.
User avatar
firlandsfarm
Posts: 2688
Joined: Sat May 03, 2014 8:20 am

Deleted … wrong thread (though you can read it in gutuami's post that follows together with his disrespectful implication)
Last edited by firlandsfarm on Fri Mar 08, 2019 1:00 pm, edited 1 time in total.
User avatar
gutuami
Posts: 1858
Joined: Wed Apr 15, 2009 4:06 pm

firlandsfarm wrote:
Fri Mar 08, 2019 10:36 am
Nigel, thanks for your reply and I think I posted my error in the wrong thread, my error was of course related to the single market spreadsheet and I'm going to assume you noticed that and your revised code is for that spreadsheet. My apologies to all for any confusion. (Can a moderator move my offending threads to the Betfair Data : Recording market odds spreadsheet - capturing data thread where they should be.)

OK, now to carry on … awaiting revised content
I am going to assume that Nigel is not obliged to do that revision even if it's his own code.
User avatar
firlandsfarm
Posts: 2688
Joined: Sat May 03, 2014 8:20 am

I'm sorry guys, you must all think I'm crazy, replying to post that are not here! Something seems to have gone crazy with my posts … posts are appearing in the wrong threads! I don't know how that's happening or why. I will try and delete and repost to sort it out. But gutuami I have to say that does not excuse you for the implication in your post. I have never, ever, considered anyone in this or any other forum to be under any obligation to do anything for anyone else … until now and I resent your inference otherwise.
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

oh here we go. the snowflakes kicking off again.!!!! lol

Fight, Fight, as the kids at school would gather round.
if you two start trading punches make sure we can all trade the fight.

in the blue corner we have Gutami, and in the red corner we have firlandsfarm
Let's get ready to rumble!!!!
User avatar
firlandsfarm
Posts: 2688
Joined: Sat May 03, 2014 8:20 am

Hey Memphis I can assure you snow doesn't sit on me for long. :lol: It should have been clear to anyone that my message was thanking Nigel for something he had already done and not looking to scrounge a feebe! Maybe I over reacted but I don't take kindly to someone questioning my honour. Let that be the end of it … love to all :D
Facedcomic
Posts: 5
Joined: Wed Apr 15, 2009 4:53 pm

Hi Nigel,

I'd just like to thank you for this spreadsheet and the work you've put into it.

Many thanks
Steve
Facedcomic
Posts: 5
Joined: Wed Apr 15, 2009 4:53 pm

Hi Nigel,

I'd like capture some data with milliseconds incorporated into the timestamp format ("hh:mm:ss.000"). I'm thinking if I could change the countdown time format this would be possible. I've tried to find the format within the vba project, but I'm thinking this is the part of the project I can't access. Is there a way I can change this format without having to access the protected area? I'm trying to learn VBA but it's very minimal at this stage.

Also, I've created a sheet based on your spreadsheet with 50 Markets in it. I've made all the sheet code and formulae updates as outlined by yourself on the first page this post. In addition, I've added a new worksheet named 'CONSTANTS' - this can be found after worksheet 'Bet Angel (50)' and before worksheet 'Data'. I've added a 'INTERVAL.SECONDS' constant to this page. I've updated all the data sheets so that the user can change the 'Interval (seconds)' value in the 'CONSTANTS' worksheet and it will update the G1 cell across all the 50 data capture sheets.

If it's ok with you I can post this up for anybody who may find it useful.

Many Thanks
Steve
jtrader
Posts: 100
Joined: Thu Feb 09, 2017 11:35 am

Excellent work,nigelk! Everything is working fine :!:

But if someone could change something in VBA code I think,cause to be possible to change capturing interval - I need for example -15,20,30 secs and etc.?
Post Reply

Return to “Betfair Data”