PureBytes Links
Trading Reference Links
|
I am
indeed talking about IBD's daily graphs online not thier IBD
Website
Lonnie Lepptllepp@xxxxxx
<FONT face=Tahoma
size=2>-----Original Message-----From:
owner-metastock@xxxxxxxxxxxxx [mailto:owner-metastock@xxxxxxxxxxxxx]On
Behalf Of Lionel IssenSent: Monday, January 22, 2001 1:08
PMTo: metastock@xxxxxxxxxxxxxSubject: Re: ISO Access and
Excel Genius
Lonnie:
Keep me posted. this sounds useful. I assume
that you are talking about the online version of IBD.
Lionel Issen<A
href="mailto:lissen@xxxxxxxxxxxxxx">lissen@xxxxxxxxxxxxxx
<BLOCKQUOTE dir=ltr
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
----- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
Lonnie Lepp
To: <A
href="mailto:metastock@xxxxxxxxxxxxx"
title=metastock@xxxxxxxxxxxxx>metastock@xxxxxxxxxxxxx
Sent: Monday, January 22, 2001 11:24
AM
Subject: ISO Access and Excel
Genius
I
want to take reports generated by William O'Neil's Daily Graphs and combine
them into 1 large database.
<SPAN
class=343314116-22012001>
<SPAN
class=343314116-22012001>Then I want to filter out the fundamental criteria
of the very best stocks available.
<FONT
color=#0000ff>
T<SPAN
class=343314116-22012001>he following is a list of field
names
<SPAN
class=343314116-22012001>Symbol; Stock
Name; EPS; RS; Group
RS by Letter ; Group RS by number;
SMR; Acc/Dis; Acc/Dis Last
Week; Price; Price
Change; Vol; Vol% vs.
50maVol; Industry Group: Group Ranking
current; Group Ranking Last
Week; Group Ranking 3 months
ago; 52 week
High; 1 week High; Prior week
High; Prior week high date; IBD
Page; Timeliness; Timeliness last
week; % growth rate;
<SPAN
class=343314116-22012001>
<SPAN
class=343314116-22012001><FONT
face=Arial>My problem is opening in Access
the 18 reports (from Daily Graphs) that these fields come from so that I can
combine this data
<SPAN
class=343314116-22012001><FONT
face=Arial><SPAN
class=343314116-22012001>
<SPAN
class=343314116-22012001><FONT
face=Arial>Once I can combine this data on
each stock and its industry group I can the narrow my universe of stocks
down to the ones with acceptable (to Me) values. At that point I want
to export a list of Stock Symbols and the stocks name in a tab format that
have exceed my minimum vales for each noteworthy
field.
<SPAN
class=343314116-22012001><FONT
face=Arial><SPAN
class=343314116-22012001>
<SPAN
class=343314116-22012001><FONT
face=Arial>Then I can use TC2000 to do
further screens and collect the Daily data for export to MetaStock
7.02
<SPAN
class=343314116-22012001><FONT
face=Arial><SPAN
class=343314116-22012001>
<SPAN
class=343314116-22012001><FONT
face=Arial>Daily graphs quickly
exports to Excel each individual
report
<SPAN
class=343314116-22012001>
My
problem is to export the initial Excel tables into
Access
<SPAN
class=343314116-22012001>
I
use Office 2000 and NT4Sp6
<SPAN
class=343314116-22012001>
<SPAN
class=343314116-22012001>Any help with this will be
appreciated
<SPAN
class=343314116-22012001>
I
will be glad to share the results of my studies with the
group
<SPAN
class=343314116-22012001>
Lonnie Lepptllepp@xxxxxx
<SPAN
class=343314116-22012001>
<SPAN
class=343314116-22012001>
|