Author Topic: Dutch Sel_Index  (Read 2046 times)

Tags:
  • All members
  • Posts: 30
  • Karma: +0/-0
Dutch Sel_Index
« on: Thu, 25 April, 2013, 19:14 »
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

  • All members
  • Posts: 527
  • Karma: +17/-5
  • Gender: Male
Re: Dutch Sel_Index
« Reply #1 on: Thu, 25 April, 2013, 22:03 »
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/

 
Improvise Adapt Overcome

  • All members
  • Posts: 30
  • Karma: +0/-0
Re: Dutch Sel_Index
« Reply #2 on: Fri, 26 April, 2013, 18:14 »
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.

  • All members
  • Posts: 527
  • Karma: +17/-5
  • Gender: Male
Re: Dutch Sel_Index
« Reply #3 on: Fri, 26 April, 2013, 20:32 »
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"
Improvise Adapt Overcome

  • All members
  • Posts: 30
  • Karma: +0/-0
Re: Dutch Sel_Index
« Reply #4 on: Sat, 27 April, 2013, 19:13 »
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

  • All members
  • Posts: 527
  • Karma: +17/-5
  • Gender: Male
Re: Dutch Sel_Index
« Reply #5 on: Sat, 27 April, 2013, 22:36 »
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

Improvise Adapt Overcome