This is yet another of those Blogs I have had sat on the Slate of Ideas for me to write but it has taken up until now to finally float to the top and therefore earn my priority and focus (turds float and all that……). That’s quite a misrepresentation really - rather than an organised and sequential list of Blog Ideas for me to work on, it is a very higgledy piggledy collection of possible Blog Titles with a few having some words underneath to help me understand what I was thinking at the time of coming up with the idea and typing it into my working Blog Word Document. So the true way that a Blog gets to this stage is that it quite simply becomes the thing I fancy doing today and I just get on with it. At least in this way it is more pleasant for me to work on as I do what I want to do, rather than a Blog that I must do because it happens to be at the top of an arbitrary List.
You might have figured out from the Title that this Blog is about how I record my Individual Share Trades and Spreadbet Trades onto dedicated Spreadsheets so I have a record of what Trades I have opened and once they are closed off it enables me to calculate my Profit or Loss in £ Note terms and in Percentage terms expressed against my Capital that was used for the Trade (read that as ‘Investment’ mostly).
Years ago I was asked by Father Ted (@harry_southdown) on Twitter if I had an example Spreadsheet for recording my Trades that he could borrow from me and use as a starting point for him to tweak as he needs. At the time I rejigged the Spreadsheet I was using myself and sent it over and since that I have shared it with a few people but it is pretty obvious that many people might find this handy - or maybe they already have one themselves but this might give ideas on how they can tweak theirs to make it better.
My plan had been to finally sort mine out so it would make more sense to Readers and then I would upload it into the ‘Useful Links’ bit of the Website, but as I have thought about this in recent days it has occurred to me that it would be better if I did it as a Blog so that I can include a bit of commentary to explain what the columns etc. mean and any other points to note on how to best use them.
Anyway, there are 2 basic Spreadsheets that I use - one for Share Trades and one for Spreadbet Trades - but then I have different Spreadsheets for different Accounts - e.g. one for my iDealing Main ISA Trading Account and a separate one for my iWeb Income Portfolio ISA etc. Obviously Readers can use Spreadsheets in any way they find most appropriate and practical.
WD Example Share Trades Record Spreadsheet v1.0
This is a very simple Spreadsheet and probably includes most things Readers would want. Here is an Embedded File in Microsoft Excel Format (hopefully):
Here is a Screenshot of how it looks (I told you it was simple !!):
Most of it should be blindingly obvious and much will be where you just key in the Numbers and the Dates and Text and stuff and then there are some that have Formulas behind them - you can just Copy and Paste and these Cells should automatically adjust to the Lines and Columns as appropriate. Here are some pointers:
WD Example Spreadbet Trades Record Spreadsheet v1.0
This is another very simple Spreadsheet and should include most things Readers would want. Here is an Embedded File in Microsoft Excel Format (hopefully):
Here is a Screenshot of how it looks (if you click on it you should get a larger version in your Browser thing):
The big difference on this one is that it has the capability (to a small extent !!) to record Short Trades as well - here are some things to note:
OK, that’s it, hopefully this makes some sort of sense - feel free to contact me by Email or Tweet or DM or whatever if something is utterly confusing you.
Welcome to my Educational Blog Page - I have another 'Stocks & Markets' Blog Page which you can access via a Button on the top of the Homepage.
Please see the Full Range of Book Ideas in Wheelie's Bookshop.