I had gone through the excel file, I think, the format has to be changed, so as to enable stock splits and bonus issues. The important thing, that has to incorporated in the sheet is to add Running closing stock has to maintained. Further changes has to be made based upon running closing balance
I will come back on this again, In a little while Regards, Kishan Reddy, K kishanreddy.kethire...@gmail.com On Oct 19, 12:10 pm, Yahya <yahya...@gmail.com> wrote: > Dear all > > Can someone help me in this or provide a better spreadsheet? > > > > On Mon, Oct 18, 2010 at 8:47 AM, Yahya <yahya...@gmail.com> wrote: > > > Dear all > > > I use the attached excel sheet to calculate the profit/loss in the trading > > of individual stocks. The formula works fine in normal cases. But whenever > > there is some bonus/stock split etc. it fails. Can someone help me to derive > > a formula that will suit all cases? > > > -- > > > Regards > > > Yahya > > -- > > Regards > > Yahya -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts