|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 5th, 2007, 10:51 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Stock Performance
I want to set-up a database to track stock performance for several people who
would buy and sell (virtual) stocks. Their performance would be evaluated monthly or quarterly. I would need a table for players and a table for stocks (symbol, name, P/E ratio, etc). Would I just need one table for purchases and sales? I'd appreciate any suggestions. -- Howard 
|
|
#2
January 5th, 2007, 11:51 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Stock Performance
Howard,
Yes... one table would be preferred. Think of your stocks, in and out, as a checkbook. A credit field for +Purchases and a debit field for -Sales. Then, a simple totals query Sum(Purchases)-Sum(Sales) grouped by Ticker symbol yields the exact number OnHand at any time. hth Al Campagna Candia Computer Consulting Microsoft MVP - Candia, NH USA http://home.comcast.net/~cccsolutions "Find a job that you love, and you'll never work a day in your life." "Howard" wrote in message ... I want to set-up a database to track stock performance for several people who would buy and sell (virtual) stocks. Their performance would be evaluated monthly or quarterly. I would need a table for players and a table for stocks (symbol, name, P/E ratio, etc). Would I just need one table for purchases and sales? I'd appreciate any suggestions. -- Howard
|
|
#3
January 6th, 2007, 12:50 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Stock Performance
Thanks, Al.
That's exactly what I wanted: How to compute the exact number on hand at any given time. -- Howard "Al Campagna" wrote: Howard, Yes... one table would be preferred. Think of your stocks, in and out, as a checkbook. A credit field for +Purchases and a debit field for -Sales. Then, a simple totals query Sum(Purchases)-Sum(Sales) grouped by Ticker symbol yields the exact number OnHand at any time. hth Al Campagna Candia Computer Consulting Microsoft MVP - Candia, NH USA http://home.comcast.net/~cccsolutions "Find a job that you love, and you'll never work a day in your life." "Howard" wrote in message ... I want to set-up a database to track stock performance for several people who would buy and sell (virtual) stocks. Their performance would be evaluated monthly or quarterly. I would need a table for players and a table for stocks (symbol, name, P/E ratio, etc). Would I just need one table for purchases and sales? I'd appreciate any suggestions. -- Howard
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
