Pages:
Actions
  • #1 by mikethebet on 06 Dec 2018
  • Hi
    I want trigger to write the following to an excel sheet. I have looked cannot see one and I am afraid I find the instructions in manual totally confusing, even though I write my own Excel sheets.

    Date
    Selection
    Backed price
    Backed amount
    won or lost
    amount won
    amount lost

    This after the market is settled.

    Hope it is possible

    Mike

  • #2 by Oxa (WellDoneSoft) on 18 Dec 2018
  • Hello!

    If it is not absolutely necessary that the trigger writes directly to Excel (resource-consuming), then you can use the attached triggers. They write to a CSV file which is easily opened in Excel for further calculations.

    Make sure you have changed the path to the export file in the trigger that writes the data.
  • #3 by Geoff Hall on 23 Mar 2020
  • Problem I have with this is I can get a csv file but I can't get the time to export as time and it therefore comes in as text which then gets converted to a decimal part of 24 hours when I use it in formula...I have no idea how to convert 10:46 as a time to 10.46 am and have it treated as that hour in excel without it being converted to 0.48888886868
  • #4 by Geoff Hall on 24 Mar 2020
  • Ive solved this elsewhere thank you 
  • #5 by bobh on 15 May 2024
  • Hello,
    I have just noticed this topic and the replies, where a solution was offered by writing to a CSV file.

    Can I ask if a solution could be provided for writing to an Excel spreadsheet with the details across the page, not down?

    There is a sample trigger provided (in Features/Triggers/Excel) for horse racing for feeding prices into Excel, but I am having trouble working out what needs to be altered in the "Initialise sheet" and or/ "Initialise the variables" to feed the details across the page rather than down.

    I am interested in doing this for soccer games with an example below:

    Match Details  Home Team  MO Back Price   Away Team   MO Back Price  MO Draw Price  Winner (when known).

    EPL etc           Liverpool         $1.80           Tottenham         $2.50             $4.00            Home

    Is this possible?

    Thanks in advance,

    bobh


     
Pages:
Actions