Need Advice With Stock Tracking/calculations.

Can someone tell me if Excel can handle stock tracking/calculations.

Ex. I have some stocks in/out of the market for the last few years.

I want to input the following:
1) date bought
2) date sold
3) Profit or Loss in $ amount
4) Maybee stock name or some other needed criteria.

I want to be able to query/sort by lets say
1) How many positions I had in the market between or on a certain date/s.
2) What's the profit/loss amount I had in certain date/s.
3) What's the highest/lowest amount of positions held in the market at one time.

Can this be done in Access or even SQL? What's the best way to approach this or is there a similar table I can find somewhere?

Thanks.