Author Topic: [TR] Write to excel  (Read 1485 times)

Tags:
  • All members
  • Posts: 9
[TR] Write to excel
« on: 19 Sep 2016, 11:12 »
Hi !
Is it possible to create a trigger that writes the following info to sheet1 in excel
taken from all the games I have loaded into My Markets.
see the attached file.
Kind Regards !
Janne

In sheet1
Match Odds,Name Home Team,Name Away Team,MarketID,SelectionID (Home Team),SelectionID (Away Team),SelectionID (The Draw)
Match Odds,Churchill Brothers,Salgaocar,1.127001318,4484783,4427250,58805
Match Odds,Sparta Prague U21,Ceske Budejovice U21,1.127000855,6789764,6553192,58805
next game
next game
next game

  • Administrator
  • Posts: 8821
  • Gender: Female
*
Re: Write to excel
« Reply #1 on: 26 Sep 2016, 12:17 »
Hello!

Please see your triggers attached.

The market details will appear in the target sheet one row after another, in the order of their start time of refresh.

I would recommend you to turn the following setting OFF prior to adding the markets to MF Pro and launching Excel:

Create a sheet for each market (OFF)

Unless of course you want to add each market sheet to the file.

All text values in MF Pro must be enclosed in double quotes, otherwise the spaces inside them will be removed, so the names of the market and selections are in double quotes.

You will need to manually clean the sheet with this data before restarting the triggers with a new set of markets.
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Join our WhatsApp chat!

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

  • All members
  • Posts: 9
Re: [TR] Write to excel
« Reply #2 on: 03 Oct 2016, 15:44 »
Thanks , works perfect !  :)

 

Please note, BetFair is seems to be currently OFFLINE