Author Topic: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!  (Read 74015 times)

Tags:
  • Élite
  • Posts: 137
*
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

  • Élite
  • Posts: 187
  • Gender: Male
*
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

  • Élite
  • Posts: 137
*
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?

Cheers,
bamthwok

  • Élite
  • Posts: 187
  • Gender: Male
*
check xscores.com

  • Élite
  • Posts: 137
*
Alright, will do! Thanks and sorry for off topic question!

  • All members
  • Posts: 13
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.

  • All members
  • Posts: 49
Hi

Does this work with excel 2010.

Regards
RB

  • All members
  • Posts: 2
It doesn't work with MF v7 and excel 2010. It'doesnt work with MF 6.5 and excel 2010.

  • All members
  • Posts: 2
Could somebody update the file to work with v7  and excel 2007 because some colums are NAME??

  • All members
  • Posts: 32
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!