Multiple Lay Spreadsheet

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
User avatar
wayne0881
Posts: 5
Joined: Fri Jun 08, 2018 10:29 pm

Hi All,

I am working on a multiple lay spreadsheet so I can play around with odds/scenarios etc... my only problem is that when I compare my spreadsheet to the Betfair calculations my figures are mirrored ie, where there is a liability showing in BF on a selection my spreadsheet shows the right figure but a positive and when on BF a selection has a profit showing my spreadsheet again has the right figure but as a minus???

Any ideas on how I can flip these figures?
Jukebox
Posts: 1576
Joined: Thu Sep 06, 2012 8:07 pm

multiply by minus1
User avatar
wayne0881
Posts: 5
Joined: Fri Jun 08, 2018 10:29 pm

First thing I tried but that didn't work - which I originally thought would
User avatar
wayne0881
Posts: 5
Joined: Fri Jun 08, 2018 10:29 pm

All sorted! yes that worked obviously just me not writing the code properly :lol:
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”