Hi,
sometime ago I started experimenting with exporting
MANY MARKETS data to ONE EXCEL sheethttp://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:
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 descriptionHow it worksthe excel web querying capabilities are used for importing 3 feeds in the excel file
MFPtoExcel2007_V3_LiveScores-Market_Moves_V3.xlsmMappings 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 triggersAs 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_E3 -
league 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 sourceCurrent Live Score source is XSCORES.COM:
http://www.xscores.com/soccer/soccer.jsp?sports=soccer&flag=sportDataWhy an external livescore feed?Browse the forum for a while searching for LiveScore....
the answer is easy!
Problems with Livescore from Betfair's API1. 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 tagged4.
Red - Yellow cards infos do not exist
5.
League position of home and away teams do not exist
How to activate LiveScoreIn MFP settings>Excel options1. 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 Excel4. Open Excel file
MFPtoExcel2007_V3_LiveScores-Market_Moves_V3.xlsm.
Do not forget to enable macros and data connections in the excel file!!!In MFP5. 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.xlsm7. 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!
Remarques1. 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