This is related to the Excel guru thread; http://www.aussiestockforums.com/for...ead.php?t=1057
I have attached the latest version of the excel program I have been working on - been using it for the past week and have imported all my past transactions over last 8 months and it seems to work without any major glitches.
What it can be used for;
monitoring Buys/sell shares
monitoring Dividends (+ franking credits etc)
Total Portfolio Return
Share trade return
Montoring linked shares account (funds transfers, interest, share buy/sell etc)
Web Server to automatically update share prices in portfolio and updates portfolio value
records all data in easy to get at page (Data page)
What it doesn't do yet;
Purchase shares on margin
I know it works with Excel 2000 (I am unsure about other versions?)
I will be making updates from time to time and posting them in this thread - with any updated version the data can be transferred across using the import function.
If you have any queries/questions/requests post them in this thread and I will answer them.
Other than that.... Have fun