Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
challenging "share stock" average prices
heloo if i have 5 columns like these suppose that this is a sell and buy stocks forum the first column is company number the second column is company name the third column is for quantity the forth is for buy price the fifth column is for sell price as shwon belo 1 microsoft 100 50 2 sakhr 3 intel 1 microsoft 100 60 1 microsoft 100 (this is blank cell) 40 1 microsoft 100 40 and i want to average the price of the stock (for only the numer on company (microsoft) ) so the result will be ((100*50+100*60)/(100+100))=55 (is the average price of the 20 stock)(downto the forth row) then i sell 100 (in the fifth row) so the result is 100 stock with average price 55 then i buy 100 with price 40 so the final result will be (100*55+100*40)/(100+100)=47.5 how can i do that in excel?? -- amrezza ----------------------------------------------------------------------- amrezzat's Profile: http://www.excelforum.com/member.php...fo&userid=2876 View this thread: http://www.excelforum.com/showthread.php?threadid=48583 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"num#" errors .. how to average a group with a "num#" error | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Why does excell switch my stock symbol "ACN" to "CAN"? | Setting up and Configuration of Excel | |||
cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
challenging "share stock" average prices | Excel Worksheet Functions |