Cymatic Trader Community

[Bedouin]

Hi Gavin

I was wondering if it's possible to to work out which side of the market the matched money is on? It would be good to see on which side of the market the flow of money is!

Thanks

Rob

[Gavin]

Hi Rob,

It might not be perfect, but the closest way to do it is to compare the column containing the last traded price, with the columns containing the front prices on the market to see if it was at the back or lay price.

This is not going to always be perfect, because sometimes the market prices will have moved away at the same time, so the front prices showing will not contain the last traded price.

Kind regards,

Gavin

[Bedouin]

Hi Gavin,

Thanks for the quick response, I've tried this before and it is surprisingly unaccurate (matching the difference in the matched money for each horse to either the back or lay odds for the last odds). Is there no way to tap into the matched moeny data at the side of the ladders?

Thanks

Rob

[Gavin]

Hi Rob,

Sorry it is not possible. Even in the ladder, each refresh from Betfair can have money becoming matched at several prices at once.

So even though it is inaccurate, I think your best chance is to do the following:

1. Write some code in Excel's Visual Basic Editor that records the last traded price and the total traded amount. You can store these values in unused cells somewhere.
2. When the next refresh of prices arrives (detected for example by the Worksheet_Change event firing), compare the new last traded price with the previous one that you recorded. If they are the same:
3. Then compare the total matched amount with the previously recorded total matched amount. If they are different, then you know that new matches have occurred. Assume that all the matches were at the the last traded price (which is not necessarily true because matches might have occurred at a range of prices at the same time, but for the purposes of devising a trading strategy if might be a good enough average assumption).
4. Compare the last traded price with the front prices for back and lay and deduce at which price the match is most likely to have occurred.

If this is something that you think might be useful, but you'd like help coding it in Excel, then I can get you a quote. Would you like a quote for it to be coded for you?

Kind regards,

Gavin

[nig299]

Two other difficulties also spring to mind.

1. Say on the first refresh the availble amount showing on the 3rd lay price is for example, 1.83 =£500, then on the next refresh it might be 1.83= £0.00
This doesn't necessarily mean that the £500 has been traded, the money might have been "pulled"

2. You have £1,000 on the first price, £500 on the second and £250 on the third. Someone comes along with a big £10,000 bet, driving the price down a dozen ticks so that the LTP is now 1.89 from a previous price of 2.00. The LTP at 1.89 could only have had £25.00 available, so it would look like that £1,750 was traded on the first three prices, with the oustanding £8250 being matched at 1.89,unless of course you divide the outstanding amount by the number of ticks to get an average traded amount for each tick.

But, as Gavin pointed out, over a number of races, you should be able to build up a pretty good picture.

[StefanBelo]

This can done with accurate precision, but the questions is how will it be used?

I tried to collaborate on Soccer Stats, but failed as he though I will do it for him for free. He did not want to put any work himself to the “project”.

Does anyone here have a positive experience with collaborating on anything with anyone?

I am not interested in money if other person can involve himself in any work, and share it. For instance I am still open to collaborate on the soccer stats from betfair sources.

[Gavin]

I think the soccer stats project that StefanBelo is referring to is in the following topic:

Soccer Stats

Any posts about that project should be posted there please.

StefanBelo, there have been a number of projects where an Excel coder has done work for another user for a fee, but I don't know if any of the coders are collaborating together on projects without fees.

Kind regards,

Gavin

[Gavin]

Hi nig299 and StefanBelo,

Your messages about soccer stats have been moved to that discussion topic:

Soccer Stats

Kind regards,

Gavin