Populating more than one Excel spreadsheet

[MatGreenaway]

Hi,

Is there a way to populate two different spreadsheets, or at least two sheets on a spreadsheet from one instance of Betting Assistant running?

I run two different systems at the moment and run this on two separate computers. I know using the Betting Assistant profiles I could run these off one PC, but having two instances running must put additional CPU load on, so wanted to know if one could populate two spreadsheets that could both trigger bets.

Cheers,
Mat

[MarkRussell]

Hi,

Yes, have a look at this example video:-

http://www.gruss-software.co.uk/Videos/ExcelMultiMarket.html

Regards,
Mark

[MatGreenaway]

Thanks for the prompt reply, but I was on about just one page in BA populating two spreadsheets.

I run a system (UK horse racing). updating every 0.2 secs. This populates one spreadsheet. I then have another instance on BA running (the same market - UK horse racing) populating a different system in another spreadsheet. In reality, they are two different Betfair accounts on two separate PCs, but they don't need to be.

Could I just have one instance of Betting Assistant with just one page (UK horse racing) which populates spreadsheet1.xls and spreadsheet2.xls

I know I can have 20 data requests a second, and the maximum BA can have is 5 so its not so much about trying to reduce the data requests, but more so to reduce precious CPU / memory / network bandwidth by having 2 BA instances requesting duplicate data 5 times a second.

Hope that makes sense!!

Many thanks,
Mat

[Captain Sensible]

Thanks for the prompt reply, but I was on about just one page in BA populating two spreadsheets.

Could I just have one instance of Betting Assistant with just one page (UK horse racing) which populates spreadsheet1.xls and spreadsheet2.xls

I know I can have 20 data requests a second, and the maximum BA can have is 5 so its not so much about trying to reduce the data requests, but more so to reduce precious CPU / memory / network bandwidth by having 2 BA instances requesting duplicate data 5 times a second.

Hope that makes sense!!

Many thanks,
Mat

All you need to do is have two betting tabs open, i.e. click new page to open a new tab and log the market to spreadsheet2.xls with the first tab logging into spreadsheet1.xls.

Because of the way BA is set up, if both tabs are displaying the same market at the same refresh rate they use the same info rather than calling the market separately. This obviously benefits you as it reduces the amount of bandwidth ,data requests by not duplicating requests for the same market

[MatGreenaway]

Ah that sounds good - I didn't know it just used the same data if the same markets are open in different tabs.

Many thanks for your help,
Mat

[Captain Sensible]

Ah that sounds good - I didn't know it just used the same data if the same markets are open in different tabs.

Many thanks for your help,
Mat

As long as the refresh rate is the same it's the same data