Moderator: 2020vision
by MarkRussell » Tue Jun 27, 2017 2:30 pm
Deestar wrote:As an aside, does anyone having any good links explaining the main advantages/disadvantages of using streaming?
by eclipse » Tue Jun 27, 2017 2:45 pm
by GaryRussell » Tue Jun 27, 2017 3:12 pm
eclipse wrote:Thanks Mark and Gary, best been having a look at it, looks great. Just a quick question if I may. I only need full streaming when the market goes in-play, otherwise a slow refresh is fine as I have 3 tabs linked to excel pages. So do I just use the excel trigger ALL-STREAM-ON as the market goes in-play and then use ALL-STREAM-OFF when the race finishes? I use Q2 to set my refresh rate and -1 to scroll thru the markets as a race finishes.
Many thanks guys.
by eclipse » Tue Jun 27, 2017 3:26 pm
GaryRussell wrote:eclipse wrote:Thanks Mark and Gary, best been having a look at it, looks great. Just a quick question if I may. I only need full streaming when the market goes in-play, otherwise a slow refresh is fine as I have 3 tabs linked to excel pages. So do I just use the excel trigger ALL-STREAM-ON as the market goes in-play and then use ALL-STREAM-OFF when the race finishes? I use Q2 to set my refresh rate and -1 to scroll thru the markets as a race finishes.
Many thanks guys.
When you say "full streaming" do you mean equivalent of ticking "Full stream" in betting options and therefore it refreshes every time new prices are streamed? If so I think I need to provide a new trigger.
FULL-STREAM-ON enables both price and order streaming.
FULL-STREAM-OFF disables both price and order streaming. ie. goes back to polling every refresh
by Drunkenight » Tue Jun 27, 2017 3:44 pm
by GaryRussell » Tue Jun 27, 2017 5:13 pm
Drunkenight wrote:Hi,
I have a similar challenge here. I only need to have the streaming on when the market reaches a certain volume, say when 100,000 has been matched in the market. I have tried turning the streaming off and on in cell Q2. However, once I turn the streaming off it doesn't update the matched volumes and so doesn't turn the streaming back on when the market reaches a matched volume of 100,000. Is there any way around this? What I am probably looking for is to refresh the market every 10 seconds, so that the matched volume is updating and then once the matched volume reaches 100,000 turn the streaming on.
Many thanks for any help.
by Drunkenight » Tue Jun 27, 2017 5:34 pm
by GaryRussell » Tue Jun 27, 2017 5:45 pm
Drunkenight wrote:"What's the refresh rate set at when you turned streaming off? "
It was set to 5 seconds. In preferences - general, I had "Full prices stream by default".
I have also found another related issue. If there is nothing in Q2 the excel logging doesn't seem to work. So for example, if you open a new spreadsheet then try and link to excel it doesn't bring in the market data. In addition if you link to excel and every thing is working ok then you change cell Q2 to be empty it seems to stop the updating.
Hope this helps.
by Drunkenight » Tue Jun 27, 2017 5:58 pm
by Drunkenight » Tue Jun 27, 2017 6:26 pm
by MarkRussell » Tue Jun 27, 2017 6:44 pm
Drunkenight wrote:OK so this time when I set a refresh rate using excel and the q2 cell it works at that refresh rate. However I can't get it to go back to the full streaming rate. If I try and set the streaming, by putting "ALL-STREAM-ON" in q2 it just refreshes at the rate I had previously selected. I can go into the preferences - general screen and select "Full prices stream by default" and check the "Stream prices" and "Stream orders" boxes, but it still only refreshes at the rate I had previously selected.
The only way I can get it to go back to full streaming is to open a new tab. Hope this makes sense. Thanks.
by Drunkenight » Tue Jun 27, 2017 7:03 pm
by GaryRussell » Wed Jun 28, 2017 11:04 am
by eclipse » Wed Jun 28, 2017 12:57 pm
GaryRussell wrote:Have just uploaded version 1.3.0.38d. This includes FULL-STREAM-ON and FULL-STREAM-OFF Q2 triggers.
The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.
Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.
Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.
He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.
We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.