Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To creat scrip ledger
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
To creat scrip ledger
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for ledger | Excel Discussion (Misc queries) | |||
in excel , arrange scrip names alphabatically | Excel Discussion (Misc queries) | |||
General Ledger Template | Excel Worksheet Functions | |||
Ledger form | Excel Discussion (Misc queries) | |||
how do i set up a purchase ledger | Excel Discussion (Misc queries) |