Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!

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.

Cheers,
bamthwok

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 (http://www.tip-ex.com/omoves.php?ot=0)
• 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,

Theodore

Hi,

Sounds very very interesting!

In the meantime I will start reading the whole thread

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

Cheers,
bamthwok

check xscores.com

Alright, will do! Thanks and sorry for off topic question!

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.

Fred.

Hi

Does this work with excel 2010.

Regards
RB

It doesn't work with MF v7 and excel 2010. It'doesnt work with MF 6.5 and excel 2010.

Could somebody update the file to work with v7  and excel 2007 because some colums are NAME??

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
        ws.Range("A1").CurrentRegion.Copy
        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.
Moose.
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!