Pages:
Actions
  • #1 by misticmerlin on 25 Apr 2013
  • Hi,

    Please can someone help me with a simple problem, I am trying to dutch cells A1:A3 from excel into a trigger, I can do just A1 with this simple line:

    Selection's index is equal to cell_mysheet_A1

    but how would I input range A1:A3

    Any help would be much appreciated.

    Thanks
  • #2 by londolozi on 25 Apr 2013
  • To refer to an excel cell use a trigger expression "cell_querymarket_id_A"
    eg. cell_querymarket_id_A1 cell_querymarket_id_A2 cell_querymarket_id_A3

    If you import selections names use "cell_querymarket_id_A(sel_index*3+?)"

    Example: You have a horse named "UBolt", it is a special selection that you want to back with 3% or our bank and you want $1.80 minimum

    On your excel sheet in cells A1,B1,C1 you enter
    UBolt,2,1.8
    Where Ubolt = the name of the selection
    2 = an identifier fora particular trigger (back or lay)
    1.8 is your minimum price

    So now you import selections A1:C1
    Your trigger expressions are
    cell_querymarket_id_A(sel_index*3+1)=2 <<<checks this selections matches this back trigger>>>>
    cell_querymarket_id_A(sel_index*3+2)>back_price <<<<checks your minimum price is met>>>>

    Watch these, they will help you understand
    http://marketfeeder.co.uk/screenshots/export-cells-excel/

    http://marketfeeder.co.uk/screenshots/video-tipster/

     
  • #3 by misticmerlin on 26 Apr 2013
  • Thanks for your rely londoloz, but i am still having problems with this, probably i didn't explain properly.
    In excel I have the following runner number for e.g

    cell A1=4
    cell A2=6
    cell A3=7

    I want to dutch all 3 in a trigger, these runner numbers will change according to the race analysis.
    many thanks.
  • #4 by londolozi on 26 Apr 2013
  • runner number?
    You must use the horses name to import a selection, not it's number.

    If importing greyhounds you need it's trap number as well
    eg. "4. Slick Amigo"
    A horse
    "Slick Amigo"
  • #5 by misticmerlin on 27 Apr 2013
  • Thanks again Londolozi for getting back, apologies for the confusion the 'runner number' part, but I meant 'Index'. Would I still need the horse name if I am only what reference to the index number, as this changes and is aligned to the race I am dutching to?

    many thanks again
  • #6 by londolozi on 27 Apr 2013
  • If you are just dutching by sel_index your don't need to import from Excel.
    Just use reference to the sel_index in your triggers.
    eg: s_1_back_price s_2_lay_price

Pages:
Actions