New Posts For Thread: Record of past betshttps://community.betfair.com/general_betting/go/thread/view/94082/23524694/record-of-past-betsI've just requested and received a complete list of matched bets I've ever made. Most of my bets are on football and unfortunately it doesn't specify which leagues my bets have been placed on eg whether any particular match is a premier league game,Just responding to Chris there.https://community.betfair.com/general_betting/go/thread/view/94082/23524694/record-of-past-bets?post_id=420411350#420411350Just responding to Chris there.Wed, 24 Feb 2010 04:31:53 -0600Hmmm . . yes just have done. At the moment this doesn't seem too much of a problem. Quite straightforward in fact. No doubt I'll encounter loads of problems when I actually attempt to do it though!https://community.betfair.com/general_betting/go/thread/view/94082/23524694/record-of-past-bets?post_id=420411346#420411346Hmmm . . yes just have done. At the moment this doesn't seem too much of a problem. Quite straightforward in fact. No doubt I'll encounter loads of problems when I actually attempt to do it though!Wed, 24 Feb 2010 04:31:16 -0600vlookup and hlookup are well worth the day it'll probably take you to learn them and get comfortableGoogling will be better than any explanation I can give though.https://community.betfair.com/general_betting/go/thread/view/94082/23524694/record-of-past-bets?post_id=420411342#420411342vlookup and hlookup are well worth the day it'll probably take you to learn them and get comfortableGoogling will be better than any explanation I can give though.Wed, 24 Feb 2010 04:30:56 -0600sorry - can't help much with excel bar suggesting googling 'vlookup'https://community.betfair.com/general_betting/go/thread/view/94082/23524694/record-of-past-bets?post_id=420411330#420411330sorry - can't help much with excel bar suggesting googling 'vlookup'Wed, 24 Feb 2010 04:10:05 -0600I have got the historical data as well and they both have event id. So the 2 lots of data have a common column.Trouble is my excel skills are a bit basic. Any pointers as to how I would go about doing this?https://community.betfair.com/general_betting/go/thread/view/94082/23524694/record-of-past-bets?post_id=420411326#420411326I have got the historical data as well and they both have event id. So the 2 lots of data have a common column.Trouble is my excel skills are a bit basic. Any pointers as to how I would go about doing this?Wed, 24 Feb 2010 04:04:09 -0600it's a long winded method but if it has the event id in the data provided you could download the historical data which gives you the full market name (e.g. Spanish Soccer/Spanish Cup/Fixtures 07 January /Gijon v Valladolid/Total Goals)https://community.betfair.com/general_betting/go/thread/view/94082/23524694/record-of-past-bets?post_id=420411322#420411322it's a long winded method but if it has the event id in the data provided you could download the historical data which gives you the full market name (e.g. Spanish Soccer/Spanish Cup/Fixtures 07 January /Gijon v Valladolid/Total Goals)Wed, 24 Feb 2010 03:54:37 -0600It's hardly a quick method, but you could use hlookup and make a table of teams/years in which division.Then you can do something like IF date = blah year, hlookup from appropriate table to get the division.It's long winded but will be faster than dohttps://community.betfair.com/general_betting/go/thread/view/94082/23524694/record-of-past-bets?post_id=420411318#420411318It's hardly a quick method, but you could use hlookup and make a table of teams/years in which division.Then you can do something like IF date = blah year, hlookup from appropriate table to get the division.It's long winded but will be faster than doWed, 24 Feb 2010 03:41:02 -0600It has for eg Fixtures 02 January / Barcelona v Alcoyano; Correct Scoreall in one column! But will be sorting that using text to columns so that eventually I'll have all in separate columns including the teams in separate columns.https://community.betfair.com/general_betting/go/thread/view/94082/23524694/record-of-past-bets?post_id=420411314#420411314It has for eg Fixtures 02 January / Barcelona v Alcoyano; Correct Scoreall in one column! But will be sorting that using text to columns so that eventually I'll have all in separate columns including the teams in separate columns.Wed, 24 Feb 2010 03:34:13 -0600Are the two teams in seperate columns, or is it "Arsenal vs ManUtd" in one column?https://community.betfair.com/general_betting/go/thread/view/94082/23524694/record-of-past-bets?post_id=420411310#420411310Are the two teams in seperate columns, or is it "Arsenal vs ManUtd" in one column?Wed, 24 Feb 2010 03:29:52 -0600I've just requested and received a complete list of matched bets I've ever made. Most of my bets are on football and unfortunately it doesn't specify which leagues my bets have been placed on eg whether any particular match is a premier league game,https://community.betfair.com/general_betting/go/thread/view/94082/23524694/record-of-past-bets?post_id=420411306#420411306I've just requested and received a complete list of matched bets I've ever made. Most of my bets are on football and unfortunately it doesn't specify which leagues my bets have been placed on eg whether any particular match is a premier league game,Wed, 24 Feb 2010 03:22:40 -0600