I would have 2 tables. One with 700-800 rows (one row for each stock) with
a unique integer ID column for each stock (autonum). The row can have
whatever columns are needed to describe the stock (name, type, etc).
The second table would have the ID column, a data date and then the other
120 or so indicator value columns. It can have millions of rows (or more)
in the second table. You can index the stock ID and the date, if desired.
Then you can create one main entry/edit form for stocks and one main
entry/edit form for the daily indicators with one (or more)reports
controlled by one (or more) command file(s).
Frank Radice
[EMAIL PROTECTED]
----------------------------------------------------------------------------
-----
>
> The database holds many years of price data information on about 700 - 800
> stocks. This involves the technical analysis of stocks. It will take the
data
> and calculate about 120 indicator values and store them in the database.
One
> value for every day of data. Then another routine will analyse the data
giving
> the best indicators that worked during certain periods of time. These
> indicators will be stored in the database and the daily data will be
tested by
> these optimized indicators giving buy and sell signals. It is actually
even more
> complex but that gives you the gist of what is happening.
>
> Best regards,
> Mike Young
>
>
