skc
Goldmember
- Joined
- 12 August 2008
- Posts
- 8,277
- Reactions
- 329
Re: Technical Trading Exercise---Discretionary, (Pavilion103 & tech/a)
Lol. That seems to be a universal truth for any trade journal!
Plenty of good bottoming patterns and it won't take long before you catch a good ride on one of those.
Pav, thanks for putting up the spreadsheet.
A couple of excel tips if you like that sort of stuff.
- On the display use "Freeze panes" may work better than split.
- Consider using conditional formating for your colour coding of win/loss/breakeven.
- Use auto-filters at top of the trade table columns so you can quickly find the rows you want.
- I have a column called "Active?" with Yes/No entries so you can toggle what trades you want to see.
- Put a summation row at the top of the sheet so it stays in the "freezed" panes
The commission column seems to be static $12, and I am unsure IB pays you 7.7% on your short positions.
Nothing like a drawdown to kick things off.
Lol. That seems to be a universal truth for any trade journal!
Plenty of good bottoming patterns and it won't take long before you catch a good ride on one of those.
Pav, thanks for putting up the spreadsheet.
A couple of excel tips if you like that sort of stuff.
- On the display use "Freeze panes" may work better than split.
- Consider using conditional formating for your colour coding of win/loss/breakeven.
- Use auto-filters at top of the trade table columns so you can quickly find the rows you want.
- I have a column called "Active?" with Yes/No entries so you can toggle what trades you want to see.
- Put a summation row at the top of the sheet so it stays in the "freezed" panes
The commission column seems to be static $12, and I am unsure IB pays you 7.7% on your short positions.