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


     
  • #6 by MarkV on 17 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
    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.
  • #7 by bobh on 18 May 2024
  • 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




     

     
  • #8 by MarkV on 18 May 2024
  • 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.   
  • #9 by bobh on 19 May 2024
  • Hi Mark,

    Thank you for that. It is perfect for me.

    Once again, I am very grateful for your help.

    bobh
Pages:
Actions