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

Tags:
  • All members
  • Posts: 134
  • 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: 6880
  • Karma: +229/-0
  • 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!

Follow us on Twitter.

Usuários brasileiros, bem vindos ao nosso WhatsApp chat!

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

  • É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: 6880
  • Karma: +229/-0
  • 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!

Follow us on Twitter.

Usuários brasileiros, bem vindos ao nosso WhatsApp chat!

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