Gruss Forum • View topic

by **eclipse** » Mon Jul 23, 2012 5:50 pm

Is there an equivalent in Excel to the close all positions on the grid interface? If not I'm sure this would be a very nice feature to have in the armoury.

by **mak** » Mon Jul 23, 2012 7:59 pm

you can use green workbook in samples section... otherwise you will have to wait a little bit... i think it is in Gary's to do list

by **eclipse** » Mon Jul 23, 2012 8:45 pm

thanks mak, will wait for that one

by **NorthView** » Sun Mar 24, 2013 5:40 pm

This would be a real boon. Any news, Gary?

by **osknows** » Sun Mar 24, 2013 5:58 pm

It can be done with just Excel. I have a working greenup formulae that will close all positions in a few milliseconds without any VBA across hundreds of horses.

by **NorthView** » Sun Mar 24, 2013 6:22 pm

Do you think it would work well with In Play horse racing, osknows?

If so, would it be possible to put the formula up here, or attach it as a file please?

When I test my triggers by watching them fire, I often notice that the largest green is usually on the horses that are least likely to win!

by **osknows** » Sun Mar 24, 2013 7:44 pm

Yes it calcs in under 16ms so is well within 1 BA refresh and is fine for inplay. Attached is a simplified version as the one I use has evolved quite a bit over time. It includes both an amended version of Gary's VBA and also my formulae only version in columns AG:AO.

You may want to apply tick offset to the prices to get them matched in play.

http://www.mediafire.com/view/?apm74ifacv47e1g

Regards
Os

by **osknows** » Sun Mar 24, 2013 7:48 pm

Sorry forgot to say, this will currently run slower as it also contains VBA. Just delete all VBA except MODULE2 and it will run full speed

by **NorthView** » Mon Mar 25, 2013 9:09 am

Thanks osknows, that's very helpful.

As a general point I notice you're populating the trigger column T from VBA
ie Sheet1.Range("Q5:U55").Value = Sheet1.Range("AJ5:AN55").Value

rather than from an Excel formula ie putting =AJ5 into Q5.

Is it more efficient with VBA?

by **osknows** » Mon Mar 25, 2013 12:31 pm

If you need to greenup then it means there are matched bets with a bet reference that need to be cleared. It's quicker to clear them and place bets all at the same time.

Also, there is approx a 200ms window between BA refreshes. As long as all the processing is done within that window it doesn't matter if it takes 1ms or 180ms. Hence the argument that Excel 2003 runs VBA quicker doesn;t really matter when using with BA.

by **NorthView** » Fri Mar 29, 2013 3:08 pm

Thanks again, osknows, this is a huge help. I've coded this and your formulae are spot on.

by **Dag** » Fri Nov 01, 2013 6:52 am

osknows wrote:***
You may want to apply tick offset to the prices to get them matched in play.
http://www.mediafire.com/view/?apm74ifacv47e1g

Link deleted. Can u post this file again?
Thanks in advance.

by **osknows** » Fri Nov 01, 2013 10:57 am

See this link http://www.gruss-software.co.uk/forum/v ... php?t=7844

by **Dag** » Fri Nov 01, 2013 11:06 am

osknows wrote:See this link http://www.gruss-software.co.uk/forum/v ... php?t=7844

Thank you osknows.

Close all positions in Excel

Close all positions in Excel

Who is online

Sports betting software from Gruss Software