Author Topic: Write To Excel Trigger  (Read 2327 times)

Tags:
  • All members
  • Posts: 132
  • Karma: +0/-0
Write To Excel Trigger
« on: Wed, 27 September, 2017, 11:03 »
Hi Guys.

I've seen a writing to excel trigger will probably do what I need. You're much better at it than me though:)

So I need a trigger that will simply list all the days horse racing selections and their prices in two columns in a sheet called say MFP Prices. Headers to be called Horse Name & Price.

I also need to be able to be able to set/change a refresh option from between 10 minutes and say 1 minute. 

That's it really 

Hope you can help.

  • Administrator
  • Posts: 6360
  • Karma: +211/-2
  • Gender: Female
*
Re: Write To Excel Trigger
« Reply #1 on: Fri, 29 September, 2017, 10:19 »
Hello!

Here's your trigger example:

Feeding all markets' prices to Excel
Always try your triggers in Test Mode before switching to real money!

You can get a faster response from us if you contact us via FaceBook Messenger.

Присоединяйтесь к нашей официальной группе ВКонтакте!

  • Élite
  • Posts: 135
  • Karma: +6/-0
*
Re: Write To Excel Trigger
« Reply #2 on: Tue, 12 June, 2018, 17:55 »
Hi Oxa,

Can you please advise how "sel_index-1" works:

horse_sheet!A(my_sidx+sel_index-1)

I figured out that "sel_index-1" identifies the number of runners in a market and writes to Excel one line per runner. But "-1" also subtracts value 1 from the value in the formula.

Above formula would not work like that: horse_sheet!A(my_sidx+sel_index-1), right?

Can you please explain the logic of "sel_index-1". In custom cells we can work with "sel_ind ex*3+1" for example. 

The whole write to excel trigger is hard to understand without knowing how sel_index-1 works.

Are there more expressions using sel_index with special functions?

Cheers,
bamthwok





  • Administrator
  • Posts: 6360
  • Karma: +211/-2
  • Gender: Female
*
Re: Write To Excel Trigger
« Reply #3 on: Fri, 15 June, 2018, 20:33 »
Hello!

The variable sel_index holds the index of the current selection, not the number of runners in the market.

The "-1" has to do with the counting of lines to start from my_sidx, and not from my_sidx+1, as it would be the case if you did not subtract 1 from sel_index (as sel_index starts from 1).
Always try your triggers in Test Mode before switching to real money!

You can get a faster response from us if you contact us via FaceBook Messenger.

Присоединяйтесь к нашей официальной группе ВКонтакте!