Author Topic: Help with Excel [TCKT15072013XL]  (Read 1574 times)

Tags:
  • All members
  • Posts: 151
Help with Excel [TCKT15072013XL]
« on: 15 Jul 2013, 13:23 »
Hi guys, could do with a little assistance in using the excel function if anyone can spare the time.

My own results spreadsheet records, sorts and filters most of the information I require to analyse my betting but I could do with knowing the SP's of all the runners in the races my trigger fires a bet into. That is all I need, I don't need to monitor all the in running prices or anything like that.

At the moment my trigger fires into all the markets I leave in my markets ie it doesn't yet filter markets due to any conditions I have placed in it.

Can I use the excel function to do this?

Thanks in advance

  • Élite
  • Posts: 3698
  • Gender: Male
*
Re: Help with Excel [TCKT15072013XL]
« Reply #1 on: 23 Jul 2013, 19:37 »
hi
you could use the remember trigger for this, name    sp_market_id  , with the condition
and selections (back/lay you didn't say which) matched is greater than 0
set the trigger to    in-play  , because the sp is only formed at in-play
then you can look or use the info like
sp_market_id_1_sel_name
sp_market_id_1_acutal_sp
this gives the name and sp for the first selection, then you use 2 and 3 etc in place of the 1


mcbee
Please read the following  disclaimer with regards to the information you may request and obtain on our forum. This specifically concerns trigger files and various instructions as to how to implement a strategy.

 

Please note, BetFair is seems to be currently OFFLINE