Spreadsheet for tracking trades

Hi all,

Just getting started in share market and trying to determine best way to track it all (especially for tax purposes)

Is there a basic spreadsheet available online available? and how do you all normally track if you buy some shares at 1 price and then down the track buy at another price?

Thanks

laidbackgav said:

Hi all,

Just getting started in share market and trying to determine best way to track it all (especially for tax purposes)

Is there a basic spreadsheet available online available? and how do you all normally track if you buy some shares at 1 price and then down the track buy at another price?

Thanks

Click to expand...

When you open an account and buy shares they will show in your portfolio, and in your transaction history, you can also setup watchlists for stocks to monitor. Many people still create their own custom excel spreadsheets to input all their trade data.

laidbackgav said:

Hi all,

Just getting started in share market and trying to determine best way to track it all (especially for tax purposes)

Is there a basic spreadsheet available online available? and how do you all normally track if you buy some shares at 1 price and then down the track buy at another price?

Thanks

Click to expand...

Hi.

Two parts.

Aussie account - I use an excel speadsheet to track my options trades, my aussie broker is not smart enough to provide me with an end of year statement.

Interactive Brokers which I mainly use generates fiscal year statements so I don't have to goof around with spreadsheets.

laidbackgav said:

Hi all,

Just getting started in share market and trying to determine best way to track it all (especially for tax purposes)

Is there a basic spreadsheet available online available? and how do you all normally track if you buy some shares at 1 price and then down the track buy at another price?

Thanks

Click to expand...

I have been running this for years to and from my accountant. Simple nothing fancy. Make a new tab each year and simply copy over the closing stock to the opening stock.

I daresay you could do a lot of fancy stuff, but I have never bothered with it. I dont track dividends, Just use what the ATO has listed against me. I sometimes put price per share in a column to the left or why I purchased.

if you're not already familiar with them, you might find it useful to read up on pivot tables and data aggregation functions like DSUM. there are plenty of how-to guides out there on these 2 concepts that can probably explain them way better than i could.

i find them both very useful for trading spreadsheets, i use them liberally in my own Excel workbook. they're particularly useful for letting you maintain a trade by trade worksheet where you can see every individual parcel, and summary sheets to give you an overall picture of your portfolio that nicely auto-update every time you make an entry in the trade by trade worksheet.

if i have multiple parcels of the same stock that turns into multiple lines on the trade by trade worksheet, but it all aggregates into a single line per stock on the summary sheet as pivot tables let you do a group by on a specific field (ie. the stock ticker). if i partially sell a parcel i split that parcel into 2 rows on the trade by trade sheet so one row is completely closed out and the other holds the remaining units of that parcel. the pivot tables make sure the summary worksheet automatically gets the latest numbers whenever i update the trade by trade worksheet.