You'll probably have to supply more information, because on the surface this
isn't very difficult. Use one row in Excel for each transaction. Have
columns for Date, Purchases, Sells, Balance. Balance is Previous +
purchases - sells. You can add further columns if you want to keep track of
amounts, dividends, etc.

Regards,
Fred.

"Rasik" wrote in message
...
I am using M.Excel to list all my sales and purchases of eq stock.
I want to creat ledger scrip wise with values .And also the balance
quantity