New Posts For Thread: ROI in Excelhttps://community.betfair.com/general_betting/go/thread/view/94082/23468842/roi-in-excelAnother quick one for you excel expertsExampleSay you stake £70 to back a number of bets during the dayAt the end of the day your bank stands at £90.58You're up £20.58. What is your ROI?sorry, misread the initial comment! :-)https://community.betfair.com/general_betting/go/thread/view/94082/23468842/roi-in-excel?post_id=419143206#419143206sorry, misread the initial comment! :-)Sun, 15 Nov 2009 16:04:42 -0600whichever way you look at it winchy has come up with the calculation which works for me.https://community.betfair.com/general_betting/go/thread/view/94082/23468842/roi-in-excel?post_id=419143202#419143202whichever way you look at it winchy has come up with the calculation which works for me.Sun, 15 Nov 2009 16:00:49 -0600He didnt say 10 bets, I read it as £70 in total for his number of bets....if this is wrong though you need to replace 70 with the total amount bet out during the dayhttps://community.betfair.com/general_betting/go/thread/view/94082/23468842/roi-in-excel?post_id=419143198#419143198He didnt say 10 bets, I read it as £70 in total for his number of bets....if this is wrong though you need to replace 70 with the total amount bet out during the daySun, 15 Nov 2009 15:59:44 -0600The total staked during the day added up to £70 (over a number of different races and at varying stakes). The balance at the end was £90.58 giving me a profit of £20.58https://community.betfair.com/general_betting/go/thread/view/94082/23468842/roi-in-excel?post_id=419143194#419143194The total staked during the day added up to £70 (over a number of different races and at varying stakes). The balance at the end was £90.58 giving me a profit of £20.58Sun, 15 Nov 2009 15:58:37 -0600Is that correct Winchy? if he bet £70 on 10 bets throughout the day, then his actual investment would have been £700, opposed to £70, which would mean that his profit would be approx 3-4%https://community.betfair.com/general_betting/go/thread/view/94082/23468842/roi-in-excel?post_id=419143190#419143190Is that correct Winchy? if he bet £70 on 10 bets throughout the day, then his actual investment would have been £700, opposed to £70, which would mean that his profit would be approx 3-4%Sun, 15 Nov 2009 15:55:00 -0600Cheers Winchy. You're a hero. So today's ROI was not too bad for me as a beginner. This time next year........................https://community.betfair.com/general_betting/go/thread/view/94082/23468842/roi-in-excel?post_id=419143186#419143186Cheers Winchy. You're a hero. So today's ROI was not too bad for me as a beginner. This time next year........................Sun, 15 Nov 2009 15:50:46 -0600=sum(20.58/70*100)=29.4%OKhttps://community.betfair.com/general_betting/go/thread/view/94082/23468842/roi-in-excel?post_id=419143182#419143182=sum(20.58/70*100)=29.4%OKSun, 15 Nov 2009 15:45:15 -0600Another quick one for you excel expertsExampleSay you stake £70 to back a number of bets during the dayAt the end of the day your bank stands at £90.58You're up £20.58. What is your ROI?https://community.betfair.com/general_betting/go/thread/view/94082/23468842/roi-in-excel?post_id=419143178#419143178Another quick one for you excel expertsExampleSay you stake £70 to back a number of bets during the dayAt the end of the day your bank stands at £90.58You're up £20.58. What is your ROI?Sun, 15 Nov 2009 15:38:32 -0600