Q2 positive - refresh rate in seconds?

[Roger]

According to the help file, a positive value in Q2 should change the refresh rate, the value is in seconds, so a 4 should mean that BA refreshes every 4 seconds, right? I tried this today and no change was made, still got refreshes every second. Have I misunderstood this function? On 1.1.0.20 Beta.

Secondly, I am trying to get two pages within BA to refresh the same worksheet, one at A1 and the other at A51. Does that follow that the two BA accesses can be refreshed at different rates by entering a value in Q52 as well?

The reason for trying to change the rate was that the recalculation of the sheet is taking more than 1 second (I am going to have to go to VBA!)

With two prices sheet accesses at A1 and A51, with result logging on, is it OK to log both sets of results to the same worksheet, Sheet 2? Wil results just get interleaved?

[GaryRussell]

You have understood correctly how the refresh rate change works and it should also work in cell Q52. I cannot understand how it couldn't have worked, is there any chance I can connect to your PC using remote assistance and have a look for myself?

You will still need to log the bet results to separate worksheets or they will overwrite each other.

[Ian]

Trigger betting not ticked

[GaryRussell]

Yes, it doesn't work if trigger betting is not ticked, forgot about that

[throwmeadisc]

The reason for trying to change the rate was that the recalculation of the sheet is taking more than 1 second (I am going to have to go to VBA!)

These are some useful articles on Excel/VBA optimising:

http://www.cpearson.com/excel/optimize.htm

http://www.ozgrid.com/VBA/SpeedingUpVBACode.htm


And also this on how to speed up the calculation of a worksheet:

http://www.ozgrid.com/Excel/ExcelSpreadsheetDesign.htm


Help me a lot and now my sheets are pretty quick. Even on an oldish laptop.

My own personal tip, use VBA to fill a sheet with formula according to how many selections there are in a market and clear all redundant formula on any change in market. This will save Excel from having to process redundant formula on every calculation etc.

To do this I use cells(x,y).FormulaR1C1
or even easier as you don't need to change the formula to R1C1 style
cells(x,y).Resize(u,t).Formula

etc.

Try it! It's totally worth educating yourself on how to optimise you code and sheets if you are serious about automate you betting. Saves headaches in the long run and it's easier when there is only one place to edit your formula.

Good luck.

Al

[Roger]

Gary, Ian, Al, Thanks for the replies, and sorry for the delay in answering - been away. While away, I have been designing on paper how to do this job in VBA. Only used it a few times, but last week I prnted down lots of examples of VBA code in BA-atteached spreadsheets, and I can get this running I think. So 1-second refreshes will be fine.

Thanks for the optimisation links - since you know ozgrid.com, this is ByTheCringe2 here, ex-Super Moderator for my sins. Well, banned for my sins, LOL.

[throwmeadisc]

ahh. You're a smarter man than me then....

Good luck with your project, let me know if you need any help.