I am trying to set up a spreadsheet that contains portfolio info. Let's say that for any given mutual fund ticker, i want to show the past year's worth of price , yield and total return info. I start with X$ number of dollars.
One number I need, is the number of shares I could have bought 1 year ago (about 262 trading days ago). To do this, i divide x$ by the price 262 trading days ago. But..to do this, to I use the raw close price, or the price adjusted for yield and splits? I would need to use the price that one would have actually paid for the fund..and not what its value was adjusted for historical yield, right? or maybe i should use the adjusted price and just subtract out the dividends? Of course this can only be done for the current year, right?.. ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Groups gets a make over. See the new email design. http://us.click.yahoo.com/ulNZQC/lOaOAA/cosFAA/GHeqlB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/quotes-plus/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
