ballterrier
New Member
Lol SirJB7,
Not speaking to you for nearly three days is most disappointing :>
the setup of the spreadsheet I would like is as follows:
(1) Ticker name in column A, following by all the stock names underneath as follows:
AAC
ABC
ACR
AGK
AIX
AMC
AMP
ANN
ANZ
APA
ARG
ASB
ASX
AWC
AWE
AZJ
BBG
BEN
BHP
BKL
BKN
BLD
BOQ
BSL
BWP
BXB
CAB
CBA
CCL
CGF
COH
CPU
CSL
CTX
DJS
DMP
DOW
DUE
ERA
FLT
FMG
FXJ
GFF
GNS
HVN
IIN
ILU
IPL
IRE
JBH
JHX
KAR
LEI
LLC
LNC
MLB
MND
MQG
MTS
MYR
NAB
NCM
NWS
ORG
ORI
OSH
PDN
PPT
QAN
QBE
RHC
RIO
RMD
SEK
SGM
SGP
SGT
SHL
SKI
SLX
STO
SUN
SWM
SYD
TAH
TEN
TGR
TOL
TRS
TTS
UGL
WBC
WDC
WOW
WPL
WTF
(2)Then I would put headers in the next 85 columns (ie following Ticker Name in column A),
(3) The vba code would then would wrap sevens times to collate all the data for all the above stock codes and the undermentioned Yahoo tags, and extract them in the 85 columns for each stock.
Note: I have changed the stock codes, as I have noticed that there are some differences in the codes used in the stock screener spreadsheet, and the ones I have found. It's probably because this code was made over 4-5 yras ago.
a
a2
a5
b
b2
b3
b4
b6
c
c1
c3
c6
c8
d1
d
d2
e
e3
e7
e8
e9
f6
g
g1
g3
g4
g5
g6
h
i
i5
j1
j3
j4
j5
j6
k1
k2
k3
k4
k5
l
l1
l2
l3
m
m2
m3
m4
m5
m6
m7
m8
n
n4
o
p1
p2
p2
p3
p5
p6
q
r
r1
r2
r5
r6
r7
s
s1
s3
s7
t1
t6
t7
t8
v
v1
v7
w
w1
w4
x
y
Regards,
Ballterrier
Not speaking to you for nearly three days is most disappointing :>
the setup of the spreadsheet I would like is as follows:
(1) Ticker name in column A, following by all the stock names underneath as follows:
AAC
ABC
ACR
AGK
AIX
AMC
AMP
ANN
ANZ
APA
ARG
ASB
ASX
AWC
AWE
AZJ
BBG
BEN
BHP
BKL
BKN
BLD
BOQ
BSL
BWP
BXB
CAB
CBA
CCL
CGF
COH
CPU
CSL
CTX
DJS
DMP
DOW
DUE
ERA
FLT
FMG
FXJ
GFF
GNS
HVN
IIN
ILU
IPL
IRE
JBH
JHX
KAR
LEI
LLC
LNC
MLB
MND
MQG
MTS
MYR
NAB
NCM
NWS
ORG
ORI
OSH
PDN
PPT
QAN
QBE
RHC
RIO
RMD
SEK
SGM
SGP
SGT
SHL
SKI
SLX
STO
SUN
SWM
SYD
TAH
TEN
TGR
TOL
TRS
TTS
UGL
WBC
WDC
WOW
WPL
WTF
(2)Then I would put headers in the next 85 columns (ie following Ticker Name in column A),
(3) The vba code would then would wrap sevens times to collate all the data for all the above stock codes and the undermentioned Yahoo tags, and extract them in the 85 columns for each stock.
Note: I have changed the stock codes, as I have noticed that there are some differences in the codes used in the stock screener spreadsheet, and the ones I have found. It's probably because this code was made over 4-5 yras ago.
a
a2
a5
b
b2
b3
b4
b6
c
c1
c3
c6
c8
d1
d
d2
e
e3
e7
e8
e9
f6
g
g1
g3
g4
g5
g6
h
i
i5
j1
j3
j4
j5
j6
k1
k2
k3
k4
k5
l
l1
l2
l3
m
m2
m3
m4
m5
m6
m7
m8
n
n4
o
p1
p2
p2
p3
p5
p6
q
r
r1
r2
r5
r6
r7
s
s1
s3
s7
t1
t6
t7
t8
v
v1
v7
w
w1
w4
x
y
Regards,
Ballterrier