Hi,
I'm trying to create a database that will calculate an ongoing volume and average price for stocks that I am trading.
For example,
I have been buying stock ABC over the past 5 days and want to know what my current vol and avg price is.
I want to create a form where I can enter the following fields each day:
Ticker
Traded Shares
Traded Price
Once I put in the Ticker, Traded Shares, and Traded Price, I'd like to see an output that shows my total volume and avg price for all the previous days I've traded the same symbol.
I was able to do this in excel but its very ugly. I was hoping I could do this in access but am unable to figure out how to get this going.
Thanks