Data extraction

mbugg4 · Jan 7, 2014

Hi All

I would like to know if there is any way of getting data from a list of URLS all in one go

The urls actual pages are all in table form

I need to this to stall all data and not delete the data from the previous URL etc etc

I know how to do this one at a time but obviously this is time consuming using Data extraction from the web

Thanks in advance

Michael

hiker95 · Jan 7, 2014

mbugg4,

What version of Excel and Windows are you using?

Can you post a screenshot of the actual raw data worksheet?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post your data, you can download and install one of the following two programs:
Excel Jeanie
MrExcel HTML Maker

Or, when using Internet Explorer, just put borders around your data in Excel and copy those cells into your post.
See reply #2 the BLUE text in the following link:
http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045

If you are not able to give us screenshots:
You can upload your workbook to Box Net,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.

jsotola · Jan 7, 2014

mbugg4 said:
getting data from a list of URLS

please clarify

mbugg4 said:
to stall all data

is this a typo?

mbugg4 · Jan 7, 2014

Hi Thanks for the reply this is what the URLS will look like

Excel 2007

	A	B	C	D	E	F	G	H	I	J	K
http://members.informracing.net/informfree/new2/results.php?date=31/12/2008&mycourse=UTTOXETER
http://members.informracing.net/informfree/new2/results.php?date=31/12/2008&mycourse=WARWICK
http://members.informracing.net/informfree/new2/results.php?date=30/12/2008&mycourse=TAUNTON
http://members.informracing.net/informfree/new2/results.php?date=29/12/2008&mycourse=MUSSELBURGH
http://members.informracing.net/informfree/new2/results.php?date=29/12/2008&mycourse=NEWBURY
http://members.informracing.net/informfree/new2/results.php?date=28/12/2008&mycourse=CATTERICK
http://members.informracing.net/informfree/new2/results.php?date=28/12/2008&mycourse=LEICESTER
http://members.informracing.net/informfree/new2/results.php?date=27/12/2008&mycourse=CHEPSTOW
http://members.informracing.net/informfree/new2/results.php?date=27/12/2008&mycourse=KEMPTON
http://members.informracing.net/informfree/new2/results.php?date=27/12/2008&mycourse=WETHERBY
http://members.informracing.net/informfree/new2/results.php?date=26/12/2008&mycourse=HUNTINGDON
http://members.informracing.net/informfree/new2/results.php?date=26/12/2008&mycourse=KEMPTON
http://members.informracing.net/informfree/new2/results.php?date=26/12/2008&mycourse=MARKET RASEN
http://members.informracing.net/informfree/new2/results.php?date=26/12/2008&mycourse=SEDGEFIELD
http://members.informracing.net/informfree/new2/results.php?date=26/12/2008&mycourse=TOWCESTER
http://members.informracing.net/informfree/new2/results.php?date=26/12/2008&mycourse=WETHERBY
http://members.informracing.net/informfree/new2/results.php?date=26/12/2008&mycourse=WINCANTON
http://members.informracing.net/informfree/new2/results.php?date=23/12/2008&mycourse=FONTWELL
http://members.informracing.net/informfree/new2/results.php?date=22/12/2008&mycourse=HEREFORD
http://members.informracing.net/informfree/new2/results.php?date=21/12/2008&mycourse=CARLISLE
http://members.informracing.net/informfree/new2/results.php?date=20/12/2008&mycourse=ASCOT
http://members.informracing.net/informfree/new2/results.php?date=20/12/2008&mycourse=HAYDOCK
http://members.informracing.net/informfree/new2/results.php?date=20/12/2008&mycourse=NEWCASTLE
http://members.informracing.net/informfree/new2/results.php?date=19/12/2008&mycourse=ASCOT
http://members.informracing.net/informfree/new2/results.php?date=18/12/2008&mycourse=EXETER
http://members.informracing.net/informfree/new2/results.php?date=18/12/2008&mycourse=LUDLOW
http://members.informracing.net/informfree/new2/results.php?date=17/12/2008&mycourse=BANGOR-ON-DEE
http://members.informracing.net/informfree/new2/results.php?date=17/12/2008&mycourse=NEWBURY
http://members.informracing.net/informfree/new2/results.php?date=16/12/2008&mycourse=CATTERICK
http://members.informracing.net/informfree/new2/results.php?date=16/12/2008&mycourse=FOLKESTONE
http://members.informracing.net/informfree/new2/results.php?date=15/12/2008&mycourse=AYR

<tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]21[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]22[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]23[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]24[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]25[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]26[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]27[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]28[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]29[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]30[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]31[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet1

And this is what the data will look like that I am requiring from the URLS

Excel 2007

	A	B	C	D	E	F	G	H	I	J	K	L
26/02/2008
LEICESTER RH	5 run	VDW Ratings
Race	FROST BOYS BEGINNERS' CHASE (4) 5YO+
Winner £5,070.40	2m

No.	Dr.	Horse	Position	SP	Master	Lto	Avg	M+A	Cse	Dis	Ability	Form
Barati	16/1	1 31	1 45	-	-
Colemanstown	U	100/1	1 27	1 46	14 96
Fandani	54 91	80 108	45 128	-
Nikola	83 29	81 53	74 66	-
Tiffin Deano	100/1	69 124	1 139	68 261	-	-


LEICESTER RH	16 run	VDW Ratings
Race	BATES FAMILY HANDICAP CHASE (0-105) (4) 5YO+
Winner £4,554.20	3m

No.	Dr.	Horse	Position	SP	Master	Lto	Avg	M+A	Cse	Dis	Ability	Form
Sovereign's Joy	F	14/1	77 27	66 87
Marshalls Run	75 34	78 67	-
Sabreflight	-	-	51 60	1 325	-
Donald Will Do	U	14/1	69 13	74 27	73 62
Ice And Soda	P	25/1	66 34	77 133	65 142	-
Ouragan De Prairie	U	83 19	75 62	78 95	-	-
Dundridge Native	U	1 7	65 28	75 67	-
Ours	1 52	69 62	71 85	-	-
Gerrard	33/1	1 13	66 55	1 89	-
Charlie's Double	67 13	58 49	64 55
Ballyvaden	1 13	1 55	69 77
Tradingup	25/1	1 58	61 77	68 89	-
Parish Oak	P	66/1	61 13	1 27	1 62
Jacarado	50/1	60 13	1 142	1 354
Black Smoke	25/1	65 13	1 46	1 95
Log On Intersky	100/1	61 13	35 21	1 49	-


LEICESTER RH	14 run	VDW Ratings
Race	GWEN FROST BEST MUM NOVICES' HANDICAP CHASE (0-90) (5) 5YO+
Winner £2,927.70	2m 5f

No.	Dr.	Horse	Position	SP	Master	Lto	Avg	M+A	Cse	Dis	Ability	Form
Curradoon	B	33/1	1 46	1 55	71 76
In Extra Time	-	-	1 85	73 133	70 149	-
Northern Quest	4 46	75 60	76 70	-
Bluecoat	F	50/1	19 85	46 323	77 336	-	-
So Brash	F	78 58	62 77	79 105	-	-
Madam Harriet	16/1	53 21	65 32	71 57	-
Red Ensign	F	14/1	1 14	68 36	73 55	-
Kaparolo	P	100/1	7 27	31 32	1 110	-
Fourpointone	71 136	-	-	-
William Butler	1 33	1 68	60 90	-	-
Minella Lodge	1 19	1 55	1 71
Sharbasia	P	50/1	60 14	54 34	67 62	-
Furze Hill	62 26	63 55	37 82
Kirby's Vic	1 12	-	-


LEICESTER RH	7 run	VDW Ratings
Race	DAN FROST MEMORIAL NOVICES' CHASE (3) 5YO+
Winner £7,515.60	3m

No.	Dr.	Horse	Position	SP	Master	Lto	Avg	M+A	Cse	Dis	Ability	Form
Cathedral Rock	F	15/8	1 19	84 43	77 62	-
Sheriff Roscoe	78 49	75 76	68 98
Burren Legend	75 15	77 45	85 69	-
Clockers Corner	100/1	1 27	1 62
Desert Tommy	33/1	61 4	1 10	72 23	-
Double Intruder	-	-	72 32	76 89	48 322	-	-
Ellies Horse	50/1	1 20	80 29	60 59	-


LEICESTER RH	11 run	VDW Ratings
Race	"RIGHT TIME" WATCHES PETERBOROUGH HANDICAP CHASE (0-115) (4) 5YO+
Winner £5,204.80	2m 5f

No.	Dr.	Horse	Position	SP	Master	Lto	Avg	M+A	Cse	Dis	Ability	Form
Copper Bay	-	-	73 28	1 79	-	-
Direct Access	80/1	1 29	61 294	-	-
Zorro De La Vega	67 27	77 60	73 76	-
Sole Agent	77 28	79 68	43 95	-	-
Lysander	100/30	79 27
No Complaint	81 29	1 45	73 60	-
Desert Secrets	78 69	63 90	1 95	-	-
Muttley Maguire	-	-	69 13
Malaga Boy	20/1	60 28	71 71	62 90	-	-
Master Somerville	64 75	75 103	54 361	-
Glimmer Of Light	P	33/1	1 46	1 68	1 92	-

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]20-Feb[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]3[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]68 -[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]24[/TD]

[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]30[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]62[/TD]

[TD="align: right"]5[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]30[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]4-Sep[/TD]
[TD="align: right"]80[/TD]

[TD="align: right"]60[/TD]
[TD="align: right"]140[/TD]

[TD="align: right"]80[/TD]
[TD="align: right"][/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]15[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]2-Jan[/TD]
[TD="align: right"]83[/TD]

[TD="align: right"]79[/TD]
[TD="align: right"]162[/TD]

[TD="align: right"]74[/TD]
[TD="align: right"][/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]7[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]4[/TD]

[TD="align: right"]69[/TD]

[TD="align: right"]46[/TD]
[TD="align: right"]115[/TD]

[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]27[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]Feb-50[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]15[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]77[/TD]

[TD="align: right"]50 -[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]141[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"][/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]13[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]6[/TD]
[TD="align: right"]2-Nov[/TD]
[TD="align: right"]78[/TD]

[TD="align: right"]68 -[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]152[/TD]

[TD="align: right"]78[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]15[/TD]

[TD="align: center"]21[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]51[/TD]

[TD="align: right"]41 -[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]51[/TD]

[TD="align: right"][/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]24[/TD]

[TD="align: center"]22[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]85[/TD]

[TD="align: right"]72[/TD]
[TD="align: right"]157[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]12[/TD]

[TD="align: center"]23[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]77[/TD]

[TD="align: right"]69[/TD]
[TD="align: right"]146[/TD]

[TD="align: right"]77[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]13[/TD]

[TD="align: center"]24[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]2-Nov[/TD]
[TD="align: right"]83[/TD]

[TD="align: right"]79[/TD]
[TD="align: right"]162[/TD]

[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]14[/TD]

[TD="align: center"]25[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]4-Nov[/TD]
[TD="align: right"]77[/TD]

[TD="align: right"]47[/TD]
[TD="align: right"]124[/TD]

[TD="align: right"]77[/TD]
[TD="align: right"][/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]16[/TD]

[TD="align: center"]26[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]7[/TD]
[TD="align: right"]1-Dec[/TD]
[TD="align: right"]71[/TD]

[TD="align: right"]47[/TD]
[TD="align: right"]118[/TD]

[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]14[/TD]

[TD="align: center"]27[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]3[/TD]

[TD="align: right"]79[/TD]

[TD="align: right"]23[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]23[/TD]

[TD="align: center"]28[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]5[/TD]
[TD="align: right"]1-Sep[/TD]
[TD="align: right"]75[/TD]

[TD="align: right"]63[/TD]
[TD="align: right"]138[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"][/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]15[/TD]

[TD="align: center"]29[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]1-Dec[/TD]
[TD="align: right"]69[/TD]

[TD="align: right"]24[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]25[/TD]

[TD="align: center"]30[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]9[/TD]

[TD="align: right"]78[/TD]

[TD="align: right"]43[/TD]
[TD="align: right"]121[/TD]

[TD="align: right"]68[/TD]
[TD="align: right"][/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]25[/TD]

[TD="align: center"]31[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]80[/TD]

[TD="align: right"]21[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"][/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]30[/TD]

[TD="align: center"]32[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]2[/TD]

[TD="align: right"]60[/TD]

[TD="align: right"]21[/TD]
[TD="align: right"]81[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"][/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]29[/TD]

[TD="align: center"]33[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]4[/TD]

[TD="align: right"]73[/TD]

[TD="align: right"]22[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"][/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]24[/TD]

[TD="align: center"]34[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]8[/TD]

[TD="align: right"]71[/TD]

[TD="align: right"]32[/TD]
[TD="align: right"]103[/TD]
[TD="align: right"]71[/TD]

[TD="align: right"][/TD]
[TD="align: right"]46[/TD]
[TD="align: right"]25[/TD]

[TD="align: center"]35[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]36[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]37[/TD]
[TD="align: right"]20-Mar[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]38[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]39[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]40[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]41[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]42[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]71[/TD]

[TD="align: right"]24[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]25[/TD]

[TD="align: center"]43[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]73[/TD]

[TD="align: right"]48[/TD]
[TD="align: right"]121[/TD]

[TD="align: right"]73[/TD]
[TD="align: right"][/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]21[/TD]

[TD="align: center"]44[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]3[/TD]
[TD="align: right"]1-Apr[/TD]
[TD="align: right"]76[/TD]

[TD="align: right"]52[/TD]
[TD="align: right"]128[/TD]

[TD="align: right"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]8[/TD]

[TD="align: center"]45[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]77[/TD]

[TD="align: right"]47[/TD]
[TD="align: right"]124[/TD]

[TD="align: right"][/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]20[/TD]

[TD="align: center"]46[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]1-Mar[/TD]
[TD="align: right"]79[/TD]

[TD="align: right"]73[/TD]
[TD="align: right"]152[/TD]

[TD="align: right"][/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]13[/TD]

[TD="align: center"]47[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]6[/TD]

[TD="align: right"]75[/TD]

[TD="align: right"]63[/TD]
[TD="align: right"]138[/TD]

[TD="align: right"]71[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]18[/TD]

[TD="align: center"]48[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]73[/TD]

[TD="align: right"]47[/TD]
[TD="align: right"]120[/TD]

[TD="align: right"]68[/TD]
[TD="align: right"][/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]18[/TD]

[TD="align: center"]49[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]77[/TD]

[TD="align: right"]13[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]7[/TD]

[TD="align: right"][/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]30[/TD]

[TD="align: center"]50[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]4[/TD]
[TD="align: right"]1-Dec[/TD]
[TD="align: right"]71[/TD]

[TD="align: right"]74 -[/TD]

[TD="align: right"]73[/TD]
[TD="align: right"]144[/TD]

[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]7[/TD]

[TD="align: center"]51[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]1-Aug[/TD]
[TD="align: right"]65[/TD]

[TD="align: right"]21[/TD]
[TD="align: right"]86[/TD]

[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]29[/TD]

[TD="align: center"]52[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]1-Oct[/TD]
[TD="align: right"]79[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]30[/TD]

[TD="align: center"]53[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]72[/TD]

[TD="align: right"]60[/TD]
[TD="align: right"]132[/TD]

[TD="align: right"]72[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]26[/TD]

[TD="align: center"]54[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]5[/TD]
[TD="align: right"]1-Aug[/TD]
[TD="align: right"]63[/TD]

[TD="align: right"]54[/TD]
[TD="align: right"]117[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]16[/TD]

[TD="align: center"]55[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]7[/TD]
[TD="align: right"]1-Aug[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]1 -[/TD]
[TD="align: right"]66 -[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]24[/TD]

[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]24[/TD]

[TD="align: center"]56[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]57[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]58[/TD]
[TD="align: right"]Mar-50[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]59[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]60[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]61[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]62[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]63[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]85[/TD]

[TD="align: right"]54[/TD]
[TD="align: right"]139[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]13[/TD]

[TD="align: center"]64[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]11-Oct[/TD]
[TD="align: right"]85[/TD]

[TD="align: right"]74[/TD]
[TD="align: right"]159[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"][/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]6[/TD]

[TD="align: center"]65[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]1-May[/TD]
[TD="align: right"]85[/TD]

[TD="align: right"]79[/TD]
[TD="align: right"]164[/TD]

[TD="align: right"]85[/TD]
[TD="align: right"][/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]8[/TD]

[TD="align: center"]66[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]5[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]56 -[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]26[/TD]

[TD="align: center"]67[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]3[/TD]

[TD="align: right"]85[/TD]

[TD="align: right"]45[/TD]
[TD="align: right"]130[/TD]

[TD="align: right"]85[/TD]
[TD="align: right"][/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]21[/TD]

[TD="align: center"]68[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]76[/TD]

[TD="align: right"]65[/TD]
[TD="align: right"]141[/TD]

[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]14[/TD]

[TD="align: center"]69[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]4[/TD]

[TD="align: right"]80[/TD]

[TD="align: right"]47[/TD]
[TD="align: right"]127[/TD]

[TD="align: right"]80[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]25[/TD]

[TD="align: center"]70[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]71[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]72[/TD]
[TD="align: right"]Apr-50[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]73[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]74[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]75[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]76[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]77[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]73[/TD]

[TD="align: right"]1 -[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]98[/TD]

[TD="align: right"][/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]25[/TD]

[TD="align: center"]78[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]8[/TD]

[TD="align: right"]61[/TD]

[TD="align: right"]1 -[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]82[/TD]

[TD="align: right"][/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]26[/TD]

[TD="align: center"]79[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]5[/TD]
[TD="align: right"]2-Nov[/TD]
[TD="align: right"]77[/TD]

[TD="align: right"]72[/TD]
[TD="align: right"]149[/TD]
[TD="align: right"]77[/TD]

[TD="align: right"][/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]9[/TD]

[TD="align: center"]80[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]4[/TD]
[TD="align: right"]1-Apr[/TD]
[TD="align: right"]79[/TD]

[TD="align: right"]66[/TD]
[TD="align: right"]145[/TD]

[TD="align: right"][/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]7[/TD]

[TD="align: center"]81[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]79[/TD]

[TD="align: right"]63 -[/TD]
[TD="align: right"]86 -[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]155[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"][/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]11[/TD]

[TD="align: center"]82[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]1-May[/TD]
[TD="align: right"]81[/TD]

[TD="align: right"]52[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]73[/TD]

[TD="align: right"][/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]19[/TD]

[TD="align: center"]83[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]3[/TD]
[TD="align: right"]1-Jul[/TD]
[TD="align: right"]78[/TD]

[TD="align: right"]47[/TD]
[TD="align: right"]125[/TD]

[TD="align: right"][/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]23[/TD]

[TD="align: center"]84[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]69[/TD]

[TD="align: right"]81 -[/TD]
[TD="align: right"]69 -[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]142[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"][/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]12[/TD]

[TD="align: center"]85[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]6[/TD]

[TD="align: right"]71[/TD]

[TD="align: right"]64[/TD]
[TD="align: right"]135[/TD]

[TD="align: right"][/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]17[/TD]

[TD="align: center"]86[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]7[/TD]
[TD="align: right"]2-Nov[/TD]
[TD="align: right"]75[/TD]

[TD="align: right"]64[/TD]
[TD="align: right"]139[/TD]

[TD="align: right"]75[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]20[/TD]

[TD="align: center"]87[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]74[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]75[/TD]

[TD="align: right"]74[/TD]
[TD="align: right"][/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]30[/TD]

</tbody>

Sheet2

obviously the next url need to be placed under the last and then carry on

John_w · Jan 9, 2014

Try this:

Code:

Sub Get_Web_Data()

    Dim URLs As Range, URL As Range
    Dim destCell As Range
    
    With Sheets("Sheet1")
        Set URLs = .Range("A1", .Cells(Rows.Count, "A").End(xlUp))
    End With
    
    For Each URL In URLs
        With Sheets("Sheet2")
            Set destCell = .Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
            With .QueryTables.Add(Connection:="URL;" & URL.Value, Destination:=destCell)
                .Name = "web_query"
                .WebSelectionType = xlEntirePage
                .WebFormatting = xlWebFormattingNone
                .WebDisableDateRecognition = True
                .Refresh False
            End With
            .QueryTables(1).Delete
            DoEvents
        End With
    Next
        
End Sub

Data extraction

mbugg4

New Member

Excel Facts

hiker95

Well-known Member

jsotola

Well-known Member

mbugg4

New Member

John_w

MrExcel MVP

Similar threads

Forum statistics

Share this page

Data extraction

mbugg4

New Member

Excel Facts

hiker95

Well-known Member

jsotola

Well-known Member

mbugg4

New Member

John_w

MrExcel MVP

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock