[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

ISO Access and Excel Genius



PureBytes Links

Trading Reference Links


I want 
to take reports generated by William O'Neil's Daily Graphs and combine them into 
1 large database. 
<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> 
<FONT 
size=2>My 
problem is opening in Access the 18 reports (from Daily Graphs) that these 
fields come from so that I can combine this 
data
<FONT 
size=2><SPAN 
class=343314116-22012001> 
<FONT 
size=2>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.
<FONT 
size=2><SPAN 
class=343314116-22012001> 
<FONT 
size=2>Then 
I can use TC2000 to do further screens and collect the Daily data for export to 
MetaStock 7.02
<FONT 
size=2><SPAN 
class=343314116-22012001> 
<FONT 
size=2>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> 
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>