Author Topic: Excel worksheet  (Read 1277 times)

Tags:
  • All members
  • Posts: 231
  • Gender: Male
Excel worksheet
« on: 08 Jan 2017, 10:27 »
Can I request some help please.

I have Excel worksheets linked to each race, and I need the back prices of each runner at 0.1 mins (6 secs) before the start to be placed in column M of the worksheet, and to be retained.

The only way I have been able to do it is to stop monitoring at 0.1 mins, but this causes problems as I need the result to be inserted in the allocated cell in the worksheet. This of course will not happen if I have ceased monitoring.

Hence this request.

If it will require a remember trigger, please explain how to do this step-by-step, as I get very confused easily (age!).

If, as usual, it is an easy fix, I will appreciate it very much.

Thanks,

bobh

  • Moderator
  • Posts: 3597
*
Re: Excel worksheet
« Reply #1 on: 08 Jan 2017, 17:46 »
Hi
Try this trigger:
action: write to excel
text: cell_querymarket_id_D(sel_index*3+1)
cell address: querymarket_id!M(sel_index*3+1)
selections: all market selections
execute: once per market
condition: markets minutes before the off is equal or less than 0.1
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.

  • All members
  • Posts: 231
  • Gender: Male
Re: Excel worksheet
« Reply #2 on: 09 Jan 2017, 03:16 »
G'day Mark,

Can I say a big "thank you" for a problem solved that has been bugging me for weeks!

It works perfectly.

bobh




 

Please note, BetFair is seems to be currently OFFLINE