Aus turnover charge

[Daywalker]

Hi

Is there a way of identifying markets that are included in aus turnover charge from excel?

Thanks
D

[Captain Sensible]

I just have the turnover markets listed on a separate sheet and use a little VBA with VLOOKUP to pick out the charge markets when the market loads. Could just as easily do it with a VLOOKUP formula. Here's my turnover course list, not sure how accurate it is as courses do drop off the turnover charge.


Alba (AUS) Charge
Alby (AUS) Charge
AnPk (AUS) No Charge
APrk (AUS) No Charge
Arar (AUS) No Charge
Armi (AUS) Charge
Asct (AUS) Charge
ASpr (AUS) No Charge
Athe (AUS) No Charge
Bair (AUS) No Charge
Bala (AUS) No Charge
Bali (AUS) Charge
Ball (AUS) No Charge
Bank (AUS) Charge
Bath (AUS) Charge
Beau (AUS) No Charge
Belm (AUS) Charge
Bena (AUS) No Charge
Bend (AUS) No Charge
BMsh (AUS) No Charge
Boor (AUS) No Charge
Bord (AUS) No Charge
Brme (AUS) Charge
Bull (AUS) Charge
Bunb (AUS) Charge
Bund (AUS) No Charge
Burn (AUS) Charge
Buss (AUS) Charge
Camp (AUS) No Charge
Canb (AUS) Charge
Cann (AUS) Charge
Cant (AUS) Charge
Carn (AUS) Charge
Carr (AUS) No Charge
Casi (AUS) Charge
Cast (AUS) No Charge
Caul (AUS) No Charge
Cess (AUS) Charge
Char (AUS) No Charge
Chel (AUS) No Charge
Chrv (AUS) No Charge
Clre (AUS) No Charge
Cnbl (AUS) Charge
Cobr (AUS) No Charge
Coff (AUS) Charge
Cola (AUS) No Charge
Cole (AUS) No Charge
Coll (AUS) Charge
Cona (AUS) Charge
Cool (AUS) Charge
Coon (AUS) Charge
Coot (AUS) Charge
Coro (AUS) Charge
Cowr (AUS) Charge
Cran (AUS) No Charge
Crns (AUS) No Charge
Dalb (AUS) No Charge
Dapt (AUS) No Charge
Darw (AUS) No Charge
Deag (AUS) No Charge
Devn (AUS) No Charge
Donl (AUS) No Charge
Doom (AUS) No Charge
Dubb (AUS) Charge
Dunk (AUS) No Charge
Echu (AUS) No Charge
Eden (AUS) No Charge
EFrm (AUS) No Charge
Emer (AUS) No Charge
Espe (AUS) Charge
Eugo (AUS) Charge
Fair (AUS) Charge
Flem (AUS) No Charge
Forb (AUS) Charge
Gard (AUS) No Charge
Gatt (AUS) No Charge
Gawl (AUS) No Charge
GCst (AUS) No Charge
Geel (AUS) No Charge
Gera (AUS) Charge
Gilg (AUS) Charge
Ginn (AUS) Charge
GlbD (AUS) No Charge
GlPk (AUS) Charge
Gosf (AUS) Charge
Goul (AUS) Charge
Graf (AUS) Charge
Gunb (AUS) No Charge
Gund (AUS) Charge
Gunn (AUS) Charge
Gwdi (AUS) No Charge
Hali (AUS) No Charge
Haml (AUS) No Charge
Harv (AUS) Charge
Hawk (AUS) Charge
Heal (AUS) No Charge
Hoba (AUS) No Charge
Hprk (AUS) Charge
HRck (AUS) No Charge
Hshm (AUS) No Charge
Inni (AUS) No Charge
Inve (AUS) Charge
Ipsw (AUS) No Charge
June (AUS) Charge
KaIs (AUS) No Charge
Kalg (AUS) Charge
Kapd (AUS) No Charge
Kell (AUS) Charge
KemG (AUS) Charge
Kemp (AUS) Charge
Kilc (AUS) No Charge
Kilm (AUS) No Charge
Kyne (AUS) No Charge
Laun (AUS) No Charge
Leet (AUS) Charge
Lism (AUS) Charge
Long (AUS) No Charge
Mack (AUS) No Charge
Mait (AUS) Charge
Mand (AUS) Charge
Mary (AUS) No Charge
MBdg (AUS) No Charge
Mdra (AUS) No Charge
Mead (AUS) No Charge
Melt (AUS) No Charge
MGam (AUS) No Charge
MIsa (AUS) No Charge
Mngl (AUS) Charge
Moe (AUS) No Charge
More (AUS) Charge
Morn (AUS) No Charge
Morp (AUS) No Charge
Mort (AUS) No Charge
Moru (AUS) Charge
Mree (AUS) Charge
MtBk (AUS) Charge
Mudg (AUS) Charge
Murt (AUS) No Charge
Murw (AUS) Charge
Musw (AUS) Charge
MVal (AUS) No Charge
Nara (AUS) No Charge
Narr (AUS) Charge
Nbri (AUS) Charge
Ndra (AUS) Charge
Newc (AUS) Charge
Ngin (AUS) Charge
Nort (AUS) Charge
Nowr (AUS) Charge
Nyah (AUS) No Charge
Oakb (AUS) No Charge
Orng (AUS) Charge
Ouyn (AUS) No Charge
Pakn (AUS) No Charge
Park (AUS) Charge
PAug (AUS) No Charge
Peak (AUS) Charge
Peno (AUS) No Charge
Penr (AUS) Charge
Phed (AUS) Charge
Pinj (AUS) Charge
PLin (AUS) No Charge
PMaq (AUS) Charge
PtPr (AUS) No Charge
Quea (AUS) Charge
Quir (AUS) Charge
Rand (AUS) Charge
Redc (AUS) No Charge
Rich (AUS) No Charge
Rock (AUS) No Charge
Roeb (AUS) Charge
Roma (AUS) No Charge
Rose (AUS) Charge
Sale (AUS) No Charge
Sand (AUS) No Charge
Sapp (AUS) Charge
Scne (AUS) Charge
SCst (AUS) No Charge
Seym (AUS) No Charge
Shep (AUS) No Charge
SPrk (AUS) No Charge
SPrk (AUS) No Charge
StAr (AUS) No Charge
Staw (AUS) No Charge
StCr (AUS) No Charge
Stra (AUS) No Charge
SwnH (AUS) No Charge
Tamw (AUS) Charge
Tare (AUS) Charge
Tatu (AUS) No Charge
Temo (AUS) Charge
Tera (AUS) No Charge
Tood (AUS) Charge
Toow (AUS) No Charge
Town (AUS) No Charge
Trar (AUS) No Charge
VicH (AUS) Charge
VicH (AUS) No Charge
VPrk (AUS) No Charge
Wagg (AUS) Charge
Wagi (AUS) Charge
Walc (AUS) Charge
Wang (AUS) No Charge
Warn (AUS) Charge
Warr (AUS) No Charge
Warw (AUS) No Charge
Well (AUS) Charge
Werr (AUS) No Charge
WeWy (AUS) Charge
WFrm (AUS) Charge
Wgul (AUS) No Charge
Whya (AUS) No Charge
Wodg (AUS) No Charge
WPrk (AUS) No Charge
Wrck (AUS) No Charge
Wyng (AUS) Charge
YarV (AUS) No Charge
Yepp (AUS) No Charge
YGln (AUS) No Charge
York (AUS) Charge
Youn (AUS) Charge

[Daywalker]

That's fantastic! Thanks for sharing your work.

I was thinking of some marker being available but with your list I can just drop it into VBA and do a one off check at market selection.

Did you manually check location of each course or is the data available online?

D

[Captain Sensible]

The turnover charge markets used to be listed here

http://betfair.com.au/helpcentre/turnov ... racks.html

Seems they've got rid of the page though, I need to have another look as a lot of courses scrapped it and my list is probably out of date .

These are the current pages

https://www.betfair.com.au/info/ausracing/

http://www.betfair.com.au/helpcentre/turnovercharge/

Where does the Turnover Charge apply?
The Turnover Charge applies in the following markets:

WA All codes
ACT Harness and Greyhound Racing
NSW Thoroughbred and Harness Racing

I'll probably compile a new list after racing as it's just a simple cut and paste of the markets from the bottom of https://www.betfair.com.au/info/ausracing/ and then flag the turnover charge ones

[Captain Sensible]

Here's a quick list I compiled, I'll check against my old one tomorrow, some duplicates as it seems the NSW greyhounds have opted out of the turnover charge.

Code: Select all

Albany,Alba,No charge,
Albion Park,APrk,No charge,
Albury,Alby,Charge,
Alice Springs,ASpr,No charge,
Angle Park,AnPk,No charge,
Ararat,Arar,No charge,
Armidale,Armi,Charge,
Ascot,Asct,No charge,
Avoca,Avoc,No charge,
Bacchus Marsh,BMsh,No charge,
Bairnsdale,Bair,No charge,
Balaklava,Bala,No charge,
Ballarat,Ball,No charge,
Ballina,Bali,Charge,
Bankstown,Bank,Charge,
Bathurst,Bath,No charge,Greyhounds
Bathurst,Bath,Charge,
Beaudesert,Beau,No charge,
Belmont,Belm,No charge,
Benalla,Bena,No charge,
Bendigo,Bend,No charge,
Blayney,Blay,Charge,
Boort,Boor,No charge,
Bordertown,Bord,No charge,
Bowraville,Bowr,Charge,
Broken Hill,BrnH,Charge,
Broome,Brme,No charge,
Bulli,Bull,No charge,Greyhounds
Bulli,Bull,Charge,
Bunbury,Bunb,No charge,
Bundaberg,Bund,No charge,
Burnie,Burn,No charge,
Busselton,Buss,No charge,
Cairns,Crns,No charge,
Camperdown,Camp,No charge,
Canberra,Canb,Charge,
Cannington,Cann,No charge,
Canterbury Park,Cant,Charge,
Carnarvon,Carn,No charge,
Carrick,Carr,No charge,
Casino,Casi,No charge,Greyhounds
Casino,Casi,Charge,
Casterton,Cast,No charge,
Caulfield,Caul,No charge,
Cessnock,Cess,Charge,
Charleville,Chrv,No charge,
Charlton,Char,No charge,
Clare,Clre,No charge,
Cobram,Cobr,No charge,
Coffs Harbour,Coff,Charge,
Colac,Cola,No charge,
Coleraine,Cole,No charge,
Coolamon,Cool,Charge,
Coonabarabran,Cona,Charge,
Coonamble,Coon,Charge,
Cootamundra,Coot,Charge,
Corowa,Coro,Charge,
Cowra,Cowr,Charge,
Cranbourne,Cran,No charge,
Dalby,Dalb,No charge,
Dapto,Dapt,No charge,
Darwin,Darw,No charge,
Deagon,Deag,No charge,
Devonport,Devn,No charge,
Donald,Donl,No charge,
Doomben,Doom,No charge,
Dubbo,Dubb,No charge,Greyhounds
Dubbo,Dubb,Charge,
Dunkeld,Dunk,No charge,
Eagle Farm,EFrm,No charge,
Echuca,Echu,No charge,
Edenhope,Eden,No charge,
Emerald,Emer,No charge,
Esperance,Espe,No charge,
Eugowra,Eugo,Charge,
Fairfield,Fair,Charge,
Flemington,Flem,No charge,
Forbes,Forb,Charge,
Gatton,Gatt,No charge,
Gawler,Gawl,No charge,
Geelong,Geel,No charge,
Geraldton,Gera,No charge,
Gilgandra,Gilg,Charge,
Glen Innes,Ginn,Charge,
Globe Derby,GlbD,No charge,
Gloucester Park,GlPk,No charge,
Gold Coast,GCst,No charge,
Goondiwindi,Goon,No charge,
Gosford,Gosf,No charge,Greyhounds
Gosford,Gosf,Charge,
Goulburn,Goul,Charge,
Grafton,Graf,No charge,Greyhounds
Grafton,Graf,Charge,
Great Western,Gwes,No charge,
Griffith,Grif,Charge,
Gunbower,Gunb,No charge,
Gundagai,Gund,Charge,
Gunnedah,Gunn,No charge,Greyhounds
Gunnedah,Gunn,Charge,
Halidon,Hali,No charge,
Hamilton,Haml,No charge,
Hanging Rock,HRck,No charge,
Harvey,Harv,No charge,
Hawkesbury,Hawk,Charge,
Healesville,Heal,No charge,
Hobart,Hoba,No charge,
Horsham,Hshm,No charge,
Innisfail,Inni,No charge,
Inverell,Inve,Charge,
Ipswich,Ipsw,No charge,
Junee,June,Charge,
Kalgoorlie,Kalg,No charge,
Kangaroo Island,KaIs,No charge,
Kapunda,Kapd,No charge,
Kellerberrin,Kell,No charge,
Kembla Grange,KemG,Charge,
Kempsey,Kemp,Charge,
Kerang,Kera,No charge,
Kilcoy,Kilc,No charge,
Kilmore,Kilm,No charge,
Kyneton,Kyne,No charge,
Launceston,Laun,No charge,
Leeton,Leet,Charge,
Lismore,Lism,No charge,Greyhounds
Lismore,Lism,Charge,
Longford,Long,No charge,
Mackay,Mack,No charge,
Maitland,Mait,No charge,Greyhounds
Maitland,Mait,Charge,
Manangatang,Mtng,No charge,
Mandurah,Mand,No charge,
Maryborough,Mary,No charge,
Melton,Melt,No charge,
Menangle,Mngl,Charge,
Mildura,Mdra,No charge,
Moe,Moe,No charge,
Moonee Valley,MVal,No charge,
Moree,More,Charge,
Mornington,Morn,No charge,
Morphettville,Morp,No charge,
Mortlake,Mort,No charge,
Moruya,Moru,Charge,
Mount Barker,MtBk,No charge,
Mount Gambier,MGam,No charge,
Mount Isa,MIsa,No charge,
Mudgee,Mudg,Charge,
Murray Bridge,MBdg,No charge,
Murtoa,Murt,No charge,
Murwillumbah,Murw,Charge,
Muswellbrook,Musw,Charge,
Naracoorte,Nara,No charge,
Narrabri,Nbri,Charge,
Narrandera,Ndra,Charge,
Narrogin,Ngin,No charge,
Narromine,Narr,Charge,
Newcastle,Newc,Charge,
Northam,Nort,No charge,
Nowra,Nowr,No charge,Greyhounds
Nowra,Nowr,Charge,
Nyah,Nyah,No charge,
Oakbank,Oakb,No charge,
Orange,Orng,Charge,
Ouyen,Ouyn,No charge,
Pakenham,Pakn,No charge,
Parkes,Park,Charge,
Peak Hill,Peak,Charge,
Penola,Peno,No charge,
Penrith,Penr,Charge,
Pinjarra,Pinj,No charge,
Port Augusta,PAug,No charge,
Port Hedland,Phed,No charge,
Port Lincoln,PLin,No charge,
Port Macquarie,PMaq,Charge,
Port Pirie,PtPr,No charge,
Queanbeyan,Quea,Charge,
Quirindi,Quir,Charge,
Randwick,Rand,Charge,
Redcliffe,Redc,No charge,
Richmond,Rich,No charge,
Rockhampton,Rock,No charge,
Roma,Roma,No charge,
Rosehill,Rose,Charge,
Sale,Sale,No charge,
Sandown,Sand,No charge,
Sandown Park,SPrk,No charge,
Sapphire Coast,Sapp,Charge,
Scone,Scne,Charge,
Seymour,Seym,No charge,
Shepparton,Shep,No charge,
St Arnaud,StAr,No charge,
Stawell,Staw,No charge,
Stony Creek,StCr,No charge,
Strathalbyn,Stra,No charge,
Sunshine Coast,SCst,No charge,
Swan Hill,SwnH,No charge,
Tamworth,Tamw,Charge,
Taree,Tare,Charge,
Tatura,Tatu,No charge,
Temora,Temo,No charge,Greyhounds
Temora,Temo,Charge,
Terang,Tera,No charge,
The Gardens,Gard,No charge,
The Meadows,Mead,No charge,
Toodyay,Tood,No charge,
Toowoomba,Toow,No charge,
Townsville,Town,No charge,
Traralgon,Trar,No charge,
Victor Harbor,VicH,No charge,
Wagga,Wagg,No charge,Greyhounds
Wagga,Wagg,Charge,
Wagin,Wagi,No charge,
Walcha,Walc,Charge,
Wangaratta,Wang,No charge,
Warracknabeal,Wrck,No charge,
Warragul,Wgul,No charge,
Warren,Warn,Charge,
Warrnambool,Warr,No charge,
Warwick,Warw,No charge,
Warwick Farm,WFrm,Charge,
Wellington,Well,Charge,
Wentworth Park,WPrk,No charge,
Werribee,Werr,No charge,
West Wyalong,WeWy,Charge,
Whyalla,Whya,No charge,
Wodonga,Wodg,No charge,
Wyong,Wyng,Charge,
Yarra Glen,YGln,No charge,
Yarra Valley,YarV,No charge,
Yeppoon,Yepp,No charge,
York,York,No charge,
Young,Youn,Charge,


[bolpx001]

Please excuse my ignorance, but what is a turnover charge and how does apply and how is it calculated - Thanks Paul

[Captain Sensible]

Here's Betfairs explanation of it http://www.betfair.com.au/helpcentre/turnovercharge/

Basically at certain tracks they charge you 1.2% of your aggregate matched back bets if you hit certain criteria.

1.2% doesn't sound much but if you're trading you may have a high turnover of matched bets and that 1.2% could easily be more than you win on the market plus if you lose on the market you'd still be liable for the turnover charge.

[Daywalker]

Please excuse my ignorance, but what is a turnover charge and how does apply and how is it calculated - Thanks Paul

For instance - last week I turned over more than £6k on all aus markets with a profit of £10. 1.2% on the min aus$2k eligibility level is aus$24 which is approx £12, more than my profit, so turns me loser.