"Freeze" the odds before In Play

[Micki]

Still can' get it to work. Could it be because of different names.
getODDSTIME and getMatchedTime are those terms the same in Over/Under 1.5 market as in the horse racing markets.

If you don't have the time to look into it, I do understand?

Have a great day!

Michael

[GaryRussell]

No, it's the same function name whatever market.

What exactly isn't working? Does anything at all appear in those two columns? Can you explain exactly what is happening compared to what you think should be happening?

[Micki]

Hi alrodopial and doris_day

Just to let you know I have sent Gary a work sheet with the cells in question, which he is looking into.

Michael

[GaryRussell]

The difference between the over/under 1.5 goals markets and the horse racing is not a difference between the markets, but how you are logging them to Excel. I wasn't aware before that you were logging all the markets to the same worksheet. The example you originally sent me had all the markets on separate worksheets which is a crucial difference. The code wasn't designed to handle this. I have email you an updated spreadsheet which can work with both types of logging.

[Micki]

Thank you so much for your efforts.
Hopefully I can make it work on the multiple markets.

Have a nice Sunday!

Michael

[Micki]

Hi Gary,

In can see on Sheet 1 that you tested it live with a race, but doesnt look like you got the right response with 437 seonds before the off as the cells return value 0.00 for both the odds and amount matched.

I have tested Sheet 2 live and the reponse is #NAVN?

I have also tested with all of todays in play matches with Over/under 1.5
I did give the top market criteria 1 next market criteria 2 etc.
What happens when the top market(s) starts to close and therefore are inactive, will market No 70 still be updated even though matches with the low criteria numbers are inactive?
I have send you the sheet with 3 matches and highlighted the 3 cells in question for each match.

Best regards,
Michael