My database is to keep a record of investments. I have a separate table for each Stock I am tracking as I have things like a chart mapping the Week ending price for each stock. The last few columns on the table are purely keeping track of each weeks price for the line chart so I can view the progress of the stock over time. The other rows on the table are taken up with each transaction Buy/Sell for each stock, so they need to be sorted by date, whereas the last few columns relate to the chart. I would prefer not to create yet another table for the chart information. I would welcome any suggestions.
