Don't hate the rookie....please help -- simple question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I would like to design a database which helps me track some stock information
which builds daily. I have an Excel file with 500 stock tickers (fixed) and
dates at top of columns. What is the best way to represent this data? I need
to calculate and report % change in the Wk EPS values. Do I build a table
for each date? Or each Ticker? Each day the data will increase and I would
like to notice trends (i.e. one week or one moth trends). I have read the
database design documents and help file to no avail...Thank you in advance.

Sample:
4/22/05 4/25/2005 4/26/2005 4/27/2005
Symbol Wk EPS Wk EPS Wk EPS Wk EPS
UIS 1 4 88 90
MAT 2 41 41 95
DYN 1 93 41 41
HAS 2 4 8 41
DPH 3 41 41 41
NAV 3 41 41 41
CSX 8 6 41 74
SANM 5 41 41 41
FITB 6 10 41 41
FRE 6 8 41 41

.

Relevant Pages

  • Re: Dont hate the rookie....please help -- simple question
    ... >I would like to design a database which helps me track some stock information ... I have an Excel file with 500 stock tickers and ... >database design documents and help file to no avail...Thank you in advance. ... A tall-thin table is the ticket (ticker?) here: ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Forms with Options?
    ... 'Cancel' a RuntimeError 3131 and Syntax error shows up. ... If your excel file does not have then, ... spreadsheet to a database, Access will create 2 other error tables. ...
    (microsoft.public.access.formscoding)
  • RE: Forms with Options?
    ... Dim tName As String 'Holds the name of the table to be modified ... If your excel file does not have then, ... spreadsheet to a database, Access will create 2 other error tables. ...
    (microsoft.public.access.formscoding)
  • RE: Forms with Options?
    ... Dim tName As String 'Holds the name of the table to be modified ... If your excel file does not have then, ... spreadsheet to a database, Access will create 2 other error tables. ...
    (microsoft.public.access.formscoding)
  • Re: MS Word/table/font changes
    ... column you want to be in italics and set it to normal. ... A database is not useful for remote work, ... on the portable computer, put in one file the data ... line where I put in blue the cell no. 1 of an Excel file, ...
    (soc.genealogy.computing)