New Posts For Thread: Gruss – Excel problemhttps://community.betfair.com/general_betting/go/thread/view/94082/30356233/gruss-excel-problemI am using a spreadsheet to trigger lays into a market but have come up against a weird problem.The price is taken from a cell in a separate worksheet – If I type a price into the correct cell in the worksheet the trigger works fine and fires the lmjaYour fixed cell reference solution has worked! Cheers!Thanks agian for all the other replies.https://community.betfair.com/general_betting/go/thread/view/94082/30356233/gruss-excel-problem?post_id=541647927#541647927mjaYour fixed cell reference solution has worked! Cheers!Thanks agian for all the other replies.Mon, 29 Sep 2014 14:05:35 -0500Haven't seen the full sheet but does it use VBA to populate the odds columns, if they're blank when it triggers it'd give the error or even if it's taking that data as text rather than numbers. Might just need the code amend to things like .Cells(trihttps://community.betfair.com/general_betting/go/thread/view/94082/30356233/gruss-excel-problem?post_id=541646225#541646225Haven't seen the full sheet but does it use VBA to populate the odds columns, if they're blank when it triggers it'd give the error or even if it's taking that data as text rather than numbers. Might just need the code amend to things like .Cells(triMon, 29 Sep 2014 11:32:10 -0500Looks like the trigger code is copying cells in columns A, B and C to Q, R and S so the Odds values that are considered invalid would actually be in column R. I suspect that the copy is modifying the formula - have you tried using "=Market!$G$20" inhttps://community.betfair.com/general_betting/go/thread/view/94082/30356233/gruss-excel-problem?post_id=541645755#541645755Looks like the trigger code is copying cells in columns A, B and C to Q, R and S so the Odds values that are considered invalid would actually be in column R. I suspect that the copy is modifying the formula - have you tried using "=Market!$G$20" inMon, 29 Sep 2014 10:48:37 -0500Cheers please update this thread if you find out the problem as it does seem oddhttps://community.betfair.com/general_betting/go/thread/view/94082/30356233/gruss-excel-problem?post_id=541644715#541644715Cheers please update this thread if you find out the problem as it does seem oddMon, 29 Sep 2014 09:26:30 -0500I have found a small workaround for now by writing a macro to copy and paste the cell values into the appropriate cells on the “Triggers” worksheet – all it means is an extra button press before triggering the LAYS which is still much quicker ahttps://community.betfair.com/general_betting/go/thread/view/94082/30356233/gruss-excel-problem?post_id=541644431#541644431I have found a small workaround for now by writing a macro to copy and paste the cell values into the appropriate cells on the “Triggers” worksheet – all it means is an extra button press before triggering the LAYS which is still much quicker aMon, 29 Sep 2014 09:03:35 -0500btw on the standard gruss spreadsheet with last price in the O column, trigger in the Q column and odds in the R, I have put =05 in the odds cell and it works fine.https://community.betfair.com/general_betting/go/thread/view/94082/30356233/gruss-excel-problem?post_id=541643377#541643377btw on the standard gruss spreadsheet with last price in the O column, trigger in the Q column and odds in the R, I have put =05 in the odds cell and it works fine.Mon, 29 Sep 2014 07:10:23 -0500No, that doesn't work Dave.The problem is, why will it only accept manual input?https://community.betfair.com/general_betting/go/thread/view/94082/30356233/gruss-excel-problem?post_id=541642919#541642919No, that doesn't work Dave.The problem is, why will it only accept manual input?Mon, 29 Sep 2014 06:32:17 -0500does it work if you just put eg = aa20 in the cell and write 2.5 in aa20? If it doesn't it would appear that the cell will only accept manual input ie it always reads "=aa20" and not the value that us humans can see?https://community.betfair.com/general_betting/go/thread/view/94082/30356233/gruss-excel-problem?post_id=541642689#541642689does it work if you just put eg = aa20 in the cell and write 2.5 in aa20? If it doesn't it would appear that the cell will only accept manual input ie it always reads "=aa20" and not the value that us humans can see?Mon, 29 Sep 2014 06:01:05 -0500I realise on re-reading this that I haven’t made what I am trying to do very clear.I am using the sample “multiple Triggers” spreadsheet from the Gruss website.This has two worksheets, “Market” and “Triggers”. The “Market” worksheethttps://community.betfair.com/general_betting/go/thread/view/94082/30356233/gruss-excel-problem?post_id=541642651#541642651I realise on re-reading this that I haven’t made what I am trying to do very clear.I am using the sample “multiple Triggers” spreadsheet from the Gruss website.This has two worksheets, “Market” and “Triggers”. The “Market” worksheetMon, 29 Sep 2014 05:49:59 -0500So the odds are still "current" per the Market sheet when it fires the bet? Or is the Market sheet being constantly updated too? (thus what were the odds you wanted to lay no longer are...)https://community.betfair.com/general_betting/go/thread/view/94082/30356233/gruss-excel-problem?post_id=541633963#541633963So the odds are still "current" per the Market sheet when it fires the bet? Or is the Market sheet being constantly updated too? (thus what were the odds you wanted to lay no longer are...)Sun, 28 Sep 2014 11:13:00 -0500