I knocked this together this morning, no eye candy and very basic. There is room for a lot of improvement so if people post suggestions I will see if I can incorporate them. Just bear in mind I am terrible at Excel, never been trained in it so I can't accomplish miracles.
Just add the date, use the drop down box to select Buy or Sell, enter the SP (up to 2 decimal places but you can alter if you wish) and quantity, commission and stamp duty is optional, then the Debit/Credit field will populate itself. Reports can be created to see how much you have made/lost in the financial year for tax calculations and planning, this is not a feature yet though.
My ideas:
Have commission/stamp duty automatically calculated if there is a set percentage
Track profit/Loss (very easy to add)
Create reports to track individual share performance
Social Networking Bookmarks