Author Topic: Write selected data to Excel sheet  (Read 1463 times)

  • All members
  • Posts: 198
Write selected data to Excel sheet
« on: 06 Dec 2018, 10:31 »
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


  • Administrator
  • Posts: 8959
  • Gender: Female
*
Re: Write selected data to Excel sheet
« Reply #1 on: 18 Dec 2018, 21:50 »
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.
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Usuários brasileiros, bem vindos ao nosso WhatsApp chat!

Присоединяйтесь к нашей официальной группе ВКонтакте!

  • All members
  • Posts: 11
  • Gender: Male
Re: Write selected data to Excel sheet
« Reply #2 on: 23 Mar 2020, 16:43 »
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

  • All members
  • Posts: 11
  • Gender: Male
Re: Write selected data to Excel sheet
« Reply #3 on: 24 Mar 2020, 15:49 »
Ive solved this elsewhere thank you