Green Up (xl sample)

[Captain Sensible]

It's just historic data of previous matched prices , 2020, much the same as looking at the prices on the betfair graphs for resistance points or where people would log a trail of prices to try and gauge the direction of the market.

[2020vision]

It's just historic data of previous matched prices , 2020, much the same as looking at the prices on the betfair graphs for resistance points or where people would log a trail of prices to try and gauge the direction of the market.

Cheers Capt

I am trying to learn but that post really loses me! Maybe me just thick

Scenario for a dog - high price 9's, low price 5's, present price 6.6? 10 secs to start...

How can I get lay bet matched at 5's and back at 9's? Impossible - Yes?

Thanks for understanding - Michael


P.S. Was that not the crux of the post - matched at high and low?

Can you explain how through vba i can get the minimum & maximum price matched for the selections?I am sure i can't write it, but with this one i don't have a clue, even to think the structure...

[Captain Sensible]

All it's doing is keeping track of the last price matched column O giving the high price and low price of previous matched bets over a period of time. I don't think mak is expecting to get matched at those prices as like you say you wouldn't get matched placing bets at those prices unless it's one had peaked.

I think the crux of maks post was just to see what were the min and max prices that had previously been matched on the exchange for the runners. You'd have to ask mak why he wanted them, I just used it to see how much movement there were in certain markets at certain times to guage volativity.

[2020vision]

Now I think I am with you Capt

I just took mak's post as posted?
As I said me far from being expert, trying to learn and give some input.

Off to bed now - Michael
P.S. Nice chatting with you

[mak]

All it's doing is keeping track of the last price matched column O giving the high price and low price of previous matched bets over a period of time. I don't think mak is expecting to get matched at those prices as like you say you wouldn't get matched placing bets at those prices unless it's one had peaked.

I think the crux of maks post was just to see what were the min and max prices that had previously been matched on the exchange for the runners. You'd have to ask mak why he wanted them, I just used it to see how much movement there were in certain markets at certain times to guage volativity.

That's right Captain,i just want to know the selections "price range".I used your code, (THANK YOU ) and is doing almost what i would like.Mainly i would like to know what is the min & max price matched until my bot get in the market.Just like the chart of a selection where you can see it in the graph.Now i am thinking about it probably this could be the structure of the code if there is a way to extract the chart data...Is there?

[Captain Sensible]

That's right Captain,i just want to know the selections "price range".I used your code, (THANK YOU ) and is doing almost what i would like.Mainly i would like to know what is the min & max price matched until my bot get in the market.Just like the chart of a selection where you can see it in the graph.Now i am thinking about it probably this could be the structure of the code if there is a way to extract the chart data...Is there?

Can't think of a simple way to extract the chart data although it shouldn't be hard if you have VBA knowledge which unfortunately I don't

If I was doing via php I'd just take the marketID which we have on the sheet send that to a web query to pull down the market data as a screen scrape, maybe use

http://uk.site.sports.betfair.com/betti ... =101324563

from there you'd have a list of the runners selectionID's and then pass those onto the individual charts pages to parse out the highest and lowest values

http://uk.site.sports.betfair.com/betti ... Id=4648988

then just match up the data on excel sheet.

Probably alot of hassle for what is usually corrupt data due to people matching at silly prices to skew the graphs early on.

[mak]

Captain i don't know vba too.The same for php ofcourse (just google it (!))..

[mak]

Gary
when you find sometime & if it is possible can can you add Greened up P&L column to the second example please?

Also can you explain how i can change the columns that the extra columns appears (for example from col Z to co CC?)
thanks

[mak]

Forgot to ask
Is there a way to extract the chart data to excel? High & low prices?

[GaryRussell]

Gary
when you find sometime & if it is possible can can you add Greened up P&L column to the second example please?

Also can you explain how i can change the columns that the extra columns appears (for example from col Z to co CC?)
thanks

The code that outputs these columns is in module1 in the code editor. Change the following lines.

Code: Select all

        trigRange(r, 25).Value = betType
        trigRange(r, 26).Value = stake
        trigRange(r, 27).Value = odds
        trigRange(r, 28).Value = backStake
        trigRange(r, 29).Value = layStake


eg. change them to read as follows to move them 1 column to the right.

Code: Select all

        trigRange(r, 26).Value = betType
        trigRange(r, 27).Value = stake
        trigRange(r, 28).Value = odds
        trigRange(r, 29).Value = backStake
        trigRange(r, 30).Value = layStake


[GaryRussell]

Forgot to ask
Is there a way to extract the chart data to excel? High & low prices?

This is not currently an available feature.

[mak]

thanks again Gary