Author Topic: Livescore - new external livefeed to MF via Excel!!!  (Read 37758 times)

  • Élite
  • Posts: 187
  • Karma: +3/-0
  • Gender: Male
*
Livescore - new external livefeed to MF via Excel!!!
« on: Mon, 27 September, 2010, 11:44 »
Hi,
sometime ago I started experimenting with exporting MANY MARKETS data to ONE EXCEL sheet
http://community.marketfeederpro.com/triggered-betting-10/exporting-many-markets-data-to-one-excel-sheet-this-is-done!/
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: http://www.tip-ex.com/omoves.php?action=help)

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:
http://www.xscores.com/soccer/soccer.jsp?sports=soccer&flag=sportData

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!

Remarques

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,

Theodore



  • Tim Vetrov
  • Administrator
  • Posts: 3851
  • Karma: +151/-0
  • Gender: Male
*
Re: Livescore - new external livefeed to MF via Excel!!!
« Reply #1 on: Mon, 27 September, 2010, 12:41 »
Wow! Great job, Theodore!
I'm happy to help Monday - Friday, 08:00-18:00 GMT
Буду раз помочь с понедельника по пятницу, 08:00-18:00 GMT

  • Élite
  • Posts: 131
  • Karma: +6/-0
*
Re: Livescore - new external livefeed to MF via Excel!!!
« Reply #2 on: Mon, 27 September, 2010, 13:32 »
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!

Cheers,
bamthwok

  • Élite
  • Posts: 187
  • Karma: +3/-0
  • Gender: Male
*
Re: Livescore - new external livefeed to MF via Excel!!!
« Reply #3 on: Mon, 27 September, 2010, 13:41 »
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,

Theodore

  • All members
  • Posts: 7
  • Karma: +0/-0
Re: Livescore - new external livefeed to MF via Excel!!!
« Reply #4 on: Mon, 27 September, 2010, 13:52 »
Great Job Theo ;D  Wow

  • Élite
  • Posts: 187
  • Karma: +3/-0
  • Gender: Male
*
Re: Livescore - new external livefeed to MF via Excel!!!
« Reply #5 on: Wed, 06 October, 2010, 12:55 »
Hi,
an error has been found in excel file.

Please, download and replace with the following excel file:

MFPtoExcel2007_V3_LiveScores-Market_Moves_V3.01

Please inform for any error found or comment

Best regards,

Theodore

  • Élite
  • Posts: 187
  • Karma: +3/-0
  • Gender: Male
*
Re: Livescore - new external livefeed to MF via Excel!!!
« Reply #6 on: Sat, 09 October, 2010, 05:17 »
Hi,
an error has been found in excel file.

Please, download and replace with the following excel file:

MFPtoExcel2007_V3_LiveScores-Market_Moves_V3.02.xlsm

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

Best regards,

Theodore

  • All members
  • Posts: 80
  • Karma: +0/-1
Re: Livescore - new external livefeed to MF via Excel!!!
« Reply #7 on: Sun, 01 December, 2013, 18:08 »
Hi tpanos, were you able to find a work around to this yet?
We only live once.

  • Moderator
  • Posts: 4013
  • Karma: +235/-9
  • Gender: Male
*
Re: Livescore - new external livefeed to MF via Excel!!!
« Reply #8 on: Sun, 01 December, 2013, 18:17 »
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.
Quote
Please, download and replace with the following excel file:

MFPtoExcel2007_V3_LiveScores-Market_Moves_V3.02.xlsm

mcbee
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: 1
  • Karma: +0/-0
  • Gender: Male
Re: Livescore - new external livefeed to MF via Excel!!!
« Reply #9 on: Thu, 25 February, 2016, 00:52 »
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 ) ?

thanks