Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Price Averaging, auto update
I'm doing a project for an Economics class and am having so much trouble,
somebody please help me! I am trying to come up with a function for a spreadsheet that would take additions to a price format, average the result in and automatically update my spreadsheet. I've searched a few knowledge bases, consulted "help", even talked to people and found no solution. Anybody who has an ideas please HELP! Here is an example of what I'm trying to update. Column A is the stock symbol, Column B is stock theoretically sold, Column C the previous average price. Column D is stock bought and Column E the previous average price for that. HBC 200 85.18 HSBA.L 1000 84.95283 Here is an example of what I need added (the message box has wrapped the line). I need the program to sort sells from buys so it knows where to put the info. Also Column C (not B, I don't know what that is) here is the actual stock done. I need the program to find the right stock first. I've tried using vlookup but for some reason it returns the wrong result. Then I need the program to figure out a new average price and automatically update the sheet above, and record the profit or loss. I mean I've done it in steps, but there are so many steps I'd be better off using a calculator! SOLD 500 180 HSBA.L 916 DEMO 14:58:08 Day 1.857 1.8576 180 85.0506 0 SOLD 500 320 HSBA.L 916 DEMO 14:58:08 Day 1.857 1.8576 320 85.0506 0 BOUGHT 36 36 HBC 85.13 DEMO 14:58:10 Day 0.0006 36 0 30.6468 BOUGHT 64 64 HBC 85.13 DEMO 14:58:11 Day 0.0006 64 0 54.4832 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel doesn't recognize stock symbol and won't update price | New Users to Excel | |||
How to update a price list with another price list from another sh | Excel Discussion (Misc queries) | |||
How do I update price lists easily from a central source? | Excel Discussion (Misc queries) | |||
update prices in inventory based on downloaded price list?? | Excel Worksheet Functions | |||
Client list price update | Excel Worksheet Functions |