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

  • All members
  • Posts: 207
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: 8826
  • 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.

Join our WhatsApp chat!

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

  • 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 

  • All members
  • Posts: 234
  • Gender: Male
Re: Write selected data to Excel sheet
« Reply #4 on: 15 May 2024, 13:42 »
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


 

  • Moderator
  • Posts: 3629
*
Re: Write selected data to Excel sheet
« Reply #5 on: 17 May 2024, 18:26 »
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
Hi bobh
Please can you confirm you definitely want to write this data directly from MFP to Excel using the connection link to Excel? The reason I ask is because the Excel link is known to be unreliable and consumes a lot of system resource. The preferred and efficient method is to write to a csv text file which can be opened in Excel. If you let me know which one you want to use I'll have a look at this.
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.

  • All members
  • Posts: 234
  • Gender: Male
Re: Write selected data to Excel sheet
« Reply #6 on: 18 May 2024, 10:37 »
Sorry for the delay Mark - time difference again.

I acknowledge your comments about resource useage, and I also confirm that I have been using the "write to excel trigger" (including live results) on horse racing for many years with just the occasional problem.

So if it is at all possible, I would like to try my excel request please.

Thanks again,

bobh




 

 

  • Moderator
  • Posts: 3629
*
Re: Write selected data to Excel sheet
« Reply #7 on: 18 May 2024, 16:09 »
Hi bobh
Please see the attached trigger. It will produce output like in the screenshot. You need to create a worksheet called soccer_sheet or you can specify the sheet name in the constant.

The trigger collects price data as soon as the market turns in-play and then writes this data and winner name as soon as the market is settled. For the price variables I have used last_last_traded which is the very last traded price recorded before the market turns in-play.   
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.

  • All members
  • Posts: 234
  • Gender: Male
Re: Write selected data to Excel sheet
« Reply #8 on: 19 May 2024, 07:26 »
Hi Mark,

Thank you for that. It is perfect for me.

Once again, I am very grateful for your help.

bobh

 

Please note, BetFair is seems to be currently OFFLINE