by Salinay » Sun Dec 19, 2010 12:40 pm
I need to be able to enter date of purchase, number of shares, cost in USD or HKD, symbol(s) (some stocks I own in different brokerage accounts with different base currencies). I need to track cost basis (amount paid per share) and it needs to be adjusted for splits and stock dividends. When I sell shares, I need to be able to allocate sales across lots, for instance:
1/4/07 buy 1000 shares Bank of China for $3 HKD/ share
1/15/07 buy 1000 shares Bank of China for $3.50 HKD/ share
3/1/07 buy 500 shares Bank of China for $0.50 USD/ share
5/1/08 split 2:1 Bank of China
6/12/10 sold 3000 shares Bank of China for $0.75 USD/ share...1000 had a cost basis of $0.25 USD from 3/1 and 2000 had a cost basis of $1.50 HKD from 1/15.
In my portfolio, Inow have 2000 shares with a cost basis of $1.75 HKD purchased on 1/15/07
I also need to track dividends. A portfolio screen is a must listing all stocks, yields, prices, etc. I currently use Quicken for all of this, but they don't have currencies and don't work on the iPad, so being able to import from Quicken would be a huge plus (I have 22 years of purchases I'm not looking forward to re-entering.