Hi All
Excel Integration with MF Pro at page 210 of the manual states that you can't use sheet1!A1 format in Excel "Settings" custom tab to address "market or selection variables in formulas addressed in this way, because MF Pro can't
determine what market or selection you are referring to. So only general and bet history variables are allowed."
I found this frustrating as I needed a way to monitor market/selection variables without having to launch an Excel sheet for each race and monitor a lot of data that I didn't want to manipulate. I've found a way of doing this now.
(1) Open Excel.
(2) Launch MF Pro. Make sure that a market sheet won't be launched in Excel for each market being monitored ( i.e. untick the relevant boxes). Make sure that at the conclusion of each race the market in play is deleted immediately and either set this to happen automatically or manual delete each race before the next one starts.
(3) Customise any cells for your triggers. As a very simple example, let's say that you want in cell A1 of Sheet 1 a calculation of the change in the first listed horse's back price since the market turned in play: write "Sheet1!A1" in the Cell Address column and - THIS IS THE KEY - g_ticks(mr_1_s_1_last_last_traded,mr_1_s_1_back_price)
(3) Select markets you want to monitor - say all Horse Racing Win Markets. Markets then load.
(4) As soon as market starts to refresh go to your Sheet1 spreadsheet and you'll find that the data is in A1 and refreshes automatically.
I am now doing some pretty sophisticated screens of data analysis using this method. Of course, without more one is always concentrating on the next race in the market list, but you could do some fancy looping through the list of races. The really powerful thing about it is that you get to choose how to manipulate the race data and can then refer to the specific cell in your triggers. Hope this is helpful with your betting strategies.
Can I suggest we all share some tips and tricks with each other. I'm not suggesting that we reveal our best triggers, but just share techniques. It's MF Pro v the Rest of the Betfair World as far as I'm concerned! I'll post a few more tips, MF Pro glitches workarounds etc. that I've discovered.
Oh, Oxa, if you read this post can you please tell me the file in which the Excel Custom Cells are stored as I keep having to retype my custom cells if the program becomes corrupted and needs to be reinstalled.
Regards
Ed.