This is a mobile optimized page that loads fast, if you want to load the real page, click this text.

Software for tracking shares

Joined
28 January 2006
Posts
202
Reactions
0
Does anyone have any good suggestions on software available to track share movement?

I need to find something that can handle capital reconstruction and name changes and will report on that basis.

Don't want to spend too much on it...any tips?

regards
 
Hi surelle and welcome

I suppose it depends on what features and functions you need from the software as well.

Anyway, below is a reply I posted to a similar question over at Stock Meeting Place.


Hope this helps

bullmarket
 
Thanks for that Bullmarket.

I simply want a program that will record the easy transactions like buying and selling and dividends received.

I have been using the investment area of quicken cashbook, and it has been fine for those easy transactions, but I find that if you have had a share that changes names or has had its capital restructured (i.e. from 10,000 to 100) Quicken cash book doesn't have the option of converting them.

I'll look into Share Analysis and see.

Thanks for the tip
regards
Surelle
 
Hi surelle

oh ok - I misunderstood your original post

Unfortunately Quicken's ShareAnalyser won't do what you are after as it is essentially a charting software package. It does have a basic trading diary built in but I doubt that is what you are after.

Personally, I use Microsoft's Excel spreadsheet to monitor my portfolio and to keep records of my share transactions and dividends/distributions (franking credits, un-franked components, tax deferred components etc). The spreadsheets also calculate any tax liabilities from dividends/distributions and capital gains/losses.

Imo if you know your way around Excel, or if you have someone to show you at least the basics to get you started, it is well worth considering putting in the effort to set up your own spreadsheet(s) to monitor your portfolio and transactions. You can fully customise a spreadsheet to do exactly what you want and how you want it and not be forced to doing what some 3rd party software restricts you to.

I still have to manually enter the basic data re my holdings as they change but the spreadsheet then does all the number crunching for me automatically.
So if you don't have too large a number of holdings and/or transactions, it's not an onerous task to keep records up to date.

Good luck

bullmarket
 
thanks again,
I will look into using excel instead, as simple as it seems, its probably more flexible than the software on offer

regards
surelle
 
Hi there
I have been using software called 'My Portolio Fronteir' - it handles sp movement updates whenever you want it to, calculates capital gains tax, how to reduce capital gains tax by selling selected shares, dividends, provides you with heaps of reports and is VERY easy to manage once you have put all the initial start up data in. It really is excellent. It handles company changeovers (eg I had Sigma which in December became SIP) so I just email them and they tell me what to do within 24 hours. Very helpful after sales service - I cant recommend them highly enough!

Solo Software House [info@solosw.com]

They will give you a try out version which doesnt really tell you its full value. I have three different portofolis (super, company and personal) and gives a licence for 3 portfolios. I cant remember the cost but it is a once off and really well worth it!

I am in NO WAY involved with the company, just a very happy user
 
thanks heaps, for that people

I'll look into the options, and let you know how I went

Cheers
Surelle
 
i created my own access database to record all contract notes/transactions i make. i think creating your own is the best solution because u can tailor it to your needs and most software you'll find is missing something you need.
my database imitates the comsec contract note history and automatically calculates brokerage+gst+gross profit+break even.

i also calculate the gross profit for a list of hypothetical sell points surrounding the buy price for day-trading purposes that allows me to see exactly how much i will make at a single glance.

excel is the easiest but access adds a lot more power. i think database is a better solution because it would allow u to sort and search etc.
 
thanks Vee303
I'm sure this is just beginners stuff to all of you...but it's helping alot
regards
 
vee303 said:
i created my own access database to record all contract notes/
excel is the easiest but access adds a lot more power. i think database is a better solution because it would allow u to sort and search etc.

The software I mentioned before uses Access as its software platform too!
 
Hi vee303

Looks like we are on a similar wavelength.

I've never used Access (I'm assuming you mean Microsoft's) but when I was in the workforce I used to write SQL scripts for an Oracle database and so I can see that with Access you should be able to set up a comprehensive database to monitor a portfolio and share transactions.

I'm using Excel 97, which uses VB (Visual Basic) to allow you to write macros/programs to do all sorts of quite extensive number crunching and data manipulation. The macros can even be set up to be interactive with the user...ie..request data input from the user and then put it in the appropriate location in the spreadsheet, thus making inputing of data virtually 'idiot proof'.

Excel macros can all be run in the background with a simple 'start' button conveniently postioned in the spreadsheet requiring only a mouse-click to start the macro.

But even without using macros, Excel has very powerful built in user selected formulae which the user can use to do the vast majority if not all the number crunching required to monitor a porfolio and share transactions. Basically, Excel can also perform all the functions/calculations you mentioned earlier. Whether it is easier or harder in Excel, I don't know as I'm not an Access user.

cheers

bullmarket
 
Cookies are required to use this site. You must accept them to continue using the site. Learn more...