Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
total running balance
I have a data with stocks (shares) purchased date and sold date
Along with a price. I want to calculate my daily amount invested in stock market can someone tell me how can I see : bought entry $ sold price $ 5/5/7 5 6/6/7 5.25 5/27/7 12.25 6/9/7 13.25 using this and so for many more trades how to get daily amount invested in stock market? here is the Spreadsheet in google docs it will be helpful to see what i am asking for (type or click) http://spreadsheets.google.com/pub?k...vkiz8KMg&gid=0 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
total running balance
You may want to look at the help index for SUMIF -- Don Guillett Microsoft MVP Excel SalesAid Software "chusu" wrote in message ups.com... I have a data with stocks (shares) purchased date and sold date Along with a price. I want to calculate my daily amount invested in stock market can someone tell me how can I see : bought entry $ sold price $ 5/5/7 5 6/6/7 5.25 5/27/7 12.25 6/9/7 13.25 using this and so for many more trades how to get daily amount invested in stock market? here is the Spreadsheet in google docs it will be helpful to see what i am asking for (type or click) http://spreadsheets.google.com/pub?k...vkiz8KMg&gid=0 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a running total (balance) in a pivot table? | Excel Worksheet Functions | |||
to keep a running balance | Excel Discussion (Misc queries) | |||
rent received/balance owed/running balance spreadsheet | Excel Discussion (Misc queries) | |||
How do i set up a running balance on one row? | Excel Worksheet Functions | |||
running balance | New Users to Excel |