• #1 by tpanos on 27 Sep 2010
  • Hi,
    sometime ago I started experimenting with exporting MANY MARKETS data to ONE EXCEL sheet!/
    This method is flexible and faster than  cell_querymarket_... method if your market calculations need Excel to get accomplished

    I realized that the same method can be used to import live external feeds to MF via Excel, Excel acting as a live data hub to external live (or pre-game) feeds from different content providers.

    Two feeds are actually  implemented:
    • Live Score
    • Market Moves

    You will need Excel 2007 to run the excel file provided

    I will add a new topic in the forum next days for Market Moves (help file:

    External Live Score description

    How it works

    the excel web querying capabilities are used for importing 3 feeds in the excel file MFPtoExcel2007_V3_LiveScores-Market_Moves_V3.xlsm

    Mappings of naming schemas BetFair, XScores, TIP-EX are different. It takes 2-4 hours / day for the mapping of all three feed providers! I will post all the difficulties I found 3 months now for the mappings in a new post. It is interesting!

    The excel file  contains 3 sheets:

    • MFSheet - This is where MFP sends its current market data via custom cells and formulas
    • LiveScores - This is where live score infos for the current market are calculated
    • MarketMoves - This is where market move infos for the current market are calculated

    How to use in MFP triggers

    As the excel livescore feed is calculated per current market, (MFSheet worksheet provides current market names in xl_market_name named range - see cells MFSheet!B3 and LiveScores!D4), LiveScores worksheet provides all the needed info.

    So, using in MFP triggers custom cells notations like:

    cell_LiveScores_O3 -  gives the equiv of market_score1 usv
    cell_LiveScores_P3 -  gives the equiv of market_score2 usv
    cell_LiveScores_D3 -  gives some sort of event_off usv (minutes)
    cell_LiveScores_E3league position for home team
    cell_LiveScores_F3 -  gives the equiv of market_ycard1 (suggested!)
    cell_LiveScores_G3 -  gives the equiv of market_rcard1 (suggested!)

    Live Score source
    Current Live Score source is XSCORES.COM:

    Why an external livescore feed?
    Browse the forum for a while searching for LiveScore....
    the answer is easy!

    Problems with Livescore from Betfair's API
    1. LiveScore from BetFair's API comes and goes all the time
    2. Many times we notice unacceptable delays on score updates after a goal is scored
    3. time since the off (event_off) is not accurate, i.e. you never know when we arrive at 85 min, because 1 HF-2HF-H/T-FT exact times are not tagged
    4. Red - Yellow cards infos do not exist
    5. League position of home and away teams do not exist

    How to activate LiveScore

    In MFP settings>Excel options

    1. untick all buttons (if you want, it works also with ticked buttons).

    2. In custom cell write:
    MFSheet!C1 . Excel cell C1 will hold ImportFromMFP() function

    3. in the custom formula on the right of the custom cell:
    =ImportFromMFP(market_index, event_start, "market_name")

    ImportFromMFP() is a user defined function (UDF) in the excel file MFPtoExcel2007_V3_LiveScores-Market_Moves_V3.xlsm  that imports data from MFP.

    In Excel

    4. Open Excel file MFPtoExcel2007_V3_LiveScores-Market_Moves_V3.xlsm.

    Do not forget to enable macros and data connections in the excel file!!!

    In MFP

    5. Launching Excel from MFP (via launch Excel button) on the betting interface

    6. Connect it to the already opened MFPtoExcel2007_V3_LiveScores-Market_Moves_V3.xlsm

    7. Start one or more markets in MFP

    E voila!!!

    LiveScores worksheet in the excel file shows score infos for the current MFP market and these infos are captured from MFP via custom cells!


    1. Livescore actually supports only soccer matches. More sports will be added in the future
    2. The really important thing is not livescore, but the transformation of Excel in a livedata hub for different web content providers and the capability to import these infos in MFP current market
    3. Web queries in Excel are unfortunately SYNCHRONOUS. That means if, when exporting the current market data in Excel MFSheet, excel is running a web query, MFP does not check excel for ready (It might check when exporting custom cells to excel).
    You might see an MFP message "invalid cell reference at MFSheet!C1". I am actually working on "Asynchronous web queries for Excel 2007".

    It will be helpful if more feeds are active.

    Code inside the excel file is commented.

    You can download the excel file, test it and leave any comments on the forum

    Best Regards,


  • #2 by Tim (WellDoneSoft) on 27 Sep 2010
  • Wow! Great job, Theodore!
  • #3 by bamthwok on 27 Sep 2010
  • Great job Theodore! I will definitely try it out once I have the time for it.

    By the way, as a matter of curiosity I would like to know whether the same method would work to import various bookmaker prices for horse racing, such like oddschecker or bestbetting.

    Keep up the good work!

  • #4 by tpanos on 27 Sep 2010
  • everything that can be retrievied by web queries.
    I mean html tables, xml feeds, database recordsets, csv,...

    I will add a new post where everybody would add its own preffered feed and then we will decide for priorities

    Best Regards,

  • #5 by stavcon on 27 Sep 2010
  • Great Job Theo ;D  Wow
  • #6 by tpanos on 06 Oct 2010
  • Hi,
    an error has been found in excel file.

    Please, download and replace with the following excel file:


    Please inform for any error found or comment

    Best regards,

  • #7 by tpanos on 09 Oct 2010
  • Hi,
    an error has been found in excel file.

    Please, download and replace with the following excel file:


    Please inform for any error you found or comment on functionality.

    Best regards,

  • #8 by peleus on 01 Dec 2013
  • Hi tpanos, were you able to find a work around to this yet?
  • #9 by mcbee on 01 Dec 2013
  • hi peleus
    PLEASE check the date of the last post before posting, this is over 3 years old.
    the answer to your question is in the last post.
    Please, download and replace with the following excel file:


  • #10 by birinhos on 25 Feb 2016
  • Iam interested in the part of Mappings of naming schemas BetFair and XScores (only).

    Can you go in detail to explain this ?

    Is it possible to have one file with the list of all teams names in two colluns (betfair and correspond xscores ) ?