Recommended database structure
I would like to do a financial portfolio analysis application.
I will enter financial results every month or quarter for each year, for initially 10 stock funds. Stock funds may be added or removed over time.
What is the best way to structure the tables? One table for all of the financial data or a table for each stock fund or some other structure?
I will be graphing quarterly results and comparing results between stock funds over periods of time.
Can anyone point me to an example of something similar?