• #61 by bamthwok on 05 Aug 2010
  • Hi tpanos,

    I'm just reading through this thread. Very interesting and very good work by you.

    May I allow to ask you whether you but some final documentation together already?

    If not, no problem and I will start from page 1 in this thread.

  • #62 by tpanos on 05 Aug 2010
  • Hi,
    I am actually working on the opposite.
    Import multi column ranges to MF automatically, refreshable, per selection.

    I will publish it with final documentation, duringf August.

    Things that will be based on MFPtoExcel:

    • Market Moves (
    • Livescore variables (red-yellow cards, exact minutes since the off, half time period, extra time,...), smaller refresh time,...
    • Arbitrage
    • Any XML interesting feed

    Best Regards,

  • #63 by bamthwok on 05 Aug 2010
  • Hi,

    Sounds very very interesting!

    In the meantime I will start reading the whole thread ;D

    As a matter of curiousity: do you know any soccer livescore feed that indicates how many minutes of stoppage time will be played?

  • #64 by tpanos on 05 Aug 2010
  • check
  • #65 by bamthwok on 05 Aug 2010
  • Alright, will do! Thanks and sorry for off topic question!
  • #66 by Fred78 on 30 May 2012
  • Hi everybody,

    I got a list of 190 values and it doesn't work !
    When my own list of values doesn't exceed 28 parameters, it's ok.

    Can someone help me ?

    Thanks in advance.

  • #67 by Roccobarocco on 24 Mar 2013
  • Hi

    Does this work with excel 2010.

  • #68 by wywy22 on 04 Aug 2013
  • It doesn't work with MF v7 and excel 2010. It'doesnt work with MF 6.5 and excel 2010.
  • #69 by wywy22 on 04 Aug 2013
  • Could somebody update the file to work with v7  and excel 2007 because some colums are NAME??
  • #70 by moose on 31 Dec 2015
  • Hi,
    I use the following Excel MACRO to do what seems like a similar job:

    Code: [Select]
    Sub DataCollect()

    'collect data from each worksheet
    'append to "NH" worksheet
    Dim ws As Worksheet
    For Each ws In Worksheets
        If ws.Visible = xlSheetVisible And ws.Name <> "bets" And ws.Name <> "NH" And ws.Name <> "AW" And ws.Name <> "xii" Then
            ws.Range("A1").CurrentRegion.MergeCells = False
            Sheets("NH").Range("A" & Cells(ws.Rows.Count, "A").End(xlUp).Row + 1).PasteSpecial Paste:=xlPasteValues
        End If
    Next ws
    End Sub

    You must insert a worksheet and name it NH before running the MACRO. It de-merges all cells so that Excel filters can be used to eliminate unwanted rows. Hope this helps someone.
    PS I had a little help with the final version as I my original inserted the first ws twice. So credit to my Mentor for that!