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 
Pages:
Actions