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

Tags:
  • Élite
  • Posts: 135
  • Karma: +6/-0
*
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #60 on: Thu, 05 August, 2010, 07:00 »
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
  • Karma: +3/-0
  • Gender: Male
*
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #61 on: Thu, 05 August, 2010, 07:53 »
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: 135
  • Karma: +6/-0
*
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #62 on: Thu, 05 August, 2010, 08:02 »
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
  • Karma: +3/-0
  • Gender: Male
*
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #63 on: Thu, 05 August, 2010, 08:45 »
check xscores.com

  • Élite
  • Posts: 135
  • Karma: +6/-0
*
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #64 on: Thu, 05 August, 2010, 10:46 »
Alright, will do! Thanks and sorry for off topic question!

  • All members
  • Posts: 13
  • Karma: +0/-0
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #65 on: Wed, 30 May, 2012, 11:55 »
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
  • Karma: +1/-0
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #66 on: Sun, 24 March, 2013, 22:42 »
Hi

Does this work with excel 2010.

Regards
RB

  • All members
  • Posts: 2
  • Karma: +0/-0
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #67 on: Sun, 04 August, 2013, 09:07 »
It doesn't work with MF v7 and excel 2010. It'doesnt work with MF 6.5 and excel 2010.

  • All members
  • Posts: 2
  • Karma: +0/-0
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #68 on: Sun, 04 August, 2013, 10:02 »
Could somebody update the file to work with v7  and excel 2007 because some colums are NAME??

  • All members
  • Posts: 32
  • Karma: +0/-0
Re: Exporting MANY MARKETS DATA to ONE Excel sheet - this is done!
« Reply #69 on: Wed, 31 December, 2014, 13:01 »
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!