Author Topic: writing selection to cell in excel  (Read 1092 times)

Tags:
  • All members
  • Posts: 314
writing selection to cell in excel
« on: 08 Aug 2017, 14:46 »
Hi,

I have a trigger, reasonably simple, and it grabs the selection from a text file, and criteria are met before it is decided to place the bet, etc...

I have set a stake value in a cell within a spreadsheet loaded through MFP, and I use that to stake on the selection.

I now want to be able to write the selection into a cell in the sheet I use... So, using Sheet1....

In the trigger,
I added an action to "Write to Excel"
I have set the Text to be "sel_name"
I have set the Cell Address to cell_Sheet1_E1...

My intention is to write the selection which has had a bet placed, into cell E1 of Sheet1

This has not wrote anything to E1, even though a bet has been placed on a number of occasions.

is "sel_name" incorrect? I have tried sel_name, that does not work either...

Any help appreciated

Thanks

Mark.

  • Moderator
  • Posts: 3605
*
Re: writing selection to cell in excel
« Reply #1 on: 08 Aug 2017, 17:24 »
Hi
use square brackets for variables, formulas etc.
["sel_name"]
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.

  • Administrator
  • Posts: 8818
  • Gender: Female
*
Re: writing selection to cell in excel
« Reply #2 on: 16 Aug 2017, 20:52 »
Thank you MarkV for helping out!

Markoone11, just a kindly reminder: the syntax for this action is described in the manual, section "Triggered Betting - Reference - Actions - write to Excel".
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Join our WhatsApp chat!

Присоединяйтесь к официальному Telegram-каналу!

 

Please note, BetFair is seems to be currently OFFLINE