Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
First In First Out Function
I am trying to find a formula that will do the following.
Say I am buying and selling stocks. On day 1, I buy 5 shares of ABC stock at $10 each. On day 2, I buy 10 shares of ABC stock at $15 each. On day 3, I buy 15 shares of ABC stock at $20 each. On day 4, I sell 20 shares of ABC stock at $18 each. What I need is a formula that will take the amount I sold (20 shares), subtract out the first 5 shares I bought on day 1, then subtract the 10 shares I bought on day 2, and then only take 5 of the share bought on day 3 because that is all that is left. I need this as automated as possible, but everytime I think I have it figured out, the numbers don't work. Any help would be more than appreciated! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
First In First Out Function
By far the best advice I can give is buy Quicken or Money. For $40, either
one will take care of tracking all your lots of purchases. If you want automation, it's the way to go. Regards, Fred. "Sarah0824" wrote in message ... I am trying to find a formula that will do the following. Say I am buying and selling stocks. On day 1, I buy 5 shares of ABC stock at $10 each. On day 2, I buy 10 shares of ABC stock at $15 each. On day 3, I buy 15 shares of ABC stock at $20 each. On day 4, I sell 20 shares of ABC stock at $18 each. What I need is a formula that will take the amount I sold (20 shares), subtract out the first 5 shares I bought on day 1, then subtract the 10 shares I bought on day 2, and then only take 5 of the share bought on day 3 because that is all that is left. I need this as automated as possible, but everytime I think I have it figured out, the numbers don't work. Any help would be more than appreciated! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
First In First Out Function
Sarah,
No need to buy additional software. Follow this link to see an example http://in.geocities.com/shahshaileshs/misc.htm Brotha lee "Sarah0824" wrote: I am trying to find a formula that will do the following. Say I am buying and selling stocks. On day 1, I buy 5 shares of ABC stock at $10 each. On day 2, I buy 10 shares of ABC stock at $15 each. On day 3, I buy 15 shares of ABC stock at $20 each. On day 4, I sell 20 shares of ABC stock at $18 each. What I need is a formula that will take the amount I sold (20 shares), subtract out the first 5 shares I bought on day 1, then subtract the 10 shares I bought on day 2, and then only take 5 of the share bought on day 3 because that is all that is left. I need this as automated as possible, but everytime I think I have it figured out, the numbers don't work. Any help would be more than appreciated! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
First In First Out Function
Your example works great. Do you have an example that considers stock splits?
Thanks "Brotha Lee" wrote: Sarah, No need to buy additional software. Follow this link to see an example http://in.geocities.com/shahshaileshs/misc.htm Brotha lee "Sarah0824" wrote: I am trying to find a formula that will do the following. Say I am buying and selling stocks. On day 1, I buy 5 shares of ABC stock at $10 each. On day 2, I buy 10 shares of ABC stock at $15 each. On day 3, I buy 15 shares of ABC stock at $20 each. On day 4, I sell 20 shares of ABC stock at $18 each. What I need is a formula that will take the amount I sold (20 shares), subtract out the first 5 shares I bought on day 1, then subtract the 10 shares I bought on day 2, and then only take 5 of the share bought on day 3 because that is all that is left. I need this as automated as possible, but everytime I think I have it figured out, the numbers don't work. Any help would be more than appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |