line |
stmt |
bran |
cond |
sub |
pod |
time |
code |
1
|
|
|
|
|
|
|
#!/usr/bin/perl -w |
2
|
|
|
|
|
|
|
# vi: set ts=4 sw=4 noai ic showmode showmatch: |
3
|
|
|
|
|
|
|
|
4
|
|
|
|
|
|
|
# This program is free software; you can redistribute it and/or modify |
5
|
|
|
|
|
|
|
# it under the terms of the GNU General Public License as published by |
6
|
|
|
|
|
|
|
# the Free Software Foundation; either version 2 of the License, or |
7
|
|
|
|
|
|
|
# (at your option) any later version. |
8
|
|
|
|
|
|
|
# |
9
|
|
|
|
|
|
|
# This program is distributed in the hope that it will be useful, |
10
|
|
|
|
|
|
|
# but WITHOUT ANY WARRANTY; without even the implied warranty of |
11
|
|
|
|
|
|
|
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
12
|
|
|
|
|
|
|
# GNU General Public License for more details. |
13
|
|
|
|
|
|
|
# |
14
|
|
|
|
|
|
|
# You should have received a copy of the GNU General Public License |
15
|
|
|
|
|
|
|
# along with this program; if not, write to the Free Software |
16
|
|
|
|
|
|
|
# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA |
17
|
|
|
|
|
|
|
# 02110-1301, USA |
18
|
|
|
|
|
|
|
|
19
|
|
|
|
|
|
|
package Finance::Quote::AEX; |
20
|
|
|
|
|
|
|
|
21
|
5
|
|
|
5
|
|
3013
|
use strict; |
|
5
|
|
|
|
|
10
|
|
|
5
|
|
|
|
|
152
|
|
22
|
5
|
|
|
5
|
|
24
|
use warnings; |
|
5
|
|
|
|
|
12
|
|
|
5
|
|
|
|
|
176
|
|
23
|
|
|
|
|
|
|
|
24
|
5
|
|
|
5
|
|
37
|
use constant DEBUG => $ENV{DEBUG}; |
|
5
|
|
|
|
|
9
|
|
|
5
|
|
|
|
|
432
|
|
25
|
5
|
|
|
5
|
|
31
|
use if DEBUG, 'Smart::Comments'; |
|
5
|
|
|
|
|
8
|
|
|
5
|
|
|
|
|
26
|
|
26
|
|
|
|
|
|
|
|
27
|
5
|
|
|
5
|
|
215
|
use vars qw( $AEX_URL); |
|
5
|
|
|
|
|
9
|
|
|
5
|
|
|
|
|
313
|
|
28
|
|
|
|
|
|
|
|
29
|
5
|
|
|
5
|
|
44
|
use LWP::UserAgent; |
|
5
|
|
|
|
|
9
|
|
|
5
|
|
|
|
|
161
|
|
30
|
5
|
|
|
5
|
|
2648
|
use Web::Scraper; |
|
5
|
|
|
|
|
389853
|
|
|
5
|
|
|
|
|
42
|
|
31
|
5
|
|
|
5
|
|
3232
|
use String::Util qw(trim); |
|
5
|
|
|
|
|
12667
|
|
|
5
|
|
|
|
|
6784
|
|
32
|
|
|
|
|
|
|
|
33
|
|
|
|
|
|
|
our $VERSION = '1.58'; # VERSION |
34
|
|
|
|
|
|
|
|
35
|
|
|
|
|
|
|
sub methods { |
36
|
5
|
|
|
5
|
0
|
47
|
return (dutch => \&aex, |
37
|
|
|
|
|
|
|
aex => \&aex); |
38
|
|
|
|
|
|
|
} |
39
|
|
|
|
|
|
|
|
40
|
|
|
|
|
|
|
our @labels = qw/name symbol price last date time p_change bid ask offer open high low close volume currency method exchange/; |
41
|
|
|
|
|
|
|
|
42
|
|
|
|
|
|
|
sub labels { |
43
|
5
|
|
|
5
|
0
|
23
|
return (dutch => \@labels, |
44
|
|
|
|
|
|
|
aex => \@labels); |
45
|
|
|
|
|
|
|
} |
46
|
|
|
|
|
|
|
|
47
|
|
|
|
|
|
|
sub aex { |
48
|
0
|
|
|
0
|
0
|
|
my $quoter = shift; |
49
|
0
|
|
|
|
|
|
my $ua = $quoter->user_agent(); |
50
|
0
|
|
|
|
|
|
my $agent = $ua->agent; |
51
|
0
|
|
|
|
|
|
$ua->agent('Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36'); |
52
|
|
|
|
|
|
|
|
53
|
0
|
|
|
|
|
|
my %info; |
54
|
|
|
|
|
|
|
my $url; |
55
|
0
|
|
|
|
|
|
my $reply; |
56
|
|
|
|
|
|
|
|
57
|
0
|
|
|
|
|
|
foreach my $symbol (@_) { |
58
|
0
|
|
|
|
|
|
my $isin = undef; |
59
|
|
|
|
|
|
|
|
60
|
|
|
|
|
|
|
# eval { |
61
|
0
|
|
|
|
|
|
my $search = "https://live.euronext.com/en/search_instruments/$symbol"; |
62
|
0
|
|
|
|
|
|
$reply = $ua->get($search); |
63
|
|
|
|
|
|
|
|
64
|
|
|
|
|
|
|
### Search: $search, $reply->code |
65
|
|
|
|
|
|
|
|
66
|
0
|
0
|
|
|
|
|
if (not defined $reply->previous) { |
67
|
|
|
|
|
|
|
# Got a search page |
68
|
|
|
|
|
|
|
my $widget = scraper { |
69
|
0
|
|
|
0
|
|
|
process 'table#awl-lookup-instruments-directory-table a', 'link[]' => '@href'; |
70
|
0
|
|
|
|
|
|
}; |
71
|
|
|
|
|
|
|
|
72
|
0
|
|
|
|
|
|
my $result = $widget->scrape($reply); |
73
|
|
|
|
|
|
|
|
74
|
|
|
|
|
|
|
# die "Failed to find $symbol" unless exists $result->{link} and @{$result->{link}} > 0; |
75
|
0
|
0
|
0
|
|
|
|
unless (exists $result->{link} and @{$result->{link}} > 0) { |
|
0
|
|
|
|
|
|
|
76
|
0
|
|
|
|
|
|
$info{$symbol, 'success'} = 0; |
77
|
0
|
|
|
|
|
|
$info{$symbol, 'errormsg'} = 'Cannot find symbol ' . $symbol; |
78
|
0
|
|
|
|
|
|
next; |
79
|
|
|
|
|
|
|
} |
80
|
|
|
|
|
|
|
|
81
|
|
|
|
|
|
|
# Loop through linkarray. Skip links containing the string |
82
|
|
|
|
|
|
|
# "product/indices" |
83
|
0
|
|
|
|
|
|
for my $newlink (@{$result->{link}}) { |
|
0
|
|
|
|
|
|
|
84
|
|
|
|
|
|
|
### NewLink: $newlink |
85
|
0
|
0
|
|
|
|
|
if ( $newlink !~ /product\/indices/i ) { |
86
|
0
|
|
|
|
|
|
$url = $newlink; |
87
|
|
|
|
|
|
|
### Setting URL: $url |
88
|
0
|
|
|
|
|
|
last; |
89
|
|
|
|
|
|
|
} |
90
|
|
|
|
|
|
|
} |
91
|
|
|
|
|
|
|
|
92
|
|
|
|
|
|
|
# die "Failed to find isin" unless $url->as_string =~ m|/([A-Za-z0-9]{12}-[A-Za-z]+)/|; |
93
|
0
|
0
|
0
|
|
|
|
unless (defined($url) && $url->as_string =~ m|/([A-Za-z0-9]{12}-[A-Za-z]+)/|) { |
94
|
0
|
|
|
|
|
|
$info{$symbol, 'success'} = 0; |
95
|
0
|
|
|
|
|
|
$info{$symbol, 'errormsg'} = 'Cannot find ISIN for ' . $symbol; |
96
|
0
|
|
|
|
|
|
next; |
97
|
|
|
|
|
|
|
} else { |
98
|
0
|
|
|
|
|
|
$isin = uc($1); |
99
|
|
|
|
|
|
|
} |
100
|
|
|
|
|
|
|
|
101
|
|
|
|
|
|
|
} |
102
|
|
|
|
|
|
|
else { |
103
|
|
|
|
|
|
|
# Redirected |
104
|
|
|
|
|
|
|
my $widget = scraper { |
105
|
0
|
|
|
0
|
|
|
process 'a', 'redirect' => '@href'; |
106
|
0
|
|
|
|
|
|
}; |
107
|
|
|
|
|
|
|
|
108
|
0
|
|
|
|
|
|
my $result = $widget->scrape($reply->previous->content); |
109
|
|
|
|
|
|
|
|
110
|
|
|
|
|
|
|
# die "Failed to find $symbol in redirect" unless exists $result->{redirect}; |
111
|
0
|
0
|
|
|
|
|
unless (exists $result->{redirect}) { |
112
|
0
|
|
|
|
|
|
$info{$symbol, 'success'} = 0; |
113
|
0
|
|
|
|
|
|
$info{$symbol, 'errormsg'} = |
114
|
|
|
|
|
|
|
'Cannot find symbol ' . $symbol . ' in redirect'; |
115
|
0
|
|
|
|
|
|
next; |
116
|
|
|
|
|
|
|
} |
117
|
|
|
|
|
|
|
|
118
|
0
|
|
|
|
|
|
my $url = $result->{redirect}; |
119
|
|
|
|
|
|
|
|
120
|
|
|
|
|
|
|
# die "Failed to find isin in redirect" unless $url =~ m|/([A-Za-z0-9]{12}-[A-Za-z]+)|; |
121
|
0
|
0
|
|
|
|
|
unless ($url =~ m|/([A-Za-z0-9]{12}-[A-Za-z]+)|) { |
122
|
0
|
|
|
|
|
|
$info{$symbol, 'success'} = 0; |
123
|
0
|
|
|
|
|
|
$info{$symbol, 'errormsg'} = |
124
|
|
|
|
|
|
|
'Cannot find ISIN for ' . $symbol . ' in redirect'; |
125
|
0
|
|
|
|
|
|
next; |
126
|
|
|
|
|
|
|
} |
127
|
|
|
|
|
|
|
|
128
|
0
|
|
|
|
|
|
$isin = uc($1); |
129
|
|
|
|
|
|
|
### ISIN: $isin |
130
|
|
|
|
|
|
|
|
131
|
|
|
|
|
|
|
} |
132
|
|
|
|
|
|
|
|
133
|
|
|
|
|
|
|
# die "No isin set" unless defined $isin; |
134
|
0
|
0
|
|
|
|
|
unless (defined $isin) { |
135
|
0
|
|
|
|
|
|
$info{$symbol, 'success'} = 0; |
136
|
0
|
|
|
|
|
|
$info{$symbol, 'errormsg'} = 'No ISIN set for ' . $symbol; |
137
|
0
|
|
|
|
|
|
next; |
138
|
|
|
|
|
|
|
} |
139
|
|
|
|
|
|
|
|
140
|
|
|
|
|
|
|
# }; # End eval |
141
|
|
|
|
|
|
|
|
142
|
0
|
0
|
|
|
|
|
if ($@) { |
143
|
0
|
|
|
|
|
|
my $error = "Search failed: $@"; |
144
|
0
|
|
|
|
|
|
$info{$symbol, 'success'} = 0; |
145
|
0
|
|
|
|
|
|
$info{$symbol, 'errormsg'} = trim($error); |
146
|
0
|
|
|
|
|
|
next; |
147
|
|
|
|
|
|
|
} |
148
|
|
|
|
|
|
|
|
149
|
|
|
|
|
|
|
# eval { |
150
|
0
|
|
|
|
|
|
my $url = "https://live.euronext.com/en/ajax/getDetailedQuote/$isin"; |
151
|
0
|
|
|
|
|
|
my %form = (theme_name => 'euronext_live'); |
152
|
0
|
|
|
|
|
|
$reply = $ua->post($url, \%form); |
153
|
|
|
|
|
|
|
|
154
|
|
|
|
|
|
|
### Header : $url, $reply->code |
155
|
|
|
|
|
|
|
### Content: $reply->content |
156
|
|
|
|
|
|
|
|
157
|
|
|
|
|
|
|
my $widget = scraper { |
158
|
0
|
|
|
0
|
|
|
process 'h1#header-instrument-name strong', 'name' => ['TEXT', sub {trim($_)}]; |
|
0
|
|
|
|
|
|
|
159
|
0
|
|
|
|
|
|
process 'span#header-instrument-price', 'last' => ['TEXT', sub {trim($_)}]; |
|
0
|
|
|
|
|
|
|
160
|
|
|
|
|
|
|
# process 'div.head_detail_bottom div.col span, div.head_detail > div > div:last-child', 'date' => ['TEXT', sub {trim($_)}]; |
161
|
|
|
|
|
|
|
# process 'div.ml-2 last-price-date-time', 'date' => ['TEXT', sub {trim($_)}]; |
162
|
0
|
|
|
|
|
|
process 'div.ml-2.last-price-date-time', 'date' => ['TEXT', sub {trim($_)}]; |
|
0
|
|
|
|
|
|
|
163
|
0
|
|
|
|
|
|
}; |
164
|
|
|
|
|
|
|
|
165
|
0
|
|
|
|
|
|
my $header = $widget->scrape($reply); |
166
|
|
|
|
|
|
|
### Header getDetailedQuote: $header |
167
|
|
|
|
|
|
|
|
168
|
0
|
|
|
|
|
|
$url = "https://live.euronext.com/en/intraday_chart/getDetailedQuoteAjax/$isin/full"; |
169
|
|
|
|
|
|
|
|
170
|
0
|
|
|
|
|
|
$reply = $ua->get($url); |
171
|
|
|
|
|
|
|
$widget = scraper { |
172
|
0
|
|
|
0
|
|
|
process 'div.table-responsive td:first-child, div.table-responsive td:first-child + td', 'data[]' => ['TEXT', sub {trim($_)}]; |
|
0
|
|
|
|
|
|
|
173
|
0
|
|
|
|
|
|
}; |
174
|
|
|
|
|
|
|
|
175
|
|
|
|
|
|
|
### Body : $url, $reply->code |
176
|
|
|
|
|
|
|
|
177
|
0
|
|
|
|
|
|
my $body = $widget->scrape($reply); |
178
|
|
|
|
|
|
|
|
179
|
|
|
|
|
|
|
# die "Failed to find detailed quote table" unless exists $body->{data}; |
180
|
0
|
0
|
|
|
|
|
unless (exists $body->{data}) { |
181
|
0
|
|
|
|
|
|
$info{$symbol, 'success'} = 0; |
182
|
0
|
|
|
|
|
|
$info{$symbol, 'errormsg'} = 'Failed to find detailed quote table'; |
183
|
0
|
|
|
|
|
|
next; |
184
|
|
|
|
|
|
|
} |
185
|
|
|
|
|
|
|
|
186
|
0
|
|
|
|
|
|
my %table = @{$body->{data}}; |
|
0
|
|
|
|
|
|
|
187
|
|
|
|
|
|
|
|
188
|
0
|
|
|
|
|
|
$info{$symbol, 'success'} = 1; |
189
|
0
|
|
|
|
|
|
$info{$symbol, 'currency'} = $table{Currency}; |
190
|
0
|
|
|
|
|
|
$info{$symbol, 'volume'} = $table{Volume}; |
191
|
0
|
|
|
|
|
|
$info{$symbol, 'volume'} =~ s/,//g; |
192
|
0
|
|
|
|
|
|
$info{$symbol, 'open'} = $table{Open}; |
193
|
0
|
|
|
|
|
|
$info{$symbol, 'high'} = $table{High}; |
194
|
0
|
|
|
|
|
|
$info{$symbol, 'low'} = $table{Low}; |
195
|
|
|
|
|
|
|
|
196
|
0
|
|
|
|
|
|
$info{$symbol, 'name'} = $header->{name}; |
197
|
0
|
0
|
|
|
|
|
$info{$symbol, 'isin'} = $1 if $isin =~ /([A-Z0-9]{12})/; |
198
|
0
|
|
|
|
|
|
$info{$symbol, 'last'} = $header->{last}; |
199
|
|
|
|
|
|
|
|
200
|
0
|
0
|
|
|
|
|
$quoter->store_date(\%info, $symbol, {eurodate => $1}) if $header->{date} =~ m|([0-9]{2}/[0-9]{2}/[0-9]{4})|; |
201
|
|
|
|
|
|
|
# }; # End eval |
202
|
|
|
|
|
|
|
|
203
|
0
|
0
|
|
|
|
|
if ($@) { |
204
|
0
|
|
|
|
|
|
my $error = "Fetch/Parse failed: $@"; |
205
|
0
|
|
|
|
|
|
$info{$symbol, 'success'} = 0; |
206
|
0
|
|
|
|
|
|
$info{$symbol, 'errormsg'} = trim($error); |
207
|
0
|
|
|
|
|
|
next; |
208
|
|
|
|
|
|
|
} |
209
|
|
|
|
|
|
|
} |
210
|
|
|
|
|
|
|
|
211
|
0
|
|
|
|
|
|
$ua->agent($agent); |
212
|
|
|
|
|
|
|
|
213
|
0
|
0
|
|
|
|
|
return wantarray() ? %info : \%info; |
214
|
|
|
|
|
|
|
} |
215
|
|
|
|
|
|
|
|
216
|
|
|
|
|
|
|
1; |
217
|
|
|
|
|
|
|
|
218
|
|
|
|
|
|
|
=head1 NAME |
219
|
|
|
|
|
|
|
|
220
|
|
|
|
|
|
|
Finance::Quote::AEX - Obtain quotes from Amsterdam Euronext eXchange |
221
|
|
|
|
|
|
|
|
222
|
|
|
|
|
|
|
=head1 SYNOPSIS |
223
|
|
|
|
|
|
|
|
224
|
|
|
|
|
|
|
use Finance::Quote; |
225
|
|
|
|
|
|
|
|
226
|
|
|
|
|
|
|
$q = Finance::Quote->new; |
227
|
|
|
|
|
|
|
|
228
|
|
|
|
|
|
|
%info = $q->fetch("aex", "AMG"); # Only query AEX |
229
|
|
|
|
|
|
|
%info = $q->fetch("dutch", "AMG"); # Failover to other sources OK |
230
|
|
|
|
|
|
|
|
231
|
|
|
|
|
|
|
=head1 DESCRIPTION |
232
|
|
|
|
|
|
|
|
233
|
|
|
|
|
|
|
This module fetches information from https://live.euronext.com. Stocks and bonds |
234
|
|
|
|
|
|
|
are supported. |
235
|
|
|
|
|
|
|
|
236
|
|
|
|
|
|
|
This module is loaded by default on a Finance::Quote object. It's also possible |
237
|
|
|
|
|
|
|
to load it explicitly by placing 'aex' in the argument list to |
238
|
|
|
|
|
|
|
Finance::Quote->new(). |
239
|
|
|
|
|
|
|
|
240
|
|
|
|
|
|
|
=head1 LABELS RETURNED |
241
|
|
|
|
|
|
|
|
242
|
|
|
|
|
|
|
The following labels may be returned: currency date high isin isodate last low |
243
|
|
|
|
|
|
|
name open success symbol volume. |
244
|
|
|
|
|
|
|
|
245
|
|
|
|
|
|
|
=head1 Terms & Conditions |
246
|
|
|
|
|
|
|
|
247
|
|
|
|
|
|
|
Use of live.euronext.com is governed by any terms & conditions of that site. |
248
|
|
|
|
|
|
|
|
249
|
|
|
|
|
|
|
Finance::Quote is released under the GNU General Public License, version 2, |
250
|
|
|
|
|
|
|
which explicitly carries a "No Warranty" clause. |
251
|
|
|
|
|
|
|
|
252
|
|
|
|
|
|
|
=cut |