Excel help/ betfair Inplay odds
-
Hi all. Can someone help with my profit and loss, basically I want anything I put in column F to multiple column G and then take away column F, and I want the results to show in column H. I found out to do it one by one but that's taking ages lol.
-
Cheers everyone for your help. I've managed to sort it now.
-
@nick-ward You will have to track them, Betfair has some data on their site which you can download but you'd have to go through the results and put the goal times in and compare to the price as it doesn't state what happened in the game to cause the movement in price.
-
@nick-ward said in Excel help/ betfair Inplay odds:
Hi all. Can someone help with my profit and loss, basically I want anything I put in column F to multiple column G and then take away column F, and I want the results to show in column H. I found out to do it one by one but that's taking ages lol.
=Sum(F:F) * Sum(G:G)-Sum(F:F) - for totals but I assume you want every cell individual.
I'm on the mobile now but later or tomorrow morning we'll do it.
Select the cell you want the result in. H2 in your case
1 - Introduce the formula
=Sum(F2 * G2-F2)
If you introduce 10 in F2 and 4 in G2, in H2 cell you will have 30.
2 - Now select H2. In the right down corner of selections you will see a very small square. Click and hold on that square and just drag down how many cells you want.
If I'm allowed I'll upload it on here. If not allowed to upload excel files just let me know, please.
0_1555456500126_New Microsoft Excel Worksheet.xlsx -
This post is deleted!
-
@nick-ward not a clue mate
-
Also this isn't to do with excel as such but do you know where I can get the inplay odds of when the first half goal went in
-
@craig-brown said in Excel help:
And then highlight the box and drag it down from the bottom right corner
Just found that out just now lol. But cheers for your help. Think I've managed to sort it now
-
And then highlight the box and drag it down from the bottom right corner
-
I am by no means a Excel guru but what I do is click in the collum you want the results and type in =sum(
When you have done this you can click in the collum you want followed by the subraction then click on the next collum. Once you have finished either close the bracket or hit enter.
Should look something like =sum(b4+c4-d4)
I find Google and YouTube always help too.
Hope this helps.
-
Can't seem to attach pictures
