Odds Recording Help Needed

[Josy]

Hello,

This is my first post.
I was reading post here for a few days and I found that members here are
very helpful.
I hope somebody can help me too.
I am a complete newbie in VBA and need some help with recording soccer
odds with BA from BetFair.
For example I have an Excel workbook with Sheet "FT 1.5" where I will have
my soccer FT O/U 1.5 odds refreshed with BA, let's say, every 30s.
And I would like to copy the odds after each refresh to another Sheet "Data1".
It would be great to have odds in one row (like Unders next to it Overs) from
second row in "Data1" so I can have some headers too.
I already found the first part which checks if the "FT 1.5" was updated but I
do not know how to write the part which will copy the timestamp and odds to
"Data1" after each refresh starting 20min before KO till the market closed.
I hope it's not confusing what I humbled here, English is not my first
language.
Thank you for your time and help in advance.

Regards,

Josy

[Captain Sensible]

Have a search of the forum there's loads of code and sample sheets on here showing how to record odds.

[Josy]

Thank you Captain for answer.
I am sure the pieces are here from which it can be built, that what I am
searching for a few days now on this Forum.
But I can't compile it myself this is why I asked for some help...
I never used VBA before.
OK, i will try to figure it out myself even if it takes weeks.

[Captain Sensible]

At the end of this thread there's probably a sheet that'd do pretty much what you needed

http://gruss-software.co.uk/forum/viewt ... ds&start=0

Just tinker around with it and if you get stuck just ask for some help saying where you're getting stuck , if you want people to write it from scratch for you there's a developers section here

http://gruss-software.co.uk/forum/viewforum.php?f=12

[Josy]

Thank you Captain.
I already read that thread earlier, it's a bit complicated for me to understand those codes but I am working on it.

[Josy]

Hello,

I have another question re Excel recording.
What I am doing wrong if in the Log Excel prices menu I cannot see any worksheet names? It's empty.

[Captain Sensible]

Do you have excel and any sheets open? If not press the browse button to navigate to your excel sheet and open it.

May also be other instances of excel open so you could click the "kill all excel processes" then browse to open and link your sheet

[Josy]

Hello Captain,

Thanx for the answer.
I have did all the procedures you suggested before I posted.
I assume something wrong with the code, maybe, because I found a post about the same problem and the reply from the same person that it was solved (code problem) but no explanation about the solution...

[Josy]

OK, I think I tried everything I had on my mind but I still can't understand why I can't connect my workbook to BA...
It happens randomly. Sometimes it's working, sometimes not.
If I open a new workbook BA can connect to it but not to my workbook with VBA codes.
Anybody can enlighten me what it depends on? So I can eliminate that.
Thanx.

[Captain Sensible]

How are you opening the new workbooks? Are you opening a new instance of excel or opening it thru an instance of excel that's already running i.e using file-> open.

Might be best for you to start a new thread in the help forum in outlining exactly what you're doing and where it';s going wrong as it may get overlooked in this thread

http://gruss-software.co.uk/forum/viewforum.php?f=5

[Josy]

Hi Captain,

There is no excel running;
I open only my file and enable macros on msgbox;
Then I try to record odds from BA but it only can see the file and no sheets in it.

I didn't want to open the 1001. thread with the same problem but I can do if you think I will get more help.
I checked almost every thread with this problem but no solution yet.

[Josy]

HI,

I am recording soccer markets, lots of them at the same time.
Is it possible somehow to load them in one step and connect to the proper sheets in excel spreadsheet?
So I don't need to do it manually each market one by one?
Or it's just a dream of mine?
Thanx for any help.

[Josy]

OK,
It must be a big secret.
So then just let me know is it possible or not, please.

[greenfingers]

Yes it is possible - it's the option right under the one you're using & called "log multiple sheets quick link"!

This thread is about it:

http://www.gruss-software.co.uk/forum/v ... php?t=3355

[Josy]

Thank you greenfingers for heads up, I will check it.
I tried it before but it didn't work properly for me. Maybe now it will.