Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
New
Im just curious, Im somewhat new to Excel.
I am starting to do stock market trades. For Tax purposes, I have to report my cost - and the Revenue gained so that I can be taxed on only the profit. Not only that, I have to report if it is long term or short term. In order to help me calculate Cost, Is it not best to set up a FiFO system? if that is the best way, then how do I impliment a nice spreadsheet that will help me with this? or is one already avaliable? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
New
I owuld just make a regular Excel Database.......ie with my Header row as
row1 and each transaction in it's own separate row below that. Row1 headings could be something like these, or any other that you want.... A1=Item B1=Date C1=StockCode D1=StockFullName E1=Buy/Sell F1=Quantity G1=Price/Share H1=BuyExpense I1=TotalPrice J1=TermLongShort etc etc hth Vaya con Dios, Chuck, CABGx3 "cheryl church" wrote: Im just curious, Im somewhat new to Excel. I am starting to do stock market trades. For Tax purposes, I have to report my cost - and the Revenue gained so that I can be taxed on only the profit. Not only that, I have to report if it is long term or short term. In order to help me calculate Cost, Is it not best to set up a FiFO system? if that is the best way, then how do I impliment a nice spreadsheet that will help me with this? or is one already avaliable? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|