Hi, I think I can get a way to solve your problem but I want a clear explanation and example sheet. I want every condition which affect the result.
Regards Sandeep ----- Original Message ----- From: "chinmay kamat" <kamatchin...@gmail.com> To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com> Sent: Thursday, October 08, 2009 2:01 PM Subject: $$Excel-Macros$$ Cap Gains calculation on shares, on FIFO basis Hello friends, I'm interested in using excel to do calculation for gains/losses in shares. As per law, there are 3 kinds of transactions which can be entered into in shares. The types are determined on the basis of the period of holding of each share by using FIFO method. FIFO method assumes that out of several shares purchased of multiple dates, the earliest shares are sold first. Thus for 10 shares sold on a day at the same price, the gains might be completely different as 5 shares might have been purchased first at some price and the rest might have been purchased on a later date. thus the date of purchase decides the category of transaction and the price decides the gain/loss. If the period of holding is 365 days or more, it is long term. if it is more that 1 day but less than 365 days it is short term. and if it is sold on d same day than the transaction is teated as a speculative transaction. The tax treatment for each type is different. I have data in the following format for purchase and sale separately. Date, quantity and total amount Is there any way that the FIFO algorithm can be implemented in excel?? Thanks in advance --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
