The Community will be undergoing maintenance from Friday February 21 - Friday, February 29 and will be "read only" during this time. To learn more, check out our Announcements blog post.
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.