I would like to create a DB for stock and option trading. I am not sure how to properly create the tables and which relationships to create. Here are the basic design logic/requirements I have come up with but I can't figure out the proper way to put this into Access:
Many accounts have many transactions.
Accounts have the following:
Flat Rate Commission Price
Per Contract Commission Price
Account Number (PK)
Account Info
Transactions have the following:
Date
Time
Description (short text)
Reference Number (PK)
Stock Type (Stock or Option)
Stocks have the following:
Ticker Symbol
Quantity
Action
Transaction Price
Options have the following:
Type (Call or Put)
Strike Price
Days to Expiration
Action
Transaction Price
Expiration Date
Ticker Symbol
Quantity
Actions:
Buy to Open
Sell to Open
Buy to Close
Sell to Close
Any visual/graphic help from someone more experienced would be massively appreciated. Thank you.