Write selected data to Excel sheet

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

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.

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

Ive solved this elsewhere thank you

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

Quote from: bobh 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

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.

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

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.

Hi Mark,

Thank you for that. It is perfect for me.

Once again, I am very grateful for your help.

bobh

Write selected data to Excel sheet

Hello Guest